Fast. Within minutes, you can have a complete preliminary analysis of a deal. Make a few changes in sales volume, prices, expenses, and interest rates for a “what-if” analysis, and you have a new report in seconds. Put the final touches on it and present it to management, investors or a potential lender.
Flexible. Use our pre-defined templates or create and save your own for future use. You are in control – no compromises needed for Land-PIE land development software. Nothing could be faster or easier… or more accurate.
You won’t have to rely on others to do your analysis, working around their schedules and conveniences. Land-PIE generates accurate and detailed projections of cash flow, loan flow, profit & loss, balance sheet, and budget analysis projections for single and/or multiple phased development projects. The forecasts are based on fundamental input variables, and may reflect projects in the initial planning stages or already underway.
Land-PIE generates accurate and detailed projections of cash flow, loan flow, profit & loss, balance sheet, and budget analysis projections for single and/or multiple phased development projects. The forecasts are based on fundamental input variables, and may reflect projects in the initial planning stages or already underway.
You won’t be frustrated by elementary models that have no flexibility to portray real-life deals accurately. Or models so complex that nobody can use them.
Click on the tabs above to navigate your way through the key features of Land-PIE.
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. Up to 15 product types with separate sales prices may be included in the product mix. You can also describe up to 30 user-defined expenses and 9 miscellaneous revenue items such as reimbursements and rebates. Each of the 30 user-defined expenses can also be “exploded” into 27 detailed sub-expenses for maximum control and accuracy if needed. Much flexibility is provided in describing the disbursement of expenses from detailing it period-by-period, by percentages, on closings, and spreading over a period of time.
The Cash Flow Forecast clearly displays the project sequence-of-events and 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. The report also solves for the Residual Land value based upon a user-desired Developer’s Profit margin. This is an extremely valuable tool when negotiating for the land.
Land-PIE performs detailed analyses for any combination of a purchase note for the acquisition of the land, an acquisition & development loan for the completion of the finished lots, and equity financing to cover the net funding requirements. A miscellaneous loan can also be described and used for things as Land Seller financing, bonds or an interim loan.
You can 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.
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.
The Profit & Loss Forecast produces a period-by-period income statement for the project based on generally accepted accounting principles. Commissions & Closing Costs and other user-defined expenses are expensed directly as incurred at closes of escrow. Balance sheet assets include cash as well as capitalized cost balances. Liabilities and capital include all loan balances, accrued property tax, net cash invested and cumulative profit.
The Budget Forecast/Analysis presents a separate column for each Parcel Type in the product mix, with additional columns to display each line item as Grand Total, Per Unit Average, Per Acre and Percent of Sales and Costs.
Land-PIE calculates costs for each budgeted cash flow line item and allocates them to each parcel type on a per-unit basis. The default allocation method is based on a relative sales value, but alternative allocation methods of relative average or unit acreage may be triggered separately for each line item, if desired.
The Budget Variance report compares a “budget” file with an update/projection file, which contains a combination of historical or actual values and planning assumptions. The report compares project-to-date and project-to-completion on a percentage and absolute dollar basis. The report is vital for tracking the performance of a project and planning for future changes.
Click on the tabs above to navigate your way through the key features of Land-PIE.
Land-PIE performs a time-phase consolidation of any number of primary Cash Flow / Loan Flow / P & L/ Balance Sheet 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 Land-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 parcel types, or if the financing for components or phases is separate and unique, requiring separate analysis.
Although flexibility for development planning is part of the primary Land-PIE Cash Flow process, a stand-alone Detailed Sub-Cost Planning option is available as part of the system for describing the expenses in much more detail. This menu option provides up to 30 separate major expenses with up to 27 detailed expenses within each one. Separate expense flow schedules can be displayed and the sub-total of each set of expenses is automatically “passed” to the Primary Report module.
The Executive Summary Report is a professional looking one-page report that itemizes the essential factors of the project. The report details the parcel revenues, financing parameters, equity participations and cashflow ratios. The report is ideal for management presentations, or for potential lenders and investors.
Our software products have been in use for more than 26 years by small and large builders, developers, lenders, appraisers and investors. We continually enhance and professionally support Tract-PIE, Land-PIE and Income-PIE to ensure that our users have the most capable and flexible analysis tools in the market.
The initial year of telephone support and enhancements/upgrades are included as part of the purchase price of the system. A modest annual maintenance and support fee provides continued support for future years and protects the value of your initial investment. User Guides are provided with the system. Online help assists users in questions of input.