+ Reply to Thread
Results 1 to 2 of 2

Need formula for different rates of completion to be used to calculate rental revenues

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need formula for different rates of completion to be used to calculate rental revenues

    I am working on a financial model for a commercial real estate development. I have created the timeline and an assumption for when the first units will be available. What I need is formula for rate of completion, as in "fast, medium, slow" where fast would be something like 30 units in first month, 50 in second, 70 in third, up to 318 and slow would be more like 10 units first month, 15 in second, etc. Our average SF / unit is 980 and average rent is 1.55/SF so I need to use those figures and the rate of completion schedule to have a projected rental revenue figure for each month starting with the month the first unit is available.

    I hope that my question is somewhat clear. Thank you for any help

  2. #2
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: Need formula for different rates of completion to be used to calculate rental revenues

    Hello there
    It seems that you have 3 scenarios with approximate values per month to get you to 318. My suggestion is to create 3 scenarios in scenario manager, where you can plug in values and create a summary report.

    Without having the full picture, the formula to calculate your rental is :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The completed units is a reference to the cell that contains the value of completed units

    Regards
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.

+ 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. Replies: 0
    Last Post: 10-07-2013, 05:59 PM
  2. Calculate Rental Cost With Varying Rates Based On Rental Days
    By jmenh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2013, 03:17 PM
  3. [SOLVED] Need formula to calculate total of different rates depending on count
    By laura2114 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2012, 05:32 PM
  4. Replies: 1
    Last Post: 06-29-2006, 03:24 AM
  5. how do i calculate CAGR for a series of years of revenues?
    By NuttinButFun2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2005, 06:06 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