Hi
I have a monthly figure for rent of $7,300 + GST and I have to calculate the monthly and yearly rent increase of 3.1% CPI for years 1 and 2. To me it doesnt make sense as I have no base amount to compare to the $7,300.
Thanks
Hi
I have a monthly figure for rent of $7,300 + GST and I have to calculate the monthly and yearly rent increase of 3.1% CPI for years 1 and 2. To me it doesnt make sense as I have no base amount to compare to the $7,300.
Thanks
Robyn
As I see it $7,300/month is the base amount (=100% at the point of starting).
CPI nomally means Comsumer Price Inflation at it's published monthly by governmental statistics organisations e.g. ONS in UK, Bureau of Labour Statistics (?) in USA. It's normally applied on an anniversary, say 12 months from now 9and based on the CPI figure calculated by them at that time).
Looks like instead you're predicting (or at least applying) a rate of 3.1% and want to apply it to the monthly rent for future years. if so...
After 12 months at $7,300, the formula for the following 12 months would simply be:
=7300*103.1%
(i.e. $7526.30/month)
CPI is normally compounded so the 12 months after that would be:
=7526.30*103.1%
(=$7,759.62 month).
John