Accounting for management

User Generated

xnebaryyl18

Business Finance

Description

PROBLEM 1:

- Prepare a schedule of net cash provide by operating activities.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET. CORRECT ANSWERS ONLY...THANK YOU!!

PROBLEM 2:

- Please refer to the word document (Unit 3 Problem 2) for instructions.

PROBLEM 3:

- Compute and interpret financial ratios that managers use to assess liquidity.

- Compute and interpret financial ratios that managers use for asset management purposes.

- Compute and interpret financial ratios that managers use for debt management purposes.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET...THANK YOU!

PROBLEM 4:

- Please refer to the word document (Unit 3 Problem 4) for instructions.

Unformatted Attachment Preview

The following information is for FloorCo, Inc. for the year just ended: End of the year Beginning of year Current assets: Cash Accounts receivable Inventory Prepaid expenses 75.000 158.000 285.000 11.000 90.000 140.000 246.000 16.000 Current liabilities Account payable Account liabilities Income taxes payable 284.000 9.500 27.000 302.000 11.200 24.000 Net Income 94.500 Acumulated depreciation total credits 45.000 Floor Company did not record any gains or losses during the year. Prepare a schedule of net cash provided by opearting activities FloorCo,Inc Operating Activities Section of the Satement of Cash Flows Net Income Adjustments to convert net income to a cash basis: Depreciation Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities Increase in income taxes payable Net cash provided by opearting activities Co, Inc. for the year just ended: FloorCo,Inc e Satement of Cash Flows 94.500 45.000 Recent financial statements for Zimmer, Inc. are as follows: Zimmer Company Comparative Balance Sheet Assets Current assets: Cash Marketable securities Accounts receivable, net Inventory Other current assets Total current assets Plant and equipment, net Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Account payable Short-term bank loans Accrued payables Other current liabilities Total current liabilities Bonds payable, 10% Total liabilities Stockholders' equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders'e equity Required: Compute the following ratios for the current year only: Gross margin percentage Current ratio (rounded to two decimal places) Acid-test ratio (rounded to two decimal places) Accounts receivable turnover (rounded to two decimal places) Average collection period (rounded to the nearest whole day) Inventory turnover ratio (rounded to two decimal places) Average sales period (rounded to the nearest whole day) Debt-to-equity ratio (rounded to two decimal places) Times interest earned (rounded to two decimal places) Book value per share (rounded to two decimal places) Earnings per share (rounded to two decimal places) Dividend payout ratio (rounded to three decimal places) Dividend yield ratio (rounded to three decimal places) Price-earnings ratio (rounded to two decimal places) ements for Zimmer, Inc. are as follows: Zimmer Company parative Balance Sheet This year Last Year 360.000 220.000 775.000 925.000 355.000 2.635.000 1.975.000 75.000 4.685.000 310.000 80.000 700.000 750.000 195.000 2.035.000 1.800.000 100.000 3.935.000 250.000 750.000 550.000 275.000 1.825.000 575.000 2.400.000 225.000 600.000 395.000 223.400 1.443.400 400.000 1.843.400 1.150.000 1.135.000 2.285.000 4.685.000 1.150.000 941.600 2.091.600 3.935.000 Zimmer Company Income Statement This Year Sales (all on account) Cost of goods sold Gross margin Selling and administrative expenses Operating expenses Depreciation and amortization General and administrative expenses Total selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes Net income Additional information: Dividend per share paid in current year Market prices of share at year end Par value of common stock per share Number of share outstanding 4.980.000 2.988.000 1.992.000 985.500 410.500 150.000 1.546.000 446.000 60.000 386.000 135.100 250.900 1,00 42,00 20,00
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

And here is the last one :)Please review and if you have any questions, please do not hesitate to ask. If all is clear please review and rate my servicesAll the best

The following information is for FloorCo, Inc. for the year just ended:

End of t...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags