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

In formulating your key concept exercise consider the

In formulating your Key Concept Exercise, consider the following questions: What are the benefits of just-in-time (JIT) techniques? What types of organisations use JIT techniques? Should things change if they are running ...

Briefly explain whether you agree with the following

Briefly explain whether you agree with the following statements: a. "A bank that expects interest rates to increase in the future will want to hold more rate-sensitive assets and fewer rate-sensitive liabilities." b. "A ...

1 deriving from the conclusion of proposition i what is the

1. Deriving from the conclusion of Proposition I, what is the crux of M&M Proposition II? What is the natural relationship between the required returns on debt and on equity that results from Proposition II? 2. In what w ...

Wampc is examining its cash conversion cycle the company

W&C is examining its cash conversion cycle. The company expects its cost of goods sold, which equal 85% of sales, to equal $770,000 this year. W&C normally turns over inventory 25 times per year, account receivable are t ...

Develop a behavioral or a free-format self-report measure

Develop a behavioral or a free-format self-report measure of the conceptual variable you assessed in problem 1, and collect the relevant data from the same people. Find a partner to help you code the responses, and compu ...

The bolts will be lubricated with moly paste for better

The bolts will be lubricated with moly paste, for better control of preload, and will be tightened with a torque wrench. What torque will you specify? What range of preload would you expect to encounter when that torque ...

According to an article in the wall street journal the us

According to an article in the Wall Street Journal: The U.S. Securities and Exchange Commission on Wednesday filed charges against the investment company GTF Enterprises Inc. . . . The SEC complaint alleges that Gedrey T ...

The scientific method can be described as a circle or a

The scientific method can be described as a circle or a spiral of steps that leads from an initial observation, to a hypothesis, to new observations, to a new hypothesis. For each of the following observations: a. State ...

Moonbeam electronics profiting from a foreign trade

MOONBEAM ELECTRONICS PROFITING FROM A FOREIGN TRADE ZONE Located in southwest Missouri,Moonbeam Electronics is a manufacturer of small electrical appliances, such as toasters, toaster ovens, can openers, mixers, and blen ...

Assignment learning outcomes covered1 to enable students to

Assignment Learning Outcomes Covered 1. To enable students to explore and develop an understanding of the theoretical techniques, concepts and methods employed in finance. 2. To develop the ability to apply the theoretic ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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