Please see attached. I need to put together a cash flow statement.

Please see attached. I need to put together a cash flow statement.

ATTACHMENT PREVIEW

Download attachment

Unit 3 Assignment
Balance Sheets
Income Statements
Statement of Cash Flows 20X2
12/31/20X1
12/31/20X2
12/31/20X1
12/31/20X2
Sales
$1,578
$2,106
Cash
$30
$40
COGS
$631
$906
Accounts Receivable
$175
$351
Gross Margin
$947
$1,200
Inventory
$90
$151
CURRENT ASSETS
$295
$542
Expenses
Marketing
$316
$495
Fixed Assets
R&D
$158
$211
Gross
$1,565
$2,373
Administration
$126
$179
Accum. Depreciation
$(610)
$(860)
Total Expenses
$600
$885
Net
$955
$1,513
EBIT
$347
$315
TOTAL ASSETS
$1,250
$2,055
Interest
$63
$95
EBT
$284
$220
Tax
$97
$75
LIABILITIES
LIABILITIES
Net Income
$187
$145
Accounts Payable
$56
$81
Accruals
$15
$20
CURRENT LIABILITIES
$71
$101
Long-Term Debt
$630
$1,260
Equity
$549
$694
TOTAL CAPITAL
$1,179
$1,954
TOTAL LIABILITIES
AND EQUITY
$1,250
$2,055
20X1
20X2
Sales
COGS
Gross Margin
Expenses
Marketing
R&D
Administration
Total Expenses
EBIT
Interest
EBT
Tax
Net Income
20X1
20X2
Current Ratio
Quick Ratio
ACP
Inventory Turnover
Fixed Asset Turnover
Total Asset Turnover
Debt Ratio
Debt:Equity
TIE
ROS
ROA
ROE
Equity Multiplier
ASSETS
ASSETS
1.
Below are Protek’s balance sheet and income statement for two years.
The company sold no stock and
paid no dividends. Numbers in the statements are in millions. Construct the statement of cash flows for 20X2
in the area to the right.
2.
Using the information above, develop common size income statements for 20X1 and 20X2.
3.
Continuing to use the information above, calculate the requested ratios for 20X1 and 20X2.

Leave a Comment