Question: Can you build a DCF using this format or teach me how to do it? ProFormaIncomeStatement: Revenue Less:Rawmaterialcosts Less:Laborexpense Less:Manufacturingoverhead Less:Maintenanceexpense Less:Selling,General&Administrativeexpenses EBITDA Less:Depreciation EBIT

Can you build a DCF using this format or teach me how to do it?

ProFormaIncomeStatement:

Revenue

Less:Rawmaterialcosts

Less:Laborexpense

Less:Manufacturingoverhead

Less:Maintenanceexpense

Less:Selling,General&Administrativeexpenses EBITDA

Less:Depreciation EBIT

Less:Taxes

NOPLAT

UnleveredFreeCashFlow:

EBIT Less:Taxes NOPLAT

Plus:Depreciation

Less:Capex

Less:Changeinworkingcapital

Freecashflow o

Thefreecashflowin2008(year0)shouldincludetheinitialcapexinvestmentonly.Thenetworking capitalinvestmentdoesnotoccuruntil2009(year1).

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!

Q:

Reconsider the overall distance data for golf balls in Exercise 10-29. Is there evidence to support the claim that the standard deviation of overall distance is the same for both brands of balls (use...

Q:

Step 1: Choose a Company (I have chosen LinkedIn) Pick a high-growth potential company. The company should have earnings or revenues expected to grow more than 50% in the near future. High-Growth...

Q:

Assignment 2: DCF Analysis - Mid-Michigan Manufacuring Inc. (MMMI) Mid-Michigan Manufacturing Inc. (MMVI) wishes to determine whether it would be advisable to replace an existing production machine...

Q:

Valuing a Texas Vineyard DCF model Build a DCF model to determine the present value of the vineyard. You have been asked by an entrepreneur to value a potential vineyard in the Texas Hill Country, an...

Q:

Part A: Part B: Part C: Part D: Conclusion: Mid-Michigan Manufacturing Inc. (MMMI) wishes to determine whether it would be advisable to replace an existing production machine with a new one. They...

Q:

Refer to the selected income statement and balance sheet items on the following page. Use your ODU University Identification Number (UIN) for the company's sales. The company plans to grow sales by...

Q:

Please show " excel functions/formulas " and step-by-step process using excel . I am struggling using excel.. :( Mid-Michigan Manufacturing Inc. (MMMI) wishes to determine whether it would be...

Q:

Mid-Michigan Manufacturing Inc. ( MIMI) wishes to determine whether it would be advisable to replace an existing production machine with a new one. The have hired your firm as a consultant to...

Q:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------...

Q:

HONDA: You are an analyst in the Honda (automobile industry), and your boss asks you to do a valuation of a global publicly traded automobile manufacturer. She wants you to devise an enterprise...

Q:

You are an Ford analyst (in the automobile industry) and your boss asks you to do a valuation of a global publicly traded automobile manufacturer. She wants you to come up with an enterprise...

Q:

When viewing the FASB Statement of Financial Accounting Concepts No. 8 and reviewing the Objective, Usefulness, and Limitations of General Purpose Financial Reporting. How does having a standard set...

Q:

The luggage department has a planned stock turnover of 4.0 for the six-month period. Determine the number of weeks supply needed to achieve the desired turnover and then calculate the addtions to...

Q:

How can a PESTLE analysis assist businesses to monitor their external environment to determine impacts on organisational objectives?

Q:

SAMATEK is an information technology services company. Other companies hire them for their services rather than maintaining their own IT departments. Woo-jin was speaking with Zeek, the receptionist...

Q:

1- Annual worth, net present value, and internal rate of return are all ways of evaluating a series of cash flows over time. What are the uses, advantages and disadvantages of each of these figures?...

Q:

Inventory does not include: a. Materials used in the production of goods to be sold. b. Assets intended to be sold in the normal course of business. c. Equipment used in the manufacturing of assets...

Q:

5. On October 1, 2006, Ming Co. purchased 300 of the $1,000 face value, 8% bonds of Loy, Ic., for $351,000, including accrued interest of $6,000. The bonds, which mature on January 1, 2013, pay...

Q:

Boone Hobbies, a wholesaler, has a sales budget for next month of $600,000. Cost of units sold is expected to be 40 percent of sales. All units are paid for in the month following purchase. The...

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

(EPS: Simple Capital Structure) Ace Company had 200,000 shares of common stock outstanding on December 31, 2008. During the year 2009 the company issued 8,000 shares on May 1 and retired 14,000...

Q:

(EPS: Simple Capital Structure) A portion of the combined statement of income and retained earnings of Seminole Inc. for the current year follows. Note 1. During the year, Seminole Inc. suffered a...

Q:

(EPS: Simple Capital Structure) On January 1, 2008, Lennon Industries had stock outstanding as follows. To acquire the net assets of three smaller companies, Lennon authorized the issuance of an...