Cash Flow Forecast Years 1-3
Prepared By: Company Name:
Sam Miller Aviation Flight Academy
  Year 1 Totals Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Year 2 Totals Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Year 3 Totals
Beginning Balance    $            41,820,125  $            45,402,809  $            49,008,759  $            51,639,277  $            52,632,261  $            57,059,718  $            60,617,863  $            65,953,288  $            71,588,374  $            75,775,372  $            81,456,357  $            87,139,005    $            91,329,723  $            91,836,321  $            95,812,853  $            98,715,977  $          103,117,913  $          107,997,604  $          111,920,745  $          117,798,868  $          124,006,450  $          128,620,960  $          134,878,698  $          141,138,100  
Cash Inflows                                                      
Cash Sales  $          191,666,304                   8,487,642                 10,758,084                 13,028,527                 15,298,969                 17,569,411                 19,839,853                 20,975,075                 20,975,075                 20,975,075                 20,975,075                 20,975,075                 20,975,075  $       210,832,934                   9,336,406                 11,833,893                 14,331,379                 16,828,866                 19,326,352                 21,823,839                 23,072,582                 23,072,582                 23,072,582                 23,072,582                 23,072,582                 23,072,582  $       231,916,228
Accounts Receivable   $            38,119,503                   4,290,356                   2,306,492                   2,335,427                   2,846,277                   3,357,126                   3,867,976                   4,378,825                   4,676,821                   4,719,392                   4,719,392                   4,719,392                   4,719,392  $          46,936,869                   4,719,392                   2,537,142                   2,568,970                   3,130,905                   3,692,839                   4,254,774                   4,816,708                   5,144,503                   5,191,331                   5,191,331                   5,191,331                   5,191,331  $          51,630,556
Total Cash Inflows  $          229,785,807  $            12,777,998  $            13,064,577  $            15,363,954  $            18,145,246  $            20,926,538  $            23,707,829  $            25,353,900  $            25,651,896  $            25,694,466  $            25,694,466  $            25,694,466  $            25,694,466  $       257,769,803                 14,055,798                 14,371,034                 16,900,350                 19,959,770                 23,019,191                 26,078,612                 27,889,290                 28,217,085                 28,263,913                 28,263,913                 28,263,913                 28,263,913  $       283,546,783
                                                       
Cash Outflows                                                      
Investing Activities                                                      
New Fixed Asset Purchases  $                                -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Additional Inventory  $               3,000,000                         3,000,000                  $            3,000,000                   3,000,000                        $            3,000,000
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
Operating Activities                                                      
Operating Expenses  $               7,863,500                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380                      675,380  $            8,104,565                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093                      696,093  $            8,353,120
Payroll  $               4,742,858                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040                      459,040  $            5,508,475                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116                      575,116  $            6,901,389
Taxes  $               4,700,105                                 -                                 -                      927,993                                 -                                 -                   1,303,787                                 -                                 -                   1,492,321                                 -                                 -                   1,493,594                                   -                                 -                   1,021,058                                 -                                 -                   1,434,305                                 -                                 -                   1,641,565                                 -                                 -                   1,642,838  $            5,739,765
Financing Activities                                                      
Loan Payments  $                                -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Owners Distribution[1]  $                                -                   2,083,506                        $            2,083,506                   2,736,365                        $            2,736,365
Line of Credit Interest  $                  (91,527)                      (18,305)                      (19,970)                      (21,634)                      (23,298)                      (24,962)                      (26,626)                      (28,290)                      (29,954)                      (31,618)                      (33,283)                      (34,947)                      (36,611)  $             (329,497)                      (38,275)                      (39,939)                      (41,603)                      (43,267)                      (44,931)                      (46,596)                      (48,260)                      (49,924)                      (51,588)                      (53,252)                      (54,916)                      (56,580)  $             (569,132)
Line of Credit Repayments  $               1,689,730                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612  $            1,843,342                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612  $            1,843,342
Dividends Paid  $                                -                          $                             -                          $                             -
Total Cash Outflows  $          188,115,682  $              9,195,315  $              9,458,626  $            12,733,437  $            17,152,262  $            16,499,080  $            20,149,685  $            20,018,474  $            20,016,810  $            21,507,468  $            20,013,482  $            20,011,818  $            21,503,748  $       203,042,509  $            13,549,201  $            10,394,502  $            13,997,226  $            15,557,834  $            18,139,500  $            22,155,471  $            22,011,167  $            22,009,503  $            23,649,404  $            22,006,175  $            22,004,511  $            23,645,684  $       229,120,178
Net Cash Flows  $            41,670,125  $              3,582,684  $              3,605,951  $              2,630,517  $                 992,984  $              4,427,458  $              3,558,144  $              5,335,426  $              5,635,085  $              4,186,999  $              5,680,984  $              5,682,648  $              4,190,718  $          54,727,294  $                 506,597  $              3,976,532  $              2,903,124  $              4,401,936  $              4,879,691  $              3,923,141  $              5,878,123  $              6,207,582  $              4,614,509  $              6,257,738  $              6,259,402  $              4,618,229  $          54,426,606
Operating Cash Balance    $            45,402,809  $            49,008,759  $            51,639,277  $            52,632,261  $            57,059,718  $            60,617,863  $            65,953,288  $            71,588,374  $            75,775,372  $            81,456,357  $            87,139,005  $            91,329,723    $            91,836,321  $            95,812,853  $            98,715,977  $          103,117,913  $          107,997,604  $          111,920,745  $          117,798,868  $          124,006,450  $          128,620,960  $          134,878,698  $          141,138,100  $          145,756,329  
Line of Credit Drawdown  $                                -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -
Ending Cash Balance    $            45,402,809  $            49,008,759  $            51,639,277  $            52,632,261  $            57,059,718  $            60,617,863  $            65,953,288  $            71,588,374  $            75,775,372  $            81,456,357  $            87,139,005  $            91,329,723    $            91,836,321  $            95,812,853  $            98,715,977  $          103,117,913  $          107,997,604  $          111,920,745  $          117,798,868  $          124,006,450  $          128,620,960  $          134,878,698  $          141,138,100  $          145,756,329  
Line of Credit Balance    $          (1,843,342)  $          (1,996,954)  $          (2,150,566)  $          (2,304,177)  $          (2,457,789)  $          (2,611,401)  $          (2,765,013)  $          (2,918,625)  $          (3,072,237)  $          (3,225,848)  $          (3,379,460)  $          (3,533,072)    $          (3,686,684)  $          (3,840,296)  $          (3,993,908)  $          (4,147,519)  $          (4,301,131)  $          (4,454,743)  $          (4,608,355)  $          (4,761,967)  $          (4,915,579)  $          (5,069,190)  $          (5,222,802)  $          (5,376,414)  
[1]
Only record owner's draws above those already listed on the payroll tabs.