+ Reply to Thread
Results 1 to 23 of 23

Calculate particular period rent with day vise escalation

  1. #1
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Question Calculate particular period rent with day vise escalation

    Hi all,


    I am new for this forum and i think this is the only place from where i get the resolution.

    I am looking for a rent calculator in which i map or input particular figures as in attached file and it will calculate the required period rent in column :B11.


    You all are great.. so please help me in this.

    Rent Master with escalation.xls
    Last edited by rahulbhanwar; 03-04-2012 at 02:02 PM. Reason: Attachment

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Hi Rahul,

    See the attachment and let me know if I understood you correctly, else please explain little on the spreadsheet itself and attach back.. Thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    First of all i thanks for the reply.


    Dilip i need a amount for a particular period that can be change like

    As in excel details if required period of rent is changed to 27 Jan 2011 to 5Th may 2011.

    I need a rent to be calculate as from 27 Jan 2011 to 3th March 2011 with previous rent (and with escalation if any) because increment date is 4th March. and from 4th March 2011 to 5th May 2011 with new escalation.

    I think you will clear by this.


    please help.

  4. #4
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Please help......

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Hi Rahul,

    I have revised the solution, please see attached. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Hi,

    Thanks Again...Calculation is still incorrect but you are very near to the solution. should pay as below but what if we change the escalation figure in B3 column also.Becoz escalation is the main thing here.

    For 3 Days 1st to 3rd march rent (@ previous rent) will be @200000=1644
    For 24 Days 4th to 27th march (escalation of 15% + previous) rent will be @230000=15123
    Total To Pay will be Rs.16767/-

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Ooppsss.. I interchanged the references.

    Now corrected the references and rent is coming to correct figure.. i.e. 16767.
    See attached file.

    B3 is currently 1, how you want it to get changed?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Correct i have already interchanged the same....

    regarding escalation, here i have given escalation after every 1 year what if i changed it to 5 or 3 or 4 any....
    in coulmn "B3".

  9. #9
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Ok . . I am travelling right now . . Willreply as soon as.I get on a system. Thanks.

    Regards,
    DILIPandey

    <click on below star if this helps>

  10. #10
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    i have to say thanks....will wait for your reply..

  11. #11
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Hi rahul,

    See the attached file and let me know if this is successful.
    If not, please provide 2-3 examples which I need to consider to incorporate the same. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Hi,

    Thanx for helping me...

    please find attached you may understand what i need.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Hi,

    Thanx for helping me...

    please find attached you may understand what i need.
    Attached Files Attached Files

  14. #14
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Hi rahul,

    Previous rent will be considered for the period 01 Mar to 03 Mar and increased (escalation) rent will apply from 4 mar onwards (including 4th).. basis the same logic, I have reformulated the sheet and attached the same for your review. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this help>
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Question Re: Calculate particular period rent with day vise escalation

    Hello Sir,

    Please find attached and check.

    I think i am unable to understand you what i need.

    I just need a master on which i mapped the required and it count rent to pay with all previous & new escalation (escalation date as per agreement commencement date vise) as per agreement start and end date.
    Attached Files Attached Files

  16. #16
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Waiting for reply sir...

  17. #17
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Calculate particular period rent with day vise escalation

    Hi Rahul,

    I am little confused here... would suggest you to post an sample file with multiple scenarios (like you have in Range A1: B13) to cover all possible loop holes and I will just develop a solution using which all the scenarios can be solved with a single solver logic. No description required.. just the Range A1:B13 only, if I will have any question, I'll ask. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  18. #18
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Thumbs up Re: Calculate particular period rent with day vise escalation

    Hi Dilip,

    As required please find attached file in different format and in now i required rent in monthly vise. I need it urgently so for the time being you please help me in this.

    I also required rent calculation in days vise as per my last attachment and you may consider this file examples in that.

    regards
    Rahul Bhanwar
    8800545959
    Attached Files Attached Files

  19. #19
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Hi


    please find attached days vise calculation requirement file with examples and check...but please first reply on my previous message attachment of Monthly calculation.

    Thanks
    Rahul Bhanwar
    8800545959
    Attached Files Attached Files

  20. #20
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Dilip sir have you got any solution????

  21. #21
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    it's seems there is no solution for my query. But I am very thankful to this forum & specially to Dilip ji for his helping hand.

  22. #22
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Thanx.............

  23. #23
    Registered User
    Join Date
    03-04-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Calculate particular period rent with day vise escalation

    Hello Sir,

    Have you got any resolution...please reply!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1