Last version published: 18/07/2018 10:44
Publication number: ELQ-88028-3
View all versions & Certificate
Real Estate Professional Developer's Excel Tool Kit
Financial analysis tools for educational purposes
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
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
- William Böll(last updated: 24/01/2019 14:17)
- Conor Farrell(last updated: 22/01/2019 04:52)
- Dwight White(last updated: 20/01/2019 21:53)
- Mihai Axinte(last updated: 19/01/2019 15:08)
- Laurence Bruchhausen(last updated: 15/01/2019 12:41)
- Valentine Sabulis(last updated: 15/01/2019 09:22)
- Nigel Chamunorwa(last updated: 13/01/2019 06:23)
- Noah Muhlstein(last updated: 31/12/2018 22:38)
- Jared Pretorius151(last updated: 25/12/2018 21:44)
- Woramon Panyarattana(last updated: 23/11/2018 08:10)
- 민성식(last updated: 05/11/2018 04:25)
- Abdul Ghafur BE, MCIOB, AClArb, CQS,610(last updated: 22/10/2018 08:56)
- naushad pm(last updated: 08/10/2018 16:22)
- aditya kothare(last updated: 26/09/2018 06:31)
- Raouf Jarmo(last updated: 11/09/2018 10:10)
- Robert Lee Phillips(last updated: 09/09/2018 17:17)
- Maria Vásquez Ossa(last updated: 22/08/2018 16:51)
- Mostafa Ramdan(last updated: 08/08/2018 12:36)
- Mike A., PMP, MBA(last updated: 03/08/2018 09:35)
- ERS LLC(last updated: 02/08/2018 16:53)
- Jose Angelito B. Alburo(last updated: 23/07/2018 07:47)
- James Ford(last updated: 23/07/2018 07:18)
- Akshat Marwah(last updated: 17/07/2018 20:18)
- Rane Pearson(last updated: 14/07/2018 06:46)
- Eugene lim(last updated: 06/07/2018 06:37)
- Tamer Mahfouz(last updated: 18/06/2018 19:55)
- Grace Bagambe(last updated: 12/06/2018 08:24)
- Islam Raslan(last updated: 08/06/2018 21:24)
- Ahmed Said Al Furqani(last updated: 04/06/2018 20:45)
- Obafemi Darabidan(last updated: 01/06/2018 05:19)
People using this tool also downloaded
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow11,607 remove_red_eye
Cash Flow Waterfall ModelA cash flow model for Real Estate based on a waterfall structurefinancecash flowreal estatewaterfallinvestordeveloper7,734 remove_red_eyefreeby Amit Tandon
Business Plan TemplateIndicative sample template to be filled up to define your objectives and determine how you'll achieve them.toolbusiness planmodelstartupguidepdffreedownload1,643 remove_red_eye
Digital Learning Business Case ToolTool to help you measure the impact of digital learning programmes.toolmodeldigital learningbusiness casemeasurequantify37 remove_red_eyefreeby Accenture
Real Estate Non Disclosure Agreement TemplateA ready-made template tailored to real estate that protects all parties involved in a real estate dealreal estatelegaldealnon disclosure agreementbuyerseller210 remove_red_eyefreeby Anita Grose
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise1,011 remove_red_eye$865.00by Alexander Jarvis
Break Even Analysis / Cost Volume Profit Analysis Excel ModelUse Coupon CHINESE_NEW_YEAR for 20% off until 17th of 2019 Break-even analysisfinancemodelcorporate financebreak evencost volume profitmanagement accountingcontribution margin533 remove_red_eye
Amazon's Corporate Excel ModelThis Excel model is an efficient tool for practicing A-Z modelling.analysisinvestmentfinancialmodelroicdatafinancial modelingamazona-z modellingvalue drivers113 remove_red_eye
Foot Forecast 2018 World Cup Prediction ToolFoot Forecast is a 100% free football prediction contest displayed in Microsoft Excel! Who said that Excel can't be fun?footmodelforecastpredictionexcelmodellingmicrosoft excelfootball736 remove_red_eyefreeby Finance 3.1
Start Up Car Park Excel Model and Valuation TemplateUse coupon CHINESE_NEW_YEAR for 20% off until 17th of Feb 2019 Car park business with 3 statements & investment metricsbusiness planmodelvaluationfinancial modelexcelexcel model3 statement modelfree cash flowcar park16 remove_red_eye
Discussion feed for Real Estate Professional Developer's Excel Tool Kit
The user community and author are here to help. Go ahead!
- 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?
- 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.
The Eloquens Team
- Dear Eloquens team,
Thank you very much for the prompt response and fast action. Very impressive!!
- 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 Honolulu1arrow_drop_uparrow_drop_downReply reply
- 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