Cost Comparison Analysis
This analysis of four
alternatives for satisfying a user need for space was prepared using planEASe
software, given the following specifications.
Since the analysis involves after tax benefits for two of the leases and the
purchase, we decided to perform the analysis after tax, assuming a 34%
corporate tax rate for the client (planEASe performs analysis before tax as
well, where appropriate). We also assumed the client has a 10% after tax Cost
of Capital. To establish a common time frame for the analysis, we decided to
use 10 years, ignoring the 11th year for Whale Point.
We assumed that the meaning of the 3% annual increases for the 1000 Ocean Blvd.
lease meant that it was tied to the CPI, and expected to be 3%. This 3%
Inflation Rate was also used for the growth in Utilities & Taxes for the
Beach Overlook purchase. No assumption was given for the reversionary value of
the Beach Overlook purchase, so we assumed that its value would increase at the
3% Inflation Rate as well, and tested this major assumption at the conclusion
of the analysis when we compared the alternatives while varying the Inflation
Rate.
Throughout the assumptions for all four alternatives, you will find that what
would normally be expenses are instead entered as negative revenues. The end
results are the same using either method, but using negative revenues is
recommended because it allows you to view the expenses planned using the
planEASe Lease Analysis capability, although that reporting is not necessary
(or shown) for these simple leases.
You may wonder about the color presentation in this report package. planEASe is
shipped with many page "styles" (this one is called
"Influential") that allow you to present your planEASe reports in
pre-defined colors and fonts. You may choose any of these styles before
printing, and all the reports and graphs will use that style until you choose
another. Of course, you may exercise your creativity at any time by easily
defining your own styles, choosing (and saving) your own choices of colors and
fonts as your own style.
We maintain an extensive website at www.planease.com, describing the product,
the many classes constantly scheduled throughout the nation, and many tutorials
available 24/7 to support the product. For instance, if you click on
Tutorials/Presentation/color Printing at the website, you will find a full
screen-by-screen tutorial telling you how to save your own styles.
planEASe measures NPV's using a mid-year convention for placing the Cash Flows
in time. This is explained in the NPV Verification Report on the last page of
this package. If you care to verify our calculations using EXCEL, be sure to
use the new XNPV function that allows unequal time periods.
Other than the NPV Verification Report mentioned above, all the reports in this
package (these pages as well) were prepared by planEASe plus the Reporting
Extension, priced at $1,395. No additional software (other than Windows itself)
is required. Additional capabilities (adding Advanced Graphs, Monthly Analysis
and Partnership (or LLC) Models) are available at additional cost.
|
|
Start |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
End |
Total |
|
Before Tax Cash Flow Projection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Investment and Sale |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Effective Income |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Operating Expense |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Cash Flow Before Debt |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Debt Service |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Cash Flow Before Tax |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Taxable Income Projection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Taxable Revenue |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Taxable Expense |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Interest Expense |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Depreciation |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Ordinary Income |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
After Tax Cash Flow Projection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Before Tax |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Ordinary Income |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Capital Gains |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Taxable Income |
(65,160) |
0 |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(781,920) |
(899,208) |
(899,208) |
(899,208) |
(899,208) |
65,160 |
(7,506,432) |
|
Taxes |
22,154 |
0 |
265,853 |
265,853 |
265,853 |
265,853 |
265,853 |
305,731 |
305,731 |
305,731 |
305,731 |
(22,154) |
2,552,187 |
|
Cash Flow After Tax |
(43,006) |
0 |
(516,067) |
(516,067) |
(516,067) |
(516,067) |
(516,067) |
(593,477) |
(593,477) |
(593,477) |
(593,477) |
43,006 |
(4,954,245) |
|
Rate of Return Before Debt (IRR) |
0.0% |
|
Rate of Return Before Tax (IRR) |
0.0% |
|
Rate of Return After Tax (IRR) |
0.0% |
|
Net Present Value Before Debt @10% |
(4,555,376) |
|
Net Present Value Before Tax @10% |
(4,555,376) |
|
Net Present Value After Tax @10% |
(3,006,548) |
|
|
|
|
|
|
Start |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
End |
Total |
|
Before Tax Cash Flow Projection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Investment and Sale |
0 |
(898,520) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
(898,520) |
|
Effective Income |
(202,167) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
202,167 |
(8,985,200) |
|
Operating Expense |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Cash Flow Before Debt |
(202,167) |
(1,707,188) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
202,167 |
(9,883,720) |
|
Debt Service |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Cash Flow Before Tax |
(202,167) |
(1,707,188) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
202,167 |
(9,883,720) |
|
Taxable Income Projection |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Taxable Revenue |
(202,167) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(808,668) |
(988,372) |
(988,372) |
(988,372) |
(988,372) |
(988,372)< |