BUSN460 Individual Financial Analysis Project 2 Student Name: 3 Instructions: 4 Go to the CanGo intranet found in the Report Guide tab under Course Home 5 Use the financial statements from the most recent year to fill in the table below 6 You may find some formulae calling for an average, e.g., average inventory, average receivables 7 Because we only have the Balance sheet for one year, you can only use the one year number not an average 8 Assume interest expense is $0.00 9 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, 10 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 11 Be sure to cite your references 12 Green boxes to be filled in by instructor Ratio Instructor feedback Formula (express the Detailed calculation Final numberExplanation of why ratio Earned points (up to 3 points per "box"/cell) (final result of is important ratio in words) (actual numbers the detailed from financialcalculation) statements used for the calculation) 13 Example: Term A/Term B (Term A divided 50 This is the explanation of the role of this ratio and 1000/2000 3 14 wh Efficiency Ratio: Receivables 15 Turnover 16 Grade for above 0.0 Efficiency Ratio: 17 Inventory Turnover 18 Grade for above 0.0 Financial Leverage Ratio: Debt/Equity 19 Ratio 20 Grade for above 0.0 Liquidity Ratio: 21 Current Ratio 22 Grade for above 0.0 Sheet1 BUSN460 Individual Financial Analysis Project 2 Student Name: 3 Instructions: 4 Go to the CanGo intranet found in the Report Guide tab under Course Home 5 Use the financial statements from the most recent year to fill in the table below 6 You may find some formulae calling for an average, e.g., average inventory, average receivables 7 Because we only have the Balance sheet for one year, you can only use the one year number not an average 8 Assume interest expense is $0.00 9 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, 10 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 11 Be sure to cite your references 12 Green boxes to be filled in by instructor Ratio Instructor feedback Formula (express the Detailed calculation Final numberExplanation of why ratio Earned points (up to 3 points per "box"/cell) (final result of is important ratio in words) (actual numbers the detailed from financialcalculation) statements used for the calculation) 13 Example: Term A/Term B (Term A divided 50 This is the explanation of the role of this ratio and 1000/2000 3 14 wh Efficiency Ratio: Receivables 15 Turnover 16 Grade for above 0.0 Efficiency Ratio: 17 Inventory Turnover 18 Grade for above 0.0 Financial Leverage Ratio: Debt/Equity 19 Ratio 20 Grade for above 0.0 Liquidity Ratio: 21 Current Ratio 22 Grade for above 0.0 Sheet1
