podplan
This user friendly Excel-based model has evolved over time to become one of the most effective tools available, combining depth and accuracy with ease of use.
Created by a team that have worked within the finance and development sections of affordable housing organisations for years, podplan has a unique benefit in being designed by users. Whether it be quickly appraising social rent, homebuy, rent to homebuy, intermediate rent, lease and sale tenures, creating more complex mixed use and phased business plans or creating board-friendly and flexible financial summaries, podplan can accommodate your needs with ease.
dynamic
Designed to cope with complex multi-tenure schemes including rent to homebuy, with customisable separate reports and indicators for each tenure and the scheme as a whole. Fully flexible and automated cashflows to produce the full range of financial indicators including NPV/IRR and all possible mortgage calculations. Clients agreed financial assumptions are fully protected whilst there is the ability to vary assumptions for individual schemes whilst providing details within the reports of any variations to original assumptions.
user-friendly
podplan has a single easy to navigate input sheet within a familiar Excel based platform making it straight-forward for project managers to input data and produce accurate feasibilities quickly. Provides warnings when certain unusual inputs are made such as units with sizes below the HQI minimum.
auditable
With internal audit and validation functions to catch any unusual or omitted inputs which may cause an incorrect calculation. The audit function also flags errors where formulae have been overwritten during any unprotected use.
transparent
With clear layouts and formats that enable users to understand how the data builds. No cells are hidden and users are able to see all calculations within the model.
multifunctional
Costs can be inputted once and spread across multi-tenure schemes without any need to consolidate. Contains options of January 1999 value calculations for target rents via Halifax or Nationwide indices to maximise target rents. Available Project Cost Controller bolt on to enable you to manage scheme budgets once the appraisal is fixed and the scheme is proceeding. podplan has a built in Affordability calculator to help ensure homebuy products are viable.
portable
With each model constructed in stand-alone Excel files, the model can be used away from the office and also provided to funders or partners in full working versions or PDF format.
adaptable
As an Excel spreadsheet, podplan can be adapted and tailored for your use or for highly unusual schemes.