Download files for Chapter 08 (Right-click link, then click SAVE to download):
Download Excel files:
ACCTG455-Ch08.xlsx
ExcelShort51-54.xlsx (Goes with the two one minute short videos)
Download PowerPoint Slides: ACCTG455-Ch8.pptx (notes for this chapter)
Videos to watch for chapter 08:
ACCTG 455: Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting (17 mins)
ACCTG 455 #68.1. Build Text Formula for Dynamic Label For Financial Model. #Short 51. (1 min)
ACCTG 455 #68.2. Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52 (1 min)
ACCTG 455 #68.3. Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53 (1 min)
ACCTG 455 #68.4. Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54 (1 min)
ACCTG 455: Excel Finance Class 70: Investment Criteria: Net Present Value (3 mins)
ACCTG 455: Excel Finance Class 71: Investment Criteria: Payback Rule (9 mins)
ACCTG 455: Excel Finance Class 72: Investment Criteria: Average Accounting Return ( 8 min)
ACCTG 455: Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function & Chart (19 mins)
ACCTG 455: Excel Finance Class 74: IRR & Non-conventional Cash Flows, Plot Chart To See Multiple IRR (8 min)
ACCTG 455: Excel Finance Class 75: IRR & Mutually Exclusive Projects, Chart To See Cross Over Rate (10 mins)
ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return (9 mins)
ACCTG 455: Excel Finance Class 77: Investment Criteria: Profitability Index (2 mins)
No Video 78.
ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index (9 mins)