Question

In: Finance

Use the following information to calculate the ratios listed below: Total Assets 650,000 Total Liabilities 300,000...

Use the following information to calculate the ratios listed below:
Total Assets 650,000
Total Liabilities 300,000
Current Assets 60,000
Current Liabilities 20,000
Net Income 70,000
Shares Outstanding 12,000
Accounts Receivable 55,000
Sales 439,000
Inventory 25,000
Dividends 10,000


Quick Ratio ____________________
Earnings Per Share ___________________
Return on Assets _________________
Debt/Equity Ratio _______________
Days Sales in Receivables ______________

View keyboard shortcuts12pt

Paragraph

Solutions

Expert Solution

Ratio Formula Ratio
Quick Ratio Liquid asset/ current liability 1.75
Earnings Per Share (Net Income - Preferred Dividend) / No of shares outstanding 5.00
Return on Assets Net Icome / Total Assets 10.77%
Debt Equity Ratio Debt/Equity 0.80
Days Sales in Receivables No of Days in the Period/Receivables Turnover Ratio 45.11
Calculation:-
1) Quick ratio= Liquid Current asset/ current liability
Where,
Liquid Current is Current Assets - Inventories
Now,
Liquid Current Assets 60000 - 25000 = 35000
Current liabilities 20000
Quick Ratio Liquid Current asset/ current liability
Quick Ratio 1.75
2) Earnings Per Share = (Net Income - Preferred Dividend) / No of shares outstanding
Net Income 70000
Dividend 10000
No of Share Outstanding 12000
Earnings Per Share (70000 - 10000) / 12000 = 5
3) Return on Assets = Net Income / Total Assets
Net Income 70000
Total Assets 650000
Return on Assets 10.77%
4) Debt Equity Ratio = Debt / Equity
where,
Debt = Total Liabilities - Current Liabilities
Equity = Total Assets - Total Liabilities
Debt 300000 - 20000 = 280000
Equity 650000 - 300000 = 350000
Debt Equity Ratio 0.80
5) Receivables Turnover Ratio = Net Credit Sales/ Average Accounts Receivable
Now,
Net Credit Sales 439,000
Average Accounts Receivable 55000
Receivables Turnover Ratio Net Credit Sales/ Average Accounts Receivable
Receivables Turnover Ratio 7.98
Days Sales in Receivables = No of days in a Period/ Receivable Turnover Ratio
Now,
No of Days 360
Receivables Turnover Ratio 7.98
Days Sales Outstanding 45.11

Related Solutions

Learning Objective: Calculate the total assets, liabilities, or equity from given information. Consider the following information:...
Learning Objective: Calculate the total assets, liabilities, or equity from given information. Consider the following information: Accounts Payable: $4,000 Notes Payable: $10,000 Salaries payable: $1,000 Revenues: $5,000 Accounts Receivable: $5,000 Utilities Expense: $2,000 Cash: $5,000 Office Supplies: $1,000 Equipment: $20,000 Accumulated Depreciation Equipment: $5,000 Unearned Revenue: $2,000 Equity: $22,000 Salaries Expense: $1,000 From the above set of data, what is the total for assets, liabilities, and equity? a) Total Assets: $26,000    Total Liabilities: $17,000 Total Equity: $9,000 b) Total...
a. Jack Repair Shop started the year with total assets of $300,000 and total liabilities of...
a. Jack Repair Shop started the year with total assets of $300,000 and total liabilities of $200,000. During the year, the repair shop recorded $500,000 in computer repair revenues, $300,000 in expenses, and paid dividends of $50,000. The repair shop stockholders' equity at the end of the year was $___________. b. Costs of goods sold is $15,000 greater than net purchases. If beginning inventory is $110,000, what is ending inventory? Using COGS=BI+P-EI c. Revenue of $45,000 had been collected, but...
Use the information given below for The Palm Limited to calculate the following ratios for 2019...
Use the information given below for The Palm Limited to calculate the following ratios for 2019 and give a brief explanation why these ratios will be used interpret and evaluate a company: 1.         Rate of return on total assets 2.         Rate of return on ordinary shareholders' equity 3.         Rate of return on net sales 4.         Times-interest-earned ratio 5.         Debt ratio, 31 December 2019 6.         Current ratio, 31 December 2019 7.         Earnings per ordinary share       The following information has been taken from the financial statements of The Palm...
Use the information below to calculate the following ratios for Allen Ales in 20Y6: earnings per...
Use the information below to calculate the following ratios for Allen Ales in 20Y6: earnings per share on common stock, price-earnings ratio, dividends per share, and dividend yield. The company paid $2,500 in preferred dividends for the year. Round ratios to one decimal place. Net income $275,300 Shares of common stock outstanding 5,750 shares Market price per share of common stock $4.80 Dividends on common stock $10,900
Following information use in Question NO.5 The following is the information about assets and liabilities of...
Following information use in Question NO.5 The following is the information about assets and liabilities of M/s. Hanish LLC and its partners A, B and C. They are sharing profits 9:6:3 with total capital of OMR 169,000 as on 31.3.2020. Particular OMR Particular OMR Cash             58,500 Bank Loan          52,000 Sundry Debtors             91,000 Bonds          65,000 Stock             32,500 Bills Payable        104,000 Machinery             52,000 Sundry Creditors        130,000 Land             91,000 Bank Overdraft          32,500 Furniture...
Following information use in Question NO.6 The following is the information about assets and liabilities of...
Following information use in Question NO.6 The following is the information about assets and liabilities of M/s. Hanish LLC and its partners A, B and C. They are sharing profits 9:6:3 with total capital of OMR 169,000 as on 31.3.2020. Particular OMR Particular OMR Cash             58,500 Bank Loan          52,000 Sundry Debtors             91,000 Bonds          65,000 Stock             32,500 Bills Payable        104,000 Machinery             52,000 Sundry Creditors        130,000 Land             91,000 Bank Overdraft          32,500 Furniture...
SOLVENCY RATIOS Debt ratio for Walgreens = Total Liabilities / Total assets Debt ratio for Walgreens...
SOLVENCY RATIOS Debt ratio for Walgreens = Total Liabilities / Total assets Debt ratio for Walgreens 2018 = $68,124 / $68,124 = 1 Debt ratio for Walgreens 2017 = $66,009 / $66,009 = 1 Debt ratio for CVS Debt ratio for CVS 2018 = $196,456 / $196,456 = 1 Debt ratio for CVS 2017 = $95,131 / $95,131 = 1 What do the results of this ratio mean in the context of Walgreens? How about CVS? Compare the two -...
Use the following items to determine the total assets, total liabilities, net worth, total cash inflows,...
Use the following items to determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. Rent for the month $ 1,450 Monthly take-home salary $ 2,985 Spending for food $ 745 Cash in checking account $ 610 Savings account balance $ 2,050 Balance of educational loan $ 3,120 Current value of automobile $ 9,500 Telephone bill paid for month $ 145 Credit card balance $ 315 Loan payment $ 240 Auto insurance $ 390 Household...
Calculate the Z-score of the firm that has the following ratios: Working capital/total assets = 0.34
Calculate the Z-score of the firm that has the following ratios: Working capital/total assets = 0.34 Retained earnings/total assets = 0.15 EBIT/total assets = 0.00 Market value equity/book value of long-term debt = 0.80 Sales/total assets = 1.6 Round your answer to 2 decimal places. For example, if your answer is 5.689, write down 5.69
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable...
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable are $87 inventory is $66 net fixed assets is $199 accounts payable is $92 accruals are $99 notes payable are $81 long term debt is $82
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT