Cash Flow Forecast Year 1
Prepared By: Company Name:
Sam Miller Aviator Inc
  Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Totals
Beginning Balance  $            22,000,000  $            29,022,644  $            52,426,243  $            51,923,413  $            86,350,012  $          120,776,611  $          120,152,156  $          154,578,755  $          189,005,354  $          188,380,899  $          222,807,498  $          257,234,096  
Cash Inflows                          
Cash Sales                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000                 33,069,000  $          396,828,000
Accounts Receivable                                  -                 66,138,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000                 77,161,000  $          837,748,000
Total Cash Inflows  $            33,069,000  $            99,207,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $          110,230,000  $       1,234,576,000
                           
Cash Outflows                          
Investing Activities                          
New Fixed Asset Purchases                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Additional Inventory                          $                             -
Cost of Goods Sold                 21,473,377                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922                 71,577,922  $          808,830,519
Operating Activities                          
Operating Expenses                   3,983,000                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500                   3,635,500  $            43,973,500
Payroll                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979                      589,979  $              7,079,749
Taxes[1]                                 -                                 -                 34,929,429                                 -                                 -                 35,051,054                                 -                                 -                 35,051,054                                 -                                 -                 35,051,054  $          140,082,590
Financing Activities                          
Loan Payments                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Owners Distribution[2]                          $                             -
Line of Credit Interest                                   -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Line of Credit Repayments                          $                             -
Dividends Paid                          $                             -
Total Cash Outflows  $            26,046,356  $            75,803,401  $          110,732,830  $            75,803,401  $            75,803,401  $          110,854,455  $            75,803,401  $            75,803,401  $          110,854,455  $            75,803,401  $            75,803,401  $          110,854,455  $          999,966,358
Net Cash Flows  $              7,022,644  $            23,403,599  $                (502,830)  $            34,426,599  $            34,426,599  $                (624,455)  $            34,426,599  $            34,426,599  $                (624,455)  $            34,426,599  $            34,426,599  $                (624,455)  $          234,609,642
Operating Cash Balance  $            29,022,644  $            52,426,243  $            51,923,413  $            86,350,012  $          120,776,611  $          120,152,156  $          154,578,755  $          189,005,354  $          188,380,899  $          222,807,498  $          257,234,096  $          256,609,642  
Line of Credit Drawdown  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -
Ending Cash Balance  $            29,022,644  $            52,426,243  $            51,923,413  $            86,350,012  $          120,776,611  $          120,152,156  $          154,578,755  $          189,005,354  $          188,380,899  $          222,807,498  $          257,234,096  $          256,609,642  
Line of Credit Balance  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  
[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.