In Progress

Real-estate Development Excel Model

Enhance an existing Excel model to make it easier to complete a financial analysis quickly on real-estate development projects. The projects are mixed use developments, primarily those with two uses – commercial space and apartments which may later be sold as condos.

The new model should be setup so that one assumption page should be able to populate the rest of the model. However, there are a tremendous number of variables. There is a much more detailed model that is the next step that I can provide to the winning bidder after we reach agreement on proceeding. This next step model will help explain what we need to plan for. With good work on this first phase there could be an ongoing business for the winning bidder to update the models as new and different opportunities require new parameters to be added.

The current model is 5 worksheets within 1 workbook. Max length of any worksheet is 120 lines long and a couple dozen columns wide. Therefore it is not currently a very big model. I will send the Excel sheet to a limited number of candidates who appear to be qualified. The new model will have a lot more worksheets.

To be selected you must send me a sample of models you have worked on in the past. The more similar to this project the better. Experience in real-estate modeling is a plus. If it makes sense to proceed I will send to you the model in Excel to allow you to better refine your bid.

Scope if selected -

1. Document the scope of work - Review the current Excel model in detail and determine all the relationships/formulas. Ask me questions about anything you don’t understand. Document the scope based on your review of the Excel model. I am looking for the selected contractor to provide ways to best organize and manage the project. I estimate this review and explanation of how the business works and the features needed in the new model will take about 10 hours. This will be a Word document with your understanding of the model and assumptions. This is a key element to the project. If not completed well we will not proceed to actually building the model with you.

2. The next step will be to define the general layout of the new Excel model and review. No time estimate. You will need to determine. I will not necessarily be selecting on lowest price so explain how you will do this.

3. Build the model.

a. Break the model into a lot of worksheets within a workbook so that each tab only contains a specific topic.

b. Include a lot of checks in the model as well to make sure no math errors.

c. New model should have a reporting tool to allow easy printing of selected pages. An easy way to hide printing certain info, etc. We can discuss and define the scope during step 1.

d. Be easy to understand so that I can have my admin work on it. Therefore documented instructions will need to be provided.

4. Test with a new set of assumptions on a project that I am working on right now.

We need this project completed quickly so please let us know your availability and how much time can be quickly dedicated to complete this.

Skills: Accounting, Data Processing, Excel, Visual Basic

See more: real estate development model excel, excel real estate development model, real estate development excel model, real estate development financial model, real estate development worksheet excel, real estate development models, real estate development excel, real estate development worksheets, real estate excel model, commercial development excel models, commercial real estate development excel model, excel models commercial real estate development, modeling mixed use real estate developments, real estate development cash flow worksheet, real estate excel modeling, projects washington, accounting tax preparation monthly excel, development excel model, real estate model excel, mixed use development excel sheet, excel real estate model, real estate development excel sheet, real estate development excel models, works need excel, we excel

About the Employer:
( 1 review ) Redwood City, United States

Project ID: #436296

Awarded to:

mbaanalyst

Dear Steve, Please check your PM for details. I look forward to hearing back from you for more details on this project. Regards, Bob

$250 USD in 2 days
(1 Review)
2.8

34 freelancers are bidding on average $599 for this job

svet63

Excel developer since 1997. Pls see PM. Regards, Svet.

$750 USD in 30 days
(74 Reviews)
6.5
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$750 USD in 30 days
(89 Reviews)
6.5
agihcam

Please refer to PMB.

$750 USD in 20 days
(40 Reviews)
5.2
nmppatel

I am an IT professional with 10 yrs experince. I have excellent experiece with VBA ( Ms-Excel, Ms-Access, Ms-Word). I do not have experince with Real-estate [url removed, login to view], i will complete this project quickly & profe More

$650 USD in 9 days
(24 Reviews)
4.8
vindhyavart

Please let me know more in details.

$700 USD in 7 days
(1 Review)
3.8
skujuira

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

$750 USD in 25 days
(6 Reviews)
3.7
nsurani

Lets start!

$500 USD in 15 days
(6 Reviews)
3.4
seraphimarts

Award-winning CPA, accounting professor, and attorney-at-law, delivering quality results in a paperless office environment. I have been working with Excel since version 1.0 and am experienced in model development. Ple More

$500 USD in 7 days
(3 Reviews)
3.4
tindz99

please have a look at pm for details

$500 USD in 7 days
(4 Reviews)
2.5
TMG

Hi, The project appear interesting. I look forward to working with you. Please see PMB for details. Thanks. TMG

$750 USD in 10 days
(1 Review)
2.5
thakkarnimesh

Please check PM for more details

$600 USD in 20 days
(2 Reviews)
1.6
prakash144

We can do this. this is itek software solutions. We are doing this type of projects

$500 USD in 20 days
(0 Reviews)
0.0
marius321

Dear Sir. I am an experienced financial analyst with tons of Excell sheets developed. Pls have a look to PMB for the details.

$450 USD in 15 days
(0 Reviews)
2.9
Alpgilas

I have been in accounting for 25 years and projects similiar to your come to my desk all the time. I can modify your Excel spreadsheet or if you prefer I can build a special Access database. Your description suggests y More

$650 USD in 7 days
(0 Reviews)
0.0
neolanzer

I've been an Excel Expert for 10 Years. I've also worked for a Real Estate Development Company that develops Retirement Villages for which I've made Excel worksheets for Development Cost, Sales and Cash Flow Projectio More

$600 USD in 15 days
(0 Reviews)
0.0
darwinrebhu

well i am a builder and running my company i think i can do this as i am doing similar kind of work in my ongoing projects. details are as follows a)budget of the project b)sheets which will monitor the ongoing pro More

$450 USD in 14 days
(0 Reviews)
0.0
Wahabbds

Dear Sir / Madam, Have a nice day. I’m a ‘COMPUTER TEACHER’ of Government High School. So I can do the job Smoothly. I promise, I’ll delivery the work with quality and honestly. – Best Regards.

$340 USD in 7 days
(0 Reviews)
0.0
Amit20sept

I have experience so i can do it. give me one chance to fulfill your requirement. Thanks Amit Kumar Sharma, delhi(India)

$650 USD in 7 days
(0 Reviews)
0.0
ManiksSoftware

We possess extensive experience of developing numerous high-end websites and are highly organized and adept at meeting tight deadlines that are so common in this industry. Please see PMB for more details.

$650 USD in 25 days
(0 Reviews)
0.0
chiksrahul

I can do it. check the PM

$700 USD in 15 days
(0 Reviews)
0.0