Post Image

Income-PIE for income-producing properties:

Income-PIE is an easy-to-use, comprehensive real estate analysis software program that addresses the unique requirements of income producing property such as apartments, office and retail buildings and even hotels.

It is excellent for the development analysis of mixed-used projects that consist of a combination of "for-rent" and "for-sale" retail, office and residential units.

Income-PIE generates accurate and detailed projections of cash flow, loan flow, profit & loss, balance sheet, and budget analysis projections for single and mixed-use development projects. The forecasts are based on fundamental input variables, and may reflect projects in the initial planning stages or already underway.

Three separate input modules are provided for different classes or types of property. These modules permit the flexibility to easily and quickly describe the unique lease assumptions for apartment style vs. office/retail/industrial style leases for income property along with inputting assumptions for "for-sale" type units, i.e., office and/or residential condos.

Using the Apartment input modules, in addition to the standard development and construction expenses, you can describe up to 9 different apartment types, i. e., studio, one-bedroom, etc. as well as parking income. You can also describe up to 16 user-defined on-going operating expenses.

The Office/Retail/Industrial tenant input model provides both a "Global lease-up" (quick and dirty) as well as a detailed lease-by-lease input mechanism. These approaches allow you to do a quick, albeit accurate, lease-up of available tenant space to perform an easy feasibility analysis as well as a much more detailed approach to describe the unique leases of separate tenants.

The Unit Sales module allows you to describe both the actual development and construction phase expenses but also the revenue derived from the sales of these units rather than the rental income.

These three input modules can be used in various combinations to describe all units or sources of income in a mixed-use development. In this manner, you could easily and accurately describe a project that might have office and/or retail for rent units on one or several floors with "for-sale" units on other floors.

 

Analyze all types of projects – new construction or existing
  • Apartments
  • UStorage facilities
  • Office
  • Retail
  • Hotels
  • Home building / land developments – simple

 

Encompasses various stages of a project
  • Acquisition
  • Land development
  • Vertical construction
  • Lease-up of units
  • Holding or operational period

 

Cash Flow Forecast Projection
  • Monthly, quarterly, annually, user-defined
  • Displays rental income, development and operating expenses
  • Automatic expense disbursement scheduling

 

Loan Flow Forecast
  • Various construction and permanent loans to automatically fund :
  •         • land acquisition
            • development expenses
            • miscellaneous items
  • Loan funding based upon % of Costs, % of Sales and user input
  • Ultimate flexibility regarding:
  •         • Fixed or variable interest rates
            • Interest reserve
            • Fees
            • Multiple payment scenarios

 

Equity Participation
  • Wholly owned or Joint Venture
  • Equity funding automatically calculated or manually input
  • Preferred returns on outstanding equity
  • Profit distributions with waterfalls
  • Multiple developer/investors participation

 

Consolidation of unlimited number of projects
  • Displays period by period cash flow forecast, loan flows, P & L report and Balance Sheet

 

Why use Income-PIE instead of a spreadsheet?

CASH FLOW FORECAST — The Cash Flow Forecast displays the results of a detailed process by which all cost and income items are spread across the months (or quarters or years) of the project.

Income-PIE's Cash Flow Forecast clearly displays the project cash flows for sales revenue and all cost categories. The net cash flow before financing is then displayed and becomes the basis for the pre-financing discounted cash flow analysis consisting of net present value and internal rate of return.

LOAN FLOW FORECAST — Income-PIE performs detailed analyses for any combination of a construction loan for the acquisition of the land and development for the completion of the vertical units. Up to two permanent loans can be placed on the property. Equity financing can be automatically computed to cover the net funding requirements. You may activate any or all of the loan categories as appropriate for the project. The amount of each loan may be determined as an input loan amount, as a percentage of costs assigned to the loan or as a percent of sales. Each loan is subject to a separate loan fee percentage and interest rate. The interest rate may be a stated rate or may fluctuate as a stated number of points over a prediction for the prime rate. Interest reserve amounts may be stated for each loan. The interest reserve will be withheld from drawable funds and will be used to cover interest costs until the reserve is depleted.

Loan draws are made in accordance with the forecast of drawable cash flows assigned to the loan. It is an easy matter to override the loan draw amount or to provide a positive or negative increment to add to the calculated loan draw for any period.

Income-PIE performs detailed analyses for any combination of a construction loan for the acquisition of the land and development for the completion of the vertical units. Up to two permanent loans can be placed on the property. Equity financing can be automatically computed to cover the net funding requirements. You may activate any or all of the loan categories as appropriate for the project. The amount of each loan may be determined as an input loan amount, as a percentage of costs assigned to the loan or as a percent of sales. Each loan is subject to a separate loan fee percentage and interest rate. The interest rate may be a stated rate or may fluctuate as a stated number of points over a prediction for the prime rate. Interest reserve amounts may be stated for each loan. The interest reserve will be withheld from drawable funds and will be used to cover interest costs until the reserve is depleted.

Loan draws are made in accordance with the forecast of drawable cash flows assigned to the loan. It is an easy matter to override the loan draw amount or to provide a positive or negative increment to add to the calculated loan draw for any period.

EQUITY PARTICIPATION — The Equity Financing category covers net funding requirements so as to maintain a cash balance of zero (or a stated cash reserve amount) until positive cash flows are available to repay the equity balance(s) and any return(s) on equity. Any remaining cash is distributed as available. The equity funding and distributions of cash may be on the part of the Developer alone (wholly owned project) or may represent a joint venture participation between the Developer and the Investor partner. A maximum of flexibility is provided to alter the default rules that apply to the joint venture participation.

A cash flow analysis section summarizes the net cash flow before financing, and the loan fees, interest, draws, and repayments for all loans in aggregate. The report then displays net cash flow after financing, cash balance, loans outstanding, maximum equity requirement, and maximum loan exposure. A summary for each equity partner is also displayed including the net present value and internal rate of return for the cash participation.

CONSOLIDATION OF PRIMARY REPORTS — Income-PIE performs a time-phase consolidation of any number of primary Cash Flow/ Loan Flow reports in a single step. Consolidated reports may also be brought into subsequent consolidations, so the number of reports to be combined is unlimited.

Although the primary Income-PIE report handles multiple-phase projects, it may be desirable to perform separate analyses for specific segments of the project followed by consolidating the results for each. This may be the case if the project involves components with totally different product types, or if the financing for components or phases is separate and unique, requiring separate analysis. This feature also allows for the combination of all of selected projects to be undertaken over time.