Excel ADDING CPI AND RENT TO AN AMOUTN


Joined
Jun 16, 2018
Messages
1
Reaction score
0
I have an amount of 7300 and I have to add 10% GST to this amount then for years 2 and 3 I have to add 3.1% CPI. I know adding 10% to 7300 is 8030. Not sure if I should be also adding 10% and 3.1% to years 2 and 3 - or is this already included from year 1. I have no idea how to do this.
I think I should be multiply monthly rent by 12 to calculate yearly rent - but how do I add CPI of 3.1% also/
Any help would be appreciated


Year Monthly rent + GST Yearly rent + GST
1 7300+
2 (plus 3.1% CPI)
3 (plus 3.1% CPI)
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,510
This sounds more like a US tax query rather than an Excel query, I don't know anything about US taxes I'm afraid :(

Unless you're asking about what calculation you need? To multiply in Excel you use the * symbol
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top