Question: 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, and 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
3.42 Rating (149 Votes )
There are 3 Steps involved in it
1 BUSN460 Individual Financial Analysis Project 2 Student Name 3 Instructions 4 Go to the CanGo intr... View full answer
Get step-by-step solutions from verified subject matter experts
