Käynnissä

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.

Taidot: kirjanpito, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: real estate development models, real estate development excel, real estate development worksheets, real estate excel model, commercial development excel models, real estate excel modeling, projects washington, development excel model, real estate model excel, excel real estate model, works need excel, we excel, commercial review, tab scope, send word, selecting business plan, review phase, reporting projects, phase review, model n, me excel, looking excel projects, layout business plan, make plan business, however big

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

Projektin tunnus: #436296

Myönnetty käyttäjälle:

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 2 päivässä
(1 arvostelu)
2.8

34 freelanceria on tarjonnut keskimäärin 599 $ tähän työhön

svet63

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

750 $ USD 30 päivässä
(74 arvostelua)
6.5
schandraram

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

750 $ USD 30 päivässä
(89 arvostelua)
6.5
agihcam

Please refer to PMB.

750 $ USD 20 päivässä
(40 arvostelua)
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 development.But, i will complete this project quickly & profe Lisää

650 $ USD 9 päivässä
(24 arvostelua)
4.8
vindhyavart

Please let me know more in details.

700 $ USD 7 päivässä
(1 arvostelu)
3.8
skujuira

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

750 $ USD 25 päivässä
(6 arvostelua)
3.7
nsurani

Lets start!

500 $ USD 15 päivässä
(6 arvostelua)
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 Lisää

500 $ USD 7 päivässä
(3 arvostelua)
3.4
tindz99

please have a look at pm for details

500 $ USD 7 päivässä
(4 arvostelua)
2.5
TMG

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

750 $ USD 10 päivässä
(1 arvostelu)
2.5
thakkarnimesh

Please check PM for more details

600 $ USD 20 päivässä
(2 arvostelua)
1.6
prakash144

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

500 $ USD 20 päivässä
(0 arvostelua)
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 15 päivässä
(0 arvostelua)
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 Lisää

650 $ USD 7 päivässä
(0 arvostelua)
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 Lisää

600 $ USD 15 päivässä
(0 arvostelua)
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 Lisää

450 $ USD 14 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 25 päivässä
(0 arvostelua)
0.0
chiksrahul

I can do it. check the PM

700 $ USD 15 päivässä
(0 arvostelua)
0.0