Financial analysis – Danny’s Consolidated Statement of cashflows – Get Paper Help

Instructions

1. Section One: Look at the income statement, balance sheet, statement of cash flows, and financial ratios of Johnny’s company, and then write a comprehensive financial analysis about its Long-Term Solvency
2. Section Two: write one paragraph explaining (based on your findings above) if the long-term solvency situation is going worse or better (must use figures from attached exhibits)
3. Section Three: write a comment on how Johnny’s company’s long-term solvency looks versus Danny’s company in 2019 only.

4. When you analyze in all three sections, you must pull data from the financial exhibits (both ratios and $) to support the analysis and to provide a comprehensive analysis.
5. Attached is a file contains financials for Johnny and Danny as follows:
   1. Balance Sheet for Johnny’s Company.
   2. Income Statement for Johnny’s Company.
   3. Statement of cashflows for Johnny’s Company.
   4. Financial ratios for Johnny’s Company.
   5. Balance Sheet for Danny’s Company.
   6. Income Statement for Danny’s Company.
   7. Statement of cashflows for Danny’s Company.
   8. Financial ratios for Danny’s Company.
6. I will attach a sample analysis just for you to know the approach I look for in writing the analysis. The sample file is in PDF.
7. Do not use any sources. Only use the numbers and ratios provided in the Johnny&Danny
8. Do not add any charts, figures, or any objects to the job.
9. Do not use subtitles throughout the paper, except to separate between the three sections.
10. Remember the analysis is only about the Long-Term Solvency for Johnny (Keep the sections one, two, and thee above as your guide).
11. Since I will need to review the job and check all data of the analysis, please stay on the deadline.
12. Open the Johnny&Danny file to make sure it’s accessible and clear.
13. If you have questions at any point, kindly let me know. I will be available on chat.

Johnny’s Consolidated Balance Sheet + Common size

Johnny’s Consolidated Income Statement + Common size

Johnny’s Consolidated Statement of Cashflows

Johnny’s Financial Ratios

End for Johnny’s Company

Danny’s Consolidated Balance Sheet + Common size

Danny’s Consolidated Income Statement + Common size

Danny’s Consolidated Statement of cashflows

Danny’s Financial Ratios

Capital Structure and Long-term Solvency
Applied has seen decreases in liabilities, with non-current liabilities falling slightly from $6.8B in 2018 to $6.4B in 2019 – with $5.3B and $4.7B of that being in long-term debt for each year respectively. Applied’s debt to equity ratios of 1.32 and 1.58 for 2019 and 2018 are higher than the industry average of 0.53, suggesting, at face value, that Applied is more highly leveraged and a bit riskier. Similarly, Applied’s debt ratio for 2019 is 56.82%, meaning their assets are financed with debt slightly above the industry average of 53%, although Applied decreased this by about 7% from 2018. This drop is largely influenced by an adjustment in deferred income taxes as Applied adopted ASU No. 2016-16 and, as a result, was able to record a deferred tax asset of $1.6B related to the estimated income tax effects of an intra-entity transfer of intangible assets. If we account for this anomalous one-time event, the 2019 debt to asset ratio is 62%, about a 1.5% decrease from 2018. Additionally, Applied’s long term debt to total capitalization decreased by 16.5% in 2019. This was driven in part by a $600M decrease in long-term debt and a $3.5B increase in retained earnings, $1.6B of which was from the accounting standard adoption mentioned above. The financial leverage index crept up a bit from 2.29 in 2018 to 2.43 in 2019, meaning Applied is using its debt in a positive way since its return on equity is larger than its return on assets. On the other hand, times interest earned and fixed-charge coverage both decreased by over 26% from 2018. Still, the cash interest coverage of 18.21 is well above the generally accepted 2.5 acceptable risk and fixed-charge coverage of 11.8 is well above the 1.25 threshold of acceptable risk. Lastly, Applied’s cash interest coverage of 18.2 seems to be healthy and well above the bare minimum acceptable of 2. Overall, Applied appears to utilize more debt than their peers, suggesting that in terms of long-term solvency, they could pose some risk to the investor.