Amethyst
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
- Joined
- Dec 21, 2008
- Messages
- 12,709
Yes, it's yet another humble appeal for help from me, the Excel newbie/weenie :
I am trying to project investment property expenses over time, using the ratio of yearly expenses to the property's original cost. Example: The property was bought in 2003 for $157,000.00. In 2003, the expenses (not including depreciation) totaled $9668, or about 6% of the purchase price.
Excel tells me that the slope of the expense trend line from 2003-2009 is
y=.002x + .062
How can I use this equation to project yearly expense ratio through 2014? (I found a SLOPE function that doesn't seem to apply).
(NOTE: If somebody knows a better/smarter way to project future expenses, please feel free to share!!)
Thank you,
Amethyst
I am trying to project investment property expenses over time, using the ratio of yearly expenses to the property's original cost. Example: The property was bought in 2003 for $157,000.00. In 2003, the expenses (not including depreciation) totaled $9668, or about 6% of the purchase price.
Excel tells me that the slope of the expense trend line from 2003-2009 is
y=.002x + .062
How can I use this equation to project yearly expense ratio through 2014? (I found a SLOPE function that doesn't seem to apply).
(NOTE: If somebody knows a better/smarter way to project future expenses, please feel free to share!!)
Thank you,
Amethyst