The credit manager at Bank of New York has just received the income statement and balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The credit manager at Bank of New York has just received the income statement and balance sheet for Cosmo, Inc. the year ended December 31,2019. The bank requires the firm to report its earnings performance and financial position quarterly as a condition of a loan agreement. The bank's credit manager must prepare two key financial statements based on the information sent by Cosmo, Inc. This will be passed on to the commercial loan officer assigned to this account, so that he may review the financial condition of the firm. Given the following financial statements and historical ratios. Calculate the Cosmo, Inc. financial ratios for the most recent year (2019). Analyze its overall financial situation from time-series viewpoint. And also. break your analysis into an evaluation of the firm's liquidity, activity, debt, and profitability. Make your interpretations. (30 points) Construct the DuPont system of analysis from 2015 to 2019. Make your comparison. Interpret your results. (10 points) Using the firm's 2018, and 2019 financial statements, develop the common-size income statements and common-size balance sheets for 2018 and 2019. Make a comparation. Which areas require further analysis and investigation? (20 points) Gross Profit Less: Operating Expenses Selling and Adm. Expenses Depreciation Miscellaneous Exp. Total Operating Expenses Operating Profit Less: Interest Expense Net Profits Before Taxes Less: Taxes Net Profits After Taxes Less: Dividends Add to Retained Earnings EPS (100,000 shares) $131,040 $43.680 50,000 17,472 $111,152 $19,888 47,280 ($27,392) (10,957) ($16,435) 0 ($16,435) (0.16) $152,006 $40,535 50,000 15,201 $105,736 $46,270 46,440 ($170) (68) ($102) 0 ($102) (SO) Historical and Industry Average Ratios Cosmo, Inc. 2015 2016 2017 2018 2019 6.38 3.68 3.56 3.62 2.54 2.00 0.57 0.61 0.47 0.55 0.64 0.65 1.90 2.20 2.75 2.83 1.79 2.06 1.07 0.42 1.92 1.99 1.31 1.43 190.10 183.49 278.54 255.60 60.00 54.58 39.00 11.25 6.08 6.69 9.36 32.44 0.94 0.83 0.78 0.89 2.77% 3.49% 0.27% -1.88% 2.60% 2.89% 0.21% -1.68% 4.94% 6.36% 0.59% -4.76% Current Ratio Quick Ratio Total Debt Ratio Equity Multiplier Times Interest Earned Ratio Inventory Turnover ratio Average Age of Inventory Receivables Turnover Average Collection Period Total Asset Turnover Net Profit Margin ROA ROE The credit manager at Bank of New York has just received the income statement and balance sheet for Cosmo, Inc. the year ended December 31,2019. The bank requires the firm to report its earnings performance and financial position quarterly as a condition of a loan agreement. The bank's credit manager must prepare two key financial statements based on the information sent by Cosmo, Inc. This will be passed on to the commercial loan officer assigned to this account, so that he may review the financial condition of the firm. Given the following financial statements and historical ratios. Calculate the Cosmo, Inc. financial ratios for the most recent year (2019). Analyze its overall financial situation from time-series viewpoint. And also. break your analysis into an evaluation of the firm's liquidity, activity, debt, and profitability. Make your interpretations. (30 points) Construct the DuPont system of analysis from 2015 to 2019. Make your comparison. Interpret your results. (10 points) Using the firm's 2018, and 2019 financial statements, develop the common-size income statements and common-size balance sheets for 2018 and 2019. Make a comparation. Which areas require further analysis and investigation? (20 points) Gross Profit Less: Operating Expenses Selling and Adm. Expenses Depreciation Miscellaneous Exp. Total Operating Expenses Operating Profit Less: Interest Expense Net Profits Before Taxes Less: Taxes Net Profits After Taxes Less: Dividends Add to Retained Earnings EPS (100,000 shares) $131,040 $43.680 50,000 17,472 $111,152 $19,888 47,280 ($27,392) (10,957) ($16,435) 0 ($16,435) (0.16) $152,006 $40,535 50,000 15,201 $105,736 $46,270 46,440 ($170) (68) ($102) 0 ($102) (SO) Historical and Industry Average Ratios Cosmo, Inc. 2015 2016 2017 2018 2019 6.38 3.68 3.56 3.62 2.54 2.00 0.57 0.61 0.47 0.55 0.64 0.65 1.90 2.20 2.75 2.83 1.79 2.06 1.07 0.42 1.92 1.99 1.31 1.43 190.10 183.49 278.54 255.60 60.00 54.58 39.00 11.25 6.08 6.69 9.36 32.44 0.94 0.83 0.78 0.89 2.77% 3.49% 0.27% -1.88% 2.60% 2.89% 0.21% -1.68% 4.94% 6.36% 0.59% -4.76% Current Ratio Quick Ratio Total Debt Ratio Equity Multiplier Times Interest Earned Ratio Inventory Turnover ratio Average Age of Inventory Receivables Turnover Average Collection Period Total Asset Turnover Net Profit Margin ROA ROE
Expert Answer:
Answer rating: 100% (QA)
COMPUTATION OF FINANCIAL RATIOS LIQUIDITY RATIOS SOLVENCY RATIO... View the full answer
Related Book For
Financial Accounting
ISBN: 978-0078025549
3rd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
Explain variance, standard deviation and beta. What do these terms describe about data? Show the calculations of variance and standard deviation using one variable such as an grades OR minutes of...
-
A 50 kg cannonball hits a 12,000 kg tank that is initially at rest. The cannonball embeds into the tank, and both move at the same velocity for 50 cm until coming to rest. The coefficient of friction...
-
On Dec. 31, 2013, Neyo Co. purchased machinery for $95,933.37. The Co. paid $20,000 down & agreed to finance the remainder by making 4 equal payments each Dec. 31 at the implicit interest rate of...
-
Mango Designs began selling its custom furniture on June 1, 2020. At the end of the month, the special journals showed the following results. Other information you will need is as follows: ? Interest...
-
The accompanying partially complete contingency table shows the responses to two treatments: (a) Invent a fictitious data set that agrees with the table and for which x2s = 0. (b) Calculate the...
-
Some of the following problems would be suitable for solution by engineering economic analysis. Which ones are they? (a) Would it be better to buy an automobile with a diesel engine or a gasoline...
-
Consider the output of a regression using one explanatory variable on \(n=3\) observations. The residuals and leverages are: Compute the PRESS statistic. i 1 2 3 Residuals ei Leverages hi 3.181...
-
Magness Delivery Service completed the following transactions during December 2016: Dec. 1 Magness Delivery Service began operations by receiving 510,000 cash and a truck with a fair value of $20,000...
-
A force at = 4.00 N - 3.00 N is applied to an object at position = 2.00 mi + 3.00 mi. What is the torque about the origin?
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
Explain void and voidable contracts with examples.
-
1. Between the Likert Scale and the Guttman Scale, which would you be more willing to participate in and why? 2. What do you think is the most effective way to measure attitude?
-
1) Write a paragraph the potential reasons for choosing a hub versus a switch, whether it be cost, speed, security or other. 2) What might prevent wireless technology from being used extensively in...
-
Watch on youtube : Filipino tattoo Mark of the four waves tribe. 1. Make an introduction explanation? 2. What is the importance of this video in Filipino cultures? 3. What is your reflection and...
-
Discuss two or three strategies you can utilize when writing or speaking to persuade others to accept your point of view. Please support your assertions using two (2) scholarly sources.
-
A topic that has a local focus, such as a change that needs to happen in your community. Please include three things: what the need for change is, what your planned solution is, and who the audience...
-
Adam smith wants to sell 4 ceramic product . He can sell 1 one 10K, two for 16K (8k each), 3 for 18K(each for 6K), and 4 for 18K ( each 4,5k) . Adams cost of producing 1 product is 4k, 2 products...
-
When you weigh yourself on good old terra firma (solid ground), your weight is 142 lb. In an elevator your apparent weight is 121 lb. What are the direction and magnitude of the elevator's...
-
Kelli Davis is in the flower business. While business has been steady, she wonders if she should expand her business to include candy as well. Both flowers and candy fit well into her business model....
-
On November 1, 2015, Aviation Training Corp. borrows $60,000 cash from Community Savings and Loan. Aviation Training signs a three-month, 7% note payable. Interest is payable at maturity. Aviations...
-
On April 1, 2015, Shoemaker Corporation realizes that one of its main suppliers is having difficulty meeting delivery schedules, which is hurting Shoemakers business. The supplier explains that it...
-
Describe which characteristics of HR metrics and workforce analytics are likely to result in greater return on investment and organizational impact.
-
Why are information security and privacy important considerations in the design, development, and maintenance of an HRIS?
-
List and discuss the major information security and privacy threats to organizations.
Study smarter with the SolutionInn App