Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1) The investor is looking at a $1.5 million parcel of land. She has two options:

a) She can put 20% down and employ 15 year loan rate found in WSJ.

b) She can put no money down and employ 30 year loan rate found in WSJ but she will have to pay private mortgage insurance (PMI) of 0.1% a month on the balance of the loan till she has 20% equity in the property. (Look up PMI on the internet if you’re not certain how this works.) The property will be grateful for in value at the rate of 0.2% a month.

Find out which option she must select. Suppose opportunity cost of her down payment is 0.25% a month. Setup cash flows in each case and then produce a column which nets them out. Think about how to determine when she no longer requires to pay monthly PMI fee. Compute the NPV by using the 15 year loan rate as discount rate.

2) Make a data table where column input is the difference in mortgage rates, go from 0% to 2% in increments of 0.1%. NPV is the other variable.

Make another data table where column input is PMI rate; go from 0% to 0.2% in increments of 0.01%. Again other variable is NPV.

Make another data table where column input is down payment amount; go from 0% to 20% in increments of 1%. Again other variable is NPV. describe the findings.

Requirements
Min Pages: 1

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914175

Have any Question? 


Related Questions in Basic Finance

Use wwwmsncomto find financial statements for any for

Use www.msn.comto find financial statements for any "for profit" company in the computer hardware industry. enter the company symbol go to menu on left side of screen go to financial results go to financial ratios Comple ...

We are going through financial crisis seven years have

We are going through financial crisis. Seven years have passed and we are still in recovery stage. Based on the analysis in the class, can you suggest and elaborate an alternative way to deal with the financial crisis?

Write an email refusing a customers request for a refundon

Write an email refusing a customer's request for a refund. On Twitter, a Whole Foods customer posted this tweet: As a representative for Whole Foods, you find this tweet and send the customer a direct message (DM) to obt ...

Explain how closeout netting reduces the credit risk for

Explain how closeout netting reduces the credit risk for two firms engaged in several derivatives contracts ? How does the legal system impose risk on a derivatives dealer? Consider a firm that has assets that generate c ...

1 why would a companys costs of manufacturing and

1. Why would a companys costs of manufacturing and procurement tend to increase as the firm changes from an MTP to an MTO strategy? Why would inventory costs tend to decrease? 2. How does a firms marketing strategy impac ...

Suppose you expected the return on the market to be 10 and

Suppose you expected the return on the market to be 10% and the return on the risk-free asset to be 2%. If you are considering a stock with a beta of 1.2, what is the expected return on this stock according to the securi ...

What is the purpose of a performance attribution model in

What is the purpose of a performance attribution model? In terms of the price-to-book (P/B) ratio, why are value stocks generally considered those with low P/B ratios? Comment on the following statements: a. "All one nee ...

What is the major concern construction lenders express

What is the major concern construction lenders express about the income approach to estimating value? Why do they prefer to use the cost approach when possible? In the latter case, if the developer has owned the land for ...

1 what does assignment mean and why would a lender want to

1. What does "assignment" mean and why would a lender want to assign a mortgage loan? 2. What is meant by a "purchase-money" mortgage loan? When could a loan not be a purchasemoney mortgage loan? 3. What does default mea ...

1 what benefits do flexible unit-load materials have in

1. What benefits do flexible unit-load materials have in contrast to rigid containers? How do return or reverse logistics considerations impact the two approaches? 2. What trade-offs are involved in the use of returnable ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen