Financial analysis

Use this spreadsheet for the information needed to complete this assignment. Complete the following: Using the company's financial statements, calculate and evaluate the firm’s sustainable growth rate (SGR) for the last 3 years, and summarize your findings in your paper. Be sure to address the following: What are the sustainable growth rates for your subject company over the period that you studied? What are the consequences faced by firms that grow at a rate that is not consistent with their sustainable rate? If the firm grew at a rate above or below the SGR, how might it finance its excessive growth or reward its stockholders for the underperformance? Please submit your assignment. For assistance with your assignment, please use your text, Web resources, and all course materials. Other Information Instructions: A minimum of 800 words is required to adequately address all the requirements in this IP! You are calculating your firms Sustainable Growth Rates for the last 3 years and providing a discussion regarding these findings. You need to compare the firm’s SGR with it’s Actual Growth Rate in order to determine if your firm grew at a rate above or below the what was sustainable; so calculate and compare these rates! Calculate the Sustainable Growth Rates for the THREE YEARS. Be sure to include the data you use in your calculations! Show ALL your calculations for the Sustainable Growth growth rates! This include your calculations for Return on Equity and Dividend Payout ratios. Explain the consequences faced by the firm if it grew at a rate that is higher than what is sustainable (this is when the Actual Growth rate exceeds the Sustainable Growth Rate) Explain the consequences faced by the firm if it grew at a rate that is lower that the SGR If your firm grew at a rate above or below the SGR, how did it finance its excessive growth (did it borrow more money? Did debt increase? Did it sell more equity? Check the Balance Sheet!) or reward its stockholders for the underperformance (did they increase dividends?) You need to compare the firm’s SGR with it’s Actual Growth Rate in order to determine if your firm grew at a rate above or below the what was sustainable; so calculate and compare these rates! Instructor's Comments: Ensure that the narrative you provide, the discussion supporting your answers, is worthy of earning full points for each requirement! If you answer the question “what are some of the consequence of growing too fast” with “the firm will suffer from a liquidity crisis;” you will be awarded some points because this is correct, however, you will not earn full points; you need to ensure you provide comprehensive depth and detail addressing each requirement and demonstrate an understanding of the concepts instead of simply regurgitating material from the textbook or chats. Please feel free to go well above and beyond this minimum; the more the better, exceeding this minimum shows extra effort. Be sure to properly reference your work providing intext citations on all data and information that is not common knowledge. References and citations must be properly APA formatted! Grammar, spelling, and punctuation should be correct and professional Do NOT copy and paste any information from your sources! ALL work must be IN YOUR OWN WORDS! Keep an eye on your OV score, if it’s over 25%, please go back and check to ensure you are properly paraphrasing! DO NOT COPY AND PASTE FROM YOUR PREVIOUS DB! Feel free to contact me if you have any concerns!