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.
Dear Steve, Please check your PM for details. I look forward to hearing back from you for more details on this project. Regards, Bob
Bu iş için 34 freelancer ortalamada $599 teklif veriyor
Excel developer since 1997. Pls see PM. Regards, Svet.
Hello - Please see PMB for details of my bid. Thank you. Chandra Ram
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 [login to view URL], i will complete this project quickly & profe Daha Fazla
Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards
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 Daha Fazla
Hi, The project appear interesting. I look forward to working with you. Please see PMB for details. Thanks. TMG
We can do this. this is itek software solutions. We are doing this type of projects
Dear Sir. I am an experienced financial analyst with tons of Excell sheets developed. Pls have a look to PMB for the details.
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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.
I have experience so i can do it. give me one chance to fulfill your requirement. Thanks Amit Kumar Sharma, delhi(India)
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.