Excel-Chapter+6 - Cumulative interest paid for a certain...

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

View Full Document Right Arrow Icon
Excel #6 Evaluating the Financial Impact of Loans and Investments
Background image of page 1

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

View Full DocumentRight Arrow Icon
Level I Terms: Interest Compounded Interest Principal Annual Percentage Rate Annual Percentage Yield
Background image of page 2
Level I (continued) Functions used in 5 financing options
Background image of page 3

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

View Full DocumentRight Arrow Icon
Level II Develop an Amortization Schedule Calculate the value of principal for one time period: PPMT(rate,per,nper,pv,fv,type) Calculate the value of interest for one time period: IPMT(rate,per,nper,pv,fv,type) Estimate Cash Flow
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cumulative interest paid for a certain time period: CUMIPMT(rate,nper,pv,start_date,end_date,type) Cumulative principal paid for a certain time period: CUMPRINC(rate,nper,pv,start_date,end_date,type) Straight Line Depreciation: SLN(Cost,Salvage,Life) Level III Net Present Value NPV(rate,value1,value2) Internal Rate of Return IRR(values,guess) Return on Investment Total return/Investment Payback Period...
View Full Document

This note was uploaded on 04/23/2008 for the course DISC 1300 taught by Professor Shemroske during the Spring '08 term at University of Houston.

Page1 / 5

Excel-Chapter+6 - Cumulative interest paid for a certain...

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

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