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

1 how does lowest tco differ from lowest purchase price2

1. How does lowest TCO differ from lowest purchase price? 2. What is the underlying rationale that explains why firms should segment their purchase requirements? 3. Explain how constraints in manufacturing are interrelat ...

1 what are the risks of global investment2 how can a

1. What are the risks of global investment? 2. How can a derivative security be used to hedge portfolio risk?

What is the business reason for china noahs potential

What is the business reason for China Noah's potential currency exposure? Does the company really need to subject itself to substantial exchange rate risk? Is the risk "material" to China Noah? Do you think China Noah sh ...

Given interest rates flat 2bull compute risky pv01 of

Given interest rates flat 2%. • Compute risky PV01 of initial the par CDS spread of 5% and 5 years time horizon. • Assume current spread is 7%, Use the computed risky PV01 to verify that this is approximately riskyPV01*( ...

1 discuss some of the advantages and disadvantages of

1. Discuss some of the advantages and disadvantages of setting up production in LCCs. Consider the benefits of market growth and the risk of an example venture. 2. Look at the information on the RDEs discussed in the tex ...

1 comment on the following proposition using floating-rate

1. Comment on the following proposition: Using floating-rate debt eliminates interest rate risk (the risk that interest payment amounts will change in the future) for both the borrower and the lender. 2. What purpose do ...

Question 1pensions have been very important to a successful

Question 1 Pensions have been very important to a successful retirement. Employer and Employee both fund parts of company pensions. Please select a NYSE listed company and report on their pension obligations. Analyze the ...

1 in what ways is the study of research methods valuable to

1. In what ways is the study of research methods valuable to students such as you? 2. Discuss the importance of systematic empiricism, public verification, and solvability to the scientific method. In what ways does pseu ...

1 what is the difference between the probability of a stock

1. What is the difference between the probability of a stock out and the magnitude of a stock out? 2. Data suggest that while overall average inventory levels are declining, the relative percentage being held by manufact ...

External capital funding proposal External capital funding proposal:  

External capital funding proposal:   For Keurigs Expansion to Europe IDEA:  Bring your finance and economics knowledge to bear by preparing an external capital funding proposal for a major international investment at a p ...

  • 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