ITM%20215%20Class%2022%20Apr%2012

ITM%20215%20Class%2022%20Apr%2012 - ITM215: Computer...

Info iconThis preview shows pages 1–13. 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
 9/15/11  New Perspectives  Cases 5 through 8 are due tonight by 11:59 PM Homework Cases
Background image of page 2
 9/15/11  New Perspectives  Average: High: Low: Exam 2: Excel
Background image of page 3

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

View Full DocumentRight Arrow Icon
 9/15/11  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 4 Objectives
Background image of page 4
 9/15/11  New Perspectives  Determine a payback period Calculate a net present value Calculate an internal rate  of return Trace a formula error to  its source 5 Objectives
Background image of page 5

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

View Full DocumentRight Arrow Icon
 9/15/11  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  6 Precedents & Dependents
Background image of page 6
 9/15/11  New Perspectives  PV (Present Value Function) FV (Future Value Function) PMT (Payment Function) NPER (Number of Periods  Function) 7 Working with Loans and 
Background image of page 7

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

View Full DocumentRight Arrow Icon
 9/15/11  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  8 Payment Function Syntax
Background image of page 8
 9/15/11  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  9 Future Value 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
 9/15/11  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  10 Number of Periods Function  Syntax
Background image of page 10
 9/15/11  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  11 Present Value Function Syntax
Background image of page 11

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

View Full DocumentRight Arrow Icon
 9/15/11  New Perspectives  =RATE(nper,payment,pv, fv,type,guess ) type : 0 or omitted is at the end of  the 
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

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

Page1 / 43

ITM%20215%20Class%2022%20Apr%2012 - ITM215: Computer...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online