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

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

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
 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
Background image of page 2
 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
Background image of page 3

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

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

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

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

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

View Full DocumentRight Arrow Icon
 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 05/05/2010 for the course COM 4123 taught by Professor Ted during the Spring '10 term at SUNY Albany.

Page1 / 41

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

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