calculate required new funds?

BIGA 100 - $ *. .00 123- Default (Ca 11 .. fix K 8 c D E F 3 4 5 6 7 9 10 11 12 13 14 15 16 97 18 19 20 21 Balance Sheet 31-Dec-20 Assets Current Assets Cash $ 55,000.00 Marketable Securities $ Account Receivable $ 363,750.00 Inventory Table 6-7 $ 625,000.00 Total Current Assets $1,043,750.00 Plant and Equipment $ 100,000.00 Total Assets $1,143,750.00 Liabilities and Shareholders Equity Account Payable $ 25,000.00 Long-Term Debt $ Common Stocks $ 268,750.00 Retained Earnings $ 850,000.00 Total Liabilities and Shareholders Equity $1,143,750.00 G H 1 J Balance Sheet 30-Jun-21 Assets Current Assets Cash $ 55,000.00 Marketable Securities $ 641,608.52 Account Recelvable $ 288,000.00 Inventory Table 6-7 $ 106,900.00 Total Current Assets $ 1,091,508.52 Plant and Equipment $ 220,000.00 Total Assets $1,311,508.52 Liabilities and Shareholders Equity Account Payable $ 95,099.50 Note Payable $ 80,394.12 Long-Term Debt $ Common Stocks $ 268,750.00 Retained Earnings $ 867,264.90 Total Liabilities and Shareholders Equity $1,311,508.52 5 6 7 8 1. Cash $55,000 - minimum cash balance as shown i Table.... 2. Marketable Securities 3. Account Receivable $288,000.00 based on the June sales $384,000.0 4. Inventory $106,900 - ending inventory from Table 6-7 5. Plant and Equipment $220,000 Initial value $ 100,000.00 Purchases $ 120.000.00 Total: $ 220,000.00 6. Accounts Payable $95,099.50 - based on June purchases Table.... TI 7. Notes Payable $80,394.12 - the amount we must borrow to maintai 8. Long-Term Debt-there is no long term debt. 9.Common stock - remain unchanged from prior value. 0 1 2 Proforma Balance Sheet (ASPE) - new funds required Pro Forma Income Statement Table(6-8) Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expense Operating Profit (EBIT) Interest Expense Earning before Taxes (EBT) Taxes 25% Earning after Taxes (EAT) Changes in Retaining Earnings Common Stock Dividends Declared Increase in Retaining Earnings $ 2,151,000.00 $ 2,001,000.00 $ 150,000.00 $ 20,000.00 $ 130,000.00 $ 10,000.00 $ 120,000.00 $ 30,000.00 $ 90,000.00 $ 12,000.00 $ 17,264.90 BIGA 100 - $ *. .00 123- Default (Ca 11 .. fix K 8 c D E F 3 4 5 6 7 9 10 11 12 13 14 15 16 97 18 19 20 21 Balance Sheet 31-Dec-20 Assets Current Assets Cash $ 55,000.00 Marketable Securities $ Account Receivable $ 363,750.00 Inventory Table 6-7 $ 625,000.00 Total Current Assets $1,043,750.00 Plant and Equipment $ 100,000.00 Total Assets $1,143,750.00 Liabilities and Shareholders Equity Account Payable $ 25,000.00 Long-Term Debt $ Common Stocks $ 268,750.00 Retained Earnings $ 850,000.00 Total Liabilities and Shareholders Equity $1,143,750.00 G H 1 J Balance Sheet 30-Jun-21 Assets Current Assets Cash $ 55,000.00 Marketable Securities $ 641,608.52 Account Recelvable $ 288,000.00 Inventory Table 6-7 $ 106,900.00 Total Current Assets $ 1,091,508.52 Plant and Equipment $ 220,000.00 Total Assets $1,311,508.52 Liabilities and Shareholders Equity Account Payable $ 95,099.50 Note Payable $ 80,394.12 Long-Term Debt $ Common Stocks $ 268,750.00 Retained Earnings $ 867,264.90 Total Liabilities and Shareholders Equity $1,311,508.52 5 6 7 8 1. Cash $55,000 - minimum cash balance as shown i Table.... 2. Marketable Securities 3. Account Receivable $288,000.00 based on the June sales $384,000.0 4. Inventory $106,900 - ending inventory from Table 6-7 5. Plant and Equipment $220,000 Initial value $ 100,000.00 Purchases $ 120.000.00 Total: $ 220,000.00 6. Accounts Payable $95,099.50 - based on June purchases Table.... TI 7. Notes Payable $80,394.12 - the amount we must borrow to maintai 8. Long-Term Debt-there is no long term debt. 9.Common stock - remain unchanged from prior value. 0 1 2 Proforma Balance Sheet (ASPE) - new funds required Pro Forma Income Statement Table(6-8) Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expense Operating Profit (EBIT) Interest Expense Earning before Taxes (EBT) Taxes 25% Earning after Taxes (EAT) Changes in Retaining Earnings Common Stock Dividends Declared Increase in Retaining Earnings $ 2,151,000.00 $ 2,001,000.00 $ 150,000.00 $ 20,000.00 $ 130,000.00 $ 10,000.00 $ 120,000.00 $ 30,000.00 $ 90,000.00 $ 12,000.00 $ 17,264.90