Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started