+ Reply to Thread
Results 1 to 2 of 2

Auto price increase and rent calculator

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2016
    Posts
    40

    Auto price increase and rent calculator

    Hi Gurus,

    I want to calculate the auto price increase calculator based on the initial price and the commencement date. Each year on April 1st the price increases by 2.5%. However, if the commencement date is prior April 1 2017, the rate remains the same as in column B, i.e. the first rent increase in April 1 2017 and each year after that.

    I also want to calculate the expected yearly rent based on two prices. For e.g. if the commencement date is 2018-07-01 then the total rent (from July 2018-March 2019 (old rate)) plus (From April 2019 - Dec 2019 (new rate)).
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Auto price increase and rent calculator

    If you could provide some manually calculated values for columns C:G then it may be easier for someone to compose formulas/code that will automatically yield those values.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate rent with 15% increase every 3 years
    By dilshandil in forum Excel General
    Replies: 3
    Last Post: 11-29-2020, 04:15 PM
  2. Translation price calculator in Excel for clients (Price per word)
    By hellofolks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2018, 05:58 AM
  3. Help on IF function to calculate rent increase
    By bubbles25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2018, 11:34 AM
  4. Help With Real Estate Price-Rent CSV Ratio Maps
    By gil_happy in forum Excel General
    Replies: 3
    Last Post: 03-05-2018, 04:38 PM
  5. formulas to calculate rent increase percentage
    By ahalter1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2014, 05:07 PM
  6. Rent vs Own Calculator
    By rpwaggy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2011, 04:54 PM
  7. how do I calculate rent over time with interest increase included
    By MarcApril in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-30-2006, 08:55 PM

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