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

Budget variance analysisplease use budget variance

Budget Variance Analysis Please use budget variance spreadsheet that is provided for part 1. 1. Budget Variance Analysis The actual quantity of material used was 31,000 with an actual cost of $7.75 per unit. The actual l ...

Nbspa shoe company checks police records on 1200 randomly

A shoe company checks police records on 1200 randomly selected auto accidents and notes that teenagers were at the wheel in 180 of them. Construct a 90% confidence interval estimate of the proportion of shoe accidents th ...

Assignment exploring the sec 10-kwe are going to explore

Assignment: Exploring the SEC 10-K We are going to explore our company's SEC-10K. For most, if not all classmates, this will be the first time you have ever seen or read this type of report. Note: the SEC 10-K is an audi ...

What distinguishes indebtedness and equity is preferred

What distinguishes indebtedness and equity? Is preferred stock a debt or equity instrument? Explain ? How does a mutual fund perform its function as a financial intermediary? What is meant by the term "maturity intermedi ...

1 what are time-series research designs and how are they

1. What are time-series research designs, and how are they used to learn about changes in behavior over time? 2. What types of independent variables can be used in participant-variable research designs, and what conclusi ...

Evaluate the quality of internet resourcesselect two

Evaluate the quality of Internet resources. Select two Internet resources and evaluate them based on the five criteria: authority, accuracy and reliability, purpose/objectivity, coverage, and currency. Search for news ab ...

Identify general-purpose statements and communication

Identify general-purpose statements and communication objectives for several situations. Read the following situations and write a general-purpose statement and a specific communication objective-the results you want-for ...

1 what industrial and national capital structure patterns

1. What industrial and national capital structure patterns are exhibited globally? What factors seem to be driving these patterns? 2. What is the observed relationship between debt ratios and profitability, and the perce ...

1 why is notional principal often exchanged in a currency

1. Why is notional principal often exchanged in a currency swap but not in an interest rate or equity swap? Why would the parties to a currency swap choose not to exchange the notional principal? 2 .Explain how the follo ...

1 if 2 buys pound1 and 22 buys pound1 how many euros are

1. If $2 buys £1 and 2.2 buys £1, how many euros are required to buy $1? 2. A student makes the following observation: "During May 2010, the euro depreciated sharply against the U.S. dollar. That was good news for attend ...

  • 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