adding consumer price index and gst to an amount

[robynl]

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
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]7300+[/TD]
[TD]


[/TD]
[/TR]
[TR]
[TD]2 (inc 3.1% CPI)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 (inc 3.1% CPI)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

I suspect that those items would be dictated by your rental agreement. Have you read over your rental agreement and what it stipulates.

 

[robynl]

I suspect that those items would be dictated by your rental agreement. Have you read over your rental agreement and what it stipulates.

This is an assignment I need to do just need some guidance

 

[robynl]

This is an assignment just need some guidance

 

[alansidman]

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).


We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.


If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.