PC Review


Reply
Thread Tools Rate Thread

Average Rent PSF Formula?

 
 
GJ
Guest
Posts: n/a
 
      18th Jun 2008
Hi - I have an excel spreadsheet for an office building that I need to
calculate the average rent per square foot. In the spreadsheet I have 5
columns: 1 - Leased area (sf), 2 - term of the lease (mo), 3 - rental rate
for yr 1 ($), 4 - annual increase (%), and 5 - the months of free rent. I
need the formula to take this information and spit out the average rent per
square foot. Thanks for the help!

Here is what it looks like in excel:

Leased SF Term Rent Yr 1 Annual Increase Mo. Free Rent Avg. Rent
PSF
2,755 65 $20 3% 5
???



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What kind of formula would I use for an annual amount for rent? maria Microsoft Excel Worksheet Functions 6 12th Mar 2009 12:10 AM
Average rent per square foot formula GJ Microsoft Excel Misc 1 18th Jun 2008 03:45 PM
formula to calculate total rent charges =?Utf-8?B?TmFybmltYXI=?= Microsoft Excel Misc 4 9th Jul 2007 08:26 PM
weighted average rent with growth prussom@yahoo.com Microsoft Excel Worksheet Functions 1 16th Jun 2007 02:37 AM
I Need a Formula for setting up what to charge for equipment rent. =?Utf-8?B?Y2hpcHBpYW4=?= Microsoft Excel Misc 2 12th Oct 2004 11:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:23 AM.