Wanting to create a sophisticated spreadsheet that enables a property valuation calculation on two basis, ten year cashflow using IRR's and NPV's and capitalisation approach.

We have a base model we are using which i will send to interested coders that we can use as a base and maybe simplify and make it more menu/step driven rather than a raw spreadsheet.

Instead of manually putting in entries, we have a series of questions and answers that can be a built into the spreadsheet, like:

1. where is the property located?

2. how many tenants are there?

3. name of tenant 1 - length of lease - annual rent review method 1,2,3,4 - lease start/end - anticipated time the tenancy will be vacant at expiry - amount to relet, leasing fees, etc.

4. what is the cost to purchase

5. what are the purchasing costs - stamp duty, dd costs, etc.

6. what are the finance costs

7. what is the gearing

8. what are the capex allowances

9. what are the outgoings for the property and escalations

10. a series of charts will need to be designed as part of this project.

So essentially the model we have works ok but needs perfecting, and we want to simplify it and have a rigid process of questions that need to be answered at the beginning that will build the spreadsheet once those questions are answered. This can be macro driven or any other form of interface that can be suggested.

This will be one of several spreadsheets we will be building, so the successful applicant will be part of a larger journey.

If you are interested in bidding, you can provide details of similiar work that has been undertaken including some samples. We will provide you with access to the raw spreadsheet attached once qualified.

Skills: Excel, Microsoft Access

See more: property valuation spreadsheet, property valuation project, excel property model, valuation excel, valuation model, valuation excel model, valuation capex excel, property valuation excel model, property valuation excel, property valuation model, works need excel, part time property, how excel works, excel spreadsheet rent, excel macro how to, end of year review, end of the year review, what is macro in excel, microsoft spreadsheets, microsoft macro, how to microsoft excel, finance in excel, finance excel, excel model, excel finance

Project ID: #4763285

29 freelancers are bidding on average $1875 for this job


I will recommend MS Access database instead of excel spreadsheet for this project. But if you want it in excel only, we are ready for this too. We are amongst top 1% global outsourcing providers. We have successfull More

$2500 AUD in 40 days
(238 Reviews)

Consider it done. Check your PM for my bid details.

$2105 AUD in 4 days
(89 Reviews)

I am interested in your project. Please see your inbox for more details.

$1500 AUD in 7 days
(31 Reviews)

Hi, I can build a simple application for you, where u can add/edit/delete such information and also have reports/graphs and other such features u mentioned in your post. Advantage of this is you and your employees c More

$2000 AUD in 6 days
(21 Reviews)

Hi, I am interested in the project. Let me know and we can discuss further.

$1500 AUD in 7 days
(65 Reviews)

Hello; I've just read your project a 5-star excel and vba coding (macro) expert here, I am highly interested in your project. I believe you wish to proceed with a top-rated and reliable partner here.. More

$1500 AUD in 7 days
(36 Reviews)

Hey, I am an expert in excel based financial models as you would see in my work history on freelancer website. Please review my private message on how best we could create a questionnaire based model. Thanks and Re More

$1944 AUD in 15 days
(49 Reviews)

Dear Sir/Madam. I'm happy to bid on your project. Please check PM for more information. Thanks - Priyal

$1500 AUD in 10 days
(44 Reviews)

Can provide you with a perfect solution.

$2577 AUD in 25 days
(5 Reviews)

I am a native English speaker with extensive experience developing custom Excel/VBA applications for individuals, businesses, and schools.

$1666 AUD in 30 days
(9 Reviews)

Experts here !

$1500 AUD in 10 days
(25 Reviews)

Why pick me? Outstanding feedback (without exception) on all projects to date. More than 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions. Past employers include both Pw More

$2500 AUD in 30 days
(9 Reviews)

Hello, excel wise is here. check p.m.

$1578 AUD in 3 days
(10 Reviews)

Hi... I would like to apply for the project.

$1666 AUD in 7 days
(9 Reviews)

Professional financial research analyst with capability to establish your desired financial model , please check inbox for details !

$1666 AUD in 10 days
(8 Reviews)

Hi seanb2! Experienced Excel user. I can do this job quickly! I'm ambitious, hardworking, punctual and really want to perform well. Please check PM and Portfolio to see my skills! :)

$1500 AUD in 7 days
(8 Reviews)

Hi. I am a professional appriser. I know the insights. Could you check your PM?

$2105 AUD in 30 days
(2 Reviews)

1. We have big experience in MS Access, Excel, Word, Visual Basic, VBA, Visual Basic.NET, C# , Crystal Reports and MS SQL 2. We have developed pure MS Access applications, applications that uses MS SQL as DataBase a More

$1500 AUD in 14 days
(1 Review)

Please read the private message.

$1666 AUD in 30 days
(1 Review)

Hi Sir, Please allow me to explain my proposal to you. Please check my PM for more details. Regards Varun

$2000 AUD in 15 days
(4 Reviews)