Compute the following ratios. Do not round your calculations. (Always use cell references and formulas where...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Compute the following ratios. Do not round your calculations. (Always use cell references and formulas where appropriate to receive full credit.) Working Capital Current Ratio Acid-Test (Quick) Ratio Cash Ratio Accounts Receivable Turnover Days' Sales in Receivables Inventory Turnover Days' Sales in Inventory Gross Profit Percentage Debt Ratio Debt to Equity Ratio Times-Interest-Earned Ratio Profit Margin Ratio Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders' Equity Earnings per Share (EPS) Price/Earnings Ratio Dividend Yield Dividend Payout 2019 HINTS 2018 HINTS Cell | Hint: C5 | Begin the formula with an equals sign (=), use the balance in the horizontal analysis worksheet for your calculations, and press the enter key. C7 | Use the function =SUM( ) to calculate the numerator. C9 | =(0.75*¹Vertical Analysis'!C8)/(('Horizontal Analysis'!C14+'Horizontal Analysis'!D14)/2) C10 | Assume 365 days in a year and use the correct ratio in this worksheet for your calculations. 5 6 7 8 9 10 Current Assets 11 Assets June 30 2018 and 2019 Cash 12 13 Short Term Investments Accounts Receivable Merchandise Inventory 14 15 Other Current Assets 16 Total Current Assets 17 PPE 18 Total Assets Liabilities 19 20 21 Current Liabiltiies: 22 Accounts payable 23 Accrued Liabilities 24 Total Current Liabilities 25 Long-Term Liabilities Bonds Payable 26 27 Mortgage payable 28 Total Long Term Liabilities 29 Total Liabilities Stockholders' Equity 2019 2018 $ 125,000.00 $ 119,000.00 $ 685,000.00 $ 650,000.00 $ 225,000.00 $ 198,000.00 $ 65,000.00 $ 70,000.00 $ 195,000.00 $ 191,000.00 $1,295,000.00 $1,228,000.00 $ 875,000.00 $ 832,000.00 $2,170,000.00 $2,060,000.00 $ 265,000.00 $ 251,750.00 $ 641,000.00 $ 725,523.00 $ 906,000.00 $ 977,273.00 $ 250,000.00 $ 150,000.00 $ 150,000.00 $ 175,000.00 $ 400,000.00 $ 325,000.00 $1,306,000.00 $1,302,273.00 30 31 Common Stock 32 Paid in Capital 33 Reatined Earnings 34 Total Stockholders' Equity 35 Total Liabilities & Stockholders' Equity $2,170,000.00 36 $ 225,000.00 $ 225,000.00 $ 58,000.00 $ 58,000.00 $ 581,000.00 $ 474,727.00 $ 864,000.00 $ 757,727.00 $2,060,000.00 Increase (Decrease) Amount $ 6,000.00 $ 35,000.00 $ 27,000.00 $ (5,000.00) $ 4,000.00 $ 67,000.00 $ 43,000.00 $ 110,000.00 $ 13,250.00 $ (84,523.00) $ (71,273.00) $ 100,000.00 $ (25,000.00) $ 75,000.00 $ 3,727.00 $ $ 106,273.00 $ 106,273.00 $ 110,000.00 Percentage 5.04% 5.38% 13.64% -7.14% 2.09% 5.46% 5.17% 5.34% 5.26% -11.65% -7.29% 66.67% -14.29% 23.08% 0.29% 0.00% 0.00% 22.39% 14.03% 5.34% Net Sales Cost of goods sold Gross Profit A Net Income Riverside Sweets Income statement Year ended June 30,2019 Operating expenses Operating Income Other Income and (Expenses) Interest expenses Income Before Income taxes Income Tax expenses B $28,00,000 1551600 1248400 450540 797860 15000 782860 153529 $6,29,331 100% с 55% 45% 16% 28% 1% 28% 5% 22% Compute the following ratios. Do not round your calculations. (Always use cell references and formulas where appropriate to receive full credit.) Working Capital Current Ratio Acid-Test (Quick) Ratio Cash Ratio Accounts Receivable Turnover Days' Sales in Receivables Inventory Turnover Days' Sales in Inventory Gross Profit Percentage Debt Ratio Debt to Equity Ratio Times-Interest-Earned Ratio Profit Margin Ratio Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders' Equity Earnings per Share (EPS) Price/Earnings Ratio Dividend Yield Dividend Payout 2019 HINTS 2018 HINTS Cell | Hint: C5 | Begin the formula with an equals sign (=), use the balance in the horizontal analysis worksheet for your calculations, and press the enter key. C7 | Use the function =SUM( ) to calculate the numerator. C9 | =(0.75*¹Vertical Analysis'!C8)/(('Horizontal Analysis'!C14+'Horizontal Analysis'!D14)/2) C10 | Assume 365 days in a year and use the correct ratio in this worksheet for your calculations. 5 6 7 8 9 10 Current Assets 11 Assets June 30 2018 and 2019 Cash 12 13 Short Term Investments Accounts Receivable Merchandise Inventory 14 15 Other Current Assets 16 Total Current Assets 17 PPE 18 Total Assets Liabilities 19 20 21 Current Liabiltiies: 22 Accounts payable 23 Accrued Liabilities 24 Total Current Liabilities 25 Long-Term Liabilities Bonds Payable 26 27 Mortgage payable 28 Total Long Term Liabilities 29 Total Liabilities Stockholders' Equity 2019 2018 $ 125,000.00 $ 119,000.00 $ 685,000.00 $ 650,000.00 $ 225,000.00 $ 198,000.00 $ 65,000.00 $ 70,000.00 $ 195,000.00 $ 191,000.00 $1,295,000.00 $1,228,000.00 $ 875,000.00 $ 832,000.00 $2,170,000.00 $2,060,000.00 $ 265,000.00 $ 251,750.00 $ 641,000.00 $ 725,523.00 $ 906,000.00 $ 977,273.00 $ 250,000.00 $ 150,000.00 $ 150,000.00 $ 175,000.00 $ 400,000.00 $ 325,000.00 $1,306,000.00 $1,302,273.00 30 31 Common Stock 32 Paid in Capital 33 Reatined Earnings 34 Total Stockholders' Equity 35 Total Liabilities & Stockholders' Equity $2,170,000.00 36 $ 225,000.00 $ 225,000.00 $ 58,000.00 $ 58,000.00 $ 581,000.00 $ 474,727.00 $ 864,000.00 $ 757,727.00 $2,060,000.00 Increase (Decrease) Amount $ 6,000.00 $ 35,000.00 $ 27,000.00 $ (5,000.00) $ 4,000.00 $ 67,000.00 $ 43,000.00 $ 110,000.00 $ 13,250.00 $ (84,523.00) $ (71,273.00) $ 100,000.00 $ (25,000.00) $ 75,000.00 $ 3,727.00 $ $ 106,273.00 $ 106,273.00 $ 110,000.00 Percentage 5.04% 5.38% 13.64% -7.14% 2.09% 5.46% 5.17% 5.34% 5.26% -11.65% -7.29% 66.67% -14.29% 23.08% 0.29% 0.00% 0.00% 22.39% 14.03% 5.34% Net Sales Cost of goods sold Gross Profit A Net Income Riverside Sweets Income statement Year ended June 30,2019 Operating expenses Operating Income Other Income and (Expenses) Interest expenses Income Before Income taxes Income Tax expenses B $28,00,000 1551600 1248400 450540 797860 15000 782860 153529 $6,29,331 100% с 55% 45% 16% 28% 1% 28% 5% 22%
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
Assume that the consensus required rate of return on common stocks is 14 percent. In addition, you read in Fortune that the expected rate of inflation is 5 percent and the estimated long-term real...
-
Assume a companys days sales in receivables is 60 days, compared to 40 days for the prior period. Identify at least three possible reasons for this change.
-
The Hershey Company. For more than 100 years, The Hershey Company has enjoyed a position as one of North Americas largest manufacturers of quality chocolate and confectionery products. Today, The...
-
The common stock of Fido Corporation was trading at $45 per share on October 15, 2010. A year later, on October 15, 2011, it was trading at $80 per share. On this date, Fidos board of directors...
-
An aircraft can seat 220 passengers, and each of the passengers booked on the Might has a probability of 0.9 of actually arriving at the gate to board the plane, independent of the other passengers....
-
Assume for a given processor the CPI of arithmetic instructions is 1, the CPI of load/store instructions is 10, and the CPI of branch instructions is 3. Assume a program has the following instruction...
-
The enzyme lipase catalyzes the hydrolysis of esters of fatty acids. The hydrolysis of p-nitrophenyloctanoate was followed by measuring the appearance of p-nitrophenol in the reaction mixture: The...
-
The adjusted trial balance for Plevin Company is presented in E4-8. In E4-8, Plevin Company ended its fiscal year on July 31, 2014. The companys adjusted trial balance as of the end of its fiscal...
-
2 1. Let I = S 1 + exc - - ex -dx. 1+ ex 0
-
Create a Case Study: Recycle4Change (R4C) - Enabling a Sustainable Recycling System 1. Introduction: Recycle4Change (R4C) is a social enterprise initiative under Chance Creators, affiliated with the...
-
Believed to be one of the first widely read female authors of the Western world , Christine de Pizan's masterwork The Book of the City of the Ladies , was written in 1405 and is a history of the...
-
pick one management role and find the example of a real life business leader performing this role.
-
4. The project manager is in the process of meeting with various people who are impacted by his new project. He is attempting to find out what their needs are for the project as well as any...
-
Energy flows in most food chains from producers to consumers. Energy is transferred from one form to another in metabolic processes. Energy can be used to establish concentration gradients and for...
-
Constant Growth Valuation Woidtke Manufacturing's stock currently sells for $18 a share. The stock just paid a dividend of $2.50 a share (i.e., D0 = $2.50), and the dividend is expected to grow...
-
the seven characteristics of form, content, substance, and style that define an inaugural, how would i build an argument as to whether or not it was effective. What would examples be? George Bush...
-
You have the following information about ABC Corp: Asset Bonds Preferred Stock Common Stock Constant growth on common stock YTM on bonds Beta Treasury bond yield Book Value $25,000,000 $8,000,000...
-
One of the significant and relevant accounts for this cycle is equipment. For this account, what would typically be the most relevant assertions for the auditor to consider? Why is it important for...
-
The petty cash custodian reported the following transactions during the month. Prepare the journal entry to record the replenishment of the fund. A $ 10 cash payment is made to Starbucks to purchase...
-
What is the difference between a secured bond and a debenture? Which type carries more risk for the lender?
-
List the three main types of business activities on the statement of cash flows and give an example of each.
-
List examples from biology, sociology and neuroscience/psychology which involve the emergence of some kind of: (a Clustering or grouping amongst components. (b) Intermittency in time.
-
If both the current and the voltage in a circuit are doubled, the power (a) remains unchanged if the resistance is constant. (b) is halved. (c) is doubled. (d) is quadrupled.
-
Consider the emergence of social class and the emergence of the way we perceive ourself. Discuss if it is an example of two interacting emergent phenomena, as seems to be implied in [277].
Study smarter with the SolutionInn App