This spreadsheet supports the Accommodation Bond Liquidity Management Strategy that is designed to ensure compliance with statutory Prudential requirements.  In addition, it is designed to ensure that residents receive repayment of bond balance entitlements on a timely basis and within legislated timeframes.
 
The spreadsheet contains a detailed  instruction how to update and has the following structure that includes a template for Liquidity Management Strategy - LMS:
DataBase - This sheet populates other spreadsheets by formulas
Summary - Contains the summary of all spreadsheets on one page
Establish RAD - Establish RAD by assessing historical bond, local real estate and competitor pricing.  And Inflate value considering loss of retentions
Financial Model - Estimate impact of loss of retentions and Estimate benefit from additional cash received from HC RADs.
Financial Model Cash - Estimate the cash flow for the forecasting period.
Financial Model Bonds/RADS - Detailed list for:
Retention Income Tail from Current Bonds
Retention Income Tail from Forecast Bonds Received Jan-14 to Jun-14 ( if applicable)
RAD Agreement Forecast
Liquidity - Prepare LMS for forecasted facility position and Assess movement from previous position
LMS - Prepare LMS for forecasted facility position and Assess movement from previous position.