Question: How do you create a cash flow statement (spreadsheet) with the two following tables? Balance Sheet (BS) 1 2 3 4 5 ASSETS Current Assets
How do you create a cash flow statement (spreadsheet) with the two following tables?
| Balance Sheet (BS) | 1 | 2 | 3 | 4 | 5 |
| ASSETS | |||||
| Current Assets | |||||
| Cash | $9,586 | $23,375 | $37,964 | $30,994 | $51,953 |
| Inventory | $28,000 | $56,000 | $84,000 | $112,000 | $96,000 |
| Accounts Receivable | $2,400 | $2,600 | $3,800 | $5,400 | $9,800 |
| Total Current Assets | $39,986 | $81,975 | $125,764 | $148,394 | $157,753 |
| Gross Fixed Assets (at Cost) | |||||
| Investment | $217,371 | $199,430 | $245,071 | $106,004 | $158,299 |
| Net Fixed Assets | $637,514 | $547,727 | $484,851 | $547,218 | $477,055 |
| Total Assets | $894,871 | $829,132 | $855,686 | $801,616 | $793,107 |
| LIABILITIES AND STOCKHOLDERS EQUITY | |||||
| Current Liabilities | |||||
| Accounts Payable | $10,000 | $12,000 | $15,000 | $15,500 | $17,000 |
| Short Term Bank Credit | $70,000 | $50,000 | $50,000 | ||
| Total Current Liabilities | $10,000 | $12,000 | $85,000 | $65,500 | $67,000 |
| Long-Term Debt (incl. financial leases) | $458,355 | $415,043 | $369,998 | $323,150 | $274,427 |
| Total Liabilities | $468,355 | $427,043 | $454,998 | $388,650 | $341,427 |
| Stockholder Equity | |||||
| Common Stock | $435,000 | $435,000 | $435,000 | $435,000 | $435,000 |
| Retained Earnings | -$8,470 | -$32,911 | -$34,312 | -$22,034 | $16,681 |
| Total stockholders' equity | $426,530 | $402,089 | $400,688 | $412,966 | $451,681 |
| Total Liabilities and Stockholders Equity | $894,885 | $829,132 | $855,686 | $801,616 | $793,108 |
| Balance Sheet (BS) | 1 | 2 | 3 | 4 | 5 |
| ASSETS | |||||
| Current Assets | |||||
| Cash | $9,586 | $23,375 | $37,964 | $30,994 | $51,953 |
| Inventory | $28,000 | $56,000 | $84,000 | $112,000 | $96,000 |
| Accounts Receivable | $2,400 | $2,600 | $3,800 | $5,400 | $9,800 |
| Total Current Assets | $39,986 | $81,975 | $125,764 | $148,394 | $157,753 |
| Gross Fixed Assets (at Cost) | |||||
| Investment | $217,371 | $199,430 | $245,071 | $106,004 | $158,299 |
| Net Fixed Assets | $637,514 | $547,727 | $484,851 | $547,218 | $477,055 |
| Total Assets | $894,871 | $829,132 | $855,686 | $801,616 | $793,107 |
| LIABILITIES AND STOCKHOLDERS EQUITY | |||||
| Current Liabilities | |||||
| Accounts Payable | $10,000 | $12,000 | $15,000 | $15,500 | $17,000 |
| Short Term Bank Credit | $70,000 | $50,000 | $50,000 | ||
| Total Current Liabilities | $10,000 | $12,000 | $85,000 | $65,500 | $67,000 |
| Long-Term Debt (incl. financial leases) | $458,355 | $415,043 | $369,998 | $323,150 | $274,427 |
| Total Liabilities | $468,355 | $427,043 | $454,998 | $388,650 | $341,427 |
| Stockholder Equity | |||||
| Common Stock | $435,000 | $435,000 | $435,000 | $435,000 | $435,000 |
| Retained Earnings | -$8,470 | -$32,911 | -$34,312 | -$22,034 | $16,681 |
| Total stockholders' equity | $426,530 | $402,089 | $400,688 | $412,966 | $451,681 |
| Total Liabilities and Stockholders Equity | $894,885 | $829,132 | $855,686 | $801,616 | $793,108 |
| Income Statement (IS) | 1 | 2 | 3 | 4 | 5 | |
| Sales Revenues | $200,000 | $242,000 | $292,820 | $354,312 | $428,718 | |
| Direct Cost | $93,000 | $115,000 | $146,300 | $174,579 | $195,340 | |
| Gross Profits | $107,000 | $127,000 | $146,520 | $179,733 | $233,378 | |
| Less Operating Expenses | ||||||
| General and Administrative Expense | $23,456 | $31,345 | $39,876 | $48,767 | $63,254 | |
| Sales Expense | $15,987 | $20,458 | $23,390 | $27,489 | $29,458 | |
| Net Profit | $67,557 | $75,197 | $83,254 | $103,477 | $140,666 | |
| Depreciation Expense | $59,486 | $91,287 | $64,076 | $68,133 | $69,962 | |
| Total Operating Expense | $8,071 | -$16,090 | $19,178 | $35,344 | $70,704 | |
| Long Term Borrowings | $20,000 | $18,334 | $16,602 | $14,800 | $12,926 | |
| Short Term Credit Interest Expense | 6.50% | $0 | $0 | $4,550 | $3,250 | $3,250 |
| Total Interest | $20,000 | $18,334 | $21,152 | $18,050 | $16,176 | |
| Profit/Loss Before Tax | -$11,929 | -$34,424 | -$1,974 | $17,294 | $54,527 | |
| Less: Taxes | 29% | -$3,459 | -$9,983 | -$572 | $5,015 | $15,813 |
| Profit/Loss After Tax | -$8,470 | -$24,441 | -$1,402 | $12,279 | $38,714 | |
| Amount in Retained Earnings | -$8,470 | -$32,911 | -$34,313 | -$22,034 | $16,680 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
