Question
The following information is given: Dunder Mifflin is a paper manufacturer and distributor which is investing in a new line of paper. The company needs
The following information is given:
Dunder Mifflin is a paper manufacturer and distributor which is investing in a new line of paper. The company needs to buy the building for US$50 million and make an initial investment of US$30 million to convert the building into a plant. Expenses are incurred today (t=0). 10 years is the expected life of the plant. The company is estimated to make sales of 5 million units per year for all of the 10 years. Fixed costs and variable costs are US$10 million each year and US$20 per unit (one ream) respectively. The companys executives have decided to set a sales price of US$30 per unit. Assume that people who buy the new paper would be new customers, i.e. introducing this paper to the market would not affect the sales of their other products. All the expenditures made for the plant today will be depreciated straight-line over 10 years (from year 1 to year 10) leaving behind a value of US$5 million, but the company believes it might be able to sell it off at US$10 million.
The company has a beta of 1.75; it is 60% financed by debt, and debt holders require a 10% rate of return on their investment. Taxes are 40%. The interest on short-term government bonds is 4%, while the market rate of return is 8% and is expected to continue.
I have calculated the following:
Return on equity:
WACC:
Finding operating cash flows:
Based on this, apply a financial break-even analysis. After, hold everything constant but the units of paper sold. At what number of units sold would the project break even?
Year Revenue Fixed costs Variable costs EBITDA Depreciation EBIT Tax (40%) Net income (+Depreciation) Operating CF Investment Sale of FA Free CF 0 -80.000.000 -80.000.000 1 2 27.000.000 3 150.000.000 150.000.000 150.000.000 150.000.000 -10.000.000 -10.000.000 -10.000.000 -10.000.000 -100.000.000 -100.000.000 -100.000.000 -100.000.000 40.000.000 -7.500.000 32.500.000 40.000.000 -7.500.000 40.000.000 -7.500.000 40.000.000 -7.500.000 32.500.000 32.500.000 32.500.000 13.000.000 13.000.000 13.000.000 13.000.000 19.500.000 19.500.000 19.500.000 19.500.000 7.500.000 7.500.000 7.500.000 7.500.000 27.000.000 27.000.000 27.000.000 27.000.000 27.000.000 4 27.000.000 27.000.000 5 150.000.000 -10.000.000 -100.000.000 40.000.000 -7.500.000 32.500.000 13.000.000 19.500.000 7.500.000 27.000.000 27.000.000 6 7 27.000.000 8 27.000.000 150.000.000 -10.000.000 -7.500.000 150.000.000 150.000.000 150.000.000 150.000.000 -10.000.000 -10.000.000 -10.000.000 -10.000.000 -100.000.000 -100.000.000 -100.000.000 -100.000.000 -100.000.000 40.000.000 40.000.000 40.000.000 40.000.000 40.000.000 -7.500.000 -7.500.000 -7.500.000 -7.500.000 32.500.000 13.000.000 19.500.000 7.500.000 27.000.000 32.500.000 32.500.000 32.500.000 32.500.000 13.000.000 - 13.000.000 13.000.000 13.000.000 19.500.000 19.500.000 7.500.000 19.500.000 19.500.000 7.500.000 27.000.000 27.000.000 7.500.000 7.500.000 27.000.000 27.000.000 9 27.000.000 10 27.000.000 8.000.000 35.000.000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started