Rondo Company: Financial Statement Analysis

Introduction

Originally, financial statement analysis is the research, which requires thorough and multi angle approach towards estimation of the financial ratios and financial flows, both horizontal and vertical. The aim of this paper is to analyze the financial ratios of Rondo Company by doing the financial ratios and also comparing it to the industry averages given in the case. The analysis will be completed in two parts – the financial part (math) and recommendation part in memo format.

Financial Ratios and Analyses

First, the analysis of accounts should be provided. The information on the matters of the accounts, provided in the case study is the following.

2003 2004 2005
Current assets
Cash 1,469,000 2,032,500 2,460,000
Accounts Receivable 9,000,000 9,375,000 9,750,000
inventory 4,125,000 4,625,000 5,250,000
Total current Assets 14,594,000 16,032,500 17,460,000

Taking into consideration the matters of the fixed denominator, it should be emphasized that it is closely associated with the matters of the incomes and expenses. The accounts of Rondo Company should be analyzed in the context of the Total Asset Turnover, which is 1.10.

  • The dividend payout ratio should be between 40% and 50%.
  • The debt to total assets ratio should not be higher than 50%. Moreover, the Board’s intention is to maintain total debt, including current liabilities, at 55% of assets or lower.
  • Annual company growth should continue in the 5% to 10% range. The board will measure growth in the annual increase in Earnings Per Share.
  • The company has investigated several sources of funding for the new project and for future needs.

In accordance with these facts the horizontal analysis of the company will be he following:

Income statement Year 1 year 2 Year3
Cash 1496000 100% 2032500 136% 2460000 121%
Accounts receivable 9000000 100% 9375000 104% 9750000 104%
Inventory 4125000 100% 4625000 112% 5250000 114%
Total Current Assets 14621000 100% 16032500 110% 17460000 109%
Equipment 19000000 100% 18375000 97% 17500000 95%
Property and Plant 16000000 100% 15375000 96% 14750000 96%

The vertical analysis, which is the analysis of net sales in the context of total assets points out that the appropriate percentage of 8,3% is the satisfying result, nevertheless, the company should refrain from large-scale investment at this stage of its development.

Balance Sheet year 1 % Year 2 % Year 3 %
Cash 1496000 3,02% 2032500 4,08% 2460000 4,95%
Accounts receivable 9000000 18,15% 9375000 18,83% 9750000 19,61%
Inventory 4125000 8,32% 4625000 9,29% 5250000 10,56%
Equipment 19000000 38,31% 18375000 36,91% 17500000 35,20%
Total Assets 49594000 100,00% 49782500 100,00% 49710000 100,00%
Accounts payable 1500000 6,70% 2250000 18,00% 2500000 25%
Accrued Expenses 3375000 15,08% 3500000 28,00% 3750000 38%
Bank Loan 10000000 44,69% 7500000 60,00% 5000000 50%
Total liabilities 22375000 100,00% 12500000 100,00% 10000000 100%
Common Stock 95875000 193,32% 9587500 19,26% 9587500 31%
Retained Earnings 17631500 35,55% 19445000 39,06% 9587500 31%
Total liabilities and Equity 49594000 100,00% 49782500 100,00% 30960000 100%

In comparison with Metal Pipe Inc. Rondos ratios look rather attractive, nevertheless, MPI has more stable financial trends

Balance Sheet year 1 % Year 2 % Year 3 %
Cash 9030765 27,48% 1034200 3,01% 1980000 5,70%
Accounts receivable 6000000 18,26% 7600000 22,13% 8760000 25,24%
Inventory 3985300 12,13% 2345000 6,83% 2250000 6,48%
Equipment 12000000 36,51% 14980000 43,62% 13500000 38,89%
Total Assets 32865000 100,00% 34340000 100,00% 34710000 100,00%

Analytical Memo

As for the financial analysis of the regarded opportunities, there is strong necessity to emphasize that the projected deal, associated with the investment, may be regarded as a potentially successful decision for the further growth of the company. Nevertheless, the analysis of the financial assets and the incomes of the company revealed the fact that the company is not ready for such large-scale investment. In spite of the fact that the financial assets and the overall financial flow analysis have revealed the incredible stability of the company, this investment may violate its stability, and cause essential losses, especially taking into consideration the marketing trends of the Poly Company.

The Initial Capital Expenditure for equipment, which is negotiated for the agreement is $6.25 million. Originally, all the expenses may be compensated by the mortgage rates. Originally, the Total Amount Offered with Poly Pipe Purchase is $13 million. The interest rates of the bank, in the case of the loan taking are 11.50%. Originally, this rate is high enough for the company, especially taking into consideration the amount of the required loan.

As for the matters of Industry analysis, it should be stated that the world trends of copper, steel, and iron pipe industry tend to grow, and the incomes will be increasing. Surely, the proper financial management of the company will assist in increasing the sales and incomes, thus increasing the credibility of favorable conditions for the investment, nevertheless, essential difficulties may be experienced in the case of managerial fault. Moreover, the poly pipe production tends to stay on the same level, and there is no necessity to look for the increase of the net income from this industry.

The recommendations, that should be given to both companies is to postpone the investment and negotiate on the matters of cooperation and financial assistance from the side of Rondo Company. The fact is that, loan will not violate the stability of Rondo Company, if it is smaller than the investment requirement, on the other hand, it would provide the necessary financial assistance for the Poly Company, thus, allowing it to expand its manufacturing capacities and penetrate the wider market segment.

Conclusion

In conclusion, it should be emphasized that the main idea of the research was to conclude whether the financial ratios of Rondo Company are stable and reliable enough to conclude the investment agreement with Poly Company, which is aimed at increasing its industrial capacity in the sphere of poly pipes. The research has revealed that the best solution will be not to conclude this agreement, as investment may violate the financial stability of Rondo Company.

Bibliography

Brigham, E.F., & Daves, P.R. Intermediate Financial Management. South-Western College Pub, 2009.

Liaw, Thomas K. The Business of Investment Banking. New York: John Wiley & Sons, 2009.

Cite this paper

Select style

Reference

StudyCorgi. (2022, February 6). Rondo Company: Financial Statement Analysis. https://studycorgi.com/rondo-company-financial-statement-analysis/

Work Cited

"Rondo Company: Financial Statement Analysis." StudyCorgi, 6 Feb. 2022, studycorgi.com/rondo-company-financial-statement-analysis/.

* Hyperlink the URL after pasting it to your document

References

StudyCorgi. (2022) 'Rondo Company: Financial Statement Analysis'. 6 February.

1. StudyCorgi. "Rondo Company: Financial Statement Analysis." February 6, 2022. https://studycorgi.com/rondo-company-financial-statement-analysis/.


Bibliography


StudyCorgi. "Rondo Company: Financial Statement Analysis." February 6, 2022. https://studycorgi.com/rondo-company-financial-statement-analysis/.

References

StudyCorgi. 2022. "Rondo Company: Financial Statement Analysis." February 6, 2022. https://studycorgi.com/rondo-company-financial-statement-analysis/.

This paper, “Rondo Company: Financial Statement Analysis”, was written and voluntary submitted to our free essay database by a straight-A student. Please ensure you properly reference the paper if you're using it to write your assignment.

Before publication, the StudyCorgi editorial team proofread and checked the paper to make sure it meets the highest standards in terms of grammar, punctuation, style, fact accuracy, copyright issues, and inclusive language. Last updated: .

If you are the author of this paper and no longer wish to have it published on StudyCorgi, request the removal. Please use the “Donate your paper” form to submit an essay.