Question
Information given 20X1 ACTUAL ($,000) INCOME STATEMENT Sales $ 9,200 Costs of goods sold 4,780 Gross margin 4,420 Wages and salaries 1,530 Rent and facilities
Information given
20X1 ACTUAL ($,000) | |
INCOME STATEMENT |
|
Sales | $ 9,200 |
Costs of goods sold | 4,780 |
Gross margin | 4,420 |
Wages and salaries | 1,530 |
Rent and facilities | 840 |
Advertising | 585 |
Administrative expenses | 435 |
Interest | 72 |
Depreciation | 57 |
Training | 38 |
Other | 54 |
Profit before taxes | 809 |
Income tax | 283 |
Net profit | $ 526 |
|
|
KEY BALANCE SHEET FIGURES | DECEMBER 31, 20X1 ($,000) |
Assets |
|
Cash | $ 208 |
Accounts Receivable | 255 |
Inventory | 985 |
Property, plant, and equipment | 1,854 |
Other assets |
325 |
Total assets | $ 3,627 |
|
|
Liabilities |
|
Accounts payable | $ 209 |
Bank loan |
1,180 |
Stockholders equity | 2,238 |
Total liabilities and stockholders equity | $ 3,627 |
Based on the given information and , fill in the blankets in the following table about the planned cash flows in Retail Company in 20X2:
Cash at the beginning of the year | ??? |
Cash from Operating Activities | |
Profit after taxes | 648 |
Tax payments | 349 |
Interest payments | 65 |
Depreciation and other noncash expenses | 109 |
EBITDA | 1171 |
Changes in Working Capital | |
Decrease (increase) in accounts receivable | ??? |
Decrease (increase) in inventory | ??? |
Increase (decrease) in accounts payable | ??? |
Cash flow from operating activities | 1068 |
Cash from Investment Activities | |
Investment in new assets | -260 |
Cash from Financing Activities | |
Payback debt | -300 |
Additional borrowing required | |
Tax payments | -349 |
Interest payments | -65 |
Total cash flows | ? |
Cash at the end of the year | ??? |
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