Booster Company is preparing its financial statements for the year ended June 30, 2018. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017.
Booster Company A1 Company Facts:
PLEASE FILL IN THE BELOW CHARTS FOR THE ASSIGNMENT:------------------------------------------------------------------
BOOSTER CONSTRUCTION COMPANY | ||||||
Cash Flows Worksheet | ||||||
For Year Ended June 30,2018 | ||||||
Balances | Change | Worksheet Entries | ||||
Account Titles | 6/30/2017 | 6/30/2018 | Increase/(Decrease) | Debit | Credit | |
Debits | ||||||
Cash | $ 3,61,700 | $ 8,80,550 | $ 5,18,850 | $ 3,000 | ||
Accounts Receivable | $ 1,00,000 | $ 1,25,000 | $ 25,000 | |||
Marketable Securities (at cost) | $ 11,700 | $ 13,000 | $ 1,300 | |||
Allowance for change in value | $ 1,500 | $ 1,800 | $ 300 | $ 300 | ||
Construction in process | $ 1,68,750 | $ 4,05,000 | $ 2,36,250 | |||
Prepaid Expenses | $ 45,000 | $ 10,000 | $ -35,000 | |||
Investments (Long Term) | $ - | $ 13,500 | $ 13,500 | |||
Leased Equipment | $ - | $ 20,000 | $ 20,000 | |||
Building | $ 30,000 | $ - | $ -30,000 | |||
Deferred Tax Asset | $ 5,375 | $ 2,200 | $ -3,175 | |||
Land | $ 10,500 | $ 10,500 | $ - | |||
Discount on Bonds payable | $ - | $ 1,305 | $ 1,305 | |||
$ 7,34,525 | $ 14,82,855 | $ 7,48,330 | ||||
Credits | $ - | |||||
Allowance for doubtful accounts | $ 6,000 | $ 4,500 | $ -1,500 | |||
Accounts Payable | $ 87,500 | $ 2,10,000 | $ 1,22,500 | |||
Deferred Tax Liability | $ 1,000 | $ 3,300 | $ 2,300 | |||
Income Taxes payable | $ 3,500 | $ 9,000 | $ 5,500 | |||
Note payable (Long term) | $ 3,500 | $ - | $ -3,500 | $ 3,500 | ||
Accumulated Depreciation on Building | $ 2,500 | $ - | $ -2,500 | |||
Accumulated Depreciation on Leased asset | $ - | $ 3,000 | $ 3,000 | |||
Lease Obligation | $ - | $ 18,000 | $ 18,000 | |||
Interest payable on Lease obligation | $ - | $ 1,800 | $ 1,800 | |||
Interest payable (Bonds) | $ - | $ 1,800 | $ 1,800 | |||
Bonds Payable | $ - | $ 45,000 | $ 45,000 | |||
Billings on Construction in Process | $ 1,50,000 | $ 3,25,000 | $ 1,75,000 | |||
Pension Liability | $ 1,50,000 | $ 4,00,000 | $ 2,50,000 | |||
Convertible Preferred stock | $ 9,000 | $ - | $ -9,000 | $ 9,000 | ||
Common Stock | $ 14,000 | $ 24,500 | $ 10,500 | $ 10,500 | ||
Additional paid-in capital | $ 8,700 | $ 13,700 | $ 5,000 | $ 5,000 | ||
Unrealised increase in value of marketable securities | $ 1,500 | $ 1,800 | $ 300 | $ 300 | ||
Retained Earnings | $ 2,97,325 | $ 4,21,455 | $ 1,24,130 | |||
$ 7,34,525 | $ 14,82,855 | $ 7,48,330 | $ 15,800 | $ 15,800 |
Booster Construction Company | ||
Statement of Cash Flows | ||
For year Ended June 30,2018 | ||
Operating Activities: | ||
Net Income | $1,24,130 | |
Adjustments for Non-Cash items: | ||
Depreciation on Leased asset | $3,000 | |
Loss on Building Destruction | $1,500 | |
Share of Income in Ricochet co. | -$4,000 | |
Discound on bond written off {(450*3)/10 yrs*4 months/12} | $45 | |
Adjustments from working capital items: | ||
Inventory{(168750-150000)-(405000-325000)} | -$61,250 | |
Accounts Receivable | -$25,000 | |
Marketable Securities (at cost) | -$1,300 | |
Prepaid Expenses | $35,000 | |
Deferred Tax Asset | $3,175 | |
Allowance for doubtful accounts | -$1,500 | |
Accounts Payable | $1,22,500 | |
Deferred Tax Liability | $2,300 | |
Income Taxes payable | $5,500 | |
Interest payable on Lease obligation | $1,800 | |
Interest payable (Bonds) | $1,800 | |
Pension Liability | $2,50,000 | |
Payment of Dividend | $650 | |
Net Cash provided (used) by Operating Activities | $4,58,350 | |
Investing Activities: | ||
Investment in Ricochet co. | -$9,500 | |
Insurance claim received for building | $26,000 | |
Net Cash provided (used) by Operating Activities | $16,500 | |
Financing Activities: | ||
Issue of common stock (300*10) | $3,000 | |
Payment of Dividend | -$650 | |
Issue of Bonds (450*97) | $43,650 | |
Principal payment of Lease obligation | -$2,000 | |
Net Cash provided (used) by Operating Activities | $44,000 | |
Net Increase in cash | $5,18,850 | |
Cash,June 30,2017 | $3,61,700 | |
Cash,June 30,2018 | $8,80,550 | |
Investing and Financing activities not affecting cash: | ||
Investing: | ||
Lease Obligation balance | $18,000 | |
Unrealised increase in value of marketable securities | $300 | |
Financing: | ||
Conversion of preference shares to common stock | $5,000 | |
Conversion of note payable to common stock | $2,500 | |
Increase in additional paid in capital due to conversions | $5,000 |
Booster Company is preparing its financial statements for the year ended June 30, 2018. The financial...
Booster Company is preparing its financial statements for the year ended June 30, 2018. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017. Download the Excel spreadsheet Booster Company A1. Required: 1. Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2018. 2. In the Excel Worksheet column named Worksheet Entries', show...
Booster Company is preparing its financial statements for the year ended June 30, 2018. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017. Download the Excel spreadsheet Booster Company A1. Required: Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2018. In the Excel Worksheet column named ‘Worksheet Entries’, show under Debit...
This question has been posted before with various answers posted. Please provide your working notes so I can see how you arrived at your answers. Thanks in advance. Smart Company is preparing its financial statements for the year ended June 30, 2017. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017. Download the excel spreadsheet found in the link...
Supplements Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 230,000 Cost of Goods Sold 93,000 Gross Profit 137,000 Operating Expenses: Salaries Expense $ 57,000 Depreciation Expense Plant Assets 28,000 Total Operating Expenses 85,000 Net Income Before Income Taxes 52,000 Income Tax Expense 8,000 $ Net Income 44,000 c. a. Acquisition of plant assets is $118,000. Of this amount, $105,000 is paid in cash and $13,000 by signing a note payable. b. Cash receipt from sale...
Mike's Equipment's accountants assembled the following data for the year ended November 30, 2018. (Click the icon to view the data.) Prepare Mike's Equipment's statement of cash flows for the year ended November 30, 2018, using the indirect method. The cash balance for Mike's Equipment, Inc., at November 30, 2017, was $15,000. Begin by completing the cash flows from operating activities. (Use parentheses or a minus sign for numbers to be subtracted.) Mike's Equipment, Inc. Statement of Cash Flows Year...
In preparation for developing its statement of cash flows for the year ended December 31, 2018, Millennium Solutions, Inc. collected the following information: ($ in millions) Payment for the early extinguishments of long-term notes (book value: $68.0 million) $ 72.0 Sale of common shares 216.0 Retirement of common shares 132.0 Loss on sale of equipment 3.0 Proceeds from sale of equipment 12.0 Issuance of short-term note payable for cash 20.0 Acquisition of building for cash 12.0 Purchase of marketable securities...
Act Inc. began operations on June 1, 2017. The financial statements for the company are shown below for the month ended June 30, 2017 (the first month of operations). Determine the missing amounts for letters (a) through (o). Hint: Start at the bottom and work your way up. Act Inc Income Statement For the Month Ended June 30, 2017 Fees earned $37,000 Operating expenses: Wages expense $15,250 Rent expense (a) Supplies expense 4,600 Utilities expense 400 Miscellaneous expense 1,250 Total...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 74,900 $ 65,000 Accounts receivable, net 96,500 72,000 Inventory 84,800 118,000 Prepaid expenses 6,500 9,600 Total current assets 262,700 264,600 Equipment 145,000 136,000 Accum. depreciation—Equipment (37,500 ) (19,500 ) Total assets $ 370,200 $ 381,100 Liabilities and Equity Accounts payable $ 46,000 $ 61,500 Wages payable 8,100 19,200 Income taxes payable 5,500 8,000 Total current liabilities...
BARCELONA INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 86,300 $ 41,700 Accounts receivable, net 78,000 61,000 Inventory 66,000 92,000 Prepaid expenses 5,000 6,300 Total current assets 235,300 201,000 Equipment 153,000 142,000 Accum. depreciation—Equipment (39,000 ) (13,000 ) Total assets $ 349,300 $ 330,000 Liabilities and Equity Accounts payable $ 30,000 $ 36,000 Wages payable 8,000 19,000 Income taxes payable 3,600 4,000 Total current liabilities 41,600 59,000 Notes payable (long term) 38,000 75,000 Total...
Accountants for Morston, Inc. have assembled the following data for the year ended December 31, 2018 in (Click the icon to view the current accounts.) Click the icon to view the transaction data.) Prepare Morston's statement of cash flows using the indirect method. Include an accompanying schedule of non-cash investing and financing activities. Complete the statement one section at a time, beginning with the cash flows from operating activities. (Use a minus sign or parentheses for amounts that result in...