Em Andamento

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)

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.

Habilidades: Contabilidade, Excel, Finanças

Ver 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

Premiar a:

priyal1997

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 [url removed, login to view] Accounting and Finance (Spec Mais

₹15000 INR em 3 dias
(92 Avaliações)
5.8

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

javed1705

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)
6.5
samin59

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)
3.6
gitapodder1989

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)
3.3
sammir87

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)
0.4
rameshpuranik09

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)
0.0