Purchase Solution

NPV for an investment

Not what you're looking for?

Ask Custom Question

What will be the NPV of an investment if the following takes place?

You have undeveloped raw land that you decide to split into 17 parcels, and begin grading the parcels and putting the streets and underground utilities in mid June 2008. The infrastructure improvements are not completed until mid 2009.

You borrow $4,470,583.00 at 6% interest to complete and pay for the all the infrastructure improvements being comleted for the site.

In addition to the above, you also incur an additional 5% site development costs overhead for supervision of this work in the amount of $223,529.15.

Once all the work is completed in 2009, you wait until the market gets better and begin selling the parcels in the year 2011. The last parcel will be sold in the year 2014.

You incur interest expense on the loan at 6% until 2011, when you can pay the loan off from the sale of the first parcels.

$1,900,000.00 was drawn on the loan in 2008, and the balance of the loan was drawn in 2009 $2,570,583.00 and paid off in 2011.

You incur additional expense of 12% sales commission on all the parcels as they sell.
Year 2011 - sell 4 parcels receive $8,630,107.20
Year 2012 - sell 2 parcels receive $5,939,841.60
Year 2013 - sell 4 parcels receive $9,036,958.60
Year 2014 - sell 7 parcels receive $11,410,180.60

What is the NPV (net present value) of this property at 10% discount rate, 12% discount rate, 15% discount rate taking all of the above into consideration?

Attachments
Purchase this Solution
Solution Summary

The expert finds the NPV for an investment of raw land.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • NPV and IRR of an investment

    The solution explains the calculation of NPV, IRR and payback period for an investment.

  • Present value

    Any project that has positive cash flows for every time period after the initial investment should be accepted. C. An investment should be accepted if the NPV is positive and rejected if it is negative. This is the correct statement.

  • A Firms Investment Opportunities

    Decisions like the change in the methods of sales distribution, or an advertisement campaign or research and development programs have long-term implications for the firm's expenditures and benefits, and therefore, they should also be evaluated as investment

  • Payback, NPV, IRR

    The NPV decision rule for determining whether to accept or reject an investment or project is to accept if the project's NPV is greater than zero and reject if NPV is less than zero.

  • Internal rate of return and NPV

    has an NPV of $20,850 based on a required rate of return of 12%.

  • Calculating Net Present and future Values

    Which investment is the most valuable? 2.A factory costs $800,000. You believe that it will produce an inflow after operating costs of $170,000 a year for 10 years. If the opportunity cost of capital is 14%, what is the NPV of the factory?

  • NPV of this opportunity

    as an opportunity as NPV is positive.

  • Payback period, IRR, and NPV

    1 onwards>add investment cost The following posting contains calculations of payback period, IRR, and NPV for 3 investments, provided in an Excel file.

  • Payback period and NPV

    What would be the NPV? 5. Suppose the annual savings will be $4,000 for eight years. What would be the NPV? Please see the attached file 1. Payback period is the time taken to recover the initial investment.

  • NPV and firm value

    This implies that the investment has given a return of $10 or the investment is worth $110 now. Thus the NPV represents the increase in the value of an investment.

View More Related Solutions