Simple excel sheet for calculations -- 2

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

Evner: Regnskab, Excel, Excel Macros, Matematik

Se mere: simple data sheet company excel, cost accounting excel sheet, excel sheet calculations hotels, excel sheet calculations hotels reservations, daily inventory cost calculation excel sheet, name address phone number excel sheet, auto generate numbers excel number generated excel sheet, number results google search keyword search excel sheet, simple excel sheet program, simple betting excel sheet, simple payroll excel sheet, enter phone number excel sheet, phone number excel sheet, excel sheet shipping cost calculator, cost estimate excel sheet, simple excel sheet, simple excel sheet android, copy names from plotted map points to their correct excel sheet category.--2

Om arbejdsgiveren:
( 9 bedømmelser ) Dallas, United States

Projekt ID: #21733476

44 freelancere byder i gennemsnit $21 på dette job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (g Flere

$50 USD på 1 dag
(717 bedømmelser)

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 på 1 dag
(37 bedømmelser)

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 Flere

$10 USD in 7 dage
(16 bedømmelser)

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 in 7 dage
(30 bedømmelser)

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 Flere

$20 USD in 7 dage
(3 bedømmelser)

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 på 1 dag
(82 bedømmelser)

Hi! I can definitely get it done. Regards.

$30 USD på 1 dag
(6 bedømmelser)

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. Flere

$48 USD in 7 dage
(10 bedømmelser)

------------------------------------------------- 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 ------- Flere

$30 USD in 3 dage
(8 bedømmelser)

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 in 7 dage
(6 bedømmelser)

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 Flere

$20 USD på 1 dag
(2 bedømmelser)

When I was working with the banks, my day-to-day job responsibilities involve actively developing tactical solutions to solve users’ problems, and constantly enhancing them. I am very confident to delivering your solut Flere

$30 USD på 1 dag
(0 bedømmelser)

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

$25 USD på 1 dag
(0 bedømmelser)

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.

$25 USD in 2 dage
(0 bedømmelser)

I am flexiable data entry clerk with good skills. I am done work according to give your as the direction I am done your work as your supervision. I am done work 100% accurecy with fully details, no errors, and takes gr Flere

$20 USD in 5 dage
(0 bedømmelser)
$20 USD på 1 dag
(0 bedømmelser)

I work on Excel files and Macros regularly. You have described the requirement very well. I can do it.

$15 USD in 4 dage
(0 bedømmelser)

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!

$29 USD in 2 dage
(0 bedømmelser)

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.

$27 USD in 5 dage
(0 bedømmelser)

This can be done with color coding of input/output/data entry cells and correct formulas in a full day for 30 USD. If possible within the time and budget we can think of providing UI forms also to key in the inputs, in Flere

$30 USD på 1 dag
(0 bedømmelser)