FINANCES

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:

Cash Flow Projection

Property Build Out

Capital Cost Assumptions

Analysis

Additional SROI Analysis

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.​

4. Analysis

 

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: 

  • Sensitivity analysis

  • 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.

This toolkit is an initiative

of Raising the Roof.

  • LinkedIn - Black Circle
  • Facebook - Black Circle
  • Twitter - Black Circle
  • YouTube - Black Circle
  • Instagram - Black Circle

© 2019 Raising the Roof

Content by Jenny Lam, Claire Ronan. 

Design and Website by Yas Salame.