Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ Current Assets, 2 0 2 0 , 2 0 2 1 ] , [ Cash , 8 4 , 9 8

image text in transcribed
\table[[Current Assets,2020,2021],[Cash,84,98],[Accounts Receivable,165,220],[Inventory,393,470],[Total Current Assets,642,788],[Long-Term Assets],[Net Plant and Equipment,2,731,3,000],[Total Assets,3,373,3,788],[Accounts Payable,312,400],[Notes Payable (1 Year),231,196],[Total Current Liabilities,543,596]] Question 1
Calculate the following ratios for both 2020 and 2021. Please note the values you use for each ratio.
Notes:
Assume the values are for year end and thus do not need to be averaged.
Assume sales are all credit sales.
All profitability ratios should be expressed as percentages \table[[Ratio,2020,2021,\table[[Industry average (2020-],[2021)]]],[Profitability Ratios],[Return on Equity,Blank 1,Blank 2,13.0%],[Return on Captial,Blank 3,Blank 4,10.1%],[Net Profit Margin,Blank 5,Blank 6,11.0%],[Operating Profit Margin,Blank 7,Blank 8,15.2%],[Gross Profit Margin,Blank 9,Blank 10,38.20%],[Activity Ratios],[\table[[Total Asset Turnover Ratio],[(TAT)]],Blank 11,Blank 12,2.2],[\table[[Fixed Asset Turnover Ratio],[(FAT)]],Blank 13,Blank 14,8.5]]\table[[Working Captial Ratio (WC),Blank 15,Blank 16,20],[Inventory Turnover Ratio,Blank 17,Blank 18,6.43],[Days of Inventory on Hand,Blank 19,Blank 20,67.31],[\table[[Accounts Receivable],[Collection (days)]],Blank 21,Blank 22,20.03],[\table[[Accounts Payable Collection],[(days)]],Blank 23,Blank 24,40.5],[Solvency Ratios],[Leverage,Blank 25,Blank 26,3.2],[Debt to Equity,Blank 27,Blank 28,1.1],[Times Interest Earned Ratio,Blank 29,Blank 30,7.8],[Current Ratio,Blank 31,Blank 32,3.82],[Quick Ratio,Blank 33,Blank 34,1.7]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Theory and Analysis Text and Cases

Authors: Richard G. Schroeder, Myrtle W. Clark, Jack M. Cathey

12th edition

1119386209, 978-1119299349, 1119299349, 1119186331, 978-1119186335, 978-1119386209

More Books

Students also viewed these Accounting questions