Question

In: Accounting

Analysts were given the following balance sheet information for the years ended June 30, 2016 and...

Analysts were given the following balance sheet information for the years ended June 30, 2016 and June 30, 2015:

Assets

2016

2015

Cash and Marketable Securities

$38,104

$25,631

Accounts Receivable

$342,742

$216,708

Inventory

$332,760

$429,860

Other Current Assets

$105,809

$85,672

Total Current Assets

$819,415

$757,871

Gross Plant and Equipment

$2,050,368

$1,859,234

Less: Accumulated Depreciation

($432,560)

($386,720)

Net Plant and Equipment

$1,617,808

$1,472,514

Goodwill and Other Assets

$286,539

$312,672

Total Assets

$2,723,762

$2,543,057

Liabilities and Equity

2016

2015

Accounts Payable

$332,450

$389,321

Notes Payable

$25,769

$35,870

Accrued Income Taxes

$42,870

$35,680

Total Current Liabilities

$401,089

$460,871

Long-Term Debt

$805,642

$701,830

Total Liabilities

$1,206,731

$1,162,701

Common Stock

$100,000

$100,000

Additional Paid-In Capital

$546,802

$546,802

Retained Earnings

$870,229

$733,554

Total Common Equity

$1,517,031

$1,380,356

Total Liabilities and Equity

$2,723,762

$2,543,057

In addition, it was reported that the company had a net income of $4,685,213 and that depreciation expenses were equal to $45,840 during 2016.

Construct a 2016 cash flow statement and statement of retained earnings for this firm and include:

1.) net cash from operating activities

2.) net cash used in investing activities

3.) net cash provided by financing activities

Solutions

Expert Solution

Statement of Cash Flows
For the Year Ended June 30, 2016
Cash flows from operating activities:
Net income $4,685,213
Add (deduct) items not affecting cash:
Depreciation expense $45,840
Amortization expense $26,133
Increase in accounts receivable -$126,034
Decrease in inventory $97,100
Increase in other current assets -$20,137
Decrease in accounts payable -$56,871
Decrease in note payable -$10,101
Increase in accrued income taxes $7,190
-$36,880
Net cash provided by operating activities $4,648,333
Cash flows from investing activities:
Purchases of plant & equipment -$191,134
Net cash used in investing activities -$191,134
Cash flows from financing activities:
Proceeds from long-term debt $103,812
Payment of dividends -$4,548,538
Net cash provided by financing activities -$4,444,726
Net increase in cash for the year $12,473
Cash and cash equivalent on June 30, 2015 $25,631
Cash and cash equivalent on June 30, 2016 $38,104
1 net cash from operating activities $4,648,333
2 net cash used in investing activities -$191,134
3 net cash provided by financing activities -$4,444,726

Related Solutions

Upham Company’s June 30, 2016, balance sheet included the following information: Upham Company Partial Balance Sheet...
Upham Company’s June 30, 2016, balance sheet included the following information: Upham Company Partial Balance Sheet June 30, 2016 1 Accounts Receivable $248,000.00 2 Less: Allowance for Doubtful Accounts (14,400.00) $233,600.00 3 Notes Receivable 21,400.00 4 Total Receivables $255,000.00 5 * The company has a recourse liability of $2,450 for notes receivable sold with recourse. During the company’s fiscal year ending June 30, 2017, the following transactions occurred: 1. Sales on credit $870,400 2. Collections of accounts receivable 842,800 3....
The draft accounts for the year ended 30 June 2019 and a balance sheet as at...
The draft accounts for the year ended 30 June 2019 and a balance sheet as at that date for W. Willow are submitted to you. Towards the end of the financial year, her accountant resigned and she had completed the records herself. She thinks that errors have occurred and asks for your help. An examination of the accounting records reveals the following. W. Willow is registered for GST. Required: (a) Show the journal entries required to make the necessary adjustments....
The draft accounts for the year ended 30 June 2015 and a balance sheet as at...
The draft accounts for the year ended 30 June 2015 and a balance sheet as at that date for Thomson are submitted to you. Towards the end of the financial year, her accountant resigned, and she had completed the records herself. He thinks that errors have occurred and asks for your help. An examination of the accounting records reveals the following Thomson is registered for GST. Required; Show the journal entries required to make the necessary adjustments. Interest of $1920...
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30,...
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30, 2013. On that date the firm had cash and marketable securities of $25,135, accounts receivable of $43,758, inventory of $165,200, net fixed assets of $329,800, and other assets of $13,125. It had accounts payables of $67,855, notes payables of $36,454, long-term debt of $223,200, and common stock of $150,000. How much retained earnings did the firm have? Retained earnings $
Given the following information about Cullumber Sporting Goods, Inc., construct a balance sheet for June 30,...
Given the following information about Cullumber Sporting Goods, Inc., construct a balance sheet for June 30, 2017. On that date the firm had cash and marketable securities of $25,135, accounts receivables of $43,758, inventory of $167,000, net fixed assets of $329,700, and other assets of $13,125. It had accounts payables of $67,855, notes payables of $36,454, long-term debt of $223,100, and common stock of $150,000. How much retained earnings did the firm have?
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30,...
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30, 2017. On that date the firm had cash and marketable securities and accounts receivable totaling 28,764, inventory of 162,391, net fixed assets of 331,346, and other assets of 15,419. It had accounts payables and notes payable totaling 169,257, long-term debt of 177,202, and common stock of 112,991. How much retained earnings did the firm have? Round to whole numbers
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30, 2013.
Given the following information about Elkridge Sporting Goods, Inc., construct a balance sheet for June 30, 2013. On that date the firm had cash and marketable securities of $25,135, accounts receivable of $43,758, inventory of $166,000, net fixed assets of $325,600, and other assets of $13,125. It had accounts payables of $67,855, notes payables of $36,454, long-term debt of $224,500, and common stock of $150,000. How much retained earnings did the firm have?Retained earnings
Panther Marine Corporation For the Years Ended June 30, 2016 and 2017 Instructions: Below are the...
Panther Marine Corporation For the Years Ended June 30, 2016 and 2017 Instructions: Below are the adjusted trial balances for the years ended June 30, 2016 and 2017. The outlined cells in the changes columns MUST be completed for the statement of cash flows. Use formulas to find the debit OR credit changes in identfied cells. USE the June 30, 2017 adjusted trial balance columns to create the financial statements. DO NOT COMPLETE CELLS THAT ARE GRAYED OUT. June 30,...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information:...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information: $(‘000s) Paid-up Capital (1,000,000 shares) 3,000 Bank Overdraft 1,000 Accounts Payable 1,500 Mortgage Bonds, $1,000 face value (10%) 4,000 You are also given the following additional information about the firm: a) The company’s marginal tax rate is 30 cents in a dollar. The proportion of tax collected from the company that is claimed by shareholders is 0.6. b) The market price per mortgage bond...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3 and Year 2: Year 3 $ Year 2 $ Total assets Owners’ equity 6,020,000 3,250,000 5,470,000 3,200,000 Annual sales Net profit (after tax) Weighted average number of ordinary shares issued 6,100,000 810,000 10,234,518 3,154,350 475,200 10,046,430 Required: Calculate the net profit margin, asset turnover, earnings per share and debt to total assets ratios for ABC Ltd for the year ended 30 June Year 3
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT