Question

You are evaluating a new product. In year 3 of your analysis, you are projecting pro...

You are evaluating a new product. In year 3 of your analysis, you are projecting pro forma sales of $5 million and cost of goods sold of $3 million. You will be depreciating a $1 million machine for 5 years using straight-line depreciation. Your tax rate is 35%. Finally, you expect working capital to increase from $200,000 in year 2 to $300,000 in year 3. What are your pro forma earning from year 3? What are your pro forma free cash flows for year 3?

Homework Answers

Answer #1

Using excel to calculate proforma earnings and free cash flow at year 3

Sales $     5,000,000.00
COGS $     3,000,000.00
Depreciation $         200,000.00 (Depreciation = 1000000/5)
EBIT $     1,800,000.00 (EBIT = Sales- Cogs-Depreciation)
TAX $         630,000.00 Tax=EBIT*Tax Rate
Earnings $     1,170,000.00 Earnings =EBIT-Tax
Depreciation $     1,370,000.00
Net working capital $         100,000.00 (300000-200000)
free cash flow $     1,270,000.00 Free Cash flow=(Earnings+Depreciation-Net Working Capital)

Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Well

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are evaluating a new product. In year 3 of your​ analysis, you are projecting pro...
You are evaluating a new product. In year 3 of your​ analysis, you are projecting pro forma sales of ​$55 million and cost of goods sold of ​$33 million. You will be depreciating a ​$11 million machine for 55 years using​ straight-line depreciation. Your tax rate is 3535​%. ​Finally, you expect working capital to increase from ​$200 comma 000200,000 in year 2 to ​$300 comma 000300,000 in year 3. What are your pro forma earnings for year​ 3? What are...
Threes Company is evaluating a new project. Mr. Jack Tripper, Chief Financial Officer, has received pro...
Threes Company is evaluating a new project. Mr. Jack Tripper, Chief Financial Officer, has received pro forma income statements for the project from the Controller’s office and wants to know whether the new project will increase shareholders' wealth. The estimated initial project cost is $25 million to undertake this six year project. The project is expected to generate the following cash flows for the next six years: $5.2 million in year 1; $6.6 million in year 2, $7.6 million in...
Your company has just completed a $0.85 million marketing survey that found that your new product...
Your company has just completed a $0.85 million marketing survey that found that your new product is going to be a big hit. Producing the game will require an immediate (year 0) $0.9 million capital investment. Net working capital will have to increase in year 0 from $0.5 million to $1million, and will return to the original 0.5 million level at the end of the project. You expect annual revenues of $5 million in years 1 through 3. The variable...
A company is evaluating the purchase of a machine to improve product quality and output levels....
A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.4 million and would be depreciated for tax purposes using the straight-line method over an estimated seven-year life to its expected salvage value of $100,000. The new machine would require an addition of $90,000 to working capital at the beginning of the project, which will of course be returned to the firm at the end of the project. In...
You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS....
You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS. This machine generates $200,000 in annual revenue. In year 4, you sold the machine for $250,000. You received a loan for $400,000 on a 5 year loan at 5% (note, you must pay the remaining balance of this loan at the end of year 4 from the proceeds of the sale). In addition, you invested $80,000 in working capital initially. Your company is in...
3. Analysis of a replacement project At times firms will need to decide if they want...
3. Analysis of a replacement project At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: • The new equipment will have a cost of $1,800,000, and it will be depreciated...
You are evaluating the purchase and installation of a new machine for your company. The purchase...
You are evaluating the purchase and installation of a new machine for your company. The purchase cost is $20,000 and its installation cost is $5,000. Its maintenance cost is estimated to be $2,000 per year starting EOY 1, increasing by 5% per year for 14 additional years. You estimate the additional revenue after installation to be $10,000 per year starting EOY 1 and continuing for 4 additional years. You estimate revenue to increase to $15,000 starting EOY 6 and increasing...
In this assignment, you will apply the concepts of company valuation that you have just learned...
In this assignment, you will apply the concepts of company valuation that you have just learned to determine whether company XYZ is overvalued. We are currently at the end of year "t". You performed a thorough financial analysis of XYZ and forecast the following Free Cash Flows (FCF): Year t+1: 352 million USD Year t+2: 385 million USD Year t+3: 407 million USD From year t+3 onward, you expect the FCFs to grow at a constant yearly rate of 4%....
You are evaluating a product for your company. You estimate the sales price of product to...
You are evaluating a product for your company. You estimate the sales price of product to be $120 per unit and sales volume to be 10,200 units in year 1; 25,200 units in year 2; and 5,200 units in year 3. The project has a 3 year life. Variable costs amount to $45 per unit and fixed costs are $202,000 per year. The project requires an initial investment of $330,000 in assets which will be depreciated straight-line to zero over...
NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base...
NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $188,000, and shipping and installation costs would add another $11,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $65,800. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $4,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on...