Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like some explanation on where values come from and not just a spread sheet with answers like the rest of the similar problems).

I would like some explanation on where values come from and not just a spread sheet with answers like the rest of the similar problems). i am trying to create this in excel for future use. Thank you.

Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $112,000 Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an upfront investment into machines and other equipment of $1.5 million. This investment can be fully depreciated straight-line over the next 10 years for tax purposes. However, Arnold Inc. expects to terminate the project at the end of eight years and to sell the machines and equipment for $598,000. Finally, the project requires an initial investment into net working capital equal to 10 percent of predicted first-year sales. Subsequently, net working capital is 10 percent of the predicted sales over the following year. Sales of protein bars are expected to be $4.9 million in the first year and to stay constant for eight years. Total manufacturing costs and operating expenses (excluding depreciation) are 80 percent of sales, and profits are taxed at 30 percent.

a. What are the free cash flows of the project?

b. If the cost of capital is 15 % what is the NPV of the project?

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

Global Finance And Development

Authors: David Hudson

1st Edition

0415436354, 978-0415436359

More Books

Students also viewed these Finance questions

Question

4. Why is visual stimulus so important?

Answered: 1 week ago