Financial Analysis: Regardless of the feasibility of all other metrics, if the financial analysis does not solidly support a project's completion then the project is a no go. The following summarizes and presents key financial inputs and outputs for the analysis of this project.

Construction Costs: There is a significant variance in the construction costs by floor for this project. Information used to estimate floor by floor estimated construction costs came from a variety of sources including RS Means, CityFeet.com, and the Fort Worth Chamber of Commerce. The following summarizes what needs to be completed on each floor and estimated costs:
Basement: To create six 1,000 sf offices in the basement will require improved lighting, the addition of toilets and the erection of partition walls. The estimate construction cost to achieve this level of basic upgrades in this size space is $100,000. Estimating construction costs of $14/sf in the basement provides a 3% cushion.
First Floor: The first floor is retail ready. Estimate $5/sf in TIs and the space should be ready to rent. This equates to $18,755.
Second Floor: Thge second floor is already office space, but is only tailored to a single tenant use. The installation of partition walls and a $5/sf TI allowance for finish out will total $53,568 in construction costs.
Third Floor: The third floor will convert office space to apartment / condo space. The cost of construction a 1-3 story apartment complex in the DFW area is about $125/sf. Because this is remedial and not new construction and is limited to one level, the third floor construction costs are estimated at $100/sf. This is approximately $669,600
Total Construction Cost: The total estimated construction cost for the entire building is $844,991. The following displays a feasibility analysis for the project that incorporates these construction estimates with acquisition costs, costs of capital and other key metrics:
Analysis: Given the above assumptions and estimates, this project needs attain an average gross rental rate psf of $13.28. This equates to a minimum Potential Gross Income of $325,468.71.
Office Space: According to Grubb & Ellis & CBRE -- Office & Industrial Trends Report, 4th Quarter 2011, average annual rates for Class B Office Space in Fort Worth's Central Business District were $19.15/sf. Offices in the basement will not enjoy the visibility and notarity of spae above ground. Accoringly, annual basement rents are estimated at $10 sf or $60,000. To be conservative, the office annual rents will be discounted 5.2% from the $19.15. Estimating second floor office space rents at $18/sf/yr yields $108,000 in revenue.
Retail Space: Information from Loop.net indicates that retail rents in and around the central business district range from $20 - $22/sf/yr. The first floor retail space in the Hogan Building is highly visible and on a busy corner of a busy street. Therefore, $20/sf/yr is estimated for the retail rent on the six 600 sf spaces. This yields $72,000 in revenue.
Residentail Space: Rates per sf in and around the central business district varied greatly. The sf rates even varied significantly within the same building. For instance, at the Houston Street Lofts, which is a few buildings down the block at 910 Houston Street, the annual sf rates varied from $1.69 sf/mo. to $2.68 sf/mo. This variance probably correlates to quality of finish out and amenities. Expecting that the third floor apartments/condos in the Hogan Building will be "above average" in these areas, but not luxurious, residential rates for our project will be stimated at $1.90 sf/mo. This equates to $136,800 in revenue.
Conclusion: Total Potential Annual Gross Revenue is $376,800. This exceeds the minimum Potential Gross Income of $325,468.71. Therefore, the project is financially feasible. The cushion of $51,331.29 is a 15.77% margin of safety vis-a-via the minimum requirement for project feasibility.
Basement: To create six 1,000 sf offices in the basement will require improved lighting, the addition of toilets and the erection of partition walls. The estimate construction cost to achieve this level of basic upgrades in this size space is $100,000. Estimating construction costs of $14/sf in the basement provides a 3% cushion.
First Floor: The first floor is retail ready. Estimate $5/sf in TIs and the space should be ready to rent. This equates to $18,755.
Second Floor: Thge second floor is already office space, but is only tailored to a single tenant use. The installation of partition walls and a $5/sf TI allowance for finish out will total $53,568 in construction costs.
Third Floor: The third floor will convert office space to apartment / condo space. The cost of construction a 1-3 story apartment complex in the DFW area is about $125/sf. Because this is remedial and not new construction and is limited to one level, the third floor construction costs are estimated at $100/sf. This is approximately $669,600
Total Construction Cost: The total estimated construction cost for the entire building is $844,991. The following displays a feasibility analysis for the project that incorporates these construction estimates with acquisition costs, costs of capital and other key metrics:
Financial Feasibility Analysis
| + Construction Costs (PSF) | $ 34.48 |
| x Total Square Feet | 24,505 |
| = Total Construction Cost | $ 844,932.40 |
| + Acquisition Costs | $ 865,000.00 |
| = Total Development Costs | $ 1,709,932.40 |
| - Governmental Rebates for Energy/Sustainability | $ - |
| = Revised Development Costs | $ 1,709,932.40 |
| Project Financing Details | |
| Maximum LTV Ratio | 75.00% |
| Loan Term in Months | 180 |
| Loan Interest Rate | 7.00% |
| Equity Required | $ 427,483.10 |
| Debt (Loan Amount) | $ 1,282,449.30 |
| Before Tax Cash Flow (BTCF) | $55,329.68 |
| Annual Debt Service | $138,324.20 |
| Minimum DSC Ratio | 1.40 |
| Required Minimum Net Operating Income (NOI) | $193,653.88 |
| Total Operating Expenses as % of EGI | 30.00% |
| Total Operating Expenses | $82,994.52 |
| Effective Gross Income (EGI) | $276,648.40 |
| Vacancy and Collection Loss % of PGI | 15.00% |
| Vacancy and Collection Loss (VCL) | $ 48,820.31 |
| Potential Gross Income (PGI) | $ 325,468.71 |
| Required Gross Rental Rate PSF | $ 13.28 |
| Required Net Rental Rate PSF | $ 7.90 |
| BTCF/EQUITY INVESTED (BTROE) | 12.94% |
Analysis: Given the above assumptions and estimates, this project needs attain an average gross rental rate psf of $13.28. This equates to a minimum Potential Gross Income of $325,468.71.
Office Space: According to Grubb & Ellis & CBRE -- Office & Industrial Trends Report, 4th Quarter 2011, average annual rates for Class B Office Space in Fort Worth's Central Business District were $19.15/sf. Offices in the basement will not enjoy the visibility and notarity of spae above ground. Accoringly, annual basement rents are estimated at $10 sf or $60,000. To be conservative, the office annual rents will be discounted 5.2% from the $19.15. Estimating second floor office space rents at $18/sf/yr yields $108,000 in revenue.
Retail Space: Information from Loop.net indicates that retail rents in and around the central business district range from $20 - $22/sf/yr. The first floor retail space in the Hogan Building is highly visible and on a busy corner of a busy street. Therefore, $20/sf/yr is estimated for the retail rent on the six 600 sf spaces. This yields $72,000 in revenue.
Residentail Space: Rates per sf in and around the central business district varied greatly. The sf rates even varied significantly within the same building. For instance, at the Houston Street Lofts, which is a few buildings down the block at 910 Houston Street, the annual sf rates varied from $1.69 sf/mo. to $2.68 sf/mo. This variance probably correlates to quality of finish out and amenities. Expecting that the third floor apartments/condos in the Hogan Building will be "above average" in these areas, but not luxurious, residential rates for our project will be stimated at $1.90 sf/mo. This equates to $136,800 in revenue.
Conclusion: Total Potential Annual Gross Revenue is $376,800. This exceeds the minimum Potential Gross Income of $325,468.71. Therefore, the project is financially feasible. The cushion of $51,331.29 is a 15.77% margin of safety vis-a-via the minimum requirement for project feasibility.