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

Investmentsinstructions for asset returns paperstep 1

Investments Instructions for Asset Returns Paper Step 1 Extending Siegel (1992) graphs to 2014 This section uses the file "AssetHistoricalReturns" to replicate and extend Siegel (1992) results to 2014. 1. Create a chart ...

Suppose that lilymac photography has annual sales of 232000

Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average inventories of $4,700, average accounts receivable of $25,400, and an average accounts payable balance of $7,200. Ass ...

A firm is expected to pay a dividend of 355 next year and

A firm is expected to pay a dividend of $3.55 next year and $3.85 the following year. Financial analysts believe the stock will be at their price target of $120 in two years. Compute the value of this stock with a requir ...

Business comprehensive problem 1 version fall buse the

BUSINESS Comprehensive Problem 1 Version FALL B Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2014 2015 Sales $ 1,050,000 $ 1,128,750 less Cost of Goods S ...

Financediscussion 1multinational financial management

Finance Discussion 1 "Multinational Financial Management" Please respond to the following: • From the e-Activity, determine key reasons why a multinational corporation might decide to borrow in a country such as Brazil, ...

Convex mechanical supplies produces a product with the

Convex Mechanical Supplies produces a product with the following costs as of July 1, 20X1:     Material $ 5 Labor 3 Overhead 2   $ 10  Beginning inventory at these costs on July 1 was 6,700 units. From July 1 to December ...

Develop a computer program that can be used to maintain the

Develop a computer program that can be used to maintain the current status of all active contracts of a construction rum. Input should include contract number and description, contract amount, date of contract award, dat ...

According to the expectations theory how is the long- term

According to the expectations theory, how is the long- term interest rate determined? Why is the geometric average used instead of the simpler arithmetic average?

You are a foreign exchange analyst at cbaprepare a brief

You are a foreign exchange analyst at CBA. Prepare a brief outlining what you believe will be the forecast for the AUD/USD exchange rate in 2017. Draw Supply Demand Graph how does it effect. Your home country is Australi ...

Jackson corporations bonds have 19 years remaining to

Jackson Corporation's bonds have 19 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 9.5%. The bonds have a yield to maturity of 12%. What is 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate