# A mortgage for \$125 000 is amortized over twenty-five years with an...

## Question

A mortgage for \$125 000 is amortized over twenty-five years with an interest rate of 5.25% compounded semiannually.
1. Find the monthly payments by rounding up and by rounding down.
2. Use the rounded-up value for the payments and an excel spreadsheet to create an amortization table. What is the value of the final payment?
3. Use the rounded-down value for the payments to create another amortization table. What is the value of the final payment?
When the final payment for year four is made, an additional \$10 000 is paid as well. The bank has a policy of charging a penalty of three months simple interest (5.25% pa on the \$10 000) to make up for its lost revenue. The penalty is taken off the \$10 000.
4. Use the rounded-up value for the payments and an excel spreadsheet to create an amortization table which takes into account the extra net payment at the end of year four.
(Regular payments will be continued until the end of the amortization period).
5. When will the final payment be made?
6. What is the value of the final payment?

## Solution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

By purchasing this solution you'll be able to access the following files:
Teaser.jpg and Solution2.xlsx.

# 50% discount

Hours
Minutes
Seconds
\$15.00 \$7.50
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

### Find A Tutor

View available Finance Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.