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) Total years of project First year change in revenue Revenues ncrease decrease each year at First year change in expenses Expenses increasidecrease each year at $10.000 10 $2.500 10.0% $750 50% Discount Rate for NPV & MIRR) Tax Rate Adjustment to Net Working Captal Salvage Value for Project Depreciation is Straight Line with 10 Year Life 1200% 35% $500 $500 Management Summary NPV IRR MIRR 0 Incremental Income Statement Year Revenues Expenses Depreciation 2 $2.750.00 3 $3,025 00 4 $3 327 50 5 $3,660.25 $2,500.00 $4,026.28 $4,428.90 8 $4.87179 $53587 10 35 B 87 EBIT Taxes Net Income Incremental Cash Flows Operating Cash Flow Ad to Working Capital Nel Capital Spending Change in CE $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3000 $0.00 5000