{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right 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 Document Right 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 Document Right 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) RATE (Interest Rate Function ) 7 Working with Loans and  Investments
Background image of page 7

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

View Full Document Right 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 Document Right 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 Document Right 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.

{[ snackBarMessage ]}