Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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

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

Handbook Of Asian Finance Financial Markets And Sovereign Wealth Funds

Authors: David Lee, Greg N. Gregoriou

1st Edition

0128009829, 978-0128009826

More Books

Students also viewed these Finance questions

Question

friendliness and sincerity;

Answered: 1 week ago