What Every Corporate Model Should Include


How to Create a Corporate Model

There are multiple key components that must be included to effectively analyze the future of a corporation. The first important component to include is the Partner Summary along with the Partner Cashflows. The Partner Summary should contain the Promote Projections and Total Projections from the existing investments and funds. A Corporate Model should also include a Cashflows tab, which rolls up the entire income and expense activity of the Firm and its Investments.

A Budget tab is needed to clearly outline the expenses and fees incurred for each investment and funds. The Assumptions tab will outline the Investment and Fund economics, as well as house projection assumptions for future capital. Live Projections are a handy tool which allow Managers to easily change projections for deals already held by the Firm. Finally, the Totals tab will show the Sales and Net Cash Flows for the entire portfolio and give expected returns for the entire portfolio along with a similar tab for each investment.


INCOME:

Within the Income section of the Detailed Budget, one can see the various fees generated by each of the investments and Funds. Important fees include Asset Management Fees, Acquisition Fees, Property Management Fees, Construction Management Fees, and Disposition Fees. It is important to not only understand the amount of fee income generated by the Firm’s investments, but also the timing.

SALARIES:

Next, the Detailed Budget considers the salaries of each of the employees, along with bonuses. It is important to denote in the Corporate Model whether Bonuses are distributed on a Quarterly or Annual basis as this will ultimately affect the total budget and timing of payments. Additionally, this employee salary section can assist the Firm in understanding staffing requirements as the firm scales and additional investments are made.

EXPENSES:

Finally, Expenses must be considered to achieve the Total Budget. These items can be divided into Office, Travel, and General expenses. The Salaries and Expenses are then subtracted from Income items to reach Total Cashflows. The budget tab is among the most important in any corporate model, as it will allow the Firm to make decisions around selling assets and deploying capital. Fee income is critical in meeting the salary and expense requirements of running an Investment Firm, so managers must understand the implication of holding or selling assets as it relates to the underlying Firm.




Previous
Previous

Sources of Capital in Real Estate

Next
Next

Common Financial Modeling Mistakes Real Estate Developers Make