Excel-Chapter+6

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

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

Excel #6 Evaluating the Financial Impact of Loans and Investments

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

View Full Document
Level I Terms: Interest Compounded Interest Principal Annual Percentage Rate Annual Percentage Yield
Level I (continued) Functions used in 5 financing options

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

View Full Document
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
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
Ask a homework question - tutors are online