Question: Please solve using excel and include important formulas if possible so that I can replicate this as I practice: Arnold Inc.Arnold Inc . is considering

Please solve using excel and include important formulas if possible so that I can replicate this as I practice: Arnold Inc.ArnoldInc.
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
$33
million and which it currently rents out for
$103 comma 000103,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.301.30
million. This investment can be fully depreciated straight-line over the next 10 years for tax purposes. However,
Arnold Inc.ArnoldInc.
expects to terminate the project at the end of
88
years and to sell the machines and equipment for
$416 comma 000416,000.
Finally, the project requires an initial investment into net working capital equal to10% of predicted first-year sales. Subsequently, net working capital is10% of the predicted sales over the following year. Sales of protein bars are expected to be
$4.504.50
million in the first year and to stay constant for
88
years. Total manufacturing costs and operating expenses(excluding depreciation) are80% of sales, and profits are taxed at
35%35%.
a. What are the free cash flows of the project?
b. If the cost of capital is
15%15%,
what is the NPV of the project?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!