H Gongora- Lab 3-1 August Online Technology Eight-Year Financial Projection.xisx - Excel Search Willie Burnside 1 X File Home Insert Draw Page Layout Formulas Data Review View Developer Help ACROBAT Power Pivot Share K Cut Corbel - 11 + A" A E 2P Wrap Text General AutoSum * Ap O Paste [ Copy + 4 Fill E Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table * Styles Clear * Filter * Select Clipboard Font Alignment Number Styles Cells Editing M11 Y fx B C D E F G H K M N 0 P August Online Technology 2 Eight-Year Financial Projection for Product X 3/22/2022 20:38 year year year's year 4 years year ! Sale $ 50,373/252.50 $ 53 570,694 70 5 56,971,094.54 5 60,507/334.77 $ 64,433,115.85 5 68,523,007.87 $ 72,872,505-80 5 77,498,088.10.. Cost of Goods 35 311,650.00 37.553,056.98 39.936 737-28 42,471,721.67 45,167,614.21 48 034 620.52 51,003,626.56 54,326,159.76 6 Gross Margin 5,061,602.50 $ 16,017,637-71 5 17,034,357-27 $ 18,115,613.10 $ 19,265,501.64 $ 20,488,379.35 $ 21,788,879.23 5 23,171,928.34 7 Expenses 8 Advertizing 4,031,110.20 $ 4,286,905.58 5 4.558,937.56 s 4,848,236.78 $ 5,155,899-27 $ 5,483090.63 $ 5,831,050.46 5 6,201,097.05 _-... Maintenance 500,000.00 60o,coo.00 440,000.00 520,000.00 555,000.00 420,000.00 390,000.00 400,000.00 ._-- 10 Rent 1,000,000.00 1,065,000.00 1,134,225-00 1,207,949.63 1,286,466.35 1,370,086.68 1,459,142.30 1,553,986.55-- 11 Salaries 6,044,790.30 6,428,403.36 6,036,531.35 7,270,450.17 7.731,973.90 0,222,760.94 8,744,700.70 9,299,770.57 12 Shipping 1,813,437.09 1,928,545.01 2,050,959-40 2,181,144.05 2,319,592.17 2,466,828.28 2,623/410.21 2,789,931-17- 13 Supplies 504,479.03 642,848.34 683,653-13 727,048.07 773,197.39 872,276.09 874,470.07 929,977-06 14 Web Services 85,000.00 90,100.00 95,506.00 101,236.36 107,310.54 113,749-17 120,574.12 127,808.57 15 Total Expenses 14 078,816.62 $ 15/041,082.29 5 15,799,812.45 5 16,856,095.01 $ 17,929,439.62 5 10,098,791.79 $ 20,043/347 06 5 21,302,570.97_ 16 17 Operating Income 982,705.80 5 975 755-43 5 1,234,544 02 5 1,259,518.09 5 1,336,062.02 5 1,589,507.56 $ 1,745,531.37 5 1,869,357.38 18 Income Tax 324,319.34 321,999-29 407,399-79 415,640.97 440,900-47 524,563.90 576,025-35 616,887.93- 19 Net Income 658,466.54 5 653 756.14 5 827,145.03 5 843 877.12 5 895,161 55 5 1,065/023.67 $ 1,169,506.02 5 1,252,469.44 20 21 22 Assumptions 23 Units sold in Prior Year 235,411 24 Unit cost $150.00 25 Annual Sales Growth 3.25% 26 Annual Price Increase 3.00% 27 Margin 29.90% Financial Projection Clustered Chart + Ready Windows Ink Workspace -+ 90% Type here to search W x 45"F Cloudy ~ 1 () 839 PM 3/22/2022