Calculate the following ratios for the year 2020 Liquidity: Current Ratio Quick Ratio Cash Ratio NWC NWC
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the following ratios for the year 2020
Liquidity:
Current Ratio
Quick Ratio
Cash Ratio
NWC
NWC to Total Assets
Interval Measure
Leverage:
Total Debt Ratio
Debt/Equity
Equity Multiplier
Long-term debt ratio
Coverage Ratios:
Times Interest Earned
Cash Coverage
Receivable Ratios:
Receivables Turnover
Days’ Sales in Receivables
Asset Turnover:
Total Asset Turnover
It is not unusual for TAT < 1, especially if a firm has a large amount of fixed assets
NWC Turnover
Fixed Asset Turnover
Profitability Measures:
Profit Margin
Return on Assets (ROA)
Return on Equity (ROE)
Transcribed Image Text:
Description Period Ended On (MM/DD/YYYY) Assets Current assets: Cash and cash equivalents Receivables Inventories Prepaid expenses Income taxes receivable Total current assets Property and equipment Land Buildings and leasehold improvements Machinery and equipment Finance lease right-of-use assets Construction in process Property and equipment, at cost Less accumulated depreciation and amortization Net property and equipment Other assets, net of amortization Goodwill Total assets Liabilities and Shareholders' Equity Current liabilities: Lines of credit Current maturities of long-term debt and finance lease obligations Accounts payable Accrued expenses Wages and related taxes Property taxes Insurance accruals Other Accrued expenses Total current liabilities Long-term debt and finance lease obligations, net of current maturities Deferred income taxes Deferred compensation Insurance accruals net of current portion Other long-term liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock no par value Retained earnings Total shareholders' equity Total liabilities and shareholders' equity FY 20 04/30/2020 78,275 48,500 236,007 9.801 14,667 387,250 872,151 1,969,585 2,369,361 24,780 125,632 5,361,509 2,037,708 3,323,801 71,766 161.075 3,943,892 120,000 570,280 184,800 34,039 36,348 22,097 95,864 188,348 1,063,428 714,502 435,598 13,604 22,862 50,693 2,300,687 33.286 1,609,919 1,643,205 3,943,892 FY 21 04/30/2021 336,545 79,698 286, 598 11.214 9,578 723,633 938, 199 2,162,261 2,478,404 22,413 98,587 5,699,864 2,206,405 3,493,459 82,147 161.075 4,460,314 2,354 355,471 69,226 39,399 24,287 122,012 254,924 612,749 FY 22 04/30/2022 15,094 26,239 72,437 2,527,635 158,878 108,028 396,199 17.859 44,071 725,035 1,097,985 2,445,509 2,695,366 75,060 92,331 6,406,251 2,425,709 3,980,542 187,219 612.934 5,505,730 24,466 588,783 87,022 47,556 25,795 131,056 291,429 904,678 1,361,395 1,663,403 439,721 520,472 12,746 27,957 135,636 3,264,892 58.951 79.412 1,873,728 2,161,426 1,932,679 2,240,838 4,460,314 5,505,730 Description Period Ended On (MM/DD/YYYY) Assets Current assets: Cash and cash equivalents Receivables Inventories Prepaid expenses Income taxes receivable Total current assets Property and equipment Land Buildings and leasehold improvements Machinery and equipment Finance lease right-of-use assets Construction in process Property and equipment, at cost Less accumulated depreciation and amortization Net property and equipment Other assets, net of amortization Goodwill Total assets Liabilities and Shareholders' Equity Current liabilities: Lines of credit Current maturities of long-term debt and finance lease obligations Accounts payable Accrued expenses Wages and related taxes Property taxes Insurance accruals Other Accrued expenses Total current liabilities Long-term debt and finance lease obligations, net of current maturities Deferred income taxes Deferred compensation Insurance accruals net of current portion Other long-term liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock no par value Retained earnings Total shareholders' equity Total liabilities and shareholders' equity FY 20 04/30/2020 78,275 48,500 236,007 9.801 14,667 387,250 872,151 1,969,585 2,369,361 24,780 125,632 5,361,509 2,037,708 3,323,801 71,766 161.075 3,943,892 120,000 570,280 184,800 34,039 36,348 22,097 95,864 188,348 1,063,428 714,502 435,598 13,604 22,862 50,693 2,300,687 33.286 1,609,919 1,643,205 3,943,892 FY 21 04/30/2021 336,545 79,698 286, 598 11.214 9,578 723,633 938, 199 2,162,261 2,478,404 22,413 98,587 5,699,864 2,206,405 3,493,459 82,147 161.075 4,460,314 2,354 355,471 69,226 39,399 24,287 122,012 254,924 612,749 FY 22 04/30/2022 15,094 26,239 72,437 2,527,635 158,878 108,028 396,199 17.859 44,071 725,035 1,097,985 2,445,509 2,695,366 75,060 92,331 6,406,251 2,425,709 3,980,542 187,219 612.934 5,505,730 24,466 588,783 87,022 47,556 25,795 131,056 291,429 904,678 1,361,395 1,663,403 439,721 520,472 12,746 27,957 135,636 3,264,892 58.951 79.412 1,873,728 2,161,426 1,932,679 2,240,838 4,460,314 5,505,730
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To calculate the requested ratios well use the financial data provided Liquidity Ratios Current Ratio Current Assets Current Liabilities For 2020 Current Assets 387250 Current Liabilities 106... View the full answer
Related Book For
Fundamental Accounting Principles Volume II
ISBN: 978-1260305838
16th Canadian edition
Authors: Kermit Larson, Tilly Jensen, Heidi Dieckmann
Posted Date:
Students also viewed these accounting questions
-
A firm has been experiencing low profitability in recent years. Perform an analysis of the firms financial position using the DuPont equation. The firm has no lease payments but has a $2 million...
-
A firm has been experiencing low profitability in recent years. Perform an analysis of the firms financial position using the DuPont equation. The firm has no lease payments but has a $2 million...
-
Big Rock Brewery Inc. is Calgary-based public company. The company is a producer of all-natural craft beers and cider. Its products are sold in nine provinces and three territories in Canada. The...
-
What functions are normally associated with the production cycle?
-
You are the manager of a firm that sells a commodity in a market that resembles perfect competition, and your cost function is C(Q) = Q + 2Q2. Unfortunately, due to production lags, you must make...
-
Explain the importance of ethical decision making.
-
Texas Inpatient Consultants, LLLP, is a partnership that employs physicians to deliver medical care to hospitalized patients of other physicians. Texas Inpatient recruited Julius Tabe, M.D., to work...
-
The comparative balance sheet of Green Earth Lawn and Garden Inc. for December 31, 2008 and 2009, is as follows: Dec. 31, 2009 Dec. 31, 2008 Assets The income statement for the year ended December...
-
Suppose that farmers have a mandatory demand expansion program where all farmers pay a certain amount to fund a promotion program. You have estimated the following market supply and demand functions...
-
An experiment is done to test the effect of artificial light on geraniums Seventy-five geranium seedlings are grown in a laboratory The plants are separated into five groups of 15 plants each. The...
-
The process for handling insurance claims at a branch of the Green Insurance Company has an average flow rate of 2 claims per minute. Branch manager Shauna Green has calculated, based on her...
-
At year-end, Snow, Inc. has cash of $ 9 comma 000, current accounts receivable of $ 50 comma 000, merchandise inventory of $ 21 comma 000, and prepaid expenses totaling $ 4 comma 100. Liabilities of...
-
Differentiate between a journal and a ledger in accounting. What is the significance of the matching principle in accounting? Explain the concept of goodwill in accounting terms. What are the types...
-
1. What is the primary objective of accounting for NGOs? 2. How are grants and donations accounted for in NGO accounting? 3. What is the purpose of a statement of financial position in NGO...
-
Assume the risk-free rate is 2% (rf = 2%), the expected return on the market portfolio is 6% (rM = 6%) and the standard deviation of the return on the market portfolio is 15% (M = 15%). (All numbers...
-
using jupyter notebook in python 1. Use the log(Salary) (log salary is the natural log of salary. You can use Numpy log function) as your output (y) and the numerical columns as your input (X). You...
-
A Johny Enterprise a sole trader extracted the following trial balance from his books at the close The following is the trial balance of Copaiba Sdn Bhd as at 31 December 2021. Particulars Debit (RM)...
-
For the following exercises, rewrite the sum as a product of two functions or the product as a sum of two functions. Give your answer in terms of sines and cosines. Then evaluate the final answer...
-
Point North Inc. issued bonds on September 1, 2020, with a par value of $150,000. The bonds mature in 15 years and pay 8% annual interest in two semiannual payments. On the issue date, the annual...
-
On January 1, 2020, Nickle Entertainment Inc. purchased a 4%, $50,000 Imax bond for $46,490. Interest is to be paid semiannually each June 30 and December 31. Nickle Inc. is planning to hold the bond...
-
The following events are for Toronto Investment Inc.: Required Prepare general journal entries to record each transaction. Round per share calculations to two decimal places. 2020 Jan. Purchased...
-
Demonstrate that both the Berry phase \(\gamma_{n}\) and the Berry curvature \(\boldsymbol{\Omega}_{n}(\boldsymbol{R})\) are invariant under a local gauge transformation.
-
Show that under a local gauge transformation (14.5) the vector potential A and the form of the wavefunction (28.7) are changed, but no observable is affected. Data from Eq. 28.7 Data from Eq. 14.5...
-
Evaluate the formula for the Gauss-Bonnet theorem in Box 28.3 for a 2-sphere and show that this leads to the usual relation for the area of a sphere. The local curvature for a 2-surface is the...
Study smarter with the SolutionInn App