How the loan changes over time for each option

Assignment Help Financial Management
Reference no: EM131962636

You have found a house in Jersey City you would like to buy that costs $600,000. Your mortgage banker offers you several choices for a mortgage and is willing to finance 90% of the purchase.

30 year fixed mortgage at 4.00%

15 year fixed mortgage at 3.875%

5 year fixed mortgage at 3.25%

Using excel spreadsheet calculate how your outstanding of how the loan changes over time for each option (i.e show interest and principal paid and the remaining balance in each month). Use Loan Amortization Excel.

Reference no: EM131962636

Questions Cloud

Unusual pension plan : You belong to an unusual pension plan because your retirement payments will continue forever
What is the present value of your annual salary : What is the present value of your annual salary 10 years from now if the discount rate is 2.5%?
Elderly ice skating clown accidentally slips at ice rink : An elderly ice skating clown accidentally slips at the ice rink and breaks his hip.
Transaction deposits on its balance sheet : Bank Three currently has $850 million in transaction deposits on its balance sheet.
How the loan changes over time for each option : Using excel spreadsheet calculate how your outstanding of how the loan changes over time for each option
Repaid with annual payments at the end of each year : A loan of $10000 is to be repaid with annual payments at the end of each year for the next 20 years.
What is the market price of face value bond : Gugenheim, Inc. offers a 9% coupon bond with annual payments. What is the market price of a $1,000 face value bond?
What are its annual coupon rate and yield to maturity : What are its annual coupon rate and yield to maturity? What is the fair price for one of Cyberdyne's zero coupon bonds?
What is the implicit interest in the first year of bond life : Suppose you purchase a zero coupon bond with a face value of ?$1000 maturing in 21 years, What is the implicit interest in the first year of the? bond's life?

Reviews

Write a Review

Financial Management Questions & Answers

  Annually to live comfortably while retired

You believe you will need $150,000 annually to live comfortably while retired. You plan on retiring when you are 65 and will begin withdrawing funds from your retirement account on your 66th birthday. If you expect to need 25 years of retirement inco..

  Seller must pay to the lender for this arrangement

What is the buydown fee that the seller must pay to the lender for this arrangement?

  Calculate the expected return for the portfolio

You have decided to invest $70,000 in Stock Fund, and $30,000 in Bond. The returns for each fund are forecasted below: Fill in the portfolio’s forecasted return for a strong economy and a weak economy. Then calculate the expected return for the portf..

  Negotiate spot currency rate or forward currency rate

Would you try to negotiate a spot currency rate or a forward currency rate? If the latter, what maturity date would you use?

  Operating cash flow of the project using tax shield approach

A project will increase sales by $60,000 and cash expenses by $41,000. The project will cost $40,000 and be depreciated using straight-line depreciation to a zero book value over the 4-year life of the project. The company has a marginal tax rate of ..

  Use derivatives to manage risk and change risk exposure

Should firms hedge? A number of firms practice hedging and use derivatives to manage risk and change risk exposure. Some people argue firms should stick with their core business (i.e airlines should concentrate and on operating airlines). What do you..

  How many passengers per day does the company

Initially, the bus company charged $1.50 per trip had a ridership of 3,000 passengers per day. The price elasticity after a $0.50 increase in fare is. -0.5 How many passengers per day does the company have after the fare increase.

  What is the percentage change in the bonds price

A(n) seven-year bond has a yield of 8% and a duration of 7.212 years. If the bond's yield increases by 40 basis points, what is the percentage change in the bond's price?

  Calculating the weighted average cost of capital

When calculating the weighted average cost of capital, weights are based on

  Using incremental rate of return analysis

A firm is considering an investment in a numerical controlled milling machine needed for an eight (8) year project life. Three alternatives are under consideration. The firm uses a 20% MARR.  Using incremental rate of return analysis, determine which..

  Investors anticipate for this company dividends

what is the growth rate that investors anticipate for this company's dividends?

  Company needs infusion of cash to invest in new project

The company needs an infusion of cash to invest in a new project. Which of the following is not an economic function of mutual funds?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd