Reference no: EM131451984
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?
|
What is the shareholder return
: Brian Carty, a prominent investor, is evaluating investment alternatives. What is the shareholder return?
|
|
Outstanding shares with four shareholders
: Bilkis Brans has 20,000 outstanding shares with four shareholders. Ester owns 9,000 shares, Mendez owns 4,000 shares, Judy owns 4,000 shares,
|
|
Treasury interest rate increase
: How much can the 10-year treasury interest rate increase before you can’t afford to make the monthly payments?
|
|
How much did vaughn pay for the bonds
: On January 1, 2017, Vaughn Corporation purchased 318 of the $1,000 face value, 9%, 10-year bonds of Walters Inc. How much did Vaughn pay for the bonds?
|
|
Your mortgage banker offers you three choices for mortgage
: 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 fina
|
|
Loan contract with a re-payment schedule
: Five years ago you signed a loan contract with a re-payment schedule of 12-year fixed-rate, at 5.5 percent interest.
|
|
Yield to maturity-investment banking firm
: What arbitrage opportunity is available for an investment banking firm? What is the profit on the activity?
|
|
Discuss how the resource-based view of the firm
: Discuss how the resource-based view (RBV) of the firm combines the two perspectives of an internal analysis of a firm.
|
|
What is percentage change in value of euro versus dollar
: what percentage change in share price would he receive? What is percentage change in value of euro versus dollar over same period?
|