Excel.09 - ExcelTutorial9 Developinga FinancialAnalysis...

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 DocumentRight 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 DocumentRight 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 DocumentRight 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
Creating an Amortization  Schedule To calculate the amount of interest due in a  specified payment period from a loan, use  the IPMT function To calculate the amount of a loan payment  used to pay off the principal of the loan, use 
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/09/2011 for the course BCIS 2610 taught by Professor Sidorova during the Spring '08 term at North Texas.

Page1 / 26

Excel.09 - ExcelTutorial9 Developinga FinancialAnalysis...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online