Question

Can you please answer question 5-8. Thank you please show your work.

Using the following information find the ratios listed:

Hamilton Company
Comparative Balance Sheets
December 31, 2018 and December 31, 2019
Assets	2018	2019	Difference
Cash	15,000	47,000	32,000
Accounts Receivable	55,000	47,000	(8,000)
Inventory	110,000	144,000	34,000
Prepaid Expenses	5,000	1,000	(4,000)
Long term investments	127,000	115,000	(12,000)
Land	55,000	55,000	-
Building	450,000	660,000	210,000
Accumulated Depr - Building	(68,000)	(103,000)	(35,000)
Total Assets	749,000	966,000	217,000
Liabilities & Stockholder's Equity
Accounts Payable	43,000	50,000	7,000
Income Tax Payable	5,000	3,000	(2,000)
Accrued Liabilities	9,000	12,000	3,000
Bonds Payable	245,000	295,000	50,000
Common Stock $5 par value	200,000	276,000	76,000
Additional paid in capital	115,000	214,000	99,000
Retained Earnings	132,000	116,000	(16,000)
Total Liabilities & S/E	749,000	966,000	217,000

Sales	225,000
Cost of Goods Sold	120,000
Gross Profit	105,000
Operating Expense	70,000
Income before interest	35,000
Interest	12,000
Income before Taxes	23,000
Taxes	7,000
Net Income	16,000

Dividends Paid $13,800

Market price of stock $12

Find the following ratios for 2015:

1.   Current Ratio

2.   Quick Ratio

3.   Accounts Receivable Turnover

4.   Days to Collect

5.   Inventory Turnover

6.   Days on hand

7.   Payable Turnover  

8.   Days to pay  

9.   Debt to Equity Ratio

10. Number of times interest Earned

11. Profit Margin

12. Assets Turnover

13. Return on Assets

14. Return on Equity

15. Earnings per Share

16. Price/Earnings Ratio

17. Dividend Yield

Answer 1

Answer of Part 5:

Average Inventory = (Beginning Inventory + Ending inventory)/2
Average Inventory = ($110,000 + $144,000)/2
Average Inventory = $127,000

Inventory Turnover = Cost of Goods Sold / Average Inventory
Inventory Turnover = $120,000 / $127,000
Inventory Turnover = 0.94 times

Answer of Part 6:

Days on Hand = 365 days / Inventory Turnover
Days on Hand = 365/0.94
Days on Hand = 388.30 days

Answer of Part 7:

Average Accounts payable = (Beginning Accounts Payable + Ending Accounts Payable)/2
Average Accounts Payable = ($43,000 + $50,000)/2
Average Accounts Payable = $46,500

Payable Turnover = Cost of Goods Sold / Average Accounts Payablea
Payable Turnover = $120,000 / $46,500
Payable Turnover = 2.58 times

Answer of Part 8:

Days to Pay = 365 days / Payable Turnover
Days to Pay = 365 / 2.58
Days to Pay = 141.47 days