Pay in interests alone during full life of mortgage

Assignment Help Financial Management
Reference no: EM132047255

1. Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. [Please be good to the forests and cut and paste only the first and last few rows of the table, not the whole thing.]

2. Using the amortization table you built for the previous question, answer the following [Again, just cut and paste the segment of the amortization table that helps you answer the question.]:

a. How much money will you still owe on the loan after making one full year of payments?

b. How much money will you still owe on the loan after making 15 full years of payments?

c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from your bank to do so?

d. How much money can you expect to pay in interests alone during the full life of the mortgage?

Reference no: EM132047255

Questions Cloud

What is the internal rate of return on this project : What is the internal rate of return (IRR) on this project?
What is the firm market value capital structure : What is the firm's market value capital structure?
What was your dollar return on this investment : You purchased 250 shares of a particular stock at the beginning of the year at a price of $87.25. What was your dollar return on this investment?
Expected percent change in the value of the british pound : If the IFE holds, what is the expected percent change in the value of the British pound relative to the dollar, over the course of the year?
Pay in interests alone during full life of mortgage : How much money can you expect to pay in interests alone during the full life of the mortgage?
Cycle of triangular arbitrage : If you have 1 million USD to conduct one cycle of triangular arbitrage, what will be your profit?
Calculate opportunity cost of capital : Calculate the opportunity cost of capital. Is the stock a good or bad buy? What will investors do?
After-tax salvage and return of working capital : What is the additional Year 3 cash flow (i.e, the after-tax salvage and the return of working capital)?
How much profit can be made with covered interest arbitrage : Given this information, how much profit can be made with covered interest arbitrage, by borrowing 1 million USD?

Reviews

Write a Review

Financial Management Questions & Answers

  Suppose an investment is estimated to have a cash flow

Suppose an investment is estimated to have a cash flow of $100,000 per year for the next five years. At the end of the fifth year the property is expected to be sold for $1,000,000. What is the present value of the investment at a 10 percent discount..

  Collision and other than collision coverages

What is the difference between Collision and Other Than Collision coverages?

  Denote the fitted volatility by gmvol

Denote the fitted volatility by gmvol.  - Build an adequate GARCH model plus gmvol as the exogenous variable for the log S&P return series.

  What would be the book value of the current assets

Rooster’s currently has $5,200 in cash. what would be the book value of the current assets?

  Strategies is most appropriate for retirement invest

Generally, which of the following asset allocation strategies is most appropriate for Jerry’s retirement investments?

  Calculate the US dollar cash flows and final payments

Calculate the US dollar cash flows and final payments. Calculate the Australian dollar cash flows and the final receipts from this arrangement.

  What is the liquidity premium on gamas bonds

GAMA Corporation's 5-year bonds yield 6.20% and 5-year T-bonds yield 4.40%. What is the liquidity premium on GAMA's bonds?

  Find the internal rate of return

An insurance firm agrees to pay you $6,620 at the end of 20 years if you pay premiums of $200 per year at the beginning of each year for 20 years. Find the internal rate of return.

  Percentage increase per year in winners check over period

In 1895, the first Putting Green Championship was held. The winner’s prize money was $210. In 2014, the winner’s check was $1,470,000. What was the percentage increase per year in the winner’s check over this period? If the winner’s prize increases a..

  What is maximum amount-company should pay for investment

Your company has the opportunity to make an investment that promises to pay $24,000 after 6 years. If your company has a required return of 8.5% on this type of investment, what is the maximum amount that the company should pay for the investment? Ex..

  What is the effective cost of the trade credit

A What is the nominal annual cost of Sixty Second Avenue Inc.'s trade credit? A What is the effective cost of the trade credit?

  Why doesnt fed seek to reduce the unemployment rate to zero

Which type of unemployment-frictional, structural, or cyclical-does the Federal Reserve seek to reduce? Why doesn't the Fed seek to reduce the unemployment rate to zero?

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