Sreps To Success: Level 2 The Equipment division at TheZone is looking into a new piece of equipmeit tho developed in Furope es mold skis mote precisely and less expensively than the technology being used at TheZone, The cost of the machinc plus installation is exped the be $10.00 folm Complete the following: 1. Open the workbook named Ski.xisx in the Chapter 6 folder, and then tave the co. as Ski Molder Cash Flow Estimate, dsx. The structure for the Projected aste the Figure 6.26: Woricsheet for ski molder projected cash flow estimate 2. Rename the Sheetl worksheet as cashflow. Insert the following title at the top of th: worksheet, merged and centered: Ski Molding Project - Projected 4-Year Cish Flow Estimate. 3. Enter the sales volume for each year, assuming sales in year 1 of 140,000 pain. The sales volume for each successive year is assumed to be 5% more than the previous yee Round your calculated sales volumes to the nearest whole number. 4. Enter the cost savings as $10.00 per pair, which will be the same amount in the sabb. sequent years. 5. Calculate the cost savings as the number of pairs of skis sold multiplied by the coe savings per ski. 6. On a separate worksheet named loan (similar to the Loan worksheet shown it Figure 6.15 ), create an amortization table listing the principal and interest paymens and remaining principal in each monthly period, assuming TheZone will borrow th money under the following terms: 1. 00 the sachiflow worksheet, calculate the cumulative infereot expente foe yrae 1 (the imerest portion of the loan payments for the cerreyoonding year . Aweatere the 550000 at the end of that period. Foe cont, he 8 year life with a whipe walue of betion. Set up a separate worksheet named depreciation to itote machine plus instal. w the depreciation worksheet shown in Figare 6.19), and ase thesed valoes (simiter firmalit. Q. Calculate the net cost savingh-the cost switsps less the interet expense and defiecciation. 10. Calculate the additional tax that would be owed (based on the net cost uvman asuming that Theilone is taxed at a 355 rate. Use a global named range to itore this value- 11. Calculate the savings after taxes 12. Complete the worksheet, adding back in the depreciation that was dedocted and ading in the cumulative principal payments for the correyooding year, to arrive at a firsal projected cash flow estimate for each of the foo yean. Wse the cotrect ahsolute athd relative cell referencing so that your formulas will work fot cach of the caih Abwyears. 13. Slapping several rows under the data, inclede a sentence summarizing whether of thot the cost of this machine will be reconered based on the Projected Cash Fow Eatinute oner the four years. Highlight your analysis in a light bliec coot. 14. Nidd titles on each workshect, and format them to make them casy to sead and understarid. 15. Sue and close the Slki Molder Cash Flow Estimate alax workbook: LEVEL 3 Evaluating the Financial Viability of Alternative Project Options Setting Up a Worksheet to Analyze Profitability Bizn has now estimated the cash flow for the manufacture of the T7Edge shoc according to the terms of the option 1 loan, which requires 51,000,000 in capital fanded throughi has from Ctrbank at 8% interest compounded quarterty. This cash flow sgreadshect will Eve the company an excellent idea of what funds will be necded when, and at what time Sreps To Success: Level 2 The Equipment division at TheZone is looking into a new piece of equipmeit tho developed in Furope es mold skis mote precisely and less expensively than the technology being used at TheZone, The cost of the machinc plus installation is exped the be $10.00 folm Complete the following: 1. Open the workbook named Ski.xisx in the Chapter 6 folder, and then tave the co. as Ski Molder Cash Flow Estimate, dsx. The structure for the Projected aste the Figure 6.26: Woricsheet for ski molder projected cash flow estimate 2. Rename the Sheetl worksheet as cashflow. Insert the following title at the top of th: worksheet, merged and centered: Ski Molding Project - Projected 4-Year Cish Flow Estimate. 3. Enter the sales volume for each year, assuming sales in year 1 of 140,000 pain. The sales volume for each successive year is assumed to be 5% more than the previous yee Round your calculated sales volumes to the nearest whole number. 4. Enter the cost savings as $10.00 per pair, which will be the same amount in the sabb. sequent years. 5. Calculate the cost savings as the number of pairs of skis sold multiplied by the coe savings per ski. 6. On a separate worksheet named loan (similar to the Loan worksheet shown it Figure 6.15 ), create an amortization table listing the principal and interest paymens and remaining principal in each monthly period, assuming TheZone will borrow th money under the following terms: 1. 00 the sachiflow worksheet, calculate the cumulative infereot expente foe yrae 1 (the imerest portion of the loan payments for the cerreyoonding year . Aweatere the 550000 at the end of that period. Foe cont, he 8 year life with a whipe walue of betion. Set up a separate worksheet named depreciation to itote machine plus instal. w the depreciation worksheet shown in Figare 6.19), and ase thesed valoes (simiter firmalit. Q. Calculate the net cost savingh-the cost switsps less the interet expense and defiecciation. 10. Calculate the additional tax that would be owed (based on the net cost uvman asuming that Theilone is taxed at a 355 rate. Use a global named range to itore this value- 11. Calculate the savings after taxes 12. Complete the worksheet, adding back in the depreciation that was dedocted and ading in the cumulative principal payments for the correyooding year, to arrive at a firsal projected cash flow estimate for each of the foo yean. Wse the cotrect ahsolute athd relative cell referencing so that your formulas will work fot cach of the caih Abwyears. 13. Slapping several rows under the data, inclede a sentence summarizing whether of thot the cost of this machine will be reconered based on the Projected Cash Fow Eatinute oner the four years. Highlight your analysis in a light bliec coot. 14. Nidd titles on each workshect, and format them to make them casy to sead and understarid. 15. Sue and close the Slki Molder Cash Flow Estimate alax workbook: LEVEL 3 Evaluating the Financial Viability of Alternative Project Options Setting Up a Worksheet to Analyze Profitability Bizn has now estimated the cash flow for the manufacture of the T7Edge shoc according to the terms of the option 1 loan, which requires 51,000,000 in capital fanded throughi has from Ctrbank at 8% interest compounded quarterty. This cash flow sgreadshect will Eve the company an excellent idea of what funds will be necded when, and at what time