Question

In: Finance

INCOME STATEMENT: 2016 2017 Sales $100,000.00 $120,300.00 Cost of Goods Sold $60,000.00 $72,180.00 Gross Margin $40,000.00...

INCOME STATEMENT:

	2016	2017
Sales	$100,000.00	$120,300.00
Cost of Goods Sold	$60,000.00	$72,180.00
Gross Margin	$40,000.00	$48,120.00
Depreciation	$16,000.00	$19,200.00
Administrative Costs	$9,000.00	$10,800.00
EBIT	$15,000.00	$18,120.00
Interest	$4,000.00	$4,000.00
Pre-tax income	$11,000.00	$14,120.00
Taxes	$4,400.00	$5,648.00
Net Income	$6,600.00	$8,472.00
Dividends	$0.00	$5,083.20
Addition to Retained Earnings	$6,600.00	$3,388.80

BALANCE SHEET AS OF 12/31/2017:

ASSETS	2016	2017
Cash	$5,000.00	$6,000.00
Inventory	$15,000.00	$18,000.00
Accounts Receivable	$15,000.00	$18,045.00
Current Assets	$35,000.00	$42,045.00
Net PPE	$80,000.00	$92,000.00
Total Assets (TA)	$115,000.00	$134,045.00

LIABILITIES & SHAREHOLDER EQUITY	2016	2017
Accounts Payable	$25,000.00	$30,000.00
Current Liabilities	$25,000.00	$30,000.00
Long Term Debt	$40,000.00	$50,656.20
Total Liabilities	$65,000.00	$80,656.20
Shareholder Equity	$50,000.00	$53,388.80
Total Liabilities and Shareholder Equity	$115,000.00	$134,045.00

1. A) What is the net cash used in investing activities in 2017? (Refer to the Statement of Cash Flows)

B) What is the net cash provided from financing activities in 2017? (Refer to the Statement of Cash Flows)

C) What is the net increase in cash and marketable securities for 2017? (Refer to the Statement of Cash Flows)

2. A) What is the final value for cash and marketable securities at the end of 2017?

Expert Solution

1 (A) In investing activities, we will check whether cash has been invested by looking at the balance sheet. In 2016, Net PPE was $80000, in 2017 net PPE was $92000.It means that $12000 i.e. ($92000 - $80000), has been used to acquire the assets.

There is no other asset acquisition in 2017. So, net cash used in investing activities in 2017 is $12000.

(B) For financing activities, we will look at the balance sheet to find out whether there is any debt increase or capital provided.

Increase in long term debt : $50656.2 - $40000 = $10656.2

Increase in shareholder's equity: $53388.8 - $50000 = $3388.8

So, cash flow from financing activities will be:

Increase in long term debt $10656.2

Increase in shareholder's equity $3388.8

Less: Dividends paid ($5083.2)

Cash from financing activities $8961.8

(C) Cash balance in 2017 = $6000

Cash balance in 2016 = $5000

Net increase in cash balance = $6000 - $5000 = $1000

Marketable securities are not given in the question.

2 (A) Final value of cash in 2017 is $6000. Marketable securities are not given in the question.

jeff jeffy answered 1 year ago

STORE 5 NET SALES = ? COST OF GOODS SOLD = $90.0 GROSS MARGIN-DOLLARS = ?...

STORE 5 NET SALES = ? COST OF GOODS SOLD = $90.0 GROSS MARGIN-DOLLARS = ? GROSS MARGIN-PERCENT = ? EXPENSE-DOLLARS = $41.1 EXPENSE-PERCENT = ? NET INCOME-DOLLARS = $0.5 NET INCOME-PERCENT = ?

2016 2017 Sales $75,000 $90,000 Cost of Goods Sold 45,000 54,000 Gross Profit $30,000 $36,000 Operating...

2016 2017 Sales $75,000 $90,000 Cost of Goods Sold 45,000 54,000 Gross Profit $30,000 $36,000 Operating Expense 15,000 15,000 Net Income $15,000 $21,000 Compute the corrected net income for 2016 and 2017 assuming that the inventory as of the end of 2016 was mistakenly understated by $7,000. 2016 2017 Corrected net income ______ _______

Bayside, Inc. 2017 Income Statement ($ in thousands) Net sales $ 6,170 Cost of goods sold...

Bayside, Inc. 2017 Income Statement ($ in thousands) Net sales $ 6,170 Cost of goods sold 4,590 Depreciation 395 Earnings before interest and taxes $ 1,185 Interest paid 44 Taxable income $ 1,141 Taxes 399 Net income $ 742 Bayside, Inc. 2016 and 2017 Balance Sheets ($ in thousands) 2016 2017 2016 2017 Cash $ 145 $ 250 Accounts payable $ 1,710 $ 1,770 Accounts rec. 1,130 970 Long-term debt 880 680 Inventory 1,805 2,130 Common stock 3,380 3,350...

Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold...

Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold 7,340 Depreciation 405 Earnings before interest and taxes $ 955 Interest paid 82 Taxable income $ 873 Taxes 306 Net income $ 567 Windswept, Inc. 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 150 $ 185 Accounts payable $ 1,180 $ 1,260 Accounts rec. 920 730 Long-term debt 1,000 1,265 Inventory 1,520 1,550 Common stock 3,210 2,900...

Joyner Company’s income statement for Year 2 follows: Sales 718,000 Cost of Goods Sold 367,000 Gross...

Joyner Company’s income statement for Year 2 follows: Sales 718,000 Cost of Goods Sold 367,000 Gross Margin 351,000 Selling and administrative expenses 217,000 Net operating income 134,000 Gain on sale of equipment 8,000 Income before taxes 142,000 Income taxes 56,800 Net Income $85,200 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $ 18,700 $ 49,200 Accounts receivable 257,000 139,000 Inventory 319,000 273,000 Prepaid expenses 10,000 20,000 Total...

Abner Company’s income statement for Year 2 follows: Sales 815,100 Cost of goods sold 338,580 Gross...

Abner Company’s income statement for Year 2 follows: Sales 815,100 Cost of goods sold 338,580 Gross margin 476,520 Selling and administrative expenses 171,570 Net operating income 304,950 Nonoperating items: Gain on sale of equipment 11,400 Income before taxes 316,350 Income taxes 126,540 Net income $189,810 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $177,156 $94,962 Accounts receivable 251,940 156,180 Inventory 363,660 310,080 Prepaid expenses 11,970 23,940 Total...

Sales $ 7,400,000 $ 5,624,000 Cost of goods sold 4,720,000 3,508,500 Gross margin 2,680,000 2,115,500 Selling...

Sales $ 7,400,000 $ 5,624,000 Cost of goods sold 4,720,000 3,508,500 Gross margin 2,680,000 2,115,500 Selling and administrative expenses: Selling expenses 1,372,000 1,082,000 Administrative expenses 710,500 608,500 Total expenses 2,082,500 1,690,500 Net operating income 597,500 425,000 Interest expense 105,000 93,000 Net income before taxes $ 492,500 $ 332,000 Members of the company’s board of directors are surprised to see that net income increased by only $160,500 when sales increased by $1,776,000. Required: 1. Express each year's income statement in common-size...

XYZ Company Income Statement Sales $140,000 Cost of Goods Sold 117,000 Gross Profit 23,000 Operating Expenses...

XYZ Company Income Statement Sales $140,000 Cost of Goods Sold 117,000 Gross Profit 23,000 Operating Expenses 12,830 EBIT 10,170 Taxes @39% 2168 Net income 3,392 Dividend 1,018 Addition to Retained Earnings $2,374 XYZ Company Balance Sheet Current Assets Cash $7,500 Accounts Receivable 12,100 Inventory 10,400 Prepaid Items 5,900 Other CA 4,300 Total Current Assets $40,200 Net Plant $ Equipment 82,300 Total Assets $122,500 XYZ Company Balance Sheet Current Liabilities Accounts Payable $7,200 Wages Payable 3,600 Notes payable 5,400 Taxes Payable...

Cullumber Company Oriole Company 2017 2016 2017 2016 Net sales $1,856,000 $596,000 Cost of goods sold...

Cullumber Company Oriole Company 2017 2016 2017 2016 Net sales $1,856,000 $596,000 Cost of goods sold 1,079,000 298,000 Operating expenses 263,000 83,000 Interest expense 7,000 2,800 Income tax expense 75,000 34,000 Current assets 590,015 $565,462 150,838 $ 143,835 Plant assets (net) 953,508 905,000 252,908 227,720 Current liabilities 120,048 137,225 63,980 54,809 Long-term liabilities 206,322 162,900 53,612 45,250 Common stock, $10 par 905,000 905,000 217,200 217,200 Retained earnings 312,153 265,337 68,954 54,296 Compute the 2017 return on assets and the return...

Determine the effect on the cost of goods sold, total assets, and gross margin for 2013...

Determine the effect on the cost of goods sold, total assets, and gross margin for 2013 and 2014 if the following inventory errors are not corrected. Indicate your answer with (+) for overstated, (-) for understated, and (0) for no effect. a. Beginning inventory for 2013 is understated b. Ending inventory for 2013 is overstated Effect in 2013 on Cost of Goods Sold ｜Total Assets｜ Gross Margin a. b. Effect in 2014 on Cost of Goods Sold ｜Total Assets ｜Gross Margin...