Cash Flow Forecast Years 1-3
Prepared By: Company Name:
Sam Miller Aviator Inc
  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    $          256,609,642  $          268,496,842  $          305,448,352  $          304,642,536  $          342,696,346  $          380,750,156  $          379,944,340  $          417,998,150  $          456,051,960  $          455,246,145  $          493,299,955  $          531,353,764    $          530,547,949  $          526,647,544  $          567,448,500  $          566,444,701  $          608,458,186  $          650,471,672  $          649,467,873  $          691,481,359  $          733,494,845  $          732,491,045  $          774,504,531  $          816,518,017  
Cash Inflows                                                      
Cash Sales  $          396,828,000                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900                 36,375,900  $       436,510,800                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490                 40,013,490  $       480,161,880
Accounts Receivable   $          837,748,000                 77,161,000                 83,774,800                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100                 84,877,100  $    1,009,706,800                 84,877,100                 92,152,280                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810                 93,364,810  $    1,110,677,480
Total Cash Inflows  $       1,234,576,000  $          113,536,900  $          120,150,700  $          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,446,217,600               124,890,590               132,165,770               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,590,839,360
                                                       
Cash Outflows                                                      
Investing Activities                                                      
New Fixed Asset Purchases  $                                -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Additional Inventory  $                                -                          $                             -                          $                             -
Cost of Goods Sold  $          808,830,519                 73,725,260                 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  $       939,818,117                 81,097,786                 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,033,799,929
Operating Activities                                                      
Operating Expenses  $            43,973,500                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822                   3,774,822  $          45,297,865                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518                   3,888,518  $          46,662,219
Payroll  $               7,079,749                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654                      688,654  $            8,263,845                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010                      867,010  $          10,404,122
Taxes  $          140,082,590                                 -                                 -                 38,859,625                                 -                                 -                 38,859,625                                 -                                 -                 38,859,625                                 -                                 -                 38,859,625                                   -                                 -                 43,017,285                                 -                                 -                 43,017,285                                 -                                 -                 43,017,285                                 -                                 -                 43,017,285  $       172,069,141
Financing Activities                                                      
Loan Payments  $                                -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Owners Distribution[1]  $                                -                 11,730,482                        $          11,730,482                 21,468,840                        $          21,468,840
Line of Credit Interest  $                                -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -                                 -  $                             -
Line of Credit Repayments  $                                -                          $                             -                          $                             -
Dividends Paid  $                                -                 11,730,482                        $          11,730,482                 21,468,840                        $          21,468,840
Total Cash Outflows  $          999,966,358  $          101,649,700  $            83,199,190  $          122,058,815  $            83,199,190  $            83,199,190  $          122,058,815  $            83,199,190  $            83,199,190  $          122,058,815  $            83,199,190  $            83,199,190  $          122,058,815  $    1,016,840,791  $          128,790,995  $            91,364,814  $          134,382,099  $            91,364,814  $            91,364,814  $          134,382,099  $            91,364,814  $            91,364,814  $          134,382,099  $            91,364,814  $            91,364,814  $          134,382,099  $    1,305,873,091
Net Cash Flows  $          234,609,642  $            11,887,200  $            36,951,510  $                (805,815)  $            38,053,810  $            38,053,810  $                (805,815)  $            38,053,810  $            38,053,810  $                (805,815)  $            38,053,810  $            38,053,810  $                (805,815)  $       429,376,809  $             (3,900,405)  $            40,800,956  $             (1,003,799)  $            42,013,486  $            42,013,486  $             (1,003,799)  $            42,013,486  $            42,013,486  $             (1,003,799)  $            42,013,486  $            42,013,486  $             (1,003,799)  $       284,966,269
Operating Cash Balance    $          268,496,842  $          305,448,352  $          304,642,536  $          342,696,346  $          380,750,156  $          379,944,340  $          417,998,150  $          456,051,960  $          455,246,145  $          493,299,955  $          531,353,764  $          530,547,949    $          526,647,544  $          567,448,500  $          566,444,701  $          608,458,186  $          650,471,672  $          649,467,873  $          691,481,359  $          733,494,845  $          732,491,045  $          774,504,531  $          816,518,017  $          815,514,218  
Line of Credit Drawdown  $                                -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -
Ending Cash Balance    $          268,496,842  $          305,448,352  $          304,642,536  $          342,696,346  $          380,750,156  $          379,944,340  $          417,998,150  $          456,051,960  $          455,246,145  $          493,299,955  $          531,353,764  $          530,547,949    $          526,647,544  $          567,448,500  $          566,444,701  $          608,458,186  $          650,471,672  $          649,467,873  $          691,481,359  $          733,494,845  $          732,491,045  $          774,504,531  $          816,518,017  $          815,514,218  
Line of Credit Balance    $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -    $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  $                             -  
[1]
Only record owner's draws above those already listed on the payroll tabs.