Question

In: Accounting

                                         Company X

  1.                                          Company XYZ

                                                       Balance Sheet

                     Assets                                                           Liabilities

   Cash                                 $15,000           Accounts Payable                               $20,000

   Marketable Securities        25,000           Accrued Wages                                    17,000

   Accounts Receivable         30,000           Bonds                                                    15,000

   Inventory                           35,000           Bank Loan                                             50,000

   Net Plant & Equipment $125,000            Total Liabilities                               $102,000

                                                                                       Owners Equity

                                                                     

                                                                 Common Stock                                        $85,000

                                                                 Retained Earnings                                      43,000

                                                                      Total Owners Equity                         $128,000

    Total Assets               $230,000           Total Liabilities & Owners Equity         $230,000

Sales during the year were $550,000.

Net Income for the year was $40,000.

Market Price per share is currently $20.00.

Interest expense for the year was $7,000.

Earnings before taxes were $50,000.

20,000 shares of Common Stock Outstanding

Based on the above information calculate and interpret the following ratios: (40 points)

  1. Current Ratio
  2. Quick Ratio
  3. Days Sales Outstanding
  4. Total Asset Turnover
  5. Total Debt Ratio

Solutions

Expert Solution

Current Ratio = Current Assets / Current Liabilities

= (Cash+Marketable Securities+Accounts Receivable+Inventory) / (Accounts Payable+Accrued Wages+Bank Loan)

= (15,000 + 25,000 + 30,000 + 35,000) / (20,000 + 17,000 + 50,000) = 105,000 / 87,000 = 1.21

Therefore, Current ratio is 1.21

Note - It has been assumed that the maturity period for bonds is more than one year (non-current liability) and that of the bank loan is one year or less (current liability).

Quick Ratio = (Current Assets - Inventory) / Current Liabilities

= (105,000 - 35,000) / 87,000 = 0.80

Therefore, Quick Ratio is 0.80

Days Sale Outstanding = Accounts Receivables / Average Sales in a day

= Accounts Receivables / ( Sales for the year / 365 days ) = 30,000 / ( 550,000 / 365 ) = 30,000 / 1,506.8 = 19.91

Therefore, Days Sale Outstanding is 19.91 days

Total Assets Turnover Ratio = Sales during the year / Total Assets = 550,000 / 230,000 = 2.39

Therefore, Total Assets Turnover Ratio is 2.39

Total Debt Ratio = Total Debt / Total Assets = 102,000 / 230,000 = 0.44

Therefore, Debt Ratio is 0.44

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

                                         Company X
                                         Company XYZ                                                        Balance Sheet                      Assets                                                           Liabilities    Cash                                 $15,000           Accounts Payable                               $20,000    Marketable Securities        25,000           Accrued Wages                                    17,000    Accounts Receivable         30,000           Bonds                                                    15,000    Inventory                           35,000           Bank Loan                                             50,000    Net Plant & Equipment $125,000            Total Liabilities                               $102,000                                                                                        Owners Equity                                                                                                                                        Common Stock                                        $85,000                                                                  Retained Earnings                                      43,000                                                                       Total Owners Equity                         $128,000     Total Assets               $230,000           Total Liabilities & Owners Equity         $230,000 Sales during the year were $550,000. Net Income for the year...
X. Bonds Company The following is a single-step income statement for the X. Bonds Company: X....
X. Bonds Company The following is a single-step income statement for the X. Bonds Company: X. Bonds Company Income Statement For the Year Ended December 31, 2016 Revenues: Net Sales $300,000 Interest Income 20,000 Total Revenues $320,000 Expenses: Cost of Goods Sold $60,000 Selling Expenses 25,000 General and Administrative Expenses 30,000 Interest Expense 14,000 Income Tax Expense 45,000 Total Expenses 174,000 Net Income $146,000 Refer to X. Bonds Company. If the income statement were prepared in a multiple-step format, income...
A company has purchased $250,000 of X, a material amount for the company. X is a...
A company has purchased $250,000 of X, a material amount for the company. X is a cryptocurrency token. One X token is currently worth $0.078150, over three times its value at the ICO. 1. Assume that the X purchase was made for cash. What journal entry should be made to record the purchase? 2. ​​​​​​​What (if any) journal entry would be required if the X value has increased to $300,000 at December 31, 2018? 3. ​​​​​​​What (if any) journal entry...
1. Company X has an employee who is paid weekly. For Company X the FUTA tax...
1. Company X has an employee who is paid weekly. For Company X the FUTA tax rate is 6%. The limit for FUTA is $7000 of employee annual earning subject to the applicable tax. The employee earns $1000 for the week and has cumulative earnings year to date through the previous week of $6500. How much is deducted from the employee’s weekly paycheck for FUTA? A. -60- B. 30 C. 600 D. 300 E. None of the above 2. For...
Problem 4: a) The comparative balance sheet of X Company appears below: X Company Comparative Balance...
Problem 4: a) The comparative balance sheet of X Company appears below: X Company Comparative Balance Sheet December 31, ———————————————————————————————— Assets                                                                                      2018        2017 Current assets.................................................................... $   360,000 $300,000 Plant assets .......................................................................      640,000   500,000 Total assets ...................................................................... $1,000,000   $800,000 Liabilities and stockholders' equity Current liabilities .............................................................. $   150,000 $120,000 Long-term debt ................................................................. 240,000    160,000 Common stock ................................................................. 350.000    280,000 Retained earnings .............................................................      260,000   240,000      Total liabilities and stockholders' equity ..................... $1,000,000    $800,000 Instructions (a)   Using horizontal analysis,...
X Company was created on September 1 and prepares monthly financial statements. During September, X Company...
X Company was created on September 1 and prepares monthly financial statements. During September, X Company issued stock to investors for $98,000, borrowed $83,000 from a bank, bought merchandise that it planned to sell, paying $3,416 and promising to pay $5,166 in October, bought equipment, paying $5,100 and promising to pay $4,800 in December, paid $3,603 that it had promised to pay to suppliers for previous purchases on account, sold merchandise, receiving cash of $16,879 and promises to pay from...
Question: Company X uses fermentation to produce a valuable industrial chemical. A startup company approaches X...
Question: Company X uses fermentation to produce a valuable industrial chemical. A startup company approaches X with a novel microbe that will increase the yield of the chemical, so that profits will increase by an estimated $14.0k/mo. The startup company wishes to sell the rights to use the microbe for a seven-year period, at a price of $480k. Engineers at company X estimate the increased production will entail additional maintenance, costing $12.0k in year 2, $14.0k in year 4, and...
X Company prepares annual financial statements. On September 1, 2017, X Company paid $63,000 in advance...
X Company prepares annual financial statements. On September 1, 2017, X Company paid $63,000 in advance for a two-year insurance policy. After the adjusting entry on December 31, 2017, what will X Company's 2017 financial statements show? Prepaid Insurance, $52,500; Insurance expense, $10,500 Prepaid Insurance, $63,000; Insurance expense, $0 Prepaid Insurance, $15,750; Insurance expense, $47,250 Prepaid Insurance, $47,250; Insurance expense, $15,750 Prepaid Insurance, $0; Insurance expense, $63,000 Prepaid Insurance, $10,500; Insurance expense, $52,500
4. Two companies, X and Y, are competitors in the same industry, but company X is...
4. Two companies, X and Y, are competitors in the same industry, but company X is more efficient at using its resources than company Y. a. If the MRTS is the same in the production processes of both companies, show and discuss how the isoquants will be different for company X than they are for company Y. b. Both companies can hire labor at the same wage, w, but company X is able to pay a lower rent per unit...
Two companies, X and Y, are competitors in the same industry, but company X is more...
Two companies, X and Y, are competitors in the same industry, but company X is more efficient at using its resources than company Y . a. If the MRTS is the same in the production processes of both companies, show and discuss how the isoquants will be different for company X than they are for company Y. b. Both companies can hire labor at the same wage, w, but company X is able to pay a lower rent per unit...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT