|
||||||||||||||||||||||||||||||||
| Sales Forecast Year 1-3 | ||||||||||||||||||||||||||||||||
| Prepared by: | Company Name: | |||||||||||||||||||||||||||||||
| Sam Miller | Aviator Inc | |||||||||||||||||||||||||||||||
| Growth Rate Year 1 to Year 2: | 10.00% | |||||||||||||||||||||||||||||||
| Growth Rate Year 2 to Year 3: | 10.00% | |||||||||||||||||||||||||||||||
| Product Lines | Year 1 Totals | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Year 2 Totals | Category Breakdown | Category / Total | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Year 3 Totals | Category Breakdown | Category / Total | |
| T1 | ||||||||||||||||||||||||||||||||
| 45 Sold | 540 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 594 | 17.3% | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 653 | 0.0% | |||
| Total Sales | $ 139,860,000 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | 12,820,500 | $ 153,846,000 | 100.0% | 10.6% | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | 14,102,550 | $ 169,230,600 | 100.0% | 0.0% | |
| Total COGS | $ 90,818,182 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | 8,325,000 | $ 99,900,000 | 64.9% | 10.6% | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | 9,157,500 | $ 109,890,000 | 64.9% | 0.0% | |
| Total Margin | $ 49,041,818 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | 4,495,500 | $ 53,946,000 | 35.1% | 10.6% | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | 4,945,050 | $ 59,340,600 | 35.1% | 0.0% | |
| T2 | ||||||||||||||||||||||||||||||||
| 45 Sold | 540 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 594 | 17.3% | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 653 | 0.0% | |||
| Total Sales | $ 177,660,000 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | 16,285,500 | $ 195,426,000 | 100.0% | 13.4% | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | 17,914,050 | $ 214,968,600 | 100.0% | 0.0% | |
| Total COGS | $ 115,363,636 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | 10,575,000 | $ 126,900,000 | 64.9% | 13.4% | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | 11,632,500 | $ 139,590,000 | 64.9% | 0.0% | |
| Margin | $ 62,296,364 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | 5,710,500 | $ 68,526,000 | 35.1% | 13.4% | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | 6,281,550 | $ 75,378,600 | 35.1% | 0.0% | |
| X | ||||||||||||||||||||||||||||||||
| 30 Sold | 360 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 396 | 11.5% | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 436 | 0.0% | |||
| Total Sales | $ 129,240,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | 11,847,000 | $ 142,164,000 | 100.0% | 9.8% | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | 13,031,700 | $ 156,380,400 | 100.0% | 0.0% | |
| Total COGS | $ 83,922,078 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | 7,692,857 | $ 92,314,286 | 64.9% | 9.8% | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | 8,462,143 | $ 101,545,714 | 64.9% | 0.0% | |
| Margin | $ 45,317,922 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | 4,154,143 | $ 49,849,714 | 35.1% | 9.8% | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | 4,569,557 | $ 54,834,686 | 35.1% | 0.0% | |
| XR | ||||||||||||||||||||||||||||||||
| 50 Sold | 600 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 660 | 19.2% | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 726 | 0.0% | |||
| Total Sales | 255000000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | 23,375,000 | $ 280,500,000 | 100.0% | 19.3% | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | 25,712,500 | $ 308,550,000 | 100.0% | 0.0% | |
| Total COGS | $ 165,584,416 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | 15,178,571 | $ 182,142,857 | 64.9% | 19.3% | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | 16,696,429 | $ 200,357,143 | 64.9% | 0.0% | |
| Margin | $ 89,415,584 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | 8,196,429 | $ 98,357,143 | 35.1% | 19.3% | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | 9,016,071 | $ 108,192,857 | 35.1% | 0.0% | |
| XL | ||||||||||||||||||||||||||||||||
| 60 Sold | 720 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 66 | 792 | 23.1% | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 871 | 0.0% | |||
| Total Sales | $ 396,000,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | 36,300,000 | $ 435,600,000 | 100.0% | 29.9% | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | 39,930,000 | $ 479,160,000 | 100.0% | 0.0% | |
| Total COGS | $ 257,142,857 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | 23,571,429 | $ 282,857,143 | 64.9% | 29.9% | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | 25,928,571 | $ 311,142,857 | 64.9% | 0.0% | |
| Margin | $ 138,857,143 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | 12,728,571 | $ 152,742,857 | 35.1% | 29.9% | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | 14,001,429 | $ 168,017,143 | 35.1% | 0.0% | |
| XLR | ||||||||||||||||||||||||||||||||
| 30 Sold | 360 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 396 | 11.5% | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 436 | 0.0% | |||
| Total Sales | $ 225,000,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | 20,625,000 | $ 247,500,000 | 100.0% | 17.0% | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | 22,687,500 | $ 272,250,000 | 100.0% | 0.0% | |
| Total COGS | $ 146,103,896 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | 13,392,857 | $ 160,714,286 | 64.9% | 17.0% | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | 14,732,143 | $ 176,785,714 | 64.9% | 0.0% | |
| Margin | $ 78,896,104 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | 7,232,143 | $ 86,785,714 | 35.1% | 17.0% | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | 7,955,357 | $ 95,464,286 | 35.1% | 0.0% | |
| Total Units Sold | 3120 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 286 | 3,432 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 3,775 | |||||
| Total Sales | $ 1,322,760,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 121,253,000 | $ 1,455,036,000 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 133,378,300 | $ 1,600,539,600 | |||||
| Total Cost of Goods Sold | $ 858,935,065 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 78,735,714 | $ 944,828,571 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 86,609,286 | $ 1,039,311,429 | |||||
| Total Margin | $ 463,824,935 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 42,517,286 | $ 510,207,429 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 46,769,014 | $ 561,228,171 | |||||