Cash Flow Forecast Year 1
Prepared By: Company Name:
Sam Miller Aviation Flight Academy
  Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Totals
Beginning Balance  $                 150,000  $              1,286,817  $              3,883,333  $              6,229,845  $              9,828,567  $            10,822,417  $            14,031,993  $            18,851,570  $            23,943,716  $            27,745,053  $            32,879,229  $            38,015,068  
Cash Inflows                          
Cash Sales                   7,716,038                   9,780,077                 11,844,115                 13,908,154                 15,972,192                 18,036,230                 19,068,250                 19,068,250                 19,068,250                 19,068,250                 19,068,250                 19,068,250  $          191,666,304
Accounts Receivable                                  -                   1,446,757                   2,123,116                   2,587,524                   3,051,933                   3,516,342                   3,980,750                   4,251,655                   4,290,356                   4,290,356                   4,290,356                   4,290,356  $            38,119,503
Total Cash Inflows  $              7,716,038  $            11,226,834  $            13,967,231  $            16,495,678  $            19,024,125  $            21,552,572  $            23,049,000  $            23,319,905  $            23,358,606  $            23,358,606  $            23,358,606  $            23,358,606  $          229,785,807
                           
Cash Outflows                          
Investing Activities                          
New Fixed Asset Purchases                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Additional Inventory                           3,000,000                $              3,000,000
Cost of Goods Sold                   5,310,984                   7,445,967                   9,580,951                 11,715,934                 13,850,918                 15,985,902                 17,053,393                 17,053,393                 17,053,393                 17,053,393                 17,053,393                 17,053,393  $          166,211,016
Operating Activities                          
Operating Expenses                      873,000                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500                      635,500  $              7,863,500
Payroll                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238                      395,238  $              4,742,858
Taxes[1]                                 -                                 -                      857,083                                 -                                 -                   1,179,401                                 -                                 -                   1,331,174                                 -                                 -                   1,332,447  $              4,700,105
Financing Activities                          
Loan Payments                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Owners Distribution[2]                          $                             -
Line of Credit Interest                                   -                        (1,664)                        (3,328)                        (4,992)                        (6,657)                        (8,321)                        (9,985)                      (11,649)                      (13,313)                      (14,977)                      (16,641)  $                  (91,527)
Line of Credit Repayments                        153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612                      153,612  $              1,689,730
Dividends Paid                          $                             -
Total Cash Outflows  $              6,579,222  $              8,630,317  $            11,620,719  $            12,896,956  $            18,030,276  $            18,342,996  $            18,229,423  $            18,227,759  $            19,557,268  $            18,224,430  $            18,222,766  $            19,553,549  $          188,115,682
Net Cash Flows  $              1,136,817  $              2,596,517  $              2,346,512  $              3,598,722  $                 993,849  $              3,209,576  $              4,819,577  $              5,092,146  $              3,801,337  $              5,134,175  $              5,135,840  $              3,805,057  $            41,670,125
Operating Cash Balance  $              1,286,817  $              3,883,333  $              6,229,845  $              9,828,567  $            10,822,417  $            14,031,993  $            18,851,570  $            23,943,716  $            27,745,053  $            32,879,229  $            38,015,068  $            41,820,125  
Line of Credit Drawdown  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -
Ending Cash Balance  $              1,286,817  $              3,883,333  $              6,229,845  $              9,828,567  $            10,822,417  $            14,031,993  $            18,851,570  $            23,943,716  $            27,745,053  $            32,879,229  $            38,015,068  $            41,820,125  
Line of Credit Balance  $                             -  $             (153,612)  $             (307,224)  $             (460,835)  $             (614,447)  $             (768,059)  $             (921,671)  $          (1,075,283)  $          (1,228,895)  $          (1,382,506)  $          (1,536,118)  $          (1,689,730)  
[1]
This line allows you to approximate the personal income tax of the owner(s). This is the tax on the profit for the business. 
[2]
Only record owner's draws above those already listed on the payroll tabs.