# Use the model in Spreadsheet C10 to solve this problem. (Attached in the file up

Use the model in Spreadsheet C10 to solve this problem. (Attached in the file uploads) Please look over the instructions in the file as well.
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 in Appendix 10A 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 (excluding depreciation) 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.
What is the NPV of this expansion project? Should GSB purchase the new machine?
Suppose GSB’s required rate of return is 12 percent rather than 10 percent. Also, assume the operating expenses increase by \$65,000 rather than \$55,000. Should the new machine be purchased in this case?
Should GSB purchase the new machine if it is expected to be used for only five years and then sold for \$31,250? Assume the conditions are the same as originally presented. (Note that the model is set up to handle a five-year life; you need to enter only the new life and salvage value.)
Would the machine be profitable if revenues increased by only \$105,000 per year? Assume everything else is as originally presented in part (a).
Suppose 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.