Question

In: Finance

Project C: The project is outside of the normal products sold of the firm. The project...

Project C: The project is outside of the normal products sold of the firm. The project is a reconsideration of a project proposed two years ago by a former manager. At that time a marketing study costing $200,000 was done; however, the project was not undertaken. Now the firm needs to consider if this project is worth the firm’s capital investment dollars. This project would require investment in equipment of $20,000,000 with an additional cost of $5,000,000 in installation fees. The project will be considered under a 6 year project cycle, but would be depreciated under the 5 year MACRS schedule. At the end of the project, management estimates that the equipment could be sold at a market value of $5,000,000. This project also creates a need to increase raw goods inventory by $6,000,000. During the operational cycle of this project, the product would have a sales price of $90.00 per unit. Costs associated with this project would be $65.00 in variable cost per unit and a fixed cost per year of $5,000,000. Management estimates that the sales volume would be 500,000 units in year 1, 600,000 units in year 2, 700,000 units in year 3, 800,000 units in year 4, 800,000 units in year 5, and 600,000 units in year 6. Because management is uneasy with undertaking a project so far outside of its normal product portfolio, it is imposing a 3 percentage point premium above the WACC as the required rate of return on the project.

Create a valuation spreadsheet for each of the projects mentioned above. Evaluate each project according to the following valuation methods: a. Net Present Value of Discounted Cash Flow b. Internal Rate of Return c. Payback Period d. Profitability Index

Modified Accelerated Cost Recovery System (MACRS)

Ownership Year 5-Year Investment Class Depreciation Schedule

1 20%

2 32%

3 19%

4 12%

5 11%

6 6%

Total = 100%

WACC = 12.064%

tax rate = 4%

Solutions

Expert Solution

Cash Flows

NPV, IRR, PAYBACK, PI


Related Solutions

The firm Prussian Clausewitz produces three products: Blücher, Napoleon, and Wellington. These three products are sold...
The firm Prussian Clausewitz produces three products: Blücher, Napoleon, and Wellington. These three products are sold at a sales mix of 1:3:2, respectively. Blücher Napoleon Wellington Price (per unit) $5,000 $18,000 $15,000 Variable Cost per Unit $4,000 $5,000 $5,000 The firm has $6,000,000 in fixed costs. How many Napoleon units must the firm sell at breakeven (round up to nearest unit if necessary)? Selected Answer: d. 462 Napoleon units. Answers: a. 100 Napoleon units. b. 1,385 Napoleon units. c. 300...
About % of the area under the curve of the standard normal distribution is outside the...
About % of the area under the curve of the standard normal distribution is outside the interval z=[−1.42,1.42]z=[-1.42,1.42] (or beyond 1.42 standard deviations of the mean).
a. About % of the area under the curve of the standard normal distribution is outside...
a. About % of the area under the curve of the standard normal distribution is outside the interval z=[−0.3,0.3]z=[-0.3,0.3] (or beyond 0.3 standard deviations of the mean). b. Assume that z-scores are normally distributed with a mean of 0 and a standard deviation of 1. If P(−b<z<b)=0.6404P(-b<z<b)=0.6404, find b. b= c. Suppose your manager indicates that for a normally distributed data set you are analyzing, your company wants data points between z=−1.6z=-1.6 and z=1.6z=1.6 standard deviations of the mean (or...
1. A balloon is floating around outside your window. The temperature outside is -15 ∘C ,...
1. A balloon is floating around outside your window. The temperature outside is -15 ∘C , and the air pressure is 0.800 atm . Your neighbor, who released the balloon, tells you that he filled it with 4.00 moles of gas. What is the volume of gas inside this balloon? Express your answer to three significant figures and include the appropriate units. Vballoon = 2. A 18.0 L gas cylinder is filled with 9.80 moles of gas. The tank is...
PART A A balloon is floating around outside your window. The temperature outside is -19 ∘C...
PART A A balloon is floating around outside your window. The temperature outside is -19 ∘C , and the air pressure is 0.700 atm . Your neighbor, who released the balloon, tells you that he filled it with 3.00 moles of gas. What is the volume of gas inside this balloon? Express your answer to three significant figures and include the appropriate units. PART B A 20.0 L gas cylinder is filled with 7.20 moles of gas. The tank is...
Part A A balloon is floating around outside your window. The temperature outside is 33 ∘C...
Part A A balloon is floating around outside your window. The temperature outside is 33 ∘C , and the air pressure is 0.800 atm . Your neighbor, who released the balloon, tells you that he filled it with 3.90 moles of gas. What is the volume of gas inside this balloon? Express your answer to three significant figures and include the appropriate units. Part B A 20.0 L gas cylinder is filled with 6.60 moles of gas. The tank is...
Salem Industries sells products A, B and C. In 2019 the quantity sold, sales revenue, total...
Salem Industries sells products A, B and C. In 2019 the quantity sold, sales revenue, total variable costs products were: Products A B C Quantity 2,000 2,000 6,000 Sales Revenue 600,000 675,000 1,125,000 Variable cost 480,000 405,000 750,000 Fixed costs were $612,000. Required: Compute Salem’s breakeven sales (units). Prove your answer. Calculate the sales (in units) required to earn a target profit $153,000. Prove your answer. Calculate the reduction needed in the fixed costs to break even at 5,000 units;...
Firm C is considering a project with an up-front cost at t = 0 of $1500....
Firm C is considering a project with an up-front cost at t = 0 of $1500. (All dollars in this problem are in thousands.) The project’s subsequent cash flows are critically dependent on whether a competitor’s product is approved by the Food and Drug Administration (FDA). If the FDA rejects the competitive product, C’s product will have high sales and cash flows, but if the competitive product is approved, that will negatively impact company C. There is a 75% chance...
If the temperature inside a room is 25°C and the temperature outside is ?10°C: a. What...
If the temperature inside a room is 25°C and the temperature outside is ?10°C: a. What is the maximum relative humidity that can be accommodated inside the room before the window fogs over? (Assume the inside of the window is not insulated from the outside temperature). b. If it is a double-pane window such that the inside of the window is perfectly insulated from the outside, what will the maximum relative humidity be?
A bio-reactor is kept at 45°C on a day where the outside is 20°C. It is...
A bio-reactor is kept at 45°C on a day where the outside is 20°C. It is estimated that the bio-reactor loses 12 kW to the ambient. Waste heat at 450 K from an engine is used to deliver the heat to the bio-reactor. Find the destruction of exergy and where it is made. The condenser in a power plant cools 10 kg/s water at 10 kPa, quality 90%, so it comes out as saturated liquid at 10 kPa. The cooling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT