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

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Finance Questions
Homework Solution
$40.00
Business
Finance
Shares
Dividends
Percentage
Stock Market
Risk-Free Rate
Companies
Annual Rate
Growth Rate
Equations
Functions
Costs
Payments
Finance Questions
Homework Solution
$28.00
Business
Accounting
Finance
Administration
Economy
Interest Rates
Number of Periods
Present Values
Future Values
Cash Flow
Discount Rates
Payments
House Price
TVM Lottery
Business Questions: Margin Purchase
Homework Solution
$33.00
Accounting
Business
Financial Management
Economics
Prices
Shares
Purchases
Percentage
General Widgets
Investments
Stock Market
Absolute Gain
Percentage Gain
Capital Budgeting Questions
Homework Solution
$50.00
Accounting
Finance
Business
Economics
Interest
Retirement
Capital Budgeting
Bonds
Monthly Payments
Maturity Value
Loan
Debt
Annual Rate
Mini Case Problems
Homework Solution
$93.00
Business
Finance
Insurance
Policy
Value
Coverage
Inflation
Replacement Value
Deductible
Weighted Average
Tax
Market
Portfolio
Beta
CAPM
Jensen’s Alpha
Sharpe Ratio
Modigliani Measure
Treynor Index
Get help from a qualified tutor
Live Chats