Cohousing-L Mailing List: Re: Reserve studies

[Mac Thomson (mac]

I've put together a reserves spreadsheet on Excel that I think works  
pretty well for us.  I'd be happy to send anyone a copy that would  
like one.  Just send me a private email requesting it.

Cheers,
Mac

--
Mac Thomson

Heartwood Cohousing
Southwest Colorado
http://www.heartwoodcohousing.com


"When love and skill work together, expect a masterpiece."
    - John Ruskin
**********************************************************



On Aug 20, 2007, at 4:16 AM, cohousing-l-request [at] cohousing.org wrote:

> Date: Sun, 19 Aug 2007 13:28:32 -0400
> From: "Zeke Holland" <zholland [at] blazenetme.net>
> Subject: [C-L]_ Reserve studies
> To: <cohousing-l [at] cohousing.org>
> Message-ID: <021e01c7e286$62617e40$6501a8c0@73n8801>
> Content-Type: text/plain;       charset="iso-8859-1"
>
> At Two Echo Cohousing we have capital reserves for the common  
> house, roads,
> our engineered septic system and other equipment.  We have a  
> spreadsheet
> that factors in inflation rates, interest rates, tax rates and the  
> expected
> life of various component items.  That worked fine initially, when
> everything was new and starting from zero.  But as items get  
> replaced and
> have different start-years, etc, I find that our spreadsheets are not
> general enough.  And I don't trust my own ability to enhance them  
> correctly
> without a model to follow.  I'm wondering if any other communities  
> have
> spreadsheets for reserve accounts that work well, and if you would be
> willing to share a sample (I don't care about the actual values, of  
> course,
> just the structure/formulas)...?  You can contact me directly at
> zholland [at] blazenetme.net, and any input is appreciated.
> Thanks,
> --Zeke Holland (Treasurer, Two Echo Cohousing, Brunswick, ME)