ITM 215 Class 23 Apr 20

# ITM 215 Class 23 Apr 20 - ITM215 Computer Applicationsin...

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

ITM 215:  Computer  Applications in  Business  Developing a

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

View Full Document
6/9/10  New Perspectives  Financial functions to analyze  loans and  investments Amortization schedule Calculate a conditional sum Interpolate and extrapolate a series of values Calculate a depreciation  schedule 2 Objectives
6/9/10  New Perspectives  Determine a payback period Calculate a net present value Calculate an internal rate  of return Trace a formula error to  its source 3 Objectives

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

View Full Document
6/9/10  New Perspectives  Precedents :  Cells that are  used by a formula;  Cells  that  precede  the formula Dependents: Cells that use  the results of the  formula; Cells that  depend  on the  formula  4 Precedents & Dependents
6/9/10  New Perspectives  PV ( Present  Value Function) FV (Future Value Function) PMT (Payment Function) NPER (Number of Periods  Function) 5 Working with Loans and

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

View Full Document
6/9/10  New Perspectives  =PMT(rate,nper,pv, fv,type ) type: 0 or  omitted is at the  end of the  period, 1 is at the beginning of the  period  6 Payment Function Syntax
6/9/10  New Perspectives  =FV(rate,nper,payment, pv,type )   type: 0 or omitted is at the  end of  the period, 1 is at  the beginning  of the period  7 Future Value Syntax

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

View Full Document
6/9/10  New Perspectives  =NPER(rate,payment,pv, fv,type   type: 0 or omitted is at the  end of  the period, 1 is at  the  beginning of the period  8 Number of Periods Function  Syntax
6/9/10  New Perspectives  =PV(rate,nper,payment, fv,type )   type: 0 or omitted is at the  end of  the period, 1 is at  the beginning  of the period  9 Present Value Function Syntax

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

View Full Document
6/9/10  New Perspectives  =RATE(nper,payment,pv, fv,type,guess ) type : 0 or omitted is at the end of  the  period, 1 is at the beginning of  the period  guess : approximate  interest rate,  assumes 10% if omitted 10 Interest Rate Function Syntax
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 06/08/2010 for the course BITM 215 taught by Professor Ross during the Spring '08 term at SUNY Albany.

### Page1 / 36

ITM 215 Class 23 Apr 20 - ITM215 Computer Applicationsin...

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

View Full Document
Ask a homework question - tutors are online