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: Practical Exercise Excel Module 3 Your Name Date G Current Date H rears Year 1 INCOME AND EXPENSES PROJECTIONS Sales $10.000.00 Year 2 $12.000.00 Year 3 $15.600.00 rear 4 Year 5 rear 6 Growth over the previous year 2025 $18.720.00 20%% $20.592.00 $22.65120 10%% 10%% MMaterials Wages $1.700.00 $1,400.00 $2.040.00 Other benefits $210.00 $1,680.00 $2.652.00 $2.184.00 $3.182.40 $3.500.64 $3.850.70 10 #:252.00 $100.00 $:108.00 $327.60 $2.620.80 $2.882.88 $3.171. 17 Others $393. 12 11 $116.64 $:125.97 $432.43 $475.68 1:136.05 $:146.93 12 13 Total Cost of Goods Sold $3.410.00 $4.080.00 15.280.24 46.322.29 16.952 00 $7.644.48 14 15 Salary: Office $1,000.00 Salary; Sales $800.00 $1.100.00 $960.00 $1.210.00 $1.33100 $1.464. 10 $1,610.51 16 17 Other Benefits 1:306.00 $1.248.00 $1.497.60 Advertising & Promotions 1250.00 1:350.20 $417.86 1480.86 $1.647.36 1528.95 $1.812. 10 1:58184 18 19 Depreciation 20 1300.00 $390.00 20 20 1468.00 20 $514.80 Miscellaneous 20 30 20 $566.28 20 20 40 50 60 21 22 Total General & Admin. E 1:2.386.00 12.750.20 13.315.86 13.837.46 $4.225.21 14.650.73 23 24 Total Operating Costs $5.796.00 $6.830.20 $8.596.10 $10.159.75 $11.177.21 $12.295.21 25 Interest on Loan 10.00 26 10.00 10.00 10.00 10. 00 10. 00 27 Pre-tax Income 14.194.00 15.159.80 28 16993.90 18 550.25 19 404.79 $10.345.99 29 Tax $2.180.88 $2,683.10 30 $3.636.83 $4.446. 13 $4.890.49 $5,379.92 31 Profit 12.013. 12 32 $2.476.70 1:3.357.07 14.104. 12 $4.514 3 14.966.08 33 34 35 36 Assumption Parameters Value 37 Sales 10000 Description 30 Materials 17%% Start a 10,000 and grows by a percentage 39 Wages 14% 17% of Sales 40 Other Benefits 2. 702% 14% of Sales 41 Others 2.17% of Sales 82 42 Salary: Office Start at 100, then grows by 8% yearly 103- 43 Salary: Sales Start at 1000, then grows by 10% annually Other Benefits 8% of Sales 45 Advertising & Promotion: 17%% of Total Salary 46 Depreciation 2.5% of Sales 47 Miscellaneous 20 48 Interest on Loan 10 Fixed at 20 every year 10 Starts at 10 and grows by a fixed amount of 10 ann 49 52% A fixed amount of 10 each year 50 52% of Pre-tax Income