for both assignments my corporation is Starbucks
Go to any financial website of your choosing (such as or the main website for your assigned corporation) and locate the financial statements for your assigned corporation. Note that certain websites, such as , will allow you to export the data to Excel for free which might simplify your Excel calculations.
Now refer to in the text.
1) Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements for your assigned corporation. The trend will consist of the following ratios:
- Current Ratio and the Quick Ratio from the I. Short term solvency, or liquidity, ratios category
- Debt to Equity Ratio and the Times Interest Earned Ratio (aka Interest Coverage Ratio) from the II. Long-term solvency, or financial leverage, ratios category
- Return on Assets Ratio and the Return on Equity Ratio from the IV. Profitability ratios category
Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, why?
2) Using the , find the industry ratios for your corporation. Note that the ratios provided in readyratios.com for your assigned corporation may not match your part (1) calculations exactly.
Compare your calculated ratios for your assigned corporation to the industry ratios. Then provide a one-page (minimum) discussion that details whether your assigned corporation is performing better or worse than the industry based on the definitions of the six ratios. Are your calculated trends from part (1) moving closer to or farther away from the industry averages? Is this good or bad?
I will attach assignment 2
Requirements: As needed
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.