The income statement and a schedule reconciling cash flows from operating activi
ID: 2490918 • Letter: T
Question
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in millions) for Mike Roe Computers.
MIKE ROE COMPUTERS
Income Statement
For the Year Ended December 31, 2013
Sales $ 151.00
Cost of goods sold (90.50)
Gross margin 60.50
Salaries expense $ 21.00
Insurance expense 13.00
Depreciation expense 5.50
Interest expense 6.50 (46.00)
Gains and losses:
Gain on sale of equipment 13.00
Loss on sale of land (4.00)
Income before tax 23.50
Income tax expense (11.75)
Net income $ 11.75
Reconciliation of Net Income
to Net Cash Flows
from Operating Activities
Net income $ 11.75
Adjustments for noncash effects:
Decrease in accounts receivable 5.50
Gain on sale of equipment (13.00)
Increase in inventory (6.50)
Increase in accounts payable 9.50
Increase in salaries payable 3.50
Depreciation expense 5.50
Decrease in bond discount 3.25
Decrease in prepaid insurance 2.50
Loss on sale of land 4.00
Increase in income tax payable 6.50
Net cash flows from operating activities $ 32.50
Required:
1.
Calculate each of the following amounts for Mike Roe Computers: (Enter your answers in millions of dollars rounded to 2 decimal places. Input all amounts as positive values.)
($ in millions)
a. Cash received from customers during the reporting period. $
b. Cash paid to suppliers of goods during the reporting period. $
c. Cash paid to employees during the reporting period. $
d. Cash paid for interest during the reporting period. $
e. Cash paid for insurance during the reporting period. $
f. Cash paid for income taxes during the reporting period. $
2.
Prepare the cash flows from operating activities section of the statement of cash flows (direct method). (Enter your answers in millions of dollars rounded to 2 decimal places.Amounts to be deducted should be indicated with a minus sign.)
($ in millions)
Cash Flows From Operating Activities:
(Click to select)To bondholdersCash paid for insuranceCash received from customersCash paid for income taxesCash paid to employeesCash paid for interestCash paid to suppliersFor depreciation expense $
(Click to select)Cash paid for income taxesCash paid to suppliersCash paid for insuranceCash paid for interestCash received from customersFor depreciation expenseCash paid to employeesTo bondholders
(Click to select)Cash paid for insuranceCash paid for income taxesTo bondholdersCash received from customersCash paid to suppliersFor depreciation expenseCash paid to employeesCash paid for interest
(Click to select)To bondholdersCash paid to employeesFor depreciation expenseCash paid for interestCash paid for insuranceCash paid for income taxesCash paid to suppliersCash received from customers
(Click to select)Cash paid for insuranceCash received from customersCash paid to employeesFor depreciation expenseCash paid for interestCash paid for income taxesTo bondholdersCash paid to suppliers
(Click to select)Cash paid to employeesCash paid for interestCash paid to suppliersTo bondholdersCash paid for insuranceCash received from customersFor depreciation expenseCash paid for income taxes
Net cash flows from operating activities $
Explanation / Answer
CAsh received from customers = Net sales +decrease in Accounts Receivable
= 151+5.50 = 156.5
Cash paid to suppliers = Cost of goods sold +Increase in Inventory - increase in Accounts payable
= 90.50+6.50-9.50 = 87.5
CAsh Paid to Employees = salaries expense - Increase in salaries payable
= 21-3.50 = 17.5
CAsh paid for interest = Interest expense
=6.50
Cash paid for insurance = Insurance Expense - decrese in prepaid insurance
= 13 -2.50 = 10.5
CAsh paid for income tax = Income tax expense - increase in income tax payable
= 11.75-6.50 =5.25
Cash flows from Operating Activities
Cash Received from customers 156.5 CAsh Payment Suppliers (87.5) Employees (17.5) Interest (6.50) Insurance (10.5) Income tax (5.25) +Decrease in bond discount 3.25 CAsh Flow from operating Activities 32.50Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.