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, skills required accounting, rental line, ratio accounting, owners equity accounting, free lancers development, free accounting excel, construction accounting, buying selling line, biz buy sell, best buy model number, balance sheet accounting, accounting construction, cf finance, buying selling business, accounting finance required, real estate financial, financial model, finance task, finance excel, excel model, excel finance, excel accounting, equity fund

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 B.Sc 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