{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel 9 tutorial

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

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

View Full Document Right Arrow Icon
COMPREHENSIVE Excel Tutorial 9 Developing a Financial Analysis
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 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
Background image of page 3

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

View Full Document Right Arrow Icon
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
Background image of page 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
Background image of page 5

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

View Full Document Right Arrow Icon
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
Background image of page 6
Schedule To calculate the amount of interest due in a specified payment period from a loan, use the IPMT function
Background image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
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 Right Arrow Icon bookmark
Ask a homework question - tutors are online