Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Energy Finance And Economics Analysis And Valuation Risk Management And The Future Of Energy

Authors: Betty Simkins, Russell Simkins

1st Edition

1118017129, 978-1118017128

More Books

Students also viewed these Finance questions

Question

What does SMART stand for? (p. 86)

Answered: 1 week ago