Sales Forecast Year 1-3
Prepared by:  Company Name:
Sam Miller Aviation Flight Academy
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
Student                                                              
1 Sold 4320 79 158 238 317 396 475 515 515 515 515 515 515 4,752   40.9% 87 174 261 348 436 523 566 566 566 566 566 566 5,227   0.0%
Total Sales  $                                               40,564,800               743,688            1,487,376            2,231,064            2,974,752            3,718,440            4,462,128            4,833,972            4,833,972            4,833,972            4,833,972            4,833,972            4,833,972  $          44,621,280 100.0% 16.9%               818,057            1,636,114            2,454,170            3,272,227            4,090,284            4,908,341            5,317,369            5,317,369            5,317,369            5,317,369            5,317,369            5,317,369  $          49,083,408 100.0% 0.0%
Total COGS  $                                               36,936,000               677,160            1,354,320            2,031,480            2,708,640            3,385,800            4,062,960            4,401,540            4,401,540            4,401,540            4,401,540            4,401,540            4,401,540  $          40,629,600 91.1% 22.2%               744,876            1,489,752            2,234,628            2,979,504            3,724,380            4,469,256            4,841,694            4,841,694            4,841,694            4,841,694            4,841,694            4,841,694  $          44,692,560 91.1% 0.0%
Total Margin  $                                                 3,628,800                 66,528               133,056               199,584               266,112               332,640               399,168               432,432               432,432               432,432               432,432               432,432               432,432  $            3,991,680 8.9% 4.9%                 73,181               146,362               219,542               292,723               365,904               439,085               475,675               475,675               475,675               475,675               475,675               475,675  $            4,390,848 8.9% 0.0%
                                                               
Aircraft Rental                                                              
1 Sold 4320 79 158 238 317 396 475 515 515 515 515 515 515 4,752   40.9% 87 174 261 348 436 523 566 566 566 566 566 566 5,227   0.0%
Total Sales  $                                             114,238,080            2,094,365            4,188,730            6,283,094            8,377,459          10,471,824          12,566,189          13,613,371          13,613,371          13,613,371          13,613,371          13,613,371          13,613,371  $       125,661,888 100.0% 47.7%            2,303,801            4,607,603            6,911,404            9,215,205          11,519,006          13,822,808          14,974,708          14,974,708          14,974,708          14,974,708          14,974,708          14,974,708  $       138,228,077 100.0% 0.0%
Total COGS  $                                               91,163,016            1,671,322            3,342,644            5,013,966            6,685,288            8,356,610          10,027,932          10,863,593          10,863,593          10,863,593          10,863,593          10,863,593          10,863,593  $       100,279,318 79.8% 54.8%            1,838,454            3,676,908            5,515,362            7,353,817            9,192,271          11,030,725          11,949,952          11,949,952          11,949,952          11,949,952          11,949,952          11,949,952  $       110,307,249 79.8% 0.0%
Margin  $                                               23,075,064               423,043               846,086            1,269,129            1,692,171            2,115,214            2,538,257            2,749,778            2,749,778            2,749,778            2,749,778            2,749,778            2,749,778  $          25,382,570 20.2% 31.4%               465,347               930,694            1,396,041            1,861,388            2,326,736            2,792,083            3,024,756            3,024,756            3,024,756            3,024,756            3,024,756            3,024,756  $          27,920,827 20.2% 0.0%
                                                               
Training PIC                                                              
1 Sold 360 33 33 33 33 33 33 33 33 33 33 33 33 396   3.4% 36 36 36 36 36 36 36 36 36 36 36 36 436   0.0%
Total Sales  $                                               10,800,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000               990,000  $          11,880,000 100.0% 4.5%            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000            1,089,000  $          13,068,000 100.0% 0.0%
Total COGS  $                                                 1,152,000               105,600               105,600               105,600               105,600               105,600               105,600               105,600               105,600               105,600               105,600               105,600               105,600  $            1,267,200 10.7% 0.7%               116,160               116,160               116,160               116,160               116,160               116,160               116,160               116,160               116,160               116,160               116,160               116,160  $            1,393,920 10.7% 0.0%
Margin  $                                                 9,648,000               884,400               884,400               884,400               884,400               884,400               884,400               884,400               884,400               884,400               884,400               884,400               884,400  $          10,612,800 89.3% 13.1%               972,840               972,840               972,840               972,840               972,840               972,840               972,840               972,840               972,840               972,840               972,840               972,840  $          11,674,080 89.3% 0.0%
                                                               
Training SIC                                                              
1 Sold 600 55 55 55 55 55 55 55 55 55 55 55 55 660   5.7% 61 61 61 61 61 61 61 61 61 61 61 61 726   0.0%
Total Sales 12000000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000            1,100,000  $          13,200,000 100.0% 5.0%            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000            1,210,000  $          14,520,000 100.0% 0.0%
Total COGS  $                                                 1,920,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000               176,000  $            2,112,000 16.0% 1.2%               193,600               193,600               193,600               193,600               193,600               193,600               193,600               193,600               193,600               193,600               193,600               193,600  $            2,323,200 16.0% 0.0%
Margin  $                                               10,080,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000               924,000  $          11,088,000 84.0% 13.7%            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400            1,016,400  $          12,196,800 84.0% 0.0%
                                                               
ATP                                                              
1 Sold 360 33 33 33 33 33 33 33 33 33 33 33 33 396   3.4% 36 36 36 36 36 36 36 36 36 36 36 36 436   0.0%
Total Sales  $                                               27,180,000            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500            2,491,500  $          29,898,000 100.0% 11.3%            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650            2,740,650  $          32,887,800 100.0% 0.0%
Total COGS  $                                               13,140,000            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500            1,204,500  $          14,454,000 48.3% 7.9%            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950            1,324,950  $          15,899,400 48.3% 0.0%
Margin  $                                               14,040,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000            1,287,000  $          15,444,000 51.7% 19.1%            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700            1,415,700  $          16,988,400 51.7% 0.0%
                                                               
VA & Military Training                                                              
1 Sold 600 55 55 55 55 55 55 55 55 55 55 55 55 660   5.7% 61 61 61 61 61 61 61 61 61 61 61 61 726   0.0%
Total Sales  $                                               34,800,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000            3,190,000  $          38,280,000 100.0% 14.5%            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000            3,509,000  $          42,108,000 100.0% 0.0%
Total COGS  $                                               21,900,000            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500            2,007,500  $          24,090,000 62.9% 13.2%            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250            2,208,250  $          26,499,000 62.9% 0.0%
Margin  $                                               12,900,000            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500            1,182,500  $          14,190,000 37.1% 17.6%            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750            1,300,750  $          15,609,000 37.1% 0.0%
Total Units Sold 10560 334 493 651 810 968 1,126 1,206 1,206 1,206 1,206 1,206 1,206 11,616     368 542 716 891 1,065 1,239 1,326 1,326 1,326 1,326 1,326 1,326 12,778    
Total Sales  $                                          239,582,880  $   10,609,553  $   13,447,606  $   16,285,658  $   19,123,711  $   21,961,764  $   24,799,817  $   26,218,843  $   26,218,843  $   26,218,843  $   26,218,843  $   26,218,843  $   26,218,843  $       263,541,168      $   11,670,508  $   14,792,366  $   17,914,224  $   21,036,082  $   24,157,940  $   27,279,798  $   28,840,728  $   28,840,728  $   28,840,728  $   28,840,728  $   28,840,728  $   28,840,728  $       289,895,285    
Total Cost of Goods Sold  $                                          166,211,016  $     5,842,082  $     8,190,564  $   10,539,046  $   12,887,528  $   15,236,010  $   17,584,492  $   18,758,733  $   18,758,733  $   18,758,733  $   18,758,733  $   18,758,733  $   18,758,733  $       182,832,118      $     6,426,290  $     9,009,620  $   11,592,950  $   14,176,281  $   16,759,611  $   19,342,941  $   20,634,606  $   20,634,606  $   20,634,606  $   20,634,606  $   20,634,606  $   20,634,606  $       201,115,329    
Total Margin  $                                             73,371,864  $     4,767,471  $     5,257,042  $     5,746,613  $     6,236,183  $     6,725,754  $     7,215,325  $     7,460,110  $     7,460,110  $     7,460,110  $     7,460,110  $     7,460,110  $     7,460,110  $          80,709,050      $     5,244,218  $     5,782,746  $     6,321,274  $     6,859,802  $     7,398,330  $     7,936,858  $     8,206,122  $     8,206,122  $     8,206,122  $     8,206,122  $     8,206,122  $     8,206,122  $          88,779,955