[ad_1]
Due Date: 11:59 p.m. EST, Sunday of Unit 2
Points: 100
Overview:
Suppose you bought a house and took out a mortgage for $50,000. The interest rate is
8%, and you must amortize the loan over 10 years with equal end-of-year payments.
For tax purposes, you must predict the yearly interest expense.
Instructions:
• Create an amortization schedule in a table in Microsoft Excel.
• Each row and column should be clearly labeled. Columns should include at a
minimum:
o Beginning Amount,
o Payment Amount,
o and Interest for each year.
• Create a graph that shows how the payments are divided between interest and
principal repayment over time.
Requirements:
• Microsoft Excel file
Be sure to read the criteria by which your work will be evaluated before you start
and again after before you submit.
BUS522 – Financial Tools for
Managers
Time Value of Money
Evaluation Rubric for Time Value of Money Assignment
CRITERIA Deficient Needs
Improvement
Proficient Exemplary
(0-35 points) (36-47 points) (48-59 points) (60 points)
Amortization
Schedule
Data is missing
or incorrect.
Table is not
labeled.
Data is complete
but incorrect.
Table missing
some labels.
Data is
complete and
accurate or
near accurate.
All columns are
labeled.
All data is
complete and
accurate.
Labels, and
formatting has
been applied to
clearly present
that data.
(0-23 points) (24-31 points) (32-39 points) (40 points)
Graph Graph missing
or showing the
wrong data.
Graph has been
included, but not
well labeled and
may be showing
the incorrect
data.
Graph presents
the data in a
readable
format,
adequate
labeling.
Graph is clear,
data is shown
and is correct.
All axes have
been labeled
with correct
number
formatting.
[ad_2]
Testimonials
