{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ITM%20215%20Class%2023%20Apr%2020

# ITM%20215%20Class%2023%20Apr%2020 - ITM 215 Computer...

This preview shows pages 1–12. 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
5/10/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
5/10/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
5/10/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
5/10/10  New Perspectives  PV (Present Value Function) FV (Future Value Function) PMT (Payment Function) NPER (Number of Periods  Function) RATE (Interest Rate Function ) 5 Working with Loans and  Investments

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

View Full Document
5/10/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
5/10/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
5/10/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
5/10/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
5/10/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
5/10/10

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 41

ITM%20215%20Class%2023%20Apr%2020 - ITM 215 Computer...

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

View Full Document
Ask a homework question - tutors are online