fin_301_penn_state_world_campus_final_excel_project.xlsx -...

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

Grading Rubric Page 1 Grading Rubric for Final Project in FIN 301 0 0.5 1 2 Calculation of Weights 2 Cost of Debt 1 Cost of Equity Beta 1 1 Risk-free Rate 1 WACC Calculation 2 Total Possible Points from WACC calculation portion of project 8 Cash Flow Calc 0 1 2 4 Initial Cash Flows Partially correct CFs 2 Operating CFs 4 Terminal CFs 2 75/25 D/E Split Partial Calculations 2.5 25/75 D/E Split Partial Calculations 2.5 Total Possible Points from Cash Flow portion of project 13 0 1 2 3 3 3 Presentation 3 Total Possible Points from NPV Profiles and Presentation portion of project 9 Total Possible Points for the Final Project 30 Total Possible Points No Calculations or Explanations Calculation using book values for weights Correct Calculation using Market Rates with NO Explanation Correct Calculation using Market Rates with Explanation No Calculations or Explanations Incorrect Calculation, Brief Explanation, Reasonable estimate Correct Calculation based on YTM with Explanation No Calculations or Explanations Reasonable Estimate of Beta based on information provided online (i.e Yahoo Finance) but No Explanation Correct Estimate of Beta based on online data with Explanation Expected Market Return No Calculations or Explanations Estimate for Market Return is not reasonable based on historical market performance Explanation of Expected Returns based on historical returns with reasonable estimate No Calculations or Explanations Estimate not based on current Treasury yields but reasonable no explanation Explanation of Risk free rate based on current T-bond or T-bill yield No Calculations or Explanations Incorrect Calculation with minor errors carried through from above assumptions with no explanation Incorrect Calculation with minor errors carried through from above assumptions with explanation Correct Cacluation with Explanation of all parameters Total Possible Points No Calculations or Explanations All initial CFs properly identified with brief explanation No Calculations or Explanations Few OCFs properly identified with no explanation Most OCFs properly identified with brief explanation All OCFs properly identified with brief explanation of all calculations (ie taxes & depr properly accounted for) No Calculations or Explanations Partially correct CFs no tax adjustments All terminal after tax CFs properly identified with brief explanation No Calculations or Explanations All PV of Cash Flows correctly calculated and Justification for use of NPV technique No Calculations or Explanations All PV of Cash Flows correctly calculated and Explantion for underlying assumptions of case Create NPV Profile for Varying Debt/WACC No Calculations or Explanations No Graph, Partial Calculations, Partial

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture