excel financial model

In Progress

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.

Skills: Accounting, Excel, Finance

See more: 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

Project ID: #5088486

Awarded to:

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 More

₹15000 INR in 3 days
(92 Reviews)
5.8

6 freelancers are bidding on average ₹9589 for this job

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 More

₹7368 INR in 3 days
(139 Reviews)
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 days
(13 Reviews)
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 days
(3 Reviews)
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 days
(1 Review)
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 More

₹5555 INR in 3 days
(0 Reviews)
0.0