Spreadsheet Limitations |
ARGUS Developer Advantages |
|
Spreadsheets are prone to errors and time consuming. Up to 80% of the time spent in spreadsheets is “programming”
formulas and checking that the numbers are right. | ARGUS Developer was designed for
real estate pro formas and includes rent roll/tenancy schedule, unit sales and cost distribution capabilities. Our clients tell us they save 75% of the time it takes to do pro formas in spreadsheets. |
There is no standard spreadsheet format for pro formas. Comparing projects of different types and sizes is extremely difficult. |
ARGUS Developer presents projects in a consistent entry grid and cashflow format. Results are consistently calculated to allow proper benchmarking of results to compare projects. |
Spreadsheets are only 2 dimensional. Time must be represented in months across the spreadsheet in columns with Revenues and Costs listed in rows. If the construction duration of the project needs to be changed from 7 to 8 months every row must be redistributed.
| ARGUS Developer automatically prepares timed cash flows based on centrally controlled project timing. Changing the construction duration from 7 to 8 months takes seconds – costs are automatically redistributed in the cashflow. |
Multi-phase projects are not easy to handle. Multiple tabs in a workbook are added up on a “Project Summary” tab. These models are difficult to follow and prone to errors.
|
Our Timescale and Phasing allows for an unlimited number of phases that can be combined in any number of phase groupings. This allows for “highest and best use” analysis along with timed multi-year cash flows without the risk of spreadsheet errors. |
Debt and equity deal structuring is very difficult to model. Equity and loan draw schedules are often not possible without hours of modeling. Profit sharing is estimated as timed cash flows are too difficult to model. Complex deals result in partners arguing over whose model is “more right”
| ARGUS Developer has a very powerful Debt & Equity Module. Unlimited numbers of partners and loans with contribution and repayment priorities are quickly set up. Our NEW deal structuring component allows for waterfall profit distribution analysis with detailed cash flows per partner and loan. |