Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FIN 3320-Excel Project Use Excel to evaluate the following capital budgeting project for the best, base, and worst cases. You will calculate the following values
FIN 3320-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 Average Accounting Return s 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- $9,000,000 Net Working Cap Requirement- $800,000 Time frame 5 years Marginal tax rate-35% .5-year straight line depreciation with assumption of zero salvage value For negative net pre-tax incomes, you must include negative taxes, i.e., if the project loses money, it will reduce the company's taxable income, thus lowering its tax bil. EACH CASE MUST BE ON A SEPARATE PAGE AND FORMATTED TO BE ON ONE PAGE, OR MINUS 20 POINTS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started