Financial analysis report
| 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 - Please do not use Investopedia or financeformulas.net as a source of reference. | |||||||
| 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 | ||||||
| References: | |||||||
10 years ago
20
Answer(2)![blurred-text]()
![]()
![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- financial_ratios.docx
Purchase the answer to view it

NOT RATED
- givens_business_460_crn_financial_analysis_project_week_solution.xlsx
Bids(1)
other Questions(10)
- Employee engagement
- Aspects of justice
- I have been out of town for work, I need answers please!
- What is the vertex for the graph of the quadratic function f(x)=1/4(x+2)^2-9
- Blank Lab Report
- homework
- Can you do this assignment by 11:00
- Collective Bargaining Labor Stoppage
- BSHS 332 Week 3 Individual Assignment Update on Agency Visit Paper
- A newspaper article talks about a research study that found a significant positive correlation between taking vitamins and crime rates. The title of the article read, "Vitamins cause crime."
