B C D E G H K CHAPTER 9 - EXCEL EXERCISE This week you will be building out a capital budgeting worksheet in excel. The project details are listed in the box below and you will be working to fill in all of the blue shaded cells with formulas that are linked to the project details. I have completed the first row for you. You will also need to make sure you complete the Management Summary Box using the skills you learned in the previous chapter Initial Investment (Equipment) $10,000 Discount Rate (for NPV & MIRR) 12.00% Management Summary Total years of project 10 Tax Rate 35% NPV First year change in revenue $2,500 Adjustment to Net Working Capital $500 IRR Revenues increase/decrease each year at. 10.0% Salvage Value for Project $500 MIRR First year change in expenses $750 Depreciation Is Straight Line with 10 Year Life Expenses increase/decrease each year at: 5.0% Incremental Income Statement Year 0 1 2 3 4 5 6 7 8 9 10 Revenues $2,500.00 $2,750.00 $3,025.00 $3,327.50 $3,660.25 $4,026.28 $4,428.90 $4,871.79 $5,358.97 $5,894 87 Expenses Depreciation EBIT Taxes Net Income Incremental Cash Flows Operating Cash Flow Adj_ to Working Capital Net Capital Spending Change in CF $0.00 $0.00 $0.00 $0 00 $0.00 $0.00 $0.00 $0 00 $0.00 $0.00 $0.00