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.
unit_3_problem_2.docx
unit_3_problem_4.docx
unit_3_problem_1.xlsx
unit_3_problem_3.xlsx
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
Recent Comments