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 at whose discretion is the decision to make a disaster

1. At whose discretion is the decision to make a disaster declaration? 2. What is the National Response Framework? 3. How does the National Response Framework compare to its predecessors, the National Response Plan and t ...

You are group treasurer of sun and sand plc a uk package

You are Group Treasurer of Sun and Sand plc, a UK package tour operator offering holidays in many parts of the world but specializing in Morocco, Spain and the United States. Sun and Sand is one of the major operators in ...

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 ...

Name the two ways in which joints loaded in shear resist

Name the two ways in which joints loaded in shear resist loads ? Which kind is slip-critical? Which kind requires control of bolt preload during assembly? What are typical coefficients of friction for slip-critical joint ...

Sandoval enterprises has gathered the projected cash flows

Sandoval Enterprises has gathered the projected cash flows for two projects. At what interest rate would the firm be indifferent between the two projects? Which project is better if the WACC is above the interest rate? W ...

Evaluate studies for a report-imagine that youre the

Evaluate studies for a report:- Imagine that you're the corporate communications vice president for Harley-Davidson Motor Company. To promote motorcycle use in the United States, you're planning a communication campaign ...

You are prohibited from discussing this assignment with

You are prohibited from discussing this assignment with other students. Construct an Excel spreadsheet that determines the following values: 1. Black-Scholes-Merton model call option without dividends. 2. Binomial model ...

Consider a 0 5 super senior tranche and a index cds spread

Consider a [0%, 5%] super senior tranche, and a index CDS spread of 400 bps for 5 years maturity assuming 0% recovery and 0% interest rates. We'll be pricing this tranche using one factor gaussian copula. a) What is the ...

A simple random sample of 120 men results in a mean of 80

A simple random sample of 120 men results in a mean of 80 beats per minute, and a standard deviation of 11 beats per minute. Based on the sample results, the researcher concludes that the pulse rates of men have a standa ...

As part of a hotel renovation program a company must choose

As part of a hotel renovation program, a company must choose between two grades of carpet to install. One grade costs $22 per square yard, and the other, $28. The costs of cleaning and maintaining the carpets are identic ...

  • 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