Back to Acctg 455 Home Page

Download files for Chapter 09 (Right-click link, then click SAVE to download):

Download Excel files:

ACCTG455-Ch09.xlsx

EMT1761.xlsx (use with ACCTG 455 80.1 / EMT 1761)

EMT1762.xlsx (use with ACCTG 455 80.2 / EMT 1762)

Download PowerPoint Slides: ACCTG455-Ch09.pptx (notes for this chapter)

Homework Template That You Complete And Upload In The Home Area of Canvas: ACCTG45-Ch09-Homework.xlsx

Videos to watch for chapter 09:

ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis (8 mins)

ACCTG 455: 80.1. Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761 (3 mins)

ACCTG 455 80.2. Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762 (5 mins)

ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses (12 mins)

ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows (17 mins) 

ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation (16.5 mins) 

ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV (7 mins)

ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows (10 mins) 

ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example. (22 mins) 

ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation (8 mins)

ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations  (14 mins 

ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations  (11 Mins)