Financial Forecasting
Financial Forecasting Case Study
Project Grade Sheet
Name __________________________________
|
POINTS |
|
|
|
_______/30 |
Part I: Financial Forecast |
|
|
|
|
Accurately prepares projected income statements for the next three years |
|
|
|
Effective use of Excel formulas and Cell References |
|
|
|
|
|
_______/10 |
Part II: Financial Analysis |
|
|
|
|
Income Statement, Common-size statements |
|
|
|
Income Statement, Horizontal analysis |
|
|
|
Effective use of Excel formulas and Cell References |
|
|
|
|
|
_______/30 |
Part III: Recommendation |
|
|
|
|
Conclusion supported by sound reasoning |
|
|
|
Comprehensive |
|
|
|
No more than 2 pages Professional appearance |
|
|
|
Well-organized, professional, and creative |
|
|
|
|
|
_______/30 |
Reflection |
|
|
|
|
Minimum 2 pages |
|
|
|
Good writing style, good grammar |
|
|
|
Provides insight in to the effectiveness of the case |
|
|
|
Provides constructive feedback, both positive and negative |
|
|
|
|
|
_______/100 |
TOTAL SCORE |