{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel 9 tutorial

Excel 9 tutorial - Excel Tutorial 9 Developing a Financial...

This preview shows pages 1–8. Sign up to view the full content.

COMPREHENSIVE Excel Tutorial 9 Developing a Financial Analysis

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Objectives Work with financial functions to analyze loans and investments Create an amortization schedule Calculate a conditional sum Interpolate and extrapolate a series of values Calculate a depreciation schedule New Perspectives on Microsoft Office Excel 2007 2
Objectives Determine a payback period Calculate a net present value Calculate an internal rate of return Trace a formula error to its source New Perspectives on Microsoft Office Excel 2007 3

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Working with Loans and Investments To calculate the present value of a loan or investment, use the PV function To calculate the future value of a loan or an investment, use the FV function To calculate the size of the monthly or quarterly payments required to pay off a loan or meet an investment goal, use the PMT function To calculate the number of monthly or quarterly payments required to pay off a loan or meet an investment goal, use the NPER function To calculate the interest of a loan or investment, use the RATE function New Perspectives on Microsoft Office Excel 2007 4
Working with Loans and Investments =PMT( rate, nper, pv, [fv=0] [type=0]) =FV( rate, nper, pmt, [pv=0] [type=0]) =NPER( rate, pmt, pv, [fv=0] [type=0]) =PV( rate, nper, pmt, [fv=0] [type=0]) =RATE( nper, pmt, pv, [fv=0] [type=0]) New Perspectives on Microsoft Office Excel 2007 5

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Calculating a Loan Payment The functions to work with loans are the same ones you used to work with investments New Perspectives on Microsoft Office Excel 2007 6
Schedule To calculate the amount of interest due in a specified payment period from a loan, use the IPMT function

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 26

Excel 9 tutorial - Excel Tutorial 9 Developing a Financial...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online