3 pages plus excel calculations needed
iamnickok
wackywineslinkedinvestmentopportunitiesstudent-4.xlsxLA
| Income Statement (Unaudited) | |||||||||||||||
| (for years ending Oct. 1) | |||||||||||||||
| 2017F | 2018F | 2019F | 2020F | 2021F | 2022F | 2023F | 2024F | 2025F | 2026F | 2027F | 2028F | 2029F | 2030F | ||
| Net Sales | $ 300,000.00 | $ 330,000.00 | $ 363,000.00 | $ 399,300.00 | $ 439,230.00 | $ 483,153.00 | $ 531,468.30 | $ 584,615.13 | $ 643,076.64 | $ 707,384.31 | $ 778,122.74 | $ 855,935.01 | $ 941,528.51 | $ 1,035,681.36 | |
| Cost of Goods Sold | $ 60,000.00 | $ 66,000.00 | $ 72,600.00 | $ 79,860.00 | $ 87,846.00 | $ 96,630.60 | $ 106,293.66 | $ 116,923.03 | $ 128,615.33 | $ 141,476.86 | $ 155,624.55 | $ 171,187.00 | $ 188,305.70 | $ 207,136.27 | |
| Gross Profit | $ 240,000.00 | $ 264,000.00 | $ 290,400.00 | $ 319,440.00 | $ 351,384.00 | $ 386,522.40 | $ 425,174.64 | $ 467,692.10 | $ 514,461.31 | $ 565,907.45 | $ 622,498.19 | $ 684,748.01 | $ 753,222.81 | $ 828,545.09 | |
| Operating expenses | |||||||||||||||
| Advertising and promotion | $ 15,000.00 | $ 16,500.00 | $ 18,150.00 | $ 19,965.00 | $ 21,961.50 | $ 24,157.65 | $ 26,573.42 | $ 29,230.76 | $ 32,153.83 | $ 35,369.22 | $ 38,906.14 | $ 42,796.75 | $ 47,076.43 | $ 51,784.07 | |
| Depreciation | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | |
| Insurance | $ 7,500.00 | $ 7,875.00 | $ 8,268.75 | $ 8,682.19 | $ 9,116.30 | $ 9,572.11 | $ 10,050.72 | $ 10,553.25 | $ 11,080.92 | $ 11,634.96 | $ 12,216.71 | $ 12,827.55 | $ 13,468.92 | $ 14,142.37 | |
| Legal and accounting | $ 18,000.00 | $ 19,800.00 | $ 21,780.00 | $ 23,958.00 | $ 26,353.80 | $ 28,989.18 | $ 31,888.10 | $ 35,076.91 | $ 38,584.60 | $ 42,443.06 | $ 46,687.36 | $ 51,356.10 | $ 56,491.71 | $ 62,140.88 | |
| Office expenses | $ 10,000.00 | $ 11,000.00 | $ 12,100.00 | $ 13,310.00 | $ 14,641.00 | $ 16,105.10 | $ 17,715.61 | $ 19,487.17 | $ 21,435.89 | $ 23,579.48 | $ 25,937.42 | $ 28,531.17 | $ 31,384.28 | $ 34,522.71 | |
| Repairs and Maintenance | $ 4,000.00 | $ 4,320.00 | $ 4,665.60 | $ 5,038.85 | $ 5,441.96 | $ 5,877.31 | $ 6,347.50 | $ 6,855.30 | $ 7,403.72 | $ 7,996.02 | $ 8,635.70 | $ 9,326.56 | $ 10,072.68 | $ 10,878.49 | |
| Telephone | $ 6,000.00 | $ 6,120.00 | $ 6,242.40 | $ 6,367.25 | $ 6,494.59 | $ 6,624.48 | $ 6,756.97 | $ 6,892.11 | $ 7,029.96 | $ 7,170.56 | $ 7,313.97 | $ 7,460.25 | $ 7,609.45 | $ 7,761.64 | |
| Utilities | $ 9,000.00 | $ 9,450.00 | $ 10,890.00 | $ 11,434.50 | $ 13,176.90 | $ 13,835.75 | $ 14,527.53 | $ 15,253.91 | $ 16,016.60 | $ 16,817.43 | $ 17,658.31 | $ 18,541.22 | $ 19,468.28 | $ 20,441.70 | |
| Wages and benefits | $ 36,000.00 | $ 39,600.00 | $ 43,560.00 | $ 47,916.00 | $ 52,707.60 | $ 57,978.36 | $ 63,776.20 | $ 70,153.82 | $ 77,169.20 | $ 84,886.12 | $ 93,374.73 | $ 102,712.20 | $ 112,983.42 | $ 124,281.76 | |
| Total operating profit | $ 104,500.00 | $ 119,335.00 | $ 134,743.25 | $ 152,768.22 | $ 171,490.35 | $ 193,382.46 | $ 217,538.60 | $ 244,188.88 | $ 273,586.60 | $ 306,010.61 | $ 341,767.85 | $ 381,196.22 | $ 424,667.63 | $ 472,591.47 | |
| Interest expense | $ 25,000.00 | $ 24,623.71 | $ 24,228.61 | $ 23,813.76 | $ 23,378.16 | $ 22,920.78 | $ 22,440.54 | $ 21,936.28 | $ 21,406.81 | $ 20,850.86 | $ 20,267.12 | $ 19,654.19 | $ 19,010.61 | $ 18,334.85 | |
| Income before taxes | $ 79,500.00 | $ 94,711.29 | $ 110,514.64 | $ 128,954.46 | $ 148,112.19 | $ 170,461.67 | $ 195,098.06 | $ 222,252.60 | $ 252,179.80 | $ 285,159.75 | $ 321,500.74 | $ 361,542.03 | $ 405,657.02 | $ 454,256.61 | |
| Income taxes | $ 31,800.00 | $ 37,884.51 | $ 44,205.85 | $ 51,581.78 | $ 59,244.88 | $ 68,184.67 | $ 78,039.23 | $ 88,901.04 | $ 100,871.92 | $ 114,063.90 | $ 128,600.29 | $ 144,616.81 | $ 162,262.81 | $ 181,702.64 | |
| Net Income | $ 47,700.00 | $ 56,826.77 | $ 66,308.78 | $ 77,372.67 | $ 88,867.32 | $ 102,277.00 | $ 117,058.84 | $ 133,351.56 | $ 151,307.88 | $ 171,095.85 | $ 192,900.44 | $ 216,925.22 | $ 243,394.21 | $ 272,553.97 | |
| Intitial Investment | $ (500,000.00) | ||||||||||||||
| Terminal Value | $ 1,500,000.00 | ||||||||||||||
Miami
| Income Statement (Unaudited) | |||||||||||||||
| (for years ending Oct. 1) | |||||||||||||||
| 2017F | 2018F | 2019F | 2020F | 2021F | 2022F | 2023F | 2024F | 2025F | 2026F | 2027F | 2028F | 2029F | 2030F | ||
| Net Sales | $ 300,000.00 | $ 306,000.00 | $ 312,120.00 | $ 318,362.40 | $ 324,729.65 | $ 389,675.58 | $ 467,610.69 | $ 561,132.83 | $ 673,359.40 | $ 808,031.28 | $ 969,637.53 | $ 1,163,565.04 | $ 1,396,278.05 | $ 1,675,533.66 | |
| Cost of Goods Sold | $ 75,000.00 | $ 76,500.00 | $ 78,030.00 | $ 79,590.60 | $ 81,182.41 | $ 97,418.89 | $ 116,902.67 | $ 140,283.21 | $ 168,339.85 | $ 202,007.82 | $ 242,409.38 | $ 290,891.26 | $ 349,069.51 | $ 418,883.41 | |
| Gross Profit | $ 225,000.00 | $ 229,500.00 | $ 234,090.00 | $ 238,771.80 | $ 243,547.24 | $ 292,256.68 | $ 350,708.02 | $ 420,849.62 | $ 505,019.55 | $ 606,023.46 | $ 727,228.15 | $ 872,673.78 | $ 1,047,208.54 | $ 1,256,650.24 | |
| Operating expenses | |||||||||||||||
| Advertising and promotion | $ 15,000.00 | $ 15,300.00 | $ 15,606.00 | $ 15,918.12 | $ 16,236.48 | $ 19,483.78 | $ 23,380.53 | $ 28,056.64 | $ 33,667.97 | $ 40,401.56 | $ 48,481.88 | $ 58,178.25 | $ 69,813.90 | $ 83,776.68 | |
| Depreciation | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | |
| Insurance | $ 7,500.00 | $ 7,875.00 | $ 8,268.75 | $ 8,682.19 | $ 9,116.30 | $ 9,572.11 | $ 10,050.72 | $ 10,553.25 | $ 11,080.92 | $ 11,634.96 | $ 12,216.71 | $ 12,827.55 | $ 13,468.92 | $ 14,142.37 | |
| Legal and accounting | $ 18,000.00 | $ 19,800.00 | $ 21,780.00 | $ 23,958.00 | $ 26,353.80 | $ 28,989.18 | $ 31,888.10 | $ 35,076.91 | $ 38,584.60 | $ 42,443.06 | $ 46,687.36 | $ 51,356.10 | $ 56,491.71 | $ 62,140.88 | |
| Office expenses | $ 10,000.00 | $ 1,417.00 | $ 3,337.00 | $ 3,164.53 | $ 12,989.19 | $ 15,587.02 | $ 18,704.43 | $ 22,445.31 | $ 26,934.38 | $ 32,321.25 | $ 38,785.50 | $ 46,542.60 | $ 55,851.12 | $ 67,021.35 | |
| Repairs and Maintenance | $ 4,000.00 | $ 4,320.00 | $ 4,665.60 | $ 5,038.85 | $ 5,441.96 | $ 5,877.31 | $ 6,347.50 | $ 6,855.30 | $ 7,403.72 | $ 7,996.02 | $ 8,635.70 | $ 9,326.56 | $ 10,072.68 | $ 10,878.49 | |
| Telephone | $ 6,000.00 | $ 6,120.00 | $ 6,242.40 | $ 6,367.25 | $ 6,494.59 | $ 6,624.48 | $ 6,756.97 | $ 6,892.11 | $ 7,029.96 | $ 7,170.56 | $ 7,313.97 | $ 7,460.25 | $ 7,609.45 | $ 7,761.64 | |
| Utilities | $ 9,000.00 | $ 9,450.00 | $ 9,363.60 | $ 9,831.78 | $ 9,741.89 | $ 10,228.98 | $ 10,740.43 | $ 11,277.45 | $ 11,841.33 | $ 12,433.39 | $ 13,055.06 | $ 13,707.82 | $ 14,393.21 | $ 15,112.87 | |
| Wages and benefits | $ 36,000.00 | $ 36,720.00 | $ 37,454.40 | $ 38,203.49 | $ 38,967.56 | $ 46,761.07 | $ 56,113.28 | $ 67,335.94 | $ 80,803.13 | $ 96,963.75 | $ 116,356.50 | $ 139,627.80 | $ 167,553.37 | $ 201,064.04 | |
| Total operating profit | $ 89,500.00 | $ 98,498.00 | $ 97,372.25 | $ 97,607.60 | $ 88,205.47 | $ 119,132.74 | $ 156,726.05 | $ 202,356.70 | $ 257,673.56 | $ 324,658.90 | $ 405,695.46 | $ 503,646.86 | $ 621,954.17 | $ 764,751.92 | |
| Interest expense | $ 25,000.00 | $ 24,623.71 | $ 24,228.61 | $ 23,813.76 | $ 23,378.16 | $ 22,920.78 | $ 22,440.54 | $ 21,936.28 | $ 21,406.81 | $ 20,850.86 | $ 20,267.12 | $ 19,654.19 | $ 19,010.61 | $ 18,334.85 | |
| Income before taxes | $ 64,500.00 | $ 73,874.29 | $ 73,143.64 | $ 73,793.84 | $ 64,827.31 | $ 96,211.96 | $ 134,285.52 | $ 180,420.43 | $ 236,266.75 | $ 303,808.04 | $ 385,428.35 | $ 483,992.67 | $ 602,943.56 | $ 746,417.07 | |
| Income taxes | $ 25,800.00 | $ 29,549.71 | $ 29,257.45 | $ 29,517.54 | $ 25,930.93 | $ 38,484.78 | $ 53,714.21 | $ 72,168.17 | $ 94,506.70 | $ 121,523.22 | $ 154,171.34 | $ 193,597.07 | $ 241,177.43 | $ 298,566.83 | |
| Net Income | $ 38,700.00 | $ 44,324.57 | $ 43,886.18 | $ 44,276.31 | $ 38,896.39 | $ 57,727.17 | $ 80,571.31 | $ 108,252.26 | $ 141,760.05 | $ 182,284.83 | $ 231,257.01 | $ 290,395.60 | $ 361,766.14 | $ 447,850.24 | |
| Intitial Investment | $ (500,000.00) | ||||||||||||||
| Terminal Value | $ 3,000,000.00 | ||||||||||||||
