please include excel functions for each answer.

Problem 8-15 Complete the steps below using cell references to given data or previsus calculations. In some cases, a sleple cell reference is all you need. To apy/paste a forma across a rew or down a coluse, an shealsts cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be the directions will specify the use of that function. De out type in narical data into a call or faction, Instead, make a reference to the call is which the data is found. Make year computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the dets in your formales, sually the Gives Ista section. Beryl's lood Teacurily res a bouling machine for $10,000 per year, including all and is comparing two option stan is considering thing chil and expenses and will lower & Punase the chine it is nestly resting for $150,000 This machine will require 320.000 per yee is ongoing ma Pune, more advanced machine for 1250,000. This machine will quire $15,000 per year in enging bottling by $10,000 per year Ales, $15,000 will be spent upboet in aning the rice operator besuche Suppose the appropriate discount rate is per year and the machine is purchased today Maintmace and boning coats are paid at the end of each year, i the real of the machine. Assime also that the machines will be depreciated via the straight line mehed over seven years and that they h with a negligible salvage value. The marginal comporte tas rate is 35% Should Beryl's lood Texceto sent, pinche its came machine, advanced machine 16-y life the Discutate Taxa 31% Useful life (years) Rest Machine Year 1 Your Your 3 Year 4 Rest Year 5 -450,000 $32,000 PCF NPV Purchase Cut Machine Maintance -$10.000 Depreciation Capital Expenditures FCF (purchase coment) kary Punta Advanced Machine Maintena 315.000 SIAP Other Couta Depreciation Capital Expeditar FCF (phase advanced) NPV Beryl's leed Tes should Year -$150,000 -$35,000 -$250.000 550,000 $32,500 -320,000 415,000 $10,000 0.000 432.560 320,000 $15.000 SI -$50,000 437,500 -$20,000 $15.000 $10,000 550.300 531,300 -520.000 $15.000 SIRAS Your 550.000 -$37.500 -424.000 415,000 SEDE Year 7 550.000 413.000 37000 -415.000 $10,000 Year 450.00 A10 410.000 STAPHE SIA Year -$50,000 KTM 420,300 $15.33 STEPH Tur -450,000 412,204 -416M ALLAN SIEM Requirements 1 5 5 7 M 2 U 1 33 1. Start Excel-completed. 2. In cell E15, by using cell references, calculate the free cash flow for year I in case of renting the machine (1 pt.). 3. To calculate the free cash flows for years 2 through 10 in case of renting the machine, copy cell E15 and paste it onto cells FIS:N15 (1 pt.). 4. In cell D16, by using cell references and the function NPV, calculate the net present value of renting the machine (1 pt.). 5. In cell E20, by using cell references, calculate the depreciation of the current machine for year 1 (1 pt.). 6. To calculate the depreciation of the current machine for years 2 through 7, copy cell E20 and paste it onto cells F20:K20 (1 pt.). 7. In cell D22, by using a cell reference, calculate the free cash flow for year 0 in case of purchasing the current machine (1 pt.). 8. In cell E22, by using cell references, calculate the free cash flow for year 1 in case of purchasing the current machine (1 pt.). 9. To calculate the free cash flows for years 2 through 10 in case of purchasing the current machine, copy cell E22 and paste it onto cells F22:N22 (1 pt.). 10. In cell D23, by using cell references and the function NPV, calculate the net present value of purchasing the current machine (1 pt.). 11. In cell E28, by using cell references, calculate the depreciation of the advanced machine for year 1 (1 pt.). 12. To calculate the depreciation of the advanced machine for years 2 through 7, copy cell E28 and paste it onto cells F28:K28 (1 pt.). 13. In cell D30, by using cell references, calculate the free cash flow for year 0 in case of purchasing the advanced machine (1 pt.). 14. To calculate the free cash flows for years 2 through 10 in case of purchasing the advanced machine, copy cell D30 and paste it onto cells E30:N30 (1 pt.). 15. In cell D31, by using cell references and the function NPV, calculate the net present value of purchasing the advanced machine (1 pt.). 16. In cells D33-E33, select from the dropdown whether Beryl's Iced Tea should continue to rent, purchase its current machine, or purchase the advanced machine (1 pt.). 17. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. Problem 8-15 Complete the steps below using cell references to given data or previsus calculations. In some cases, a sleple cell reference is all you need. To apy/paste a forma across a rew or down a coluse, an shealsts cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be the directions will specify the use of that function. De out type in narical data into a call or faction, Instead, make a reference to the call is which the data is found. Make year computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the dets in your formales, sually the Gives Ista section. Beryl's lood Teacurily res a bouling machine for $10,000 per year, including all and is comparing two option stan is considering thing chil and expenses and will lower & Punase the chine it is nestly resting for $150,000 This machine will require 320.000 per yee is ongoing ma Pune, more advanced machine for 1250,000. This machine will quire $15,000 per year in enging bottling by $10,000 per year Ales, $15,000 will be spent upboet in aning the rice operator besuche Suppose the appropriate discount rate is per year and the machine is purchased today Maintmace and boning coats are paid at the end of each year, i the real of the machine. Assime also that the machines will be depreciated via the straight line mehed over seven years and that they h with a negligible salvage value. The marginal comporte tas rate is 35% Should Beryl's lood Texceto sent, pinche its came machine, advanced machine 16-y life the Discutate Taxa 31% Useful life (years) Rest Machine Year 1 Your Your 3 Year 4 Rest Year 5 -450,000 $32,000 PCF NPV Purchase Cut Machine Maintance -$10.000 Depreciation Capital Expenditures FCF (purchase coment) kary Punta Advanced Machine Maintena 315.000 SIAP Other Couta Depreciation Capital Expeditar FCF (phase advanced) NPV Beryl's leed Tes should Year -$150,000 -$35,000 -$250.000 550,000 $32,500 -320,000 415,000 $10,000 0.000 432.560 320,000 $15.000 SI -$50,000 437,500 -$20,000 $15.000 $10,000 550.300 531,300 -520.000 $15.000 SIRAS Your 550.000 -$37.500 -424.000 415,000 SEDE Year 7 550.000 413.000 37000 -415.000 $10,000 Year 450.00 A10 410.000 STAPHE SIA Year -$50,000 KTM 420,300 $15.33 STEPH Tur -450,000 412,204 -416M ALLAN SIEM Requirements 1 5 5 7 M 2 U 1 33 1. Start Excel-completed. 2. In cell E15, by using cell references, calculate the free cash flow for year I in case of renting the machine (1 pt.). 3. To calculate the free cash flows for years 2 through 10 in case of renting the machine, copy cell E15 and paste it onto cells FIS:N15 (1 pt.). 4. In cell D16, by using cell references and the function NPV, calculate the net present value of renting the machine (1 pt.). 5. In cell E20, by using cell references, calculate the depreciation of the current machine for year 1 (1 pt.). 6. To calculate the depreciation of the current machine for years 2 through 7, copy cell E20 and paste it onto cells F20:K20 (1 pt.). 7. In cell D22, by using a cell reference, calculate the free cash flow for year 0 in case of purchasing the current machine (1 pt.). 8. In cell E22, by using cell references, calculate the free cash flow for year 1 in case of purchasing the current machine (1 pt.). 9. To calculate the free cash flows for years 2 through 10 in case of purchasing the current machine, copy cell E22 and paste it onto cells F22:N22 (1 pt.). 10. In cell D23, by using cell references and the function NPV, calculate the net present value of purchasing the current machine (1 pt.). 11. In cell E28, by using cell references, calculate the depreciation of the advanced machine for year 1 (1 pt.). 12. To calculate the depreciation of the advanced machine for years 2 through 7, copy cell E28 and paste it onto cells F28:K28 (1 pt.). 13. In cell D30, by using cell references, calculate the free cash flow for year 0 in case of purchasing the advanced machine (1 pt.). 14. To calculate the free cash flows for years 2 through 10 in case of purchasing the advanced machine, copy cell D30 and paste it onto cells E30:N30 (1 pt.). 15. In cell D31, by using cell references and the function NPV, calculate the net present value of purchasing the advanced machine (1 pt.). 16. In cells D33-E33, select from the dropdown whether Beryl's Iced Tea should continue to rent, purchase its current machine, or purchase the advanced machine (1 pt.). 17. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed