Hi could someone help answer the Foundation 15 (1-15) attached, please place the answers in excel with the formula. Thank you for the help!

REVIEW PROBLEM: COMPARISON OF CAPITAL BUDGETING METHODS Lamar Company is considering a project that would have an eight-year life and require a $2,400,000 investment in equipment. At the end of eight years, the project would terminate and the equipment would have no salvage value. The project would provide net operating income each year as follows: The company's discount rate is 12%. Required: 1. Compute the annual net cash inflow from the project. 2. Compute the project's net present value. Is the project acceptable? 3. Compute the project's payback period. 4. Compute the project's simple rate of return. Solution to Review Problem 1. The annual net cash inflow can be computed by deducting the cash expenses from sales: Or the annual net cash inflow can be computed by adding depreciation back to net operating income: 2. The net present value is computed as follows: Yes, the project is acceptable because it has a positive net present value. 3. The formula for the payback period is: Page 514 4. The formula for the simple rate of return is: THE FOUNDATIONAL 15 Cardinal Company is considering a project that would require a $2,975,000 investment in equipment with a useful life of five years. At the end of five years, the project would terminate and the equipment would be sold for its salvage value of $300,000. The company's discount rate is 14%. The project would provide net operating income each year as follows: Required: 1. Which item(s) in the income statement shown above will not affect cash flows? 2. What are the project's annual net cash inflows? 3. What is the present value of the project's annual net cash inflows? 4. What is the present value of the equipment's salvage value at the end of five years? 5. What is the project's net present value? 6. What is the project profitability index for this project? (Round your answer to the nearest whole percent.) 7. What is the project's payback period? 8. What is the project's simple rate of return for each of the five years? 9. If the company's discount rate was 16% instead of 14%, would you expect the project's net present value to be higher than, lower than, or the same as your answer to question 4? No computations are necessary 10. If the equipment's salvage value was $500,000 instead of $300,000, would you expect the project's payback period to be higher than, lower than, or the same as your answer to question 7? No computations are necessary. 11. If the equipment's salvage value was $500,000 instead of $300,000, would you expect the project's net present value to be higher than, lower than, or the same as your answer to question 4? No computations are necessary. 12. Page 517 If the equipment's salvage value was $500,000 instead of $300,000, what would be the project's simple rate of return? 13. Assume a postaudit showed that all estimates (including total sales) were exactly correct except for the variable expense ratio, which actually turned out to be 45%. What was the project's actual net present value? 14. Assume a postaudit showed that all estimates (including total sales) were exactly correct except for the variable expense ratio, which actually turned out to be 45%. What was the project's actual payback period? 15. Assume a postaudit showed that all estimates (including total sales) were exactly correct except for the variable expense ratio, which actually turned out to be 45%. What was the project's actual simple rate of return? EXERCISES EXERCISE 11-1 Net Present Value Method [LO1] The management of Opry Company, a wholesale distributor of suntan products, is considering the purchase of a $25,000 machine that would reduce operating costs in its warehouse by $4,000 per year. At the end of the machine's 10-year useful life, it will have no scrap value. The company's required rate of return is 12%. Required: (Ignore income taxes.) 1. Determine the net present value of the investment in the machine. 2. What is the difference between the total, undiscounted cash inflows and cash outflows over the entire life of the machine? EXERCISE 11-2 Preference Ranking [LO2] Information on four investment proposals is given below: Required: 1. Compute the project profitability index for each investment proposal. 2. Rank the proposals in terms of preference. EXERCISE 11-3 Payback Method [LO3] The management of Weimar, Inc., a civil engineering design company, is considering an investment in a high-quality blueprint printer with the following cash flows: Required: 1. Determine the payback period of the investment. 2. Would the payback period be affected if the cash inflow in the last year were several times larger? EXERCISE 11-4 Simple Rate of Return Method [LO4] The management of Wallingford MicroBrew is considering the purchase of an automated bottling machine for $80,000. The machine would replace an old piece of equipment that costs $33,000 per year to operate. The new machine would cost $10,000 per year to operate. The old machine currently in use could be sold now for a scrap value of $5,000. The new machine would have a useful life of 10 years with no salvage value. Required: Compute the simple rate of return on the new automated bottling machine. EXERCISE 11-5 Payback Period and Simple Rate of Return [LO3, LO4] The Heritage Amusement Park would like to construct a new ride called the Sonic Boom, which the park management feels would be very popular. The ride would cost $450,000 to construct, and it would have a 10% salvage value at the end of its 15-year useful life. The company estimates that the following annual costs and revenues would be associated with the ride: Required: (Ignore income taxes.) 1. Assume that the Heritage Amusement Park will not construct a new ride unless the ride provides a payback period of six years or less. Does the Sonic Boom ride satisfy this requirement? 2. Compute the simple rate of return promised by the new ride. If Heritage Amusement Park requires a simple rate of return of at least 12%, does the Sonic Boom ride meet this criterion? EXERCISE 11-6 Comparison of Projects Using Net Present Value [LO1] Sharp Company has $15,000 to invest. The company is trying to decide between two alternative uses of the funds as follows: Sharp Company uses a 16% discount rate. Required: (Ignore income taxes.) Which investment would you recommend that the company accept? Show all computations using net present value. Prepare separate computations for each investment. Page 519 EXERCISE 11-7 Basic Payback Period and Simple Rate of Return Computations [LO3, L04] Martin Company is considering the purchase of a new piece of equipment. Relevant information concerning the equipment follows: Required: (Ignore income taxes.) 1. Compute the payback period for the equipment. If the company rejects all proposals with a payback period of more than four years, would the equipment be purchased? 2. Compute the simple rate of return on the equipment. Use straight-line depreciation based on the equipment's useful life. Would the equipment be purchased if the company's required rate of return is 14%? EXERCISE 11-8 Net Present Value Analysis of Two Alternatives [LO1] Wriston Company has $300,000 to invest. The company is trying to decide between two alternative uses of the funds. The alternatives are as follows: The working capital needed for project B will be released for investment elsewhere at the end of seven years. Wriston Company uses a 20% discount rate. Required: (Ignore income taxes.) Which investment alternative (if either) would you recommend that the company accept? Show all computations using the net present value format. Prepare separate computations for each project. EXERCISE 11-9 Basic Net Present Value Analysis [LO1] On January 2, Fred Critchfield paid $18,000 for 900 shares of the common stock of Acme Company. Mr. Critchfield received an $0.80 per share dividend on the stock at the end of each year for four years. At the end of four years, he sold the stock for $22,500. Mr. Critchfield has a goal of earning a minimum return of 12% on all of his investments. Required: (Ignore income taxes.) Did Mr. Critchfield earn a 12% return on the stock? Use the net present value method and the general format shown in Exhibit 11-2. Round all computations to the nearest whole dollar. PROBLEMS PROBLEM 11-10A Basic Net Present Value Analysis [LO1] Renfree Mines, Inc., owns the mining rights to a large tract of land in a mountainous area. The tract contains a mineral deposit that the company believes might be commercially attractive to mine and sell. An engineering and cost analysis has been made, and it is expected that the following cash flows would be associated with opening and operating a mine in the area: The mineral deposit would be exhausted after five years of mining. At that point, the working capital would be released for reinvestment elsewhere. The company's required rate of return is 14%. Required: (Ignore income taxes.) Determine the net present value of the proposed mining project. Should the project be accepted? Explain. PROBLEM 11-11A Preference Ranking of Investment Projects [LO2] Austin Company is investigating four different investment opportunities. Information on the four projects under study is given below: Because the company's required rate of return is 10%, a 10% discount rate has been used in the above present value computations. Limited funds are available for investment, so the company can't accept all of the available projects. Required: 1. Compute the project profitability index for each investment project. 2. Rank the four projects according to preference, in terms of: a. Net present value. b. Project profitability index. c. Internal rate of return. 3. Which ranking do you prefer? Why? PROBLEM 11-12A Preference Ranking of Investment Projects [LO2] Yancey Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows: The net present values above have been computed using a 10% discount rate. The company wants your assistance in determining which project to accept first, which to accept second, and so forth. The company's investment funds are limited. Required: 1. Compute the project profitability index for each project. 2. In order of preference, rank the four projects in terms of: a. Net present value. b. Project profitability index. c. Internal rate of return. 3. Which ranking do you prefer? Why? PROBLEM 11-13A Simple Rate of Return; Payback [LO3, LO4] Lugano's Pizza Parlor is considering the purchase of a large oven and related equipment for mixing and baking \"crazy bread.\" The oven and equipment would cost $120,000 delivered and installed. It would be usable for about 15 years, after which it would have a 10% scrap value. The following additional information is available: a. Mr. Lugano estimates that purchase of the oven and equipment would allow the pizza parlor to bake and sell 72,000 loaves of crazy bread each year. The bread sells for $1.25 per loaf. b. The cost of the ingredients in a loaf of bread is 40% of the selling price. Mr. Lugano estimates that other costs each year associated with the bread would be as follows: salaries, $18,000; utilities, $9,000; and insurance, $3,000. c. The pizza parlor uses straight-line depreciation on all assets, deducting salvage value from original cost. Required: (Ignore income taxes.) 1. Prepare a contribution format income statement showing the net operating income each year from production and sale of the crazy bread. 2. Compute the simple rate of return for the new oven and equipment. If a simple rate of return above 12% is acceptable to Mr. Lugano, will he purchase the oven and equipment? 3. Compute the payback period on the oven and equipment. If Mr. Lugano purchases any equipment with less than a six-year payback, will he purchase this equipment? PROBLEM 11-14A Basic Net Present Value Analysis [LO1] Doughboy Bakery would like to buy a new machine for putting icing and other toppings on pastries. These are now put on by hand. The new machine that the bakery is considering costs $90,000. It would last the bakery for eight years but would require a $7,500 overhaul at the end of the fifth year. After eight years, the machine could be sold for $6,000. The bakery estimates that it will cost $14,000 per year to operate the new machine. The present manual method of putting toppings on the pastries costs $35,000 per year. In addition to reducing operating costs, the new machine will allow the bakery to increase its production of pastries by 5,000 packages per year. The bakery realizes a contribution margin of $0.60 per package. The bakery requires a 16% return on all investments in equipment. Required: (Ignore income taxes.) 1. What are the annual net cash inflows that will be provided by the new machine? 2. Compute the new machine's net present value. Use the incremental cost approach, and round all dollar amounts to the nearest whole dollar