5/19/2021 Projecting Cash Flow Projecting Cash Flow pronghorn Quarter 4 Pro Forma Cash Flow Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 Beginning Cash Balance 0 820,000 858,229 485,961 485,961 485,961 RECEIPTS AND DISBURSEMENTS FROM OPERATING ACTIVITIES Revenues 0 430,830 595,000 O O O - Rebates 0 8,600 13,100 O O - Production 0 179,439 231,394 O O Research and Development 0 90,000 90,000 Quality Costs 0 46,189 32,375 O - System Improvement Costs 0 5,000 40,000 O - Advertising 0 64,781 164,702 O O Internet Marketing Expenses 1,000 4,000 O o - Sales Force Expense 50,396 95,690 - Store Expense 200,000 152,000 215,000 O o - Marketing Research 0 15,000 0 0 8,154 - Shipping 5,687 - Excess Capacity Cost 0 34,508 92,854 - Income Taxes 0 + Interest Income o o o - Interest Charges o o O + Other Income o O 0 - Other Expenses O = Net Operating Cash Flow -200,000 -221,771 -392,2685/19/2021 Projecting Cash Flow Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 INVESTING ACTIVITIES Fixed Production Capacity 480,000 240,000 480,000 0 O O O O = Total Investing Activities 480,000 240,000 480,000 FINANCING ACTIVITIES Increase in Common Stock 1,500,000 500,000 500,000 + Borrow Conventional Loan - Repay Conventional Loan + Borrow Emergency Loan o o o o o 0 0 0 o o o o o o o o o o o o oo oo oo - Repay Emergency Loan - Deposit 3 Month Certificate + Withdraw 3 Month Certificate = Total Financing Activities 1,500,000 500,000 500,000 Cash Balance, End of Period 820,000 858,229 485,961 485,961 485,961 485,9615/19/2021 Pro Forma Income Statement Pro Forma Income Statement pronghorn Quarter 4 Pro Forma Income Statement Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 GROSS PROFIT Revenues 430,830 595,000 O o O Rebates 0 8,600 13,100 Cost of Goods Sold O 179,439 231,394 0 242,791 350,506 O O = Gross Profit EXPENSES Research and Development 0 90,000 90,000 + Quality Costs O 46,189 32,375 oooo + System Improvement Costs 0 5,000 40,000 + Advertising O 64,781 164,702 + Internet Marketing Expenses 0 1,000 4,000 o o + Sales Force Expense 50,396 95,690 ooo + Store Expense 200,000 152,000 215,000 + Marketing Research 15,000 + Shipping 0 5,687 8,154 + Excess Capacity Cost 0 34,508 92,854 + Depreciation 0 20.000 30,000 = Total Expenses 200,000 484,562 772,774 Operating Profit -200,000 -241,771 -422,268 0 0 MISCELLANEOUS INCOME AND EXPENSES * Other Income O o o Other Expenses = Earnings Before Interest and Taxes -200,000 -241,771 -422,268 https//game.lisworld.com/mp//web7/engine.php?tpi-print&studentID=111100998sessionID-$2079196360876157172d095272fb&quarters4&language-en-us&resource-proformaincomestatement