BUSN460_Financial_Analysis_Project_Week.xlsx - BUSN460 Individual Financial Analysis Project Student Name Instructions Go to the CanGo intranet found in

BUSN460_Financial_Analysis_Project_Week.xlsx - BUSN460...

This preview shows page 1 - 2 out of 4 pages.

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 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 ex Be sure to cite your references Green boxes to be filled in by instructor Ratio Explanation of why ratio is important Example: 1000/2000 .50 1.56 Grade for above 0.28 Grade for above 0.67 Formula (express the ratio in words) Detailed calculation (actual numbers from financial statements
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 4 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture