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

Assume a linear velocity distribution and a linear

Assume a linear velocity distribution and a linear concentration profile in the laminar boundary layer over a flat plate. Apply the boundary conditions for a laminar boundary layer and evaluate the velocity and concentra ...

1 financing what factors are considered in managing

1. Financing. What factors are considered in managing financing? 2. Investing. What is the primary objective of investing? What else must be considered? What potential investment vehicles are available? 3. Protecting You ...

Finance problems1 after placing 8000 in a savings account

Finance Problems 1. After placing $8,000 in a savings account paying annual compound interest of 7%, calculate the amount that will accumulate if it is left for 10 years? 2. Sarah Wiggum would like to make a single inves ...

1 name the principal types of mortgage-related securities

1. Name the principal types of mortgage-related securities. What are the differences between them? 2. There are several ways that mortgages can be sold in the secondary market. Choose two and compare and contrast their l ...

Part 1 short questions a short precise and concise answer

Part 1: Short questions. A short, precise and concise answer will obtain full credit. (NB: We will take the seven highest grades of your answers to these eight questions.) Question 1 A treasurer argues with the CFO that ...

Discussionmiddot determine a key difference between

Discussion · Determine a key difference between a fee-for-service plan and an episode of care payment plan, and indicate the plan that you believe to be most advantageous for the majority of patients. Provide support for ...

1 some consumers force themselves to save money by

1. Some consumers force themselves to save money by depositing a portion of their paycheck into a savings account. They deposit the remainder into a checking account and then only spend the money in the checking account. ...

1 many things that society values such as good health

1. Many things that society values, such as good health, high-quality education, enjoyable recreational opportunities, and desirable moral attributes of the population, are not measured as part of the GDP. It follows tha ...

Now consider a second joint of the same material width and

Now consider a second joint of the same material, width and thickness as the joint in problem 4 above but eccentrically loaded. This time, however, the line of action of the external load is 0.563 in. removed from the ce ...

1 define the followinga a conditional sales contractb a

1. Define the following: a. A conditional sales contract b. A chattel mortgage 2. Under what conditions would a firm prefer the following: a. A "fixed-rate" term loan from a bank b. A "floating-rate" term loan, with the ...

  • 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