In: Accounting
Portions of the financial statements for Myriad Products are
provided below.
|
MYRIAD PRODUCTS COMPANY Income Statement For the Year Ended December 31, 2018 ($ in millions) |
|||||||
| Sales | $ | 780 | |||||
| Cost of goods sold | 273 | ||||||
| Gross margin | 507 | ||||||
| Salaries expense | $ | 120 | |||||
| Depreciation expense | 86 | ||||||
| Patent amortization expense | 5 | ||||||
| Interest expense | 26 | ||||||
| Loss on sale of land | 4 | 241 | |||||
| Income before taxes | 266 | ||||||
| Income tax expense | 133 | ||||||
| Net Income | $ | 133 | |||||
|
MYRIAD PRODUCTS COMPANY Selected Accounts from Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) |
|||||||||
| Year | |||||||||
| 2018 | 2017 | Change | |||||||
| Cash | $ | 120 | $ | 118 | $ | 2 | |||
| Accounts receivable | 249 | 259 | (10 | ) | |||||
| Inventory | 449 | 468 | (19 | ) | |||||
| Accounts payable | 185 | 170 | 15 | ||||||
| Salaries payable | 92 | 104 | (12 | ) | |||||
| Interest payable | 52 | 38 | 14 | ||||||
| Income taxes payable | 42 | 28 | 14 | ||||||
Required:
Prepare the cash flows from operating activities section of the
statement of cash flows for Myriad Products Company using the
direct method. (Amounts to be deducted should be
indicated with a minus sign. Enter your answers in millions (i.e.,
10,000,000 should be entered as 10).)
First I am giving you all the calculations to arrive at the figures to be used in the Cash Flow Statement
1. Purchases for the year
Cost of goods sold = Op Inventory + Purchases - Cl
Inventory
Purchases = Cost of goods sold + Cl Inventory - Op Inventory
Purchases = 273 + 449 - 468
Purchases = 254
This means amount paid to vendor would be
Cl Payable = Op Payable + Purchases - Amount paid
Amount paid = Op Payable + Purchases - Cl Payable
Amount paid = 170 + 254 - 185 = 239
2. Amount collected from Debtors
Cl Receivable = Op Receivable + Sales - Amount Collected
Amount collected = Op Receivable + Sales - Cl Receivable
Amount collected = 259 + 780 - 249 = 790
3. Salaries Paid
Cl Payable = Op Payable + Salaries Expenses - Salaries
paid
Salaries paid = Op Payable + Salaries Expense - Cl Payable
Salaries paid = 104 + 120 - 92 = 132
4. Interest paid
Cl Payable = Op Payable + Interest expense - Interest paid
Interest paid = Op payable + Interest expense - Cl payable
Interest paid = 38 + 26 - 52 = 12
5. Income taxes paid
Cl Payable = Op Payable + Tax expense - Tax paid
Tax paid = Op payable + Tax expense - Cl payable
Taxes paid = 28 + 133 - 42 = 119
| Cash Flow Statement | |
| Particulars | Amount |
| Cash collected from customers | $ 790 |
| Cash paid to suppliers | $ (239) |
| Cash paid to employees | $ (132) |
| From Operations | $ 419 |
| Interest paid | $ (12) |
| Income taxes paid | $ (119) |
| Cash generated from operating activities | $ 288 |
Here it is from indirect
| Net Income | $ 133 |
| Depreciation | $ 86 |
| Amortization | $ 5 |
| Loss on sale | $ 4 |
| Decrease in receivable | $ 10 |
| Inventory | $ 19 |
| Payable | $ 15 |
| Salaries | $ (12) |
| Interest | $ 14 |
| Taxes | $ 14 |
| $ 288 |