|
The
Feasibility Advisor
The
Feasibility Advisor is a Cash
Flow Model designed for use by Residential Builders and Developers.
The model is used by single project developers with no financial staff, as
well as public companies with a sophisticated finance group handling more
than 70 projects in a single Operating Division.
This
Microsoft Excel 97 template is used to create
cash flow projections from one page
of assumptions. This
Cash Flow Model forecasts:
The
user can easily change assumptions
for prices, costs, debt and equity pricing and structure, sales rates, as
well as construction and development cycle times.
These "what-if-analysis" clearly demonstrate the impact
of changing assumptions in the following reports.
The
Absorption
Schedule summarizes the Starts, Sales, and Closings at any moment
in the project. The user can
easily change the assumed sales rate, construction and development cycle
time, and unsold inventory targets to see the impact upon the project's
performance. The resultant
levels of sold and unsold inventory can then be managed to fit the limits
of Debt and Equity Capital available to drive the project.
The
Funding
Analysis provides an easy to read summary of the Funding
Requirements and Funding Sources. The
builder can see how much Debt, Builder Equity, and Joint Venture Equity
are required, and when.
The
Proceeds
Projection predicts the closing proceeds over the life of the
project. As changes are made
in the underlying assumptions, the proceeds projection is then
automatically re-forecast.
The
Gross
Profit by Plan and Mix analysis shows the margin for each house
plan and demonstrates the impact of changes in the product mix based upon
margin insights.
The
Financing
Summary report provides a concise, one page recap of several
measures of the project's financial performance, including Internal Rate
of Return, Modified Internal Rate of Return, Return on Assets, and Debt to
Equity Ratio.
An
experienced Residential Real Estate Professional with modest Excel
experience is typically able to comfortably
use the program in less than two hours.
Our
related program, The Business Plan Advisor is used to Consolidate several projects into
a Business Plan. Our
Financial Reporting Program, The
Financial Advisor is used to compare
actual results to the Business Plan.
Download
sample reports
The
Business Plan Advisor
This
program is used to create a Profit Center (Division)
Business Plan by consolidating the forecasts of several individual
projects generated by our Cash Forecasting program, The Feasibility Advisor.
The user then incorporates other Division costs, such as G&A,
to create a Consolidated Business Plan, complete with Projected Income
Statements, Balance Sheets, and Statements of Cash Flow.
(Projections of EBIT and / or EBITDA can also be available from the
program.)
This
Microsoft Excel 97 template can be used to create Multi Level Consolidations by combining profit centers as well as projects. In addition to projecting Income Statements, Balance
Sheets, and Statements of Cash Flow, numerous other management planning
reports are provided. Each of
these reports is in the same familiar format used in The
Feasibility Advisor.
Summary
Income Statements and Balance Sheets are presented showing side by side comparisons
of individual projects. Significant
aberrations of a single project (positive or negative) are seen at a
glance.
The
Absorption Schedule summarizes
on a single page Sales
by Project and Month for the entire Division.
Similar pages shows Starts and Closings. The user can easily change
the assumed sales rate, construction and development cycle time, and
unsold inventory targets in an individual project, and then see the impact
upon the Division's performance. The
resultant levels of sold and unsold inventory can then be managed to fit
the limits of Debt and Equity Capital available to the Division.
The
Proceeds
Projection predicts the closing proceeds for the Division.
As changes are made in the underlying assumptions, the proceeds
projection is then automatically re-forecast.
The
Financing
Summary report provides a concise, one page recap of several
measures of the Division's financial performance, including Internal Rate
of Return, Modified Internal Rate of Return, Return on Assets, and Debt to
Equity Ratio.
This
program requires the use of our Cash Flow Model, The
Feasibility Advisor.
Our
related program, The Financial Advisor, is designed to capture the Business
Plan created by this program, and compare it to actual results.
Download
sample reports
The
Financial Advisor
This
is a Financial Reporting Program
designed to compare Actual Results of a Profit Center (Division) to a
Business Plan. (The
program automatically loads Budgeted Income Statements and Balance Sheets
created with our related program The
Business Plan Advisor.)
The user then loads the actual results from their accounting
system, and the variance analysis are created.
(Or we can create a customized download of financial reports from
the user's accounting / financial reporting software.)
The
Income
Statement Variance Analysis is designed to clearly segregate any
deviation from Business Plan caused by:
The
Balance
Sheet Variance Analysis shows the impact of variances upon the
Division's financial condition, especially cash and the risk profile of
the Division couched in terms of Debt to Equity Ratios.
These deviations from the Business Plan can help those with Profit
Center Responsibility proactively manage their Balance Sheets by focusing
on the individual components of the Balance Sheet including inventories,
asset turnover rates for each type of inventory, leverage, and cash.
One
of the most powerful features of The
Financial Advisor is the ability to see each project 's actual
Income Statement and Balance Sheet compared to Business Plan.
These Project
level Variance Analysis are in exactly the same Income Statement
and Balance Sheet formats as the Division, thus helping pinpoint precisely
which projects are causing the Division to deviate from the Business Plan.
The
user can see at a glance how each project
compares to the others with the Summary Income Statements and
Balance Sheets. This report
is a side by side presentation of every project's Income Statement and
Balance Sheet.
Although
this program can be used to report actual results vs. budgets created with
other software, it works most easily when using when using budgets created
with our related programs The
Business Plan Advisor and The
Feasibility Advisor.
Download
sample reports
|
