Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Conclude working on your Individual Financial Analysis Report, due this week. Note that this is not a team assignment. Be sure to include proper citations
Conclude working on your Individual Financial Analysis Report, due this week. Note that this is not a team assignment. Be sure to include proper citations for all references you use.
Go to the CanGo Intranet and pull the financial statements.
https://devry.equella.ecollege.com/file/d0a0f0ed-47f3-4e74-ac74-aeadc25f3f3e/1/CanGo_Intranet.zip/CanGo_Intranet/financialinfo.html
BUSN460 Individual Financial Analysis Project | ||||||
Student Name: | ||||||
Instructions: | ||||||
Go to the CanGo intranet found in the Report Guide tab under Course Home | ||||||
Use the financial statements from the most recent year to fill in the table below. | ||||||
You may find some formulae calling for an average, e.g., average inventory, average receivables. | ||||||
Because we only have the Balance sheet for one year, you can only use the one year number not an average. | ||||||
Assume interest expense is $0.00 | ||||||
Be careful of the Debt equity ratio. The review covers debt asset ratio as an example of how to calculate ratios and that is different from debt equity ratio, | ||||||
and that is different from the debt equity ratio so think about how you calculate the debt equity ratio using the debt asset ratio as an example. | ||||||
Be sure to cite your references | ||||||
Green boxes to be filled in by instructor | ||||||
Ratio | Formula (express the ratio in words) | Detailed calculation (actual numbers from financial statements used for the calculation) | Final number (final result of the detailed calculation) | Explanation of why ratio is important | Earned points (up to 3 points per "box"/cell) | Instructor feedback |
Example: | Term A/Term B (Term A divided by Term B) | 1000/2000 | .50 | This is the explanation of the role of this ratio and why it is important | 3 | |
Efficiency Ratio: Receivables Turnover | ||||||
Grade for above | 0.0 | |||||
Efficiency Ratio: Inventory Turnover | ||||||
Grade for above | 0.0 | |||||
Financial Leverage Ratio: Debt/Equity Ratio | ||||||
Grade for above | 0.0 | |||||
Liquidity Ratio: Current Ratio | ||||||
Grade for above | 0.0 | |||||
Liquidity Ratio: Quick Ratio | ||||||
Grade for above | 0.0 | |||||
Liquidity: Working Capital | ||||||
Grade for above | 0.0 | |||||
Profitability Ratio: Return on Assets | ||||||
Grade for above | 0.0 | |||||
Profitability Ratio: Return on Sales | ||||||
Grade for above | 0.0 | |||||
Total Earned Points | 0.0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started