I just need help with the balance sheet I have everything else done by myself
.
A B 1 Blue Screen Company 2 Pro Forma Income Statement 3 Quarter Ended September 30, 2019 Vertical 4. Analysis 5 Sales $932,668 100% 6 Cost of Goods Sold $606,234 65% 7 Gross Profit $326,434 35% 8 Operating Expenses: 9 Salary Expense $121,247 13% 10 Depreciation Expense $12,000 1% 11 Other Operating Expenses $102,594 11% 12 Total Expenses $235,840 25% 13 Net Income $90,594 10% 14 A 1 2 Blue Screen Company Pro Forma Balance Sheet 30-Sep-19 3 4. Vertical Analysis 5 $50,000 5 Assets 6 Cash 7 Accounts Receivable 8 Inventory 9 Equipment, net 10 Total Assets 11 12 Liabilities 13 Accounts Payable 14 Notes Payable 15 Total Liabilities 16 17 Stockholders Equity 19 Common Stock 20 Retained Earnings 21 Total Stockholders Equity 22 Total Liabilities & Stockholders Equity 23 18 $100,000 $260,809 24 25 26 Beginning Accounts Receivable=$35,000 27 Beginning Accounts Payable=$1,785 28 D E F 1 2. 3 4 5 Cost of Goods Sold 6 Desired Ending Inventory 7 Total Inventory Required 8 Beginning Inventory 9 Total Purchases Required 10 B Blue Screen Company Cost of Goods Sold Budget 3rd Quarter 2019 July August $197,925 $ 201,884 $173,236 $176,601 $371,161 $378,484 $125,000 $173,236 $246,161 $205,248 September Total $206,426 $606,234 $180,462 $530,299 $386,888 $1,136,534 $176,601 $474,837 $210,287 $661,696 11 12 June Ending Inventory=$125,000 13 14 Assumptions 15 Cost of Goods Sold=65% of Sales 16 Desired Ending Inventory=$5,000+85% of Cost of Goods Sold 17 18 A B 1 2 3 Blue Screen Company Purchases Budget 3rd Quarter 2019 July August September $86,156 $71,837 $73,600 $103,500 $110,772 $92,362 $189,656 $182,609 $165,962 Total $231,594 $306,634 $538,228 4 5 35% Current Month 6 45% Previous Month 7 Total Payments 8 9 10 Assumptions: 11 June Purchases=$230,000 12 A B D 1 Blue Screen Company 2 Cash Budget 3 3rd Quarter 2019 4 July August September 5 Beginning Balance $0 $186,319 $349,251 6 Cash Collections $345,555 $309,311 $316,600 7 Cash Available $345,555 $495,630 $665,851 8 Cash Payments: 9 Purchases $86,156 $71,837 $73,600 10 Operating Expenses $73,080 $74,542 $76,219 11 Total Cash Payments $159,236 $146,379 $149,819 12 Desired Ending Cash Balance $50,000 $50,000 $50,000 13 Cash Excess or (Deficiency) $186,319 $349,521 $516,031 14 Note Payable 15 Ending Cash Balance $186,319 $349,521 $516,031 16 17 18 Assumptions: 19 Ending Cash Balance for June=$50,000 20 Desired Ending Cash Balance=$7,500 21 Note Payable of $6,000 was issued September 30 22 A B 1 Blue Screen Company 2 Pro Forma Income Statement 3 Quarter Ended September 30, 2019 Vertical 4. Analysis 5 Sales $932,668 100% 6 Cost of Goods Sold $606,234 65% 7 Gross Profit $326,434 35% 8 Operating Expenses: 9 Salary Expense $121,247 13% 10 Depreciation Expense $12,000 1% 11 Other Operating Expenses $102,594 11% 12 Total Expenses $235,840 25% 13 Net Income $90,594 10% 14 A 1 2 Blue Screen Company Pro Forma Balance Sheet 30-Sep-19 3 4. Vertical Analysis 5 $50,000 5 Assets 6 Cash 7 Accounts Receivable 8 Inventory 9 Equipment, net 10 Total Assets 11 12 Liabilities 13 Accounts Payable 14 Notes Payable 15 Total Liabilities 16 17 Stockholders Equity 19 Common Stock 20 Retained Earnings 21 Total Stockholders Equity 22 Total Liabilities & Stockholders Equity 23 18 $100,000 $260,809 24 25 26 Beginning Accounts Receivable=$35,000 27 Beginning Accounts Payable=$1,785 28 D E F 1 2. 3 4 5 Cost of Goods Sold 6 Desired Ending Inventory 7 Total Inventory Required 8 Beginning Inventory 9 Total Purchases Required 10 B Blue Screen Company Cost of Goods Sold Budget 3rd Quarter 2019 July August $197,925 $ 201,884 $173,236 $176,601 $371,161 $378,484 $125,000 $173,236 $246,161 $205,248 September Total $206,426 $606,234 $180,462 $530,299 $386,888 $1,136,534 $176,601 $474,837 $210,287 $661,696 11 12 June Ending Inventory=$125,000 13 14 Assumptions 15 Cost of Goods Sold=65% of Sales 16 Desired Ending Inventory=$5,000+85% of Cost of Goods Sold 17 18 A B 1 2 3 Blue Screen Company Purchases Budget 3rd Quarter 2019 July August September $86,156 $71,837 $73,600 $103,500 $110,772 $92,362 $189,656 $182,609 $165,962 Total $231,594 $306,634 $538,228 4 5 35% Current Month 6 45% Previous Month 7 Total Payments 8 9 10 Assumptions: 11 June Purchases=$230,000 12 A B D 1 Blue Screen Company 2 Cash Budget 3 3rd Quarter 2019 4 July August September 5 Beginning Balance $0 $186,319 $349,251 6 Cash Collections $345,555 $309,311 $316,600 7 Cash Available $345,555 $495,630 $665,851 8 Cash Payments: 9 Purchases $86,156 $71,837 $73,600 10 Operating Expenses $73,080 $74,542 $76,219 11 Total Cash Payments $159,236 $146,379 $149,819 12 Desired Ending Cash Balance $50,000 $50,000 $50,000 13 Cash Excess or (Deficiency) $186,319 $349,521 $516,031 14 Note Payable 15 Ending Cash Balance $186,319 $349,521 $516,031 16 17 18 Assumptions: 19 Ending Cash Balance for June=$50,000 20 Desired Ending Cash Balance=$7,500 21 Note Payable of $6,000 was issued September 30 22
