Simple excel sheet for calculations -- 2
$10-30 USD
Plačilo ob prevzemu
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
-TI Budget
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
ID projekta: #21733476
Več o projektu
43 freelancerjev ponuja v povprečju za $21 na tem delu
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
Hello, I am an excel professional and I would be happy to assist you with your rent calculator sheet. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, B Več
Hi, It's done as per your formula which actually is averaging out for all 5 years i.e. duration of lease. Otherwise, this should look something like this. End figure need to be multiplied by the area(sqft) for the actu Več
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
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 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
Hi, I’m new freelancer here but I have personal around 10 years’ experience in data entry work & others service. I have a very good knowledge of MS Office Package, especially Excel, Word and Power Point. So, due to m Več
Hello, i made a table with your requirements. I can`t attach the screenshots in my bid, but you can see the screenshots showing how its designed and how it works (with examples, included the one in this project descrip Več
i there, Quality and time is my commitment. I’ve checked the project details and I can do this project perfectly. I have huge experience in working with these projects. If you need sample work just send me a message. W Več
Hi! I have analyzed your project details. I will complete your project on time with great accuracy.
I can do this for you in one day and as quickly as possible in one day. There will be quality work from me. You will see it by yourself after completion because i am expert in MS Office. Cheers
Hi, I can fix you up with an excel sheet that will fulfill your purpose. We create excel sheets like this at work all the time. Won't take long to do it. Thank you. Regards, Pasan.
Hii, i’m an enthusiastic & professional data entry specialist. I can collect & fill in the spreadsheet with data. I’m a web scrapping expert. I am basically into website scraping, email finding, product research, findi Več
Accurate and precise attention to detail Strong written and verbal communication skills Excellent time management skills; able to prioritize Skilled knowledge in generating process documentation Assists team member Več
