please help me with this excel hw im very conffused You have the opportunity to invest in an office building in downtown Tampa, in which you would purchase as a 5 year holding investment with a 12 required rate of return (discount rate) The building offers a total rentable area of 31,100 square feet, and 170 garage parking spaces You are provided the following information on the property from the current owner The owner is asking $11,500,000 for the building The owner has annual contracts from tenants on the building for 28,000 square feet of the total space at $24 00 psf, gross Additionally, 153 parking spaces are leased by annual contract for $135 00 per month, per space You expect this same office vacancy to occur into perpetuity, and expect parking vacancy to equally correlate with the office vacancy These lease terms are found to be in line with the downtown office market Current annual operating expenses for the building follow Management Fees 8 of EGI Annual Real Estate Taxes $9,500 Hazard Insurance $7,500 Maintenance Repairs $22,000 Supplies $6,000 Capital Replacement Allowance $13,000 Administrative Costs $8,250 Operating Costs of the Garage $9,800 Your mortgage lender has committed to you a loan to purchase the office building (should you decide to partake in the investment), which would offer the following terms Loan to Value $6,825,000 Mtg $4,675,000 hard equity Interest Rate 4 25 FRM Loan Duration 25 years, fully amortizing Payment $443,684 per annum Prepayment Penalty None A study of the office building market in downtown Tampa indicates the following trended increases in incomes and expenses, which can safely be assumed in analysis forecasts Office rents 3 per annum Parking rents 3 per annum Real Estate Taxes 3 5 per annum Other Operating Expenses 3 4 per annum Based on the above information, prepare a reconstructed income and expense statement forecasting returns for the 5 year holding period (six years analysis required) Calculate through Before Tax Cash Flows, show your work in Excel

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 29, 2024

please help me with this excel hw im very conffused You have the opportunity to invest in an office building in downtown Tampa, in which

please help me with this excel hw im very conffused

You have the opportunity to invest in an office building in downtown Tampa, in which you would purchase as a 5-year holding investment with a 12% required rate of return (discount rate). The building offers a total rentable area of 31,100 square feet, and 170 garage-parking spaces. You are provided the following information on the property from the current owner:

The owner is asking $11,500,000 for the building.
The owner has annual contracts from tenants on the building for 28,000 square feet of the total space at $24.00 psf, gross. Additionally, 153 parking spaces are leased by annual contract for $135.00 per month, per space. You expect this same office vacancy to occur into perpetuity, and expect parking vacancy to equally correlate with the office vacancy. These lease terms are found to be in line with the downtown office market.
Current annual operating expenses for the building follow:
1. Management Fees: 8% of EGI
2. Annual Real Estate Taxes: $9,500
3. Hazard Insurance: $7,500
4. Maintenance/Repairs: $22,000
5. Supplies $6,000
6. Capital Replacement Allowance: $13,000
7. Administrative Costs: $8,250
8. Operating Costs of the Garage: $9,800

Your mortgage lender has committed to you a loan to purchase the office building (should you decide to partake in the investment), which would offer the following terms:

Loan-to-Value: $6,825,000 Mtg; $4,675,000 hard equity

Interest Rate: 4.25% FRM

Loan Duration: 25 years, fully amortizing

Payment: $443,684 per annum

Prepayment Penalty: None

A study of the office building market in downtown Tampa indicates the following trended increases in incomes and expenses, which can safely be assumed in analysis forecasts:

Office rents: 3% per annum
Parking rents: 3% per annum
Real Estate Taxes: 3.5% per annum
Other Operating Expenses: 3.4% per annum

Based on the above information, prepare a reconstructed income and expense statement forecasting returns for the 5-year holding period (six years analysis required). Calculate through Before Tax Cash Flows, show your work in Excel.