{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

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

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

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

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

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

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

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

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

View Full Document
9/15/11  New Perspectives  =RATE(nper,payment,pv, fv,type,guess ) type : 0 or omitted is at the end of  the
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}