I need a simple excel sheet/macro created to calculate net effective rent.
How to calculate:
"For instance, if a tenant signed a 5 year lease for $20/sf per year, but received a $10/sf tenant improvement allowance and five months free rent, the effective rent would be $16.33/sf ($20 / 12 months = $1.67/month x 5 months free = $8.33 plus $10/sf tenant improvement allowance = $18.33/sf total cost to landlord. $18.33 / 5 year lease = $3.67 per year deduction from the face rate of $20/sf = $16.33/sf effective rent)."
Free rent would be applied to the amount of year 1 rent, not the average of all the years.
The factors would be:
-term of lease
-rent for each year (up to 10 years) but may be as little as 1 year
-Number of months of free rent
-Sqft of suite
Only apply if you fully understand! I will also instantly award project @ $10 to the first one to submit a working one if you want to do it that way
44 freelancere byder i gennemsnit $21 på dette job
Hello, I have done an excel sheet for calculations net effective rent according to your requirements. Let’s discuss if you’re interested. Best regards, Duong
Hi. I can do this accurately and immediately. If you like to hire me. Please let me know. Hi. I can do this accurately and immediately. If you like to hire me. Please let me know.
I am an investment banker with years of experience in preparing feasibility reports for different companies.I am also CFA and FRM qualified. Therefore, I can undertake your work aptly. For more details, contact me
I have read your project and I am expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks
Hello Sir/Mam, I have completely understood your requirement and have created a sample of the same. If you would like to see kindly inbox. Kind regards, Harsh
I have a completed version for review. It is formula-based, and I am willing to teach yoou how to modify it if needed. I will have 1 clarification question if selected.
Hi! I am a data Analyst from an important insurance company (MetLife), I had worked in special projects for collections, claims and customer service. Please reach me if you have any doubt. Regards!
I have skills in Excel. I have confidence to complete the assigned job well in time framed and with 100% accuracy. Thankyou and waiting for your reply.