6.4 Assignment: Spreadsheet Exercises

 

  1. Time Value of Money – Single Sums: Problems 1 and 2
  2. Rate of Return: Problems 3 and 4
  3. Perpetuities and Annuities: Problems 5 through 8
  4. Capital Budgeting: Problems 9 and 10
  5. 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.

 

Preview Rubric
6.4 Assignment (60 Points)

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 ScoreSingle Sums10 points

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

9 points

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

8 points

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

7 points

(0-7 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 Single Sums,/ 10Rate of Return10 points

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

9 points

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

8 points

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

7 points

(0-7 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 Rate of Return,/ 10Perpetuities and Annuities20 points

(19-20 Points)

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

18 points

(17-18 Points)

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

16 points

(15-16 Points)

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

14 points

(0-14 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 Perpetuities and Annuities,/ 20Capital Budgeting20 points

(19-20 Points)

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

18 points

(17-18 Points)

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

16 points

(15-16 Points)

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

14 points

(0-14 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 Capital Budgeting,/ 20Rubric Total ScoreTotal/ 60