I need a real estate fund financial model in MS excel to be developed.
I am looking for free lancers who have good experience and knowledge about best financial modelling practices with accounting skills to complete this task.
The model would be for 5 years.
It needs to have the projected IS,BS,CF statements with assumptions populated in a separate sheet.
The fund would have 3 business lines namely; (each of the biz lines below requires inputs for 3 properties / biz line)
DEVELOPMENT - involves construction of properties which would be rented after construction and subsequently sold at a later point of time.
RELEASING - involves agreeing with other property owners to rent their buildings on their behalf and receive a margin on the rents received.
BUY & SELL - involves buying of ready properties , holding it for price appreciation and selling it at a later point of time.
The fund would operate in 3 locations with the 3 stated biz lines in each location. Therefore total number of property inputs required would be (3 locations*3 biz lines*3 properties per biz line = 27 properties in total)
Assumptions required for each of the biz lines are as follows;
Fund size - equity 10M , debt 80M at fund level. (the fund would be allocated 30M to each location)
DEVELOPMENT ( to be modeled on % completion methodology)
Area in sqm
Hard costs / sqm
Soft costs / sqm
construction period (1 to 2 yrs max)
Rent/sqm
Occupancy rate during rental period
appreciation rate (YoY)
Selling price
RELEASING
Area in sqm
Rental rate/sqm
Rental ratio (to property owner and to the fund)
BUY & SELL
Area in sqm
purchase price
Appreciation rate (YoY)
Selling price
EXPENSES
pls see the attached file named 'RE fund expenses'
Balance sheet assumptions can be assumed appropriately.
Dear Sir/Madam
I can help you on this and can develop a PERFECT Model for you
I have all the requirements for this project
01) String Financial Background - Chartered Accountant and [login to view URL] Accounting and Finance (Special) degree with a first class honors
02) String excel modeling skills
03) I have developed various such kind of financial models
Please refer bellow link to see my reliability and ratings..
https://www.freelancer.com/u/priyal1997.html
If you are comfortable, will discuss the project
I assure you that, I will do my best to go beyond your expectations...
I look forward to hearing from you
Best regards
Priyal
I am an ACCA , APA and Mcom finance
You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern...
I am fully competent in doing said assignment
i have more than 8 years of working experience
hire me at fordable cost with best results, readily available for said task........
regards
javed
Hi,
I am an Indian Chartered Accountant (equivalent to US CPA).
I can prepare financial model for your real estate business in excel.
Regards,
Samir Ajmerwala
I have long years of experience in banking/venture capital industry. I have prepared many project reports based on multiple business models. I am well versed in excel, modelling and researching on businesses. I assure quality work.