This Project Feasibility Model is purpose-built to assist Quantity Surveyors, Architects, Developers, and Real Estate Practitioners analyze the profitability and feasibility of the Development or Project. The Model uses XNPV and XIRR, the date-sensitive equivalents of NPV and IRR.
The common mistake many make is relying on the measurement tool of Gross Profit without considering the TMV effect (Time Value of Money).
The Model is broken into three distinct types of development.
A) The development project that is built for selling
B) The development Project that retains all or a part of the development as rental stock. and
C) Quick compare multi-projects which only require a limited number of inputs, usually inflows/outflows on a month-end basis with no categorization.
When we perform the feasibility assessment on the (B) type with Retained rental stock, we provide a Commercial Type Valuation Calculator which makes use of an appropriate Cap rate that you choose, and the resultant Net Present Value at the fruition date is then brought into the XNPV and XIRR formulas.
The XNPV must naturally be a positive number or else the project will lose money, and the XNPV must achieve above the Hurdle Rate, the more times it beats the hurdle rate the better. It is also easy to guage how sensitive the project is simply by altering the dates of expected income, etc.
The Model is also easily expandable and you may also expand the multi-project quick compare model by as much as you like.
Similar Products
Other customers were also interested in...
Public-Private Partnership (PPP) Financial Model
Financial Model presenting development and operating scenarios of various projects under a Public-Pr... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
Project Management Financial Evaluation Model
Project Management - Financial Viability, Comparisons, and Evaluation using XNPV, XIRR as the date-s... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Advanced Financial Model with DCF & Valuation
General Overview Advanced Financial Model suitable for any type of business/industry and fully cu... Read more
Corporate Finance Toolkit – 24 Financial Mod...
They are essential models to increase your productivity, plan your future with budgeting and forecas... Read more
You must log in to submit a review.