User Account

All Pages

Annualized irr for the mortgage in the spreadsheet

Assignment Help Financial Management
Reference no: EM131913315

Ann would like to buy a house.

It costs $800,000.

Her down payment will be $40,000.

She will take out a mortgage for $760,000.

It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding.

The annual interest rate is 4.00%.

She must pay 2.5% in fees at the time of the loan.

Note: the home is bought and the loan is taken in month 0, the first payment is due in month 1.

In the spreadsheet where it says “cash inflow”, “outflow” and “net cash flow” you should only take into account cash flow related to the mortgage.

2. Compute Ann’s annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.)

(a.) What is the annualized IRR for the mortgage?

(b.) Is it higher or lower than the mortgage contract rate?

(c.) Why?

PLEASE SHOW ON EXCEL SHEET

Reference no: EM131913315

Questions Cloud

Satisfactory opportunities-sources of investment of funds : Should a company always have "other satisfactory opportunities and sources of investment of funds available" or is it ok to issue the dividends?
Differences between for-profit and nonprofit organizations : What are the differences between For-Profit and Nonprofit organizations?
What is the company cost of equity capital : What is the company’s cost of equity capital?
What is price per share of company stock : What is the price per share of the company's stock?
Annualized irr for the mortgage in the spreadsheet : Compute Ann’s annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.)
Discount loan is paid : A Discount Loan is Paid. What is the EFFECTIVE ANNUAL INTEREST RATE?
Compute the discount rate and net present value : Compute the discount rate. Calculate the present value of total inflows. Calculate the net present value. Calculate the present value of total outflows.
Using the fully adjusted equity method : Using the fully adjusted equity method, an intercompany gain on an upstream sale of land is:
What is the effective annual interest rate of loan : A Bank is willing to lend your company $20,000 for six months at 8% interest, with 10% compensating balance. What is the effective annual interest rate of loan?

Reviews

Write a Review

Financial Management Questions & Answers

  Calculate the cost to the bakery if it takes delivery

Consider a bakery that estimates its requirement of wheat in May as 50,000 bushels. The manager of the bakery can hedge against price risk by going long on 10 May wheat futures contracts at the currently prevailing futures price of $8.65 a bushel for..

  Capital losses always reduce the investor rate of return

The YTM on a discount bond will be above its coupon rate. Capital losses always reduce the investor’s rate of return.

  What is the most vivid instance you can recall

What is the most vivid instance you can recall, from ?rsthand experience, when a company was hurt by its bungling of the mode issue? How would you account for what the company did? What is the single thing you could do that would have the best chance..

  Within budget than large building construction projects

Explain why IT projects are less likely to be delivered on time and within budget than large building construction projects.

  Weighted-average cost of capital assuming a tax rate

The total market value of Okefenokee Real Estate Company's equity is $12 million, and the total value of its debt is $8 million. The treasurer estimates that the beta of the stock currently is 1.4 and that the expected risk premium on the market is 1..

  Requuired annual rate of return on the investment

A permanent scholarship fund is started through a donation of $750,000. If scholarships totalling $100,000 are awarded each year beginning five years from now, the requuired annual rate of return on the investment is nearest to:

  What is company target debt–equity ratio

Fama’s Llamas has a WACC of 9.3 percent. The company’s cost of equity is 11.2 percent, and its pretax cost of debt is 7.9 percent. The tax rate is 34 percent. What is the company target debt–equity ratio

  Explain the theory of normal backwardation

Explain the theory of Normal Backwardation. Explain the expected effects on price relationships and risk premiums.

  Stock produced returns

Over the past five years, a stock produced returns of 14%, 22%, -16%, 2%, and 10%. What is the probability that an investor in this stock will NOT lose more than 8% nor earn more than 21% in any one given year?

  The value of the peso could reduce your dollar cash flows

You are already aware that a decline in the value of the peso could reduce your dollar cash flows. Yet, according to purchasing power parity, a weak peso should only occur in response to a high level of Mexican inflation, and such high inflation shou..

  Bond valuation with annual payments

Jackson Corporation's bonds have 5 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 9.5%. The bonds have a yield to maturity of 7%. What is the current market price of these bo..

  Separate market risk from unique asset risk

Why is it important to separate market risk from unique asset risk? Can market risk be segmented and measured differently than just looking at index benchmarks?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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