Simple excel sheet for calculations -- 2

Cerrado Publicado hace 4 años Pagado a la entrega
Cerrado Pagado a la entrega

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

Contabilidad Excel Excel Macros Matemáticas

Nº del proyecto: #21733476

Sobre el proyecto

43 propuestas Proyecto remoto Activo hace 4 años

43 freelancers están ofertando un promedio de $21 por este trabajo

hdlan

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

$10 USD en 1 día
(60 comentarios)
6.5
razvancotofana

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 Más

$10 USD en 7 días
(19 comentarios)
6.1
zohaab85

Hi! I can definitely get it done. Regards.

$30 USD en 1 día
(13 comentarios)
5.4
subirbbiswas0

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 Más

$20 USD en 7 días
(6 comentarios)
5.3
Baderah

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

$10 USD en 1 día
(89 comentarios)
5.5
ljayasooriya83

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.

$10 USD en 7 días
(42 comentarios)
5.4
Galata16

------------------------------------------------- Hey, I'm interested in your project. Please send me a message so that we can discuss more. PS: I have skills in programming language R, Python, SPSS, Excel VBA ------- Más

$30 USD en 3 días
(21 comentarios)
4.4
hemsingh1

Accounting, Excel, Excel Macros, Mathematics skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss the project further. Más

$48 USD en 7 días
(16 comentarios)
4.2
umairali8062

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

$20 USD en 7 días
(10 comentarios)
3.4
Prompty

Hi, i can set the required formulas and give you to calculate the rent and other issues. Will do it in a day, once you award it. $10 not feasible, as i will be deducted 5$ by Freelancer. Further i loose on conversion Más

$20 USD en 1 día
(5 comentarios)
2.2
Rakibz2003

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 Más

$10 USD en 2 días
(1 comentario)
1.6
GermanLass

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 Más

$10 USD en 1 día
(2 comentarios)
0.8
fedrik08

Hi there, Expert here Sir i have read your project ants' match with my skills i can provide you quality work on time i can done in 2 hours Can you please come to the chat box so we can easily discuss bout project detai Más

$10 USD en 1 día
(0 comentarios)
0.0
Naveedmudassar

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 Más

$20 USD en 7 días
(0 comentarios)
0.0
abdullahasif864

Hi! I have analyzed your project details. I will complete your project on time with great accuracy.

$10 USD en 1 día
(0 comentarios)
0.0
Ahtishamzia

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

$15 USD en 1 día
(0 comentarios)
0.0
pasancent

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.

$15 USD en 1 día
(0 comentarios)
0.0
sujeetkt07

I am work very fast

$20 USD en 1 día
(0 comentarios)
0.0
Mkhanna547

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 Más

$20 USD en 7 días
(0 comentarios)
0.0
harshitaneja786

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 Más

$25 USD en 5 días
(0 comentarios)
0.0