Question

In: Accounting

Use the following information for the next four questions: 2017 2018 Beginning Cash Balance 20,000 50,000...

Use the following information for the next four questions:

	2017	2018
Beginning Cash Balance	20,000	50,000
Net Income	65,000.00	75,000.00
Accounts Receivable	10,000.00	6,000.00
Prepaid Insurance	5,000.00	3,500.00
Inventory	20,000.00	24,000.00
Accounts Payable	3,000.00	2,000.00
Unearned Revenue	5,000.00	7,000.00
Depreciation Expense	25,000.00	20,000.00
Cash Paid for Dividends	25,000.00	5,000.00
Cash Payment to Repay Note Payable	-	10,000.00
Cash Payment to Purchase Land	10,000.00	-
Cash Received for Sale of Equipment	-	15,000.00
Cash Received for Issuance of Stock	-	10,000.00

What is the cash flow from operating activities for 2018 (use negative number for cash outflow and positive number for net cash inflow)

What is the cash flow from investing activities for 2018 (use negative number for cash outflow and positive number for net cash inflow)

What is the cash flow from financing activities for 2018 (use negative number for cash outflow and positive number for net cash inflow)

What is the ending cash balance for 2018?

Expert Solution

Solution:

Requirement:1

Cash flows from operating activities:
Net Income	$ 75,000
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense	$ 20,000
Changes in current operating assets and liabilities:
Decrease in Account Receivable	$ 4,000
Decrease in Prepaid insurance	$ 1,500
Increase in Inventory	$ (4,000)
Decrease in accounts payable	$ (1,000)
Increase in unearned revenue	$ 2,000
Cash flows from operating activities		$ 97,500

Requirement:2

Cash flow from[used for] investing activities:
Cash payment to repay note payable	$ (10,000)
Cash received for sale of equipment	$ 15,000
Cash flow from investing activities (B)	$ -	$ 5,000

Requirement:3

Cash flow from financing activities:
Cash from issuance of common stock	$ 10,000
Cash used for dividends	$ (5,000)
Cash flow from financing activities (C )		$ 5,000

Requirement:4

Ending cash balance for 2018 = $ 157,500

Calculation:

Ending cash balance for 2018 = Opening Balance + Cash flow from operating, investing and financing activities

= 50000 + 97500+5000+5000 = 157500

ekkarill92 answered 1 year ago

Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000...

Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000 A/R 24,000 25,000 Inventory 79,000 78,000 Prepaid Insurance 5,000 4,000 Preoperty plant, & Equipment 35,000 30,000 Accumlated Depreciation (7,000) (5,000) Total Assets 151,000 146,000 Account Payable 6,000 9,000 Bonds Payable (mature in yr 2022 45,000 60,000 Common Stock 70,000 60,000 Retaind Earnings 30,000 17,000 Total Liabilities & Equity 151,000 146,000 Sunny Company had the following comparative balance sheet information for 2018, 2017: Sunny reported...

Use the following information to answer the next four questions. The cash flows for two mutually...

Use the following information to answer the next four questions. The cash flows for two mutually exclusive projects are shown in the following table. Investors require a 16% rate of return for each project. Year Cash Flows: Project S (in millions) Cash Flows: Project T (in millions) 0 -200 -200 1 -20 50 2 45 60 3 70 30 4 -10 -40 5 125 100 6 125 100 7 150 100 Find the profitability index for project S. Round intermediate...

Use the following information to answer the next 10 questions: A company with 50,000 authorized shares...

Use the following information to answer the next 10 questions: A company with 50,000 authorized shares of $1 par common stock issued 10,000 shares at $10 per share. Subsequently, the company declared and paid a $3 cash dividend per share. On the date the company declared the dividend, the market price of the shares was $30 per share. What is the effect of the dividend on Retained Earnings? Retained earnings decreased Retained earnings increased Retained earnings remained the same None...

Use the information below to answer the next 3 questions: At the beginning of the year,...

Use the information below to answer the next 3 questions: At the beginning of the year, JJB Inc. estimated that overhead would be $880,000 and direct labor hours would be 220,000 hours. At the end of the year actual overhead was $920,600 and there were actual direct labor hours of 230,000. Year ended unadjusted COGS is $2,000,000. What is the Rredetermined Overhead Rate? $2.63 $4 $4.18 None of the above QUESTION 8 What is the overhead variance? $200 overapplied $400...

1.3.22 Choosing numbers Use the following information to answer the next four questions. One of the...

1.3.22 Choosing numbers Use the following information to answer the next four questions. One of the authors read somewhere that it’s been conjectured that when people are asked to choose a number from the choices 1, 2, 3, and 4, they tend to choose “3” more than would be expected by random chance. To investigate this, she collected data in her class. Here is the table of responses from her students: chose 1 chose 2 chose 3 chose 4 10...

Use the following information for the next four questions: Question 16: The Umbrella Corporation is considering...

Use the following information for the next four questions: Question 16: The Umbrella Corporation is considering expanding one of its production facilities to research a new type of zombie, which will hopefully not result in another zombie outbreak. The project would require a $21,000,000 capital investment and will be depreciated (straight-line to zero) over its 3 year life. They know that they will be able to salvage $8,500,000 for the equipment at that time. Incremental sales are expected to be...

Use the following information to answer the next four questions: Consider two municipalities, A and B,...

Use the following information to answer the next four questions: Consider two municipalities, A and B, in the same province. Residents in municipality A enjoy attending outdoor music concerts (a public good) held in their public park. Each resident in municipality A has a marginal benefit curve for these concerts given by MB=10-2Q, where Q is the number of outdoor concerts. There are 100 residents in this municipality. Residents in municipality B do not enjoy outdoor music concerts (they are...

Use the following information to create 1) Balance Sheet for yearends 2017 and 2018 and 2)...

Use the following information to create 1) Balance Sheet for yearends 2017 and 2018 and 2) and Income statement for 2018 1) She had 305 breeding does value at $340/head at yearend 2017. She increased her flock in 2018 to 325 head. 2) As of December 31, 2017, she had livestock held for sale (lambs and non-breeding ewes) valued at $38,000. She also had wool inventories valued at $9,000. As of December 31, 2018, her livestock inventories increased to $43,000,...

The Murdock Corporation reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash...

The Murdock Corporation reported the following balance sheet data for 2018 and 2017: 2018 2017 Cash $77,375 $22,955 Available-for-sale debt securities (not cash equivalents) 15,500 85,000 Accounts receivable 80,000 68,250 Inventory 165,000 145,000 Prepaid insurance 1,500 2,000 Land, buildings, and equipment 1,250,000 1,125,000 Accumulated depreciation (610,000) (572,000) Total assets $979,375 $876,205 Accounts payable $76,340 $148,670 Salaries payable 20,000 24,500 Notes payable (current) 25,000 75,000 Bonds payable 200,000 0 Common stock 300,000 300,000 Retained earnings 358,035 328,035 Total liabilities and shareholders'...

The following information is available for the Perez Company: Comparative Balance Sheets 2017 2018 Cash $800...

The following information is available for the Perez Company: Comparative Balance Sheets 2017 2018 Cash $800 $1,200 Accounts receivable 440 400 Inventory 740 1,220 Land 500 820 Equipment 4,140 4,400 Less:Accumulated depreciation (620) (800) Total Assets $6,000 $7,240 Accounts payable $1,600 $1,000 Notes payable (long-term) 1,800 1,440 Common stock, no par 1,200 2,000 Retained earnings 1,400 2,800 Total Liabilities and Stockholders' Equity $6,000 $7,240 Partial additional information:The net income for 2018 totaled $3,200. During 2018, the company sold for $780,...