Excel for Finance

Excel for Finance

Loan Calculator Data Table

Amortization Table

Financial Functions

Many financial functions

? Functions for Calculating Depreciation

? Straight line ? Declining balance depreciation ? Double declining balance ? Sum of the year's digits

Other Financial Functions

Present value Future value Internal rate of return Payments

Functions we will use in this Chapter

PMT (to calculate monthly payments)

PV (to calculate the present value of a loan--a lump sum to pay it off early and avoid the interest that would accrue in the remaining years)

Three Parts of the Worksheet

$ Loan Calculator on a Disk $ Data Table to Show Payments at

Various Interest Rates $ Amortization Table to Show Pay off

Amounts Throughout the Life of the Loan

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download