Q Inc. -‐ 9 -‐ PRO FORMA CASH FLOW Q5 – Q8 Quarter 5 Quarter 6 Quarter 7 Quarter 8 Beginning Cash Balance $ 1,749,898 $ 930,423 $ 1,455,435 $ 12,348,662 Receipts and Disbursements from Operating Activities Revenues $ 12,700,000 $ 40,000,000 $ 75,000,000 $ 98,000,000 - Rebates $ 205,150 $ 300,000 $ 640,000 $ 750,000 - Production $ 5,825,474 $ 16,500,000 $ 37,800,000 $ 42,194,000 - Research and Development $ 4,421,725 $ 4,980,000 $ 4,980,000 $ 420,000 - Quality Costs $ 442,202 $ 500,000 $ 500,000 $ 500,000 - Advertising $ 608,925 $ 750,000 $ 1,000,000 $ 1,250,000 - Sales Force Expense $ 831,134 $ 1,777,468 $ 3,090,040 $ 3,653,940 - Sales Office and Web Center $ 1,213,897 $ 1,565,555 $ 2,027,518 $ 1,799,518 - Marketing Research $ 115,000 $ 115,000 $ 115,000 $ 115,000 - Shipping $ 200,197 $ 800,000 $ 1,600,000 $ 1,800,000 - Inventory Holding Cost $ 8,470 $ 68,470 $ 488,470 $ 792,515 - Excess Capacity Cost $ - $ - $ - $ - - Web Marketing Expenses $ - $ 500,000 $ 500,000 $ 500,000 - Income Taxes $ - $ 3,218,495 $ 7,765,745 $ 13,962,697 + Interest Income $ - $ - $ - $ - - Interest Charges $ - $ - $ - $ - + Licensing Income $ - $ - $ - $ - - Licensing Fees $ - $ - $ - $ - + Other Income $ - $ - $ - $ - - Other Expenses $ - $ - $ - $ - = Net Operating Cash Flow $ (1,172,174) $ 8,925,012 $ 14,493,227 $ 30,262,330 Investing Activities Fixed Plant Capacity $ 3,647,301 $ 8,400,000 $ 3,600,000 $ - + Sinking Fund $ - $ - $ - $ - = Total Investing Activities $ 3,647,301 $ 8,400,000 $ 3,600,000 $ - Financing Activities Increase in Common Stock $ 4,000,000 $ - $ - $ - + Borrow Conventional Loan $ - $ - $ - $ - - Repay Conventional Loan $ - $ - $ - $ - + Borrow Long-Term Loan $ - $ - $ - $ - + Borrow Emergency Loan $ - $ - $ - $ - - Repay Emergency Loan $ - $ - $ - $ - - Dividends $ - $ - $ - $ - - Deposit 3 Month Certificate $ - $ - $ - $ - + Withdraw 3 Month Certificate $ - $ - $ - $ - = Total Financing Activities $ 4,000,000 $ - $ - $ - Cash Balance, End of Period $ 930,423 $ 1,455,435 $ 12,348,662 $ 42,610,992 Cost of Goods Sold Starting Inventory $ 149,663 $ 84,704 $ 684,704 $ 4,884,704 + Production $ 5,825,474 $ 16,500,000 $ 37,800,000 $ 42,194,000 = Available Inventory $ 5,975,137 $ 16,584,704 $ 38,484,704 $ 47,078,704 - Cost of Goods Sold $ 5,890,433 $ 15,900,000 $ 33,600,000 $ 39,153,550 = Ending Inventory $ 84,704 $ 684,704 $ 4,884,704 $ 7,925,154