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.
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 successfully finished over 430 projects in last 13 years.
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 can use same system at the same time.
See my few systems in your PMB
Hello; I've just read your project descriptions...as 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...
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 Regards,
Shikha
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 PwC (where I was for just under 6 years) and UBS AG, where I worked in highly analytical, Excel and VBA based roles. My PwC clients included a diverse range of FTSE 100 companies. I am a qualified actuary and I am familiar with IRRs/NPVs etc. So you can be certain I will deliver. I run my own Professional Excel & VBA based consultancy business, www.buyaspreadsheet.com. You can find further information about me on that website should you so wish. The website also includes a range of portfolio examples, demonstrating the quality of my work. Finally, please see my private message and feel free to view my Freelancer profile. Many thanks, Andrew.
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! :)