Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the information provided above, calculate the projects NPV, IRR and MIRR in excel. Should HHI pursue this investment? Explain why. Happy Holiday Inc

image text in transcribed

Based on the information provided above, calculate the projects NPV, IRR and MIRR in excel. Should HHI pursue this investment? Explain why.

Happy Holiday Inc (HHI) is considering a new capital budgeting project that will last for three years. The initial investment outlay for project equipment is expected to be $150,000. The equipment will be straight-line depreciated down to zero book value over the three-year period. The company anticipates it can sell the asset for $60,000 when the project is liquidated at the end of the third year. The project requires an initial investment in Net Working Capital of $10,000. During the operational period Net Working Capital Requirements is expected to be 10% of the revenues. HHI's cost of capital is 10% and the project does not have a distinct risk profile. HHI's tax rate is 21%. Based on extensive research, analysts have prepared the following revenue forecasts for the project. The gross margin is estimated to 50% of sales, and it is assumed to be the similar to those for other HHI's other projects. Note that gross project costs include cost of sales and operating expenses except for depreciation. Please also note that the Net Working Capital investments will be recovered at the end of the project and should be part of terminal cash flows

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_2

Step: 3

blur-text-image_3

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

Financial Modeling

Authors: Simon Benninga, Tal Mofkadi

5th Edition

0262046423, 9780253337825

More Books

Students also viewed these Finance questions