Review closely

EXCEL Module 3 Practical Exercise You oversee a young and growing business. You have identified the various factors sources of revenue and expenses) that influence the business as shown in the table below. Use the figures provided and the layout to create a financial projection model for the business for the next six years. The parameters are given on Table 2 as Assumptions. Table 1: INCOME AND EXPENSES PROJECTIONS 8 888888 8 8 8 8 8 88888888888 1352 Exercise Instructions. (i). Create a new worksheet named W7-PE-M 3-Your Name (ii). Enter all the tries and texts (iii). Create the Table 2 since Row 35 with the title Assumption (iv). Calculate the Sales for the Year 1 in B4 and for the other years using the percentage given in the rowc (V). Calculate the different items that make up the Total Operating costs using the parameters in the Assumption sheet and the Description provided (Use Absolute Referencing effectively as learned in the Module 3 of the Book) (vi). Calculate Total Cost of Goods Sold - Materials + Wages Other Benefits Other (vii). Calculate the Total Operating costs - Total Cost of Goods Sold Total General and Administrative Expenses. (viii). Calculate the interest on Loans (Check the Description for Interest of Loans Assumption-cell CAS) b) Calculate the Pre-tax income Sales - Total Operating cost-interest on Loans 1x). Calculate the Tax Check the Description for Tax Assumption-cell 49 and Cell CSO) (Note: Uself Function (xi). Calculate the Profit Pre-tax Income Tax (xii). Format the worksheet as shown in the Table 1. Exercise Instructions. (i). (ii) (iii). (iv) (v) Create a new worksheet named W7-PE-M3-Your Name Enter all the titles and texts Create the Table 2 since Row 35 with the title Assumption. Calculate the Sales for the Year 1 in B4 and for the other years using the percentage given in the row C Cakulate the different items that make up the Total Operating costs using the parameters in the Assumption sheet and the Description provided (Use Absolute Referencing effectively as learned in the Module 3 of the Book). (vi). Calculate Total Cost of Goods Sold - Materials + Wages Other Benefits Other (vid. Calculate the Total Operating costs - Total Cost of Goods Sold Total General and Administrative Expenses. (vii), Cakulate the interest on Loans (Check the Description for Interest of Loans Assumption cell 048) (1x). Cakulate the Pre-tax income Sales - Total Operating cost- terest on Loans (x). Calculate the Tax. (Check the Description for Tax Assumption. Cell C49 and Cell C50) (Note: Use IF Function) (xi). Cakulate the Profit Pre-tax Income Tax. (xii). Format the worksheet as shown in the Table 1. Table 1: 1 of 4 Practical Exerci E l Module Your Name INCOME AND EXPENSES PROJECTIONS Sales $10,000.00 $12,000.00 209 SI5.600.00 S1,720.00 $20.592.00 $22.65110 $1.700.00 52.040.00 $1..00 5252.00 $10.00 52.652.00 52. 14.00 $127.60 52.0 20.0 $210.00 $125.9 00 OLOS 00 ONS 00 SOES 00 OSS $1,100.00 S960.00 $350.20 S300.00 S1.210.00 $1.248.00 $417.86 S390.00 $1,497.60 540.6 5460.00 $1.667.36 552895 5514 BO Advertising Promotions $2,386.00 $2,750.20 $3,315.36 $3,037.46 54.650.7 56.830.20 S8.596.10 S10, 159.75 $11.177.21 10.00 10.00 10.00 10.00 10.00 10.00 56,99.90 59.404.79 $10,345.95 SOGERES $2.01.09 51.03.42 52.213.71 53.00738 53.7661 54,06406 54.440.70 Assume 52.750.20 $3,315.86 S42252 1 of 4 ts $2.386.00 $5.796.00 S883746 $10,159.75 56,8:30.20 10.00 4.650.73 $12.295.21 10.00 30.00 10.00 $11.277.21 10.00 S9.404.79 $8.596.10 10.00 $6,993.30 $3,936.52 53.00738 $5,159.BO S.550.25 $10,345.99 $2,941.09 5.360.73 $2,390.SE $1.803.42 $2,218.71 53.676.61 $4,044.00 54.448.78 Assumption Value Starta 10.000 and grow by percenter 10000 2.100 Start at 100, then Start at 1.000, then by a yearly hy 10 w 2.50 10d bywed amount of 1 of 4 EXCEL Module 3 Practical Exercise You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table below. Use the figures provided and the layout to create a financial projection model for the business for the next six years. The parameters are given on Table 2 as Assumptions Table 1: INCOME AND EXPENSES PROJECTIONS 10.000.00 $12.000.00 $15,000.00 1.720.00 $20.592.00 $22,65120 $1.400.00 52.184.00 15 Salary: Sales 17 Advertising Promotions 18 Depreciation EXCEL Module 3 Practical Exercise You oversee a young and growing business. You have identified the various factors sources of revenue and expenses) that influence the business as shown in the table below. Use the figures provided and the layout to create a financial projection model for the business for the next six years. The parameters are given on Table 2 as Assumptions. Table 1: INCOME AND EXPENSES PROJECTIONS 8 888888 8 8 8 8 8 88888888888 1352 Exercise Instructions. (i). Create a new worksheet named W7-PE-M 3-Your Name (ii). Enter all the tries and texts (iii). Create the Table 2 since Row 35 with the title Assumption (iv). Calculate the Sales for the Year 1 in B4 and for the other years using the percentage given in the rowc (V). Calculate the different items that make up the Total Operating costs using the parameters in the Assumption sheet and the Description provided (Use Absolute Referencing effectively as learned in the Module 3 of the Book) (vi). Calculate Total Cost of Goods Sold - Materials + Wages Other Benefits Other (vii). Calculate the Total Operating costs - Total Cost of Goods Sold Total General and Administrative Expenses. (viii). Calculate the interest on Loans (Check the Description for Interest of Loans Assumption-cell CAS) b) Calculate the Pre-tax income Sales - Total Operating cost-interest on Loans 1x). Calculate the Tax Check the Description for Tax Assumption-cell 49 and Cell CSO) (Note: Uself Function (xi). Calculate the Profit Pre-tax Income Tax (xii). Format the worksheet as shown in the Table 1. Exercise Instructions. (i). (ii) (iii). (iv) (v) Create a new worksheet named W7-PE-M3-Your Name Enter all the titles and texts Create the Table 2 since Row 35 with the title Assumption. Calculate the Sales for the Year 1 in B4 and for the other years using the percentage given in the row C Cakulate the different items that make up the Total Operating costs using the parameters in the Assumption sheet and the Description provided (Use Absolute Referencing effectively as learned in the Module 3 of the Book). (vi). Calculate Total Cost of Goods Sold - Materials + Wages Other Benefits Other (vid. Calculate the Total Operating costs - Total Cost of Goods Sold Total General and Administrative Expenses. (vii), Cakulate the interest on Loans (Check the Description for Interest of Loans Assumption cell 048) (1x). Cakulate the Pre-tax income Sales - Total Operating cost- terest on Loans (x). Calculate the Tax. (Check the Description for Tax Assumption. Cell C49 and Cell C50) (Note: Use IF Function) (xi). Cakulate the Profit Pre-tax Income Tax. (xii). Format the worksheet as shown in the Table 1. Table 1: 1 of 4 Practical Exerci E l Module Your Name INCOME AND EXPENSES PROJECTIONS Sales $10,000.00 $12,000.00 209 SI5.600.00 S1,720.00 $20.592.00 $22.65110 $1.700.00 52.040.00 $1..00 5252.00 $10.00 52.652.00 52. 14.00 $127.60 52.0 20.0 $210.00 $125.9 00 OLOS 00 ONS 00 SOES 00 OSS $1,100.00 S960.00 $350.20 S300.00 S1.210.00 $1.248.00 $417.86 S390.00 $1,497.60 540.6 5460.00 $1.667.36 552895 5514 BO Advertising Promotions $2,386.00 $2,750.20 $3,315.36 $3,037.46 54.650.7 56.830.20 S8.596.10 S10, 159.75 $11.177.21 10.00 10.00 10.00 10.00 10.00 10.00 56,99.90 59.404.79 $10,345.95 SOGERES $2.01.09 51.03.42 52.213.71 53.00738 53.7661 54,06406 54.440.70 Assume 52.750.20 $3,315.86 S42252 1 of 4 ts $2.386.00 $5.796.00 S883746 $10,159.75 56,8:30.20 10.00 4.650.73 $12.295.21 10.00 30.00 10.00 $11.277.21 10.00 S9.404.79 $8.596.10 10.00 $6,993.30 $3,936.52 53.00738 $5,159.BO S.550.25 $10,345.99 $2,941.09 5.360.73 $2,390.SE $1.803.42 $2,218.71 53.676.61 $4,044.00 54.448.78 Assumption Value Starta 10.000 and grow by percenter 10000 2.100 Start at 100, then Start at 1.000, then by a yearly hy 10 w 2.50 10d bywed amount of 1 of 4 EXCEL Module 3 Practical Exercise You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table below. Use the figures provided and the layout to create a financial projection model for the business for the next six years. The parameters are given on Table 2 as Assumptions Table 1: INCOME AND EXPENSES PROJECTIONS 10.000.00 $12.000.00 $15,000.00 1.720.00 $20.592.00 $22,65120 $1.400.00 52.184.00 15 Salary: Sales 17 Advertising Promotions 18 Depreciation