Hi
I have this table and I need to add 10% GST and CPI of 3.1%. I know adding 10% to rent of 7300 equals 8030.
Then I'm lost - do I need to add GST to year 2 & 3 or is this already included from year1. If need to add GST plus CPI how do I do this.
I think for yearly rent I multiply by 12 - then how do I add GST to this
Very new to excel so any help would be appreciated
Year Monthly rent +10% GST Yearly Rent +GST
<tbody>
</tbody>
I have this table and I need to add 10% GST and CPI of 3.1%. I know adding 10% to rent of 7300 equals 8030.
Then I'm lost - do I need to add GST to year 2 & 3 or is this already included from year1. If need to add GST plus CPI how do I do this.
I think for yearly rent I multiply by 12 - then how do I add GST to this
Very new to excel so any help would be appreciated
Year Monthly rent +10% GST Yearly Rent +GST
1 | 7300+ | |
2 (inc 3.1% CPI) | ||
3 (inc 3.1% CPI) |
<tbody>
</tbody>