Standard Food Company plans to establish a new production line for producing ice creams The equipment costs $500,000 with a 10 year life For depreciation the company is using MACRS method (you need to check the IRS table online or in the textbook) The project is expected to generate $ 200,000 worth of sale every year The annual fixed expense is $ 40,000 per year, and the variable cost is always 35 of the revenue of the same year Starting at year 0, the company needs to maintain an inventory that is worth 15 of next years sale At the end of the project, no inventory needs to be maintained and all existing inventory will be liquidated Also, at the end of the project the equipment will be sold at a market value of $ 30,000 Assuming the tax rate is 40 and the cost of capital is 9 for the company Calculate the Projects NPV, IRR, Regular Payback Period, Discounted Payback Period and Modified Internal Rate of Return, assuming a 9 reinvestment rate (12 points) Please show all your work for full credit From part a, the company faces two different scenarios one scenario is the scenario in part a and b when sales is given as 200,000 in another scenario the sales is 175,000 The probability of each scenario is listed below Bad Good Probability 40 60 Sales at year 1 175,000 200,000 Please solve the NPV for the different scenario and the expected NPV and standard deviation of NPV based on all scenarios From part a, please calculate the sensitivity of NPV to sales (and the sensitivity of NPV to the cost of equipment at year 0 (Hint you can put a 10 increase for each variable and calculate the corresponding NPV) Which variable would affect NPV more effectively )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 05, 2024

Standard Food Company plans to establish a new production line for producing ice creams. The equipment costs $500,000 with a 10-year life. For depreciation the

Standard Food Company plans to establish a new production line for producing ice creams. The equipment costs $500,000 with a 10-year life. For depreciation the company is using MACRS method (you need to check the IRS table online or in the textbook). The project is expected to generate $ 200,000 worth of sale every year. The annual fixed expense is $ 40,000 per year, and the variable cost is always 35% of the revenue of the same year. Starting at year 0, the company needs to maintain an inventory that is worth 15% of next years sale. At the end of the project, no inventory needs to be maintained and all existing inventory will be liquidated. Also, at the end of the project the equipment will be sold at a market value of $ 30,000. Assuming the tax rate is 40% and the cost of capital is 9% for the company.

Calculate the Projects NPV, IRR, Regular Payback Period, Discounted Payback Period and Modified Internal Rate of Return, assuming a 9% reinvestment rate (12 points) Please show all your work for full credit.

From part a, the company faces two different scenarios: one scenario is the scenario in part a and b when sales is given as 200,000; in another scenario the sales is 175,000. The probability of each scenario is listed below:

	Bad	Good
Probability	40%	60%
Sales at year 1	175,000	200,000

Please solve the NPV for the different scenario and the expected NPV and standard deviation of NPV based on all scenarios.

From part a, please calculate the sensitivity of NPV to sales (and the sensitivity of NPV to the cost of equipment at year 0 (Hint: you can put a 10% increase for each variable and calculate the corresponding NPV). Which variable would affect NPV more effectively? )