Tag Archives: Excel

Excel Finance Class 35: Calculate PMT for Present Value of Annuity PMT Function for Loan Payment

Download Excel workbook people.highline.edu Learn how to use the PMT function to calculate a loan payment.

Excel Finance Trick #8: Complete Loan Analysis

See how to use the PMT and RATE functions for a complete Debt/Loan Analysis. Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Payment, Actual Cash Received, Adjusted APR, and PMT w Balloon Payment. In ThisSeries learn 17 amazing Finance Tricks. Learn about … Continue reading

Excel Finance Trick #12: SLN & DDB Depreciation functions

See how to use the SLN & DDB Depreciation functions. The non-cash depreciation expenses are important for finance cash flow analysis. This video shows you the SLN & DDB functions. In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions … Continue reading

How to find Interest & Principal payments on a Loan in Excel

www.TeachMsOffice.com How to find the interest and principal payments on a fixed rate loan in excel. This tutorial will walk you through using the PPMT() and IPMT() functions in excel in order to find out how much of a monthly payment on a loan actually goes to pay off the loan amount and how much … Continue reading

Excel Finance Class 43: Business Amortized Loans

Download Excel workbook people.highline.edu Learn how to build an amortization table for a business loan using the PMT function and a few other Excel tricks.

Excel Finance Class 42: Consumer Amortized Loans

Download Excel workbook people.highline.edu Learn how to build an amortization table for a consumer loan using the PMT function and a few other Excel tricks.

Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed

See how to create an Amortization table that can handle variable year inputs. See the functions: PMT, IF, and ROWS. Video Rating: 4 / 5

Mortgage Payment Calculator for Microsoft Excel

This is a brief demo of our Mortgage Payment Calculator for Microsoft Excel. The spreadsheet allows you to enter the loan amount and mortgage repayment terms (ie years, interest rate, etc). The monthly payment amount and amortization schedule will be calculated and displayed automatically. You can download the spreadsheet for free at www.requantify.com Video Rating: … Continue reading

lynda.com: Excel 2007: Financial Analysis

www.lynda.com Numbers and financial data drives todays business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to … Continue reading

Excel Finance Class 43: Business Amortized Loans

Download Excel workbook people.highline.edu Learn how to build an amortization table for a business loan using the PMT function and a few other Excel tricks. Video Rating: 5 / 5