ITM 215 Class 23 Apr 20

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

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

View Full Document Right Arrow Icon
  ITM 215:  Computer  Applications in  Business  Developing a 
Background image of page 1

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

View Full DocumentRight Arrow Icon
 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
Background image of page 2
 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
Background image of page 3

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

View Full DocumentRight Arrow Icon
 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
Background image of page 4
 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 
Background image of page 5

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

View Full DocumentRight Arrow Icon
 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
Background image of page 6
 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
Background image of page 7

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

View Full DocumentRight Arrow Icon
 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
Background image of page 8
 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
Background image of page 9

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

View Full DocumentRight Arrow Icon
 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
Background image of page 10
Image of page 11
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 Right Arrow Icon
Ask a homework question - tutors are online