Calculate how your interest payment changes over time

Reference no: EM131948342

Question: You have borrowed $450,000 to buy a house. The loan officer offers you three options:

A) 10-year fixed rate loan, with an annual rate of 4% and with fixed monthly installments

B) 10-year fixed rate loan, with an annual rate of 5%, fixed monthly installments and a one-time (balloon) payment of $50,000 at the end of the loan.

C) 30-year fixed rate loan, with an annual rate of 6% and fixed monthly installments

1. Create an Excel spreadsheet and calculate how your interest payments, principal payments, and the outstanding loan balance changes over time for each of these options (20 points) (You do NOT need to print the entire excel sheet; just few cells from the beginning and end would be enough. However, you should explain your approach.)

2. Suppose you stop re-paying your loan at the end of the fifth year. What fraction of the original loan has been paid by then? (3. Plot an Excel graph showing the share of principal re-payment and interest payment from your fixed monthly payments, as a function of time (for all three options)

Reference no: EM131948342

Questions Cloud

What is the annual interest rate you are paying : You have just borrowed $20,000 to buy a new car. The loan agreement calls (or Ml monthly payments of $444.89 each to begin one month from today.

Award a vehicle production contract : Your acquisition program expects to award a vehicle production contract in April 2017. The first item from this contract is expected to be delivered

How much is each weekly payment : You borrowed $54,000 from a loan shark. He charges an annual interest rate of 21.9 percent but requires you to make weekly payments and pay the loan off.

Analyzing business communication theories : What should be the main focus? Is it overcome the dress code issue or analyzing business communication theories?

Calculate how your interest payment changes over time : Create an Excel spreadsheet and calculate how your interest payments, principal payments, and the outstanding loan balance changes over time for each of these.

Devising a contingency action plan for a company : Imagine that you are on a committee that has been tasked with devising a contingency action plan for a company.

Differences in contingency and situational leadership : Compare and contrast the differences in contingency and situational leadership. Then, determine the key influences they each have on organizational performance.

How much is the prepayment fee : Should the borrower choose to prepay this loan at any time after the end of the 10th year, a prepayment fee of 2% of balance will be changed.

Name the disadvanatages of form of business : What form of business ownership is the easiest to start and end. Name the disadvanatages of this form of business.

User Account

All Pages