Question

In: Finance

A new Stout engineer who just was hired by Machine Excellence is pushing for a brand...

A new Stout engineer who just was hired by Machine Excellence is pushing for a brand new laser machining center. He insists that it is a money maker from the first day. He did not figure the deprecation and the after taxes cash flow (CFAT). Give this rookie engineer a little intelligent guidance here on the CFAT for a ROR analysis of the new laser equipment. Here are the figures for the production machining equipment for making detailed laser signs and complex shapes. Calculate the CFAT and ROR for the end of 6 years. Answer the question: "Is the investment economically viable"? Depr method: MACRS GDS Class life: 5 Years Depr recapture: Taxed as TI First cost: $550,000 Gross Income:$250,000 Expenses: $80,000 Salvage: 0 in year 6 Effective Tax Rate: 45% After-tax MARR: 10% per year compounded semiannually

Solutions

Expert Solution

Year 0 1 2 3 4 5 6
1.First cost -550000
2.Gross Income 250000 250000 250000 250000 250000 250000
3.Expenses -80000 -80000 -80000 -80000 -80000 -80000
4.MACRS Depreciation -110000 -176000 -105600 -63360 -63360 -31680
5.EBT(2+3+4) 60000 -6000 64400 106640 106640 138320
6.Tax at 45%(5*45%) -27000 2700 -28980 -47988 -47988 -62244
7.EAT(5-6) 33000 -3300 35420 58652 58652 76076
8.Add back:depn.(Row 4) 110000 176000 105600 63360 63360 31680
9.OCFs(7+8) 143000 172700 141020 122012 122012 107756
10.CFAT---FCFs(1+9) -550000 143000 172700 141020 122012 122012 107756
11.PV F at MARR 10.25%p.a.(1/1.1025^Yr.n) 1 0.90703 0.82270 0.74622 0.67684 0.61391 0.55684
12.PV at 10.25%(10*11) -550000 129705.2 142080.7 105231.3 82582.52 74904.78 60002.57
13.NPV(sum of row 12) 44507.11
14.IRR/ROR (Of FCF row 10) 13.16%
MARR= 10% p.a. compounded semi-annually is
Interest compounded twice in a year, so
(1+10%/2)^2-1=
10.25%
p.a.
As salvage is $ 0,
there is no depreciation recapture
ANSWERS:
10.CFAT---FCFs(1+9) -550000 143000 172700 141020 122012 122012 107756
13.NPV(sum of row 12) 44507.11
14.IRR/ROR (Of FCF row 10) 13.16%

Related Solutions

You just got hired at a brand new hospital as a financial analyst and the Board...
You just got hired at a brand new hospital as a financial analyst and the Board wants to buy an MRI machine but they are unsure if this makes financial sense. You gather some figures so you can make an informed decision to present to the Board. (questions 40-44) Use CF’s given, no further calculation has to be done for CF’s. Cost of the MRI machine 1.5 million Salvage value after 5 years 50k Working capital to hire an operator...
You just got hired at a brand new hospital as a financial analyst and the Board...
You just got hired at a brand new hospital as a financial analyst and the Board wants to buy an MRI machine but they are unsure if this makes financial sense. You gather some figures so you can make an informed decision to present to the Board. (questions 40-44) Use CF’s given, no further calculation has to be done for CF’s. Cost of the MRI machine 1.5 million Salvage value after 5 years 50k Working capital to hire an operator...
You just got hired at a brand new hospital as a financial analyst and the Board...
You just got hired at a brand new hospital as a financial analyst and the Board wants to buy an MRI machine but they are unsure if this makes financial sense. You gather some figures so you can make an informed decision to present to the Board. (questions 40-44) Use CF’s given, no further calculation has to be done for CF’s. Cost of the MRI machine 1.5 million Salvage value after 5 years 50k Working capital to hire an operator...
An engineer who works for Zpac is pitching a project for a new machine to his...
An engineer who works for Zpac is pitching a project for a new machine to his management. Zpac’s MARR is 12%. To finance this project, Zpac would have to invest $34,000 immediately and then $5000 each year for the next five years starting one year from now. The project is expected to generate revenue of $10000 one year from now, and then the revenue would increase by $2000 each year through year 4. The revenue in year 5 would be...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:      Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000   Selling price per unit $7 per unit             Chapter 7: Applying Excel 2 3...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 70,000 120,000 60,000 80,000 95,000 Selling price per unit $7 Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 45,000 70,000 110,000 75,000 90,000 95,000   Selling price per unit $7 per unit             A B C D E F F...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 70,000 120,000 70,000 90,000 90,000 Selling price per unit $7 1 2 3 4 5 6 7 8 9 10 11 12 13...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 110,000 65,000 85,000 100,000 Selling price per unit $7 1 2 3 4 5 6 7 8 9 10 11 12 13...
The company has just hired a new marketing manager who insists that unit sales can be...
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 70,000 105,000 75,000 85,000 90,000 Selling price per unit $7 A B C D E F G 1 2 3 4 5 6...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT