finance week 6
You boss needs help again.
- What are the forecasted levels of the line of credit and special dividends? (Hints: Create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. Also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. Identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.)
- Now assume that the growth in sales is only 3%. What are the forecasted levels of the line of credit and special dividends?
Scoring Rubric
Levels of Achievement | ||||
---|---|---|---|---|
Criteria | Exemplary | Accomplished | Developing | Beginning |
Weight 50.00%
|
100 %
Models were estimated with great accuracy, using Excel and provided relevant outputs in an excel file |
85 %
Models were estimated with moderate accuracy, using Excel and provided relevant outputs in an excel file |
75 %
Models were estimated with inaccuracy, using Excel and provided relevant outputs in an excel file |
50 %
Model estimations are mostly incorrect, or no model was provided |
Weight 50.00%
|
100 %
Interpretations are provided with great accuracy by addressing all the required questions, and minimum words requirement is met |
85 %
Interpretations are provided with moderate accuracy by addressing most of all required questions, and minimum words requirement is met |
75 %
Interpretations are provided with many errors, and, some of important questions were not answered. Minimum words requirement is not met. |
50 %
Interpretations are mostly incorrect, or no interpretation was provided. |