# Looking for tutoring help with calculating cpi and gst

Status
Not open for further replies.

#### robynl

##### New Member
Hi
Need tutoring or tips to help me calculate increasing an amount by 3.1% CPI and 10% GST over 3 years.
For the first year I have a starting amount of rent at 7300 which is required to be increased by 10% GST. I have calculated this to be 8030 - 7300*(1+0.10). No CPI is included in this first year.

For the second years rent using this amount of 8030 I need to add CPI of 3.1%. My thinking is 8030*(1+0.031) which equals 8278.93. Since GST was included in the amount of 8030 already I don't think I need to add GST for this year??

For the third year I have calculated the 8278.93 plus 3.1% - 8278.93* (1+0.031) =8535.58. Not sure if I need to add 10% GST to this amount.

Also need to calculate yearly rent total plus 10% GST - I have calculated that I should be multiplying monthly totals by 12. But I'm not sure how to multiply by 12 and then add the 10% GST.
Anyone that can give tips or tutoring - not looking for the answer as this is an assignment. I have been researching for ages but still stuck

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

#### Fluff

##### MrExcel MVP, Moderator
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Status
Not open for further replies.

Replies
4
Views
321
Replies
8
Views
433
Replies
5
Views
63
Replies
0
Views
34
Replies
13
Views
98

1,109,395
Messages
5,528,487
Members
409,820
Latest member
gabrielrms

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...