Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

HBR Guide To Finance Basics For Managers

Authors: Harvard Business Review

1st Edition

1422187306, 978-1422187302

More Books

Students also viewed these Finance questions

Question

Do you think physicians should have unions? Why or why not?

Answered: 1 week ago