4.4 Assignment: Spreadsheet Exercises

by

 

  1. Using  (course exclusive), complete all eight of the following problems:
    1. Pro Forma Financial Statements: Problems 1 and 2
    2. Preparing a Cash Budget: Problems 3 through 6
    3. Growth Management Analysis: Problems 7 and 8
  2. Be sure your Excel spreadsheet is prepared in a professional manner, with answers clearly indicated and all your calculations shown. Full credit will not be given if your process for arriving at the answer is not fully displayed, including any intermediate steps.
  3. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.

 This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.CriteriaLevel 4Level 3Level 2Level 1Criterion ScorePro Forma Financial Statements15 points

(14-15 Points)

You demonstrated a clear understanding of performing the calculations and insightful critical thinking when interpreting the results.

13 points

You demonstrated competent understanding of performing the calculations and critical thinking when interpreting the results.

12 points

(11-12 Points)

You demonstrated some understanding of performing the calculations or limited critical thinking when interpreting the results.

10 points

(0-10 Points)

You demonstrated little to no understanding of how to perform the calculations or little to no critical thinking when interpreting the results.

Score of Pro Forma Financial Statements,/ 15Preparing a Cash Budget30 points

(28-30 Points)

You demonstrated a clear understanding of performing the calculations and insightful critical thinking when interpreting the results.

27 points

(25-27 Points)

You demonstrated competent understanding of performing the calculations and critical thinking when interpreting the results.

24 points

(22-24 Points)

You demonstrated some understanding of performing the calculations or limited critical thinking when interpreting the results.

21 points

(0-21 Points)

You demonstrated little to no understanding of how to perform the calculations or little to no critical thinking when interpreting the results.

Score of Preparing a Cash Budget,/ 30Growth Management Analysis15 points

(14-15 Points)

You demonstrated a clear understanding of performing the calculations and insightful critical thinking when interpreting the results.

13 points

You demonstrated competent understanding of performing the calculations and critical thinking when interpreting the results.

12 points

(11-12 Points)

You demonstrated some understanding of performing the calculations or limited critical thinking when interpreting the results.

10 points

(0-10 Points)

You demonstrated little to no understanding of how to perform the calculations or little to no critical thinking when interpreting the results.

Score of Growth Management Analysis,/ 15Rubric Total ScoreTotal/ 60