Please see the attachments and help me to resolve Excel project- Finance 3320 class.

Thanks.

Excel Project Use Excel to evaluate the following capital budgeting project for the best, base, and worst cases. You will calculate the following values for each case: Net present value Internal rate of return Profitability Index Payback Discounted payback Accounting rate of return The cash flows change every year because of the assumptions below. Note: You must do your calculations in Excel. Do not do them with a calculator and type them in. Example: For the base case, unit sales is 100,000 in year 1. The assumptions state that unit sales will decline in the second year by 1,000. Assuming that the year 1 unit sales is in cell B46, year 2 unit sales would be in C46 and the formula in that cell would be =B46-1,000 Here is information about the project. Initial Fixed Asset investment= $8,000,000 Net Working Cap Requirement= $1,000,000 (constant) Time frame = 5 years Marginal tax rate= 30% 5-year straight line depreciation Projected salvage value =$100,000 Best Base Worst Unit Sales year 1= 110,000 100,000 90,000 Change in unit sales per year= 0 -1,000 -2,000 Price/unit year 1= $210 $200 $190 Change in price per year= $0 -$5 -$10 Variable Cost/unit year 1= $146 $150 $154 Change in variable cost per year= $0 +$1 +$2 Fixed costs year 1= $20,000 $20,000 $20,000 Change in fixed costs per year -$500 $0 +$500 Actual salvage value= $120,000 $100,000 $80,000 Initial FA investment= Net Working Cap Reqt.= Time frame in years= Marginal tax rate= Straight line depn. Projected salvage val.= Required rate of return= $8,000,000 $1,000,000 5 30% $100,000 0.12 BEST CASE Year Initial FA Investment Net Working Capital Rqt Unit Sales Price/unit VarCost/unit 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 Revenue Variable costs Fixed costs year Depreciation EBIT Tax Net Income Depreciation After tax salvage Return of Working Capital Cash Flow Accumulated cash flow Discounted Cash flow Net Present value 12% Internal Rate of Return Profitability Index Payback Discounted Payback Accounting rate of return BASE CASE Year Initial FA Investment Net Working Capital Rqt Unit Sales Price/unit VarCost/unit Revenue Variable costs Fixed costs year Depreciation EBIT Tax Net Income Depreciation After tax salvage Return of Working Capital Cash Flow Accumulated cash flow Discounted Cash flow Net Present value 12% Internal Rate of Return Profitability Index Payback Discounted Payback Accounting rate of return WORST CASE Year Initial FA Investment Net Working Capital Rqt Unit Sales Price/unit VarCost/unit Revenue Variable costs Fixed costs year Depreciation EBIT Tax Net Income Depreciation After tax salvage Return of Working Capital Cash Flow Accumulated cash flow Discounted Cash flow Net Present value 12% Internal Rate of Return Profitability Index Payback Discounted Payback Accounting rate of return