The Reside Financial Model is a tool created to assist interested communities and agencies to manage the financial components of their Reside program. Download the file by clicking here or on the Excel file icon.
Find below a description of the 5 tabs:
1. Cash Flow Projection
The first section of the Reside Financial Model Tool is 'Cash Flow Projection.' As its name implies, this worksheet lays out a projected estimate of the project's cash flow, including all sources of expenses and revenues.
How to use this worksheet: insert the appropriate expenses and revenues into the correct section. The total will be automatically calculated for you.
2. Property Build Out
The second section of the Reside Financial Model is 'Property Build Out.' This section determines the total cost of renovating various types of properties.
The 6 types are:
Donated finished home
Donated unfinished home
Unkept heritage home
Well kept heritage home
Given assumptions ('other')
How to use this worksheet: insert the appropriate values into the correct section. The total cost of renovating the specified type of property will be automatically calculated for you. Lease Revenue and Vacancy Expenses will also be calculated automatically. Lease Revenue refers specifically to the revenue generated from the property's lease. Vacancy expense, on the other hand, refers to the cost of leaving the property vacant.
Note: when entering in in-kind materials donations (i.e. a credit value of the donated materials) be sure to add a negative sign ('-') before the value. This ensures that the total cost is reduced, rather than increased.
3. Capital Cost Assumptions
The third section of this tool is 'Capital Cost Assumptions.' Similar to the 'Property Build Out' section, this section offers a comprehensive list of all expenses that are likely incurred while renovating any of the 6 property types.
How to use this worksheet: insert the appropriate values into the correct section. The total cost of renovating the specified type of property will be automatically calculated for you.
Note: this worksheet can also be used as the program budget.
The purpose of the 'Analysis' section is to help the users determine whether or not a property should be purchased, based on the property's cost-effectiveness.
There are various analyses used to assess its cost-effectiveness:
Social return on investment
How to use this worksheet: insert the appropriate values into the correct section. Analyses are automatically generated to assess whether the property should be purchased.
5. Additional SROI Analysis
Similar to the 'Analysis' section, the 'Additional SROI Analysis' section helps users to determine whether the property should be purchased, specifically based on the social impacts generated by the property. These social impacts are noted under the 'outcome heading' and are for the following 4 key stakeholders: tenant, government, environment, and other agencies.
How to use this worksheet: insert the appropriate values into the correct sections (e.g. 'Number of Instances' and 'Period of Value.' Analyses are automatically generated to assess whether the total social benefits outweigh the costs.