Question

In: Finance

Base price ($260,000) Modifications ($15,000) Increase in NWC ($22,500) Increase in sales revenue 220,000 Operating costs...

Base price ($260,000)
Modifications ($15,000)
Increase in NWC ($22,500)
Increase in sales revenue 220,000
Operating costs 150,000
Salvage value 8,500
Required rate of return 13%
Tax rate 40%
MACRS class life (years) 5
Useful life (years) 8

Golden State Bakers, Inc. (GSB) has an opportunity to invest in a new bread-making machine. GSB needs more productive capacity, so the new machine will not replace an existing machine. The new machine is priced at $260,000 and will require modifications costing $15,000. It has an expected useful life of 10 years, will be depreciated using the MACRS method over its 5-year class life, and has an expected salvage value of $12,500 at the end of Year 10. (See Table 10A.2 for MACRS recovery allowance percentages.) The machine will require a $22,500 investment in net working capital. It is expected to generate additional sales revenues of $125,000 per year, but its use also will increase annual cash operating expenses by $55,000. GSB’s required rate of return is 10 percent, and its marginal tax rate is 40 percent. The machine’s book value at the end of Year 10 will be $0, so GSB will have to pay taxes on the $12,500 salvage value.

a.   What is the NPV of this expansion project? Should GSB purchase the new machine?

b.   Suppose GSB’s required rate of return is 12 percent rather than 10 percent. Should the new machine be purchased in this case?

c.   Should GSB purchase the new machine if it is expected to be used for only five years and then sold for $31,250? (Note that the model is set up to handle a five-year life; you need enter only the new life and salvage value.)

d.         Would the machine be profitable if revenues increased by only $105,000 per year? Assume everything else is as originally presented and evaluated in part a.

Solutions

Expert Solution

a.

Year

0 1 2 3 4 5 6 7 8 9 10
Additional sales revenue 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00
Additional operating costs 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00
Depreciation per annum 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00 15,840.00 0.00 0.00 0.00 0.00
PBT 15,000.00 -18,000.00 17,200.00 38,320.00 38,320.00 54,160.00 70,000.00 70,000.00 70,000.00 70,000.00
Tax @ 40% 6,000.00 -7,200.00 6,880.00 15,328.00 15,328.00 21,664.00 28,000.00 28,000.00 28,000.00 28,000.00
PAT 9,000.00 -10,800.00 10,320.00 22,992.00 22,992.00 32,496.00 42,000.00 42,000.00 42,000.00 42,000.00
Cash flows:
Year 0 1 2 3 4 5 6 7 8 9 10
PAT 0.00 9,000.00 -10,800.00 10,320.00 22,992.00 22,992.00 32,496.00 42,000.00 42,000.00 42,000.00 42,000.00
Add: Depreciation 0.00 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00 15,840.00 0.00 0.00 0.00 0.00
Initial capital investment -275,000.00
W.Capital requirement -22,500.00 22,500.00
Salvage net of tax 7,500.00
Net cash flows -275,000.00 41,500.00 77,200.00 63,120.00 54,672.00 54,672.00 48,336.00 42,000.00 42,000.00 42,000.00 72,000.00
PVF @ 10% 1.0000 0.9091 0.8264 0.7513 0.6830 0.6209 0.5645 0.5132 0.4665 0.4241 0.3855
PV -275,000.00 37,727.27 63,801.65 47,422.99 37,341.71 33,947.01 27,284.41 21,552.64 19,593.31 17,812.10 27,759.12
NPV 59,242

WN-1:

Depreciation schedule
Year Rate of Dep. Amount
1 20.00% 55000
2 32.00% 88000
3 19.20% 52800
4 11.52% 31680
5 11.52% 31680
6 5.76% 15840

WN-2: Salvage net of tax:

Profit on sale = Salvage value- book value = 12500-0 = 12500

Tax on profit = 12500*0.40 = 5000

Salvage,net of tax = 12500-5000 = 7500

Since the NPV>0, the new machine should be purchased.

b)

Year Net cash flows PVF @ 12% PV
0 -275,000.00 1.0000 -275,000.00
1 41,500.00 0.8929 37,053.57
2 77,200.00 0.7972 61,543.37
3 63,120.00 0.7118 44,927.57
4 54,672.00 0.6355 34,745.04
5 54,672.00 0.5674 31,022.36
6 48,336.00 0.5066 24,488.52
7 42,000.00 0.4523 18,998.67
8 42,000.00 0.4039 16,963.10
9 42,000.00 0.3606 15,145.62
10 72,000.00 0.3220 23,182.07
NPV 33,069.89

Since the NPVis still >0, the new machine should be purchased.

c)

Year 0 1 2 3 4 5
Additional sales revenue 125,000.00 125,000.00 125,000.00 125,000.00 125,000.00
Additional operating costs 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00
Depreciation per annum 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00
PBT 15,000.00 -18,000.00 17,200.00 38,320.00 38,320.00
Tax @ 40% 6,000.00 -7,200.00 6,880.00 15,328.00 15,328.00
PAT 9,000.00 -10,800.00 10,320.00 22,992.00 22,992.00
Cash flows:
Year 0 1 2 3 4 5
PAT 0.00 9,000.00 -10,800.00 10,320.00 22,992.00 22,992.00
Add: Depreciation 0.00 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00
Initial capital investment -275,000.00
W.Capital requirement -22,500.00 22,500.00
Salvage net of tax 25,086.00
Net cash flows -275,000.00 41,500.00 77,200.00 63,120.00 54,672.00 102,258.00
PVF @ 10% 1.0000 0.9091 0.8264 0.7513 0.6830 0.6209
PV -275,000.00 37,727.27 63,801.65 47,422.99 37,341.71 63,494.17
NPV -25,212


WN-1: Since life of the equipment is only 5 years, the depreciation will be charges till year 5:Since the NOV is now -ve, the prjoect is not profitable and should npt be selected.

Depreciation schedule
Year Rate of Dep. Amount
1 20.00% 55,000.00
2 32.00% 88,000.00
3 19.20% 52,800.00
4 11.52% 31,680.00
5 11.52% 31,680.00
259,160.00

WN-2: Salvage net of tax:

Book value = 260000+15000-259160 = 15840

Profit on sale = 31250-15840 = 15410

Tax on profit = 15410*0.40 = 6164.00

Salvage net of tax = 31250-6164 = 25086

d)

Year 0 1 2 3 4 5 6 7 8 9 10
Additional sales revenue 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00 105,000.00
Additional operating costs 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00 55,000.00
Depreciation per annum 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00 15,840.00 0.00 0.00 0.00 0.00
PBT -5,000.00 -38,000.00 -2,800.00 18,320.00 18,320.00 34,160.00 50,000.00 50,000.00 50,000.00 50,000.00
Tax @ 40% -2,000.00 -15,200.00 -1,120.00 7,328.00 7,328.00 13,664.00 20,000.00 20,000.00 20,000.00 20,000.00
PAT -3,000.00 -22,800.00 -1,680.00 10,992.00 10,992.00 20,496.00 30,000.00 30,000.00 30,000.00 30,000.00
Cash flows:
Year 0 1 2 3 4 5 6 7 8 9 10
PAT 0.00 -3,000.00 -22,800.00 -1,680.00 10,992.00 10,992.00 20,496.00 30,000.00 30,000.00 30,000.00 30,000.00
Add: Depreciation 0.00 55,000.00 88,000.00 52,800.00 31,680.00 31,680.00 15,840.00 0.00 0.00 0.00 0.00
Initial capital investment -275,000.00
W.Capital requirement -22,500.00 22,500.00
Salvage net of tax 7,500.00
Net cash flows -275,000.00 29,500.00 65,200.00 51,120.00 42,672.00 42,672.00 36,336.00 30,000.00 30,000.00 30,000.00 60,000.00
PVF @ 10% 1.0000 0.9091 0.8264 0.7513 0.6830 0.6209 0.5645 0.5132 0.4665 0.4241 0.3855
PV -275,000.00 26,818.18 53,884.30 38,407.21 29,145.55 26,495.95 20,510.72 15,394.74 13,995.22 12,722.93 23,132.60
NPV -14,493

Since the NPV is now negetive, the project is not profitable.


Related Solutions

The Redding Co has sales of $116,097, operating costs of  $68,608, depreciation of $15,000, and debt of...
The Redding Co has sales of $116,097, operating costs of  $68,608, depreciation of $15,000, and debt of $9,000 for which it pays 8% interest. If it is paying taxes at 35% what is its net income?  
Pina Colada Corporation had net sales revenue of $5,860,000 and investment revenue of $220,000 for the...
Pina Colada Corporation had net sales revenue of $5,860,000 and investment revenue of $220,000 for the year ended December 31, 2020. Other items pertaining to 2020 were as follows: Cost of goods sold $4,610,000 Salaries and wages expense (sales) 450,000 Advertising expense 122,000 Entertainment expense 81,000 Selling expenses 653,000 Salaries and wages expense (administrative) 297,000 Rent expense 100,000 Utilities expense 45,000 Administrative expenses 442,000 Increase in value of company reputation 70,000 Unrealized gain on value of patents 35,000 Interest expense...
The cooker will increase sales by $9,300 per year and will cut annual operating costs by...
The cooker will increase sales by $9,300 per year and will cut annual operating costs by $13,200. The system will cost $45,900 to purchase and install. This system is expected to have a 5-year life and will be depreciated to zero using straight-line depreciation and have no salvage value. The tax rate is 35 percent and the required return is 10.7 percent. What is the NPV of purchasing the pressure cooker?
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000  ...
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000   0 50   15,000   10,500   25,500   15,000 100   15,000   21,000   36,000   30,000 150   15,000   31,500   46,500   45,000 200   15,000   42,000   57,000   60,000 250   15,000   52,500   67,500   75,000 300   15,000   63,000   78,000   90,000 Create a CVP graph.
Sugar Land Inc. recently reported $15,000 of sales, $7,500 of operating costs other than depreciation, and...
Sugar Land Inc. recently reported $15,000 of sales, $7,500 of operating costs other than depreciation, and $1,200 of depreciation. The company had no amortization charges, it had outstanding $6,500 of bonds that carry a 6.25% interest rate, and its federal-plus-state income tax rate was 35%. How much was the firm's net income after taxes? a. $3,284.55 b.$3,457.42 c.$3,639.39 d.$3,830.94 e.$4,022.48
Year 0 1 Revenue 600.00 Fixed costs 100.00 Variable costs 200.00 Additional investment in NWC 10.00...
Year 0 1 Revenue 600.00 Fixed costs 100.00 Variable costs 200.00 Additional investment in NWC 10.00 Additional investment in operating long-term assets 70.00 Depreciation 60.00 Interest expenses 35.00 Newly issued debt 25.00 Principle repayments 15.00 Tax rate 0.40 Market value of the firm: Price per share No. of shares Market value Short-term debt 100.00 Long-term debt 600.00 Preferred stock 10.00 10 100.00 Common stock, equity 18.00 100 1,800.00 Total 2,600.00 Cost of equity (Rs) 0.1500 Growth rate per year from...
Year 0 1 Revenue 600.00 Fixed costs 100.00 Variable costs 200.00 Additional investment in NWC 10.00...
Year 0 1 Revenue 600.00 Fixed costs 100.00 Variable costs 200.00 Additional investment in NWC 10.00 Additional investment in operating long-term assets 70.00 Depreciation 60.00 Interest expenses 35.00 Newly issued debt 25.00 Principle repayments 15.00 Tax rate 0.40 Market value of the firm: Price per share No. of shares Market value Short-term debt 100.00 Long-term debt 600.00 Preferred stock 10.00 10 100.00 Common stock, equity 18.00 100 1,800.00 Total 2,600.00 Cost of equity (Rs) 0.1500 Growth rate per year from...
Question 1 Revenues Revenue from sales of goods and services .......................... $100,000,000 Operating costs and expenses:...
Question 1 Revenues Revenue from sales of goods and services .......................... $100,000,000 Operating costs and expenses: Cost of products and services sold ....................................... $30,000,000 Selling expenses ................................................................... $3,000,000 Administrative expense ........................................................ $4,000,000 Total operating costs and expenses ............................... $37,000,000 Income from operations.............................................................. $63,000,000 Interest expense (corporate bonds & loans) ............................... $500,000 Non-recurring expense (Legal expenses/fines in settling a federal antitrust suit .............................................. $100,000 Income taxes ............................................................................... $740,000 Net income ................................................................................. $61,660,000 During this year of operation, Bonus Realty owned and...
Sales Revenue                                     54670000 Cash Operating C
Sales Revenue                                     54670000 Cash Operating Costs                         47562900 Depreciation                                        3513000 Total Operating Costs                         51075900 Operating Income EBIT                     3594100 Interest Expenses                                623000 Taxable Income                                   2971100 Taxes                                                   1188440 Deferred Income                                 171500 Net Income                                         1611160 Using a Cash flow statement for the year, Explain how Greg would sum up the company’s cash position?
An increase in price will result in no change in total revenue if: * A) the...
An increase in price will result in no change in total revenue if: * A) the percentage change in price is large enough to cause quantity demanded to fall to zero. B) the coefficient of elasticity is equal to zero. C) the percentage change in quantity demanded is equal to the percentage change in price (in absolute values). D) the demand function is perfectly elastic. Assume the demand for a good is price inelastic, i.e., ed < 1 (in absolute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT