How your interest payments changes over time

Assignment Help Finance Basics

Reference no: EM131977175

Question: You have found a condo in Hoboken you would like to buy that costs $500,000. Your mortgage banker offers you three choices for a mortgage and is willing to finance 100% of the purchase.

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

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

c) 15-year fixed rate loan, with an annual rate of 3.5% 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. Under which option/s would you walk away from your condo if prices fell by 10% of the original purchase price by the end of year 4? Assume no other costs to walk away.

3. Assume that your budget allows you to afford $3,200 in monthly payments and you want to pay principal down as quickly as possible. Which option would you choose?

Reference no: EM131977175

Questions Cloud

List possible objects in the bookstore operation : List possible objects in the bookstore operation, including their attributes and methods.

What is the loan balance after the grace period : What is the loan balance after the grace period? Assume the freshman year loan earns 1.1% interest for 3/4 year during the first year.

Determining the atmospheric pressure : Assuming that the density of the fluid being administered is 1.07 g/ml, at what height should the IV bag be placed above the entry point

Determine solanos return on investment : Solano Company has sales of $800,000 cost of good sold. Determine Solano's return on investment (ROI), investment turnover, profit margin, and residual income.

How your interest payments changes over time : Create an Excel spreadsheet and calculate how your interest payments, principal payments, and the outstanding loan balance changes over time.

Average eardrum has an area : What is the force in Newtons exerted on an eardrum if you are at the bottom of a water-filled pool that is 4.98 meters deep?

What is the mac address used for ipv4 multicast : What are some causes of the number of bytes on the wire exceeding the number of bytes being captured? What are the source and destination MAC address in Frame

Calculate the annual reduction in your bill due : Calculate the annual reduction in your bill due to (a) 5-year MACRS depreciation, and (b) straight line depreciation.

Create a monthly claim status summary report : Create a monthly Claim Status Summary report. He wants you to include in the report layout the insurance company number.

User Account

All Pages