Use the computerized model in File C10 to work this problem.

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. GSBs required rate of return is 10 percent, and its marginal tax rate is 40 percent. The machines 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 GSBs 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.

e.Suppose that revenues rose by $125,000 but expenses rose by $65,000. Would the machine be acceptable under these conditions? Assume a 10-year project life and a salvage value of $12,500.

Chapter 10 Spreadsheet Problem Solutions (C10)Expansion Project1. There are a number of instructions with which you should be familiarto use these computerized models. These instructions appear in aseparate worksheet labeled INSTRUCTIONS. If you have not alreadydone so, you should read these instructions now. To read theseinstructions, click on theworksheet labeled INSTRUCTIONS.2. The model is set up to deal with a situation where the entireinvestment outlay occurs at t=0 and the inflows occur over thesubsequent five to 10 years. Modification of the model would berequired to deal with a shorter or longer time frame.INPUT DATA:KEY OUTPUT:Base price($260,000)NPVModifications($15,000)-6,216Increase in NWC($22,500)Increase in sales revenue220,000Operating costs150,000Salvage value8,500Required rate of return13%Tax rate40%MACRS class life (years)5Useful life (years)8MODEL-GENERATED DATA:Initial investment at t=0:Base price($260,000)Modification($15,000)Increase in NWC($22,500)Initial investment outlay($297,500)Depreciation schedule:Terminal cash flow:Depr. basis =$275,000Salvage value8,500EndingTax on sale of asset(3,400)YearMACRSDepreciationBookReverse of NWC22,500RateAllowanceValueTerminal CF27,60010.2055,000220,00020.3288,000132,00030.1952,25079,75040.1233,00046,75050.1130,25016,50060.0616,5000Annual cash flows:012345678910Initial invest.(297,500)Sales increase220,000220,000220,000220,000220,000220,000220,000220,00000Operating costs(150,000)(150,000)(150,000)(150,000)(150,000)(150,000)(150,000)(150,000)00Depreciation(55,000)(88,000)(52,250)(33,000)(30,250)(16,500)0000Earn. b/f taxes15,000(18,000)17,75037,00039,75053,50070,00070,00000Taxes(6,000)7,200(7,100)(14,800)(15,900)(21,400)(28,000)(28,000)00Net income9,000(10,800)10,65022,20023,85032,10042,00042,00000Add back deprec.55,00088,00052,25033,00030,25016,5000000Supplemental oper. CF64,00077,20062,90055,20054,10048,60042,00042,00000Salvage AT000000027,60000Net cash flow(297,500)64,00077,20062,90055,20054,10048,60042,00069,60000NPV(6,216)