If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




how do I calculate rent over time with interest increase included
What is the Excel formula to calculate what my rent would be in future years
when a percentage rate increase is added each year ? 
Ads 
#2




how do I calculate rent over time with interest increase included
Hi,
Assuming that there will be a constant precent increase in rent every year, Future rent = Current rent * (1+percent increase/100)^(number of years later) (e.g.,) if the current rent is $1000, and there will a 5% increase every year, the rent three years later will be, 1000*(1+5/100)^3 SO, if the current rent is in A1, % increase is in B1, the number of years after this year is in C1, in D1 enter the formula, =A1*(1+B1/100)^C1 However, if you are calling the current year "Year 1" and you want to calculate the rent during "Year N", Rent during Nth year = Rent during 1st year *(1+percent increase/100)^(N1) Hope this helps, Regards, B. R. Ramachandran If the rent for the current year is in "MarcApril" wrote: > What is the Excel formula to calculate what my rent would be in future years > when a percentage rate increase is added each year ? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
calculate time periods  umbasr  Excel Worksheet Functions  1  February 21st 06 03:13 PM 
How do I calculate time durations over numerous dates  MBubier  Excel Worksheet Functions  4  November 30th 05 09:08 PM 
How do I write the formula to calculate someones time worked  deusy  Excel Worksheet Functions  3  November 16th 05 09:49 PM 
How do I set up a formula on a time sheet to calculate time in 1/.  gschmid  Excel Discussion (Misc queries)  2  January 18th 05 02:48 PM 
calculate negative or positve difference in time  kpmoore  Excel Discussion (Misc queries)  2  January 5th 05 02:35 AM 