Hello, I am trying to work out if it is possible to start with a base rent, a lease length in years, and an annual increase, and show with one formula the total rent paid over the period.
Say $20,000 rent, 3% increase and 5 years.
I had a look in another thread that was similar (I see I cannot link to it because I don't have enough posts) but saw instructions to start a new thread so here I am :-)
Thank you!
Are you really still using Excel 2003? Please update your profile if not.
There are several powerful new functions and features that may make short work of this.
Also please mock up a sample workbook with data and layout as you envision. It saves volunteers typing and guessing what you want. Instructions are in the 'gold' banner at the top of the page.
Thank you.
Dave
Thank you. I have (hopefully) uploaded an attachment
If I understand correctly this in cell D6and this in cell D7Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
@nickTokyo.... Try:
=FV(C6,C5,-(C3-C4))
where C6=3% (CPI), C5=10 (years), C3=50000 (rent) and C4=10000 (OPEX).
In the attached Excel file, I include a "proof of concept" in columns H:I.
The FV function works because the sum of your net income ("p" = 40,000) over "n" years has the form:
=p + p*(1+3%) + p*(1+3%)^2 + ... + p*(1+3%)^(n-1)
In reverse, that has the form of the FV of saving "p" each year at 3% interest.
Last edited by curiouscat408; 07-14-2022 at 11:25 PM. Reason: attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks