Real Estate Professional Developer's Excel Tool Kit
  • Real Estate Professional Developer's Excel Tool Kit
  • Real Estate Professional Developer's Excel Tool Kit
  • Real Estate Professional Developer's Excel Tool Kit
  • Real Estate Professional Developer's Excel Tool Kit
  • Real Estate Professional Developer's Excel Tool Kit
Originally published: 04/01/2017 14:33
Last version published: 18/07/2018 10:44
Publication number: ELQ-88028-3
View all versions & Certificate
certified

Real Estate Professional Developer's Excel Tool Kit

Financial analysis tools for educational purposes

developerfeasibilityfinancial analysisincome propertyland propertymodelreal estatereal estate developmenttooltoolkit

Description
The set of developer tools attached are set to be used together with the third edition of Professional Real Estate Development: The ULI Guide to the Business. These have been broken up into sections in correspondence to the book.

Chapter 3 of the book focuses of development financial feasibility analysis, where land development is analysed using a for-sale method appropriate for a subdivision, condominiums, for-sale homes, and other real estate, in which the product is sold at completion rather than being operated as income-producing property.

Financial feasibility analysis for land development is performed in two stages:

Stage 1: a “quick and dirty” analysis that summarizes the project’s sales revenues, expenses, interest, and profit; and

Stage 2: a multiperiod discounted cash flow (DCF) analysis that provides a detailed forecast of cash flows, equity and loan needs, profits, and internal rates of return (IRR). Where a two-stage model for land development analysis in used instead of a five-stage model for income property analysis (like the one below).

The figures used in the financial analysis model are taken from Veranda, a project developed in Lancaster, Pennsylvania, by Charter Homes.

In chapter 4 of the book, the focus is income property financial feasibility analysis. Here, evaluating financial feasibility for income property development involves a five-stage analysis, each more detailed than the previous one. These stages are:

Stage 1: Simple Capitalization;
Stage 2: Discounted Cash Flow Analysis;
Stage 3: Combined Analysis of the Development and Operating Periods;
Stage 4: Monthly Cash Flows during the Development Period; and
Stage 5: Discounted Cash Flow for Investors.

These stages are summarized in an attached Word file, which explains each stage in more details.

The last attached Excel spreadsheet is based on chapter 6, which focuses on industrial development. A feature box outlines a sample deal structure with a three-tier hurdle rate of return.

This business tool includes
4 Excel Spreadsheets, 1 word file

Adrienne Schmitz offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Applies best for educational purposes.

It is advised that individuals rely on their own financial assumptions and criteria for feasibility as background to any investment decision

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Real Estate Professional Developer's Excel Tool Kit

The user community and author are here to help. Go ahead!

  • Eugene lim
    Hi Eloquens Team,

    Hope all is well. Per the download instructions, it is stated that there are 4 excel files and 1 word document. However, upon downloading, the word document is missing. Are you able to help please?

    Best,
    Eugene
    1arrow_drop_uparrow_drop_downReply reply
    • Eloquens Team
      Hi Eugene,

      Thanks for your question - that we have passed on to Adrienne. She has just uploaded the attached word file to a new version of this tool.

      To access it, simply go to your library here: https://www.eloquens.com/account/products and then upgrade your tool to the latest version.

      Let us know if you have any other questions.

      Best regards,
      The Eloquens Team
      arrow_drop_uparrow_drop_downReply reply
      • Eugene lim
        Dear Eloquens team,

        Thank you very much for the prompt response and fast action. Very impressive!!

        Best wishes,
        Eugene
        arrow_drop_uparrow_drop_downReply reply
    • Loren C. Divers
      Hi, my computer crashed with loss of the Developer's Excel Tool Kit and am wondering you would be able to relate another copy for download, I'd appreciate it.
      With thanks in advance

      loren in Honolulu
      1arrow_drop_uparrow_drop_downReply reply
      • Eloquens Team
        Hi Loren,
        Your New Password to access your account has just been sent to your email, from which you will be able to access Eloquens again and download Adrienne's Developer's Excel Tool Kit from your "Library" Tab. Hope this helps!
        The Eloquens User Support Team
        arrow_drop_uparrow_drop_downReply reply
      please wait...