excel financial model

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)


Occupancy rate during rental period

appreciation rate (YoY)

Selling price


Area in sqm

Rental rate/sqm

Rental ratio (to property owner and to the fund)


Area in sqm

purchase price

Appreciation rate (YoY)

Selling price


pls see the attached file named 'RE fund expenses'

Balance sheet assumptions can be assumed appropriately.

Habilidades: Contabilidade, Excel, Finanças

Veja mais: financial model excel, total finance, the free lancers, skills required for accounting, rental on line, ratio in accounting, owners equity in accounting, free model, free lancers for development, free lancers c#, free accounting in excel, construction accounting, buying and selling on line, biz buy sell, best buy model number, balance sheet in accounting, accounting for free, accounting for construction , cf finance, buying and selling business, buy sell on line, accounting finance required, real estate financial, financial Model, finance task

Acerca do Empregador:
( 1 comentário ) muscat, Oman

ID do Projeto: #5088486

Concedido a:


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 (Spec Mais

₹15000 INR em 3 dias
(92 Comentários)

6 freelancers estão ofertando em média ₹9589 para esse trabalho


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 h Mais

₹7368 INR in 3 dias
(139 Comentários)

Experienced and accomplished finance expert excelling in MS Excel at your service. Please contact for quality and result oriented services. Regards

₹6500 INR in 3 dias
(13 Comentários)

i have gone through your project. I am expert both in excel and finance. Please check reviews of my past works before awarding the project.

₹12000 INR in 3 dias
(3 Comentários)

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

₹11111 INR in 3 dias
(1 Comentário)

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 Mais

₹5555 INR in 3 dias
(0 Comentários)