Question # 4 please. You can use the BTCF from the excel picture from mortgage option # A ($3850060.00)

H34 Excel File Edit View Insert Format Tools Data Window Help Washington Tower Q- Search Sheet Home Insert Page Layout Formulas Data Review View P , Calibri (Body) - 10 AA = = 0 . Conditional Formatting Paste Format as Table BI UAB. 70 BI ULAZ Number Cell Styles x fx A M 1 OPERATIONS 4 5 6 REVERSION 2 Potential Gross Income PG $1,334,000 $1,374,020 $1,374,020 $1,374,020 $1,374,020 $1,374,020 Sales Price SP $9.391.828.43 3 Vacancy Loss VC $120,060 $123,662 $123.562 $123,662 $123,662 $123,562 Sales Exp -SE $281.754.85 4 Miscellaneous Income +MI $120,000 $121,125 $122,278 $123,460 $124,572 $125,913 Net Sales Price WASP $9,110,073.57 5 Effective Gross Income =EGI $1,213,940 $1,250,358 $1,250,358 51,250,358 $1,250,358 $1,250,358 6 Operating Expenses -OE $425,750 $439,473 $453,645 $468,282 $483 399 $499,012 7 Net Operating Income =NOI $788,190 $810,886 $796,714 $782,077 $756,960 5751,346 9 Price 12% $8,481,030 10 -DS -BTCF 22% $403,418 $384,772 $403 418 $407468 $403.418 $393,296 S403.418 $378,659 $403 418 $363.542 Net Sales Price Mortgage+PP BTCF-Reversion NSP $9.110,074 DS55.260.013 =BTCF $3,850,060 11 Mortgage Option: A 12 Debt Service 13 BTCF-Operations 15 Levered Retum 16 17 Mortgage Option: B 18 Debt Service 19 BTCF-Operations 21 Levered Return 22 23 Mortgage Option: C 24 Debt Service 25 BTCF-Operations 27 Levered Return US =BTCF 25% $380,250 $407,940 $380,250 $430,636 $380,250 $416,464 $380,250 $401,827 $380,250 $386,710 Net Sales Price Mortgage PP BTCF-Reversion NSP D S - BTCF S9.110.074 $6075500 $3.084574 -DS -BTCF 23% $540,000 $248,190 $540,000 $270,886 $540,000 $256,714 $540,000 $242.077 $540,000 $226,960 Net Sales Price Mortgage.pp BTCF Reversion NSP US BTCF $9110074 $6.000.000 $3,110,074 Washington Tower BTCF RentRollAndExpenses Financing Alternatives Partnership Waterfall falu - A Ready x M Inbox (3, M Inbox (3,1 x My Drive * REE proje * M Inbox (3, ! oads/WashingtonTower%20(2).pdf Guide... DOPRA Non-Profes... D Subscriber Agree... eLearning f Home Learning Center - Questions: Ignoring financing alternatives, is this property a good investment? What purchase price provides the owner with the 12.0% unlevered required rate of return? You have three financing alternatives. a. A 70% loan/value ratio loan with a 6.25% annual interest rate with monthly payments, a 30 year amortization schedule with one discount point, 2% other financing costs, and a 3% prepayment penalty. The market required rate of return on after debt, before tax equity for 70% L/V ratio loans is 14%. b. A 75% loan/value ratio loan with an 6.5% annual interest rate with monthly interest only payments for five years, one discount point, 2% other financing costs, and a 3% prepayment penalty. The loan begins to amortize after the initial five-year period. The amortization period is 25 years. The market required rate of return on after debt, before tax equity for 75% L/V ratio loans is 16%. c. An 80% loan/value ratio loan with monthly payments of $41,500 and a balloon payment of $6M at the end of the five-year holding period. The loan also has two discount points and 2% other financing costs. The market required rate of return on after debt, before tax equity for 80% L/V ratio loans of this type is 18%. Which financing alternative, if any, should you use? You are planning to structure the acquisition as a partnership with two other investors using the most favorable financing option. You are the general partner and plan to contribute 20% of the required equity. The remaining equity will be divided equally between the two limited partners-Bill Jones and Mary Smith. The distributions will be structured differently. Bill wants current income while Mary wants capital appreciation. You propose to give Bill a 9% cumulative preferred retum on all operating year cash flows plus 60% of any excess cash. Any unpaid return will accumulate at 10% per vear. Mr. Jones will receive 20% of the BTCF from the sale of the property. Mary Smith is willing to forego current income in exchange for 50% before tax cash flow from the sale of the property. The general partner must cover any assessments and receives all residual distributions. What are the expected partnership returns? Is this structure appropriate for the three equity positions? Why or why not? If not, suggest a more equitably structured partnership agreement. Real Esta x M Inbox (3, X M Inbox (3, X My Drive x E REE proje x M Inbox (3, X Cer D/Downloads/WashingtonTower%20(2).pdf Complete Guide... DOPRA Non-Profes... Subscriber Agree... Learning f Home & Learning Center -... Market Data Quoted rates and actual recent lease terms at comparable office buildings were analyzed to determine current market rent. The building has two classifications of office space. One is for offices of less than 20,000 SF and the other is for offices of more than 20,000 SF. For offices less than 20,000SF: Renewal Probability: Market Rent: Months Vacant: Tenant Improvements: 70% $23.00/SF for new tenants $20.00/SF for renewing tenants 4 months downtime between leases A $10.00/SF tenant improvement allowance for renewing tenants and $12.00/SF allowance for new tenants occupying previously fitted out space. Initialew leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Base Year Stop 5 Years Leasing Commissions: Reimbursements: Term Lengths: For offices more than 20,000SF: Renewal Probability: Market Rent: Months Vacant: Tenant Improvements: 85% $21.00/SF for new tenants $19.00/SF for renewing tenants 6 months downtime between leases An $8.00/SF tenant improvement allowance for renewing tenants and $11.00/SF allowance for new tenants occupying previously fitted out space. Initialew leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Base Year Stop Lensing Commissions: Reimbursements Term Length: 10 Years Terminal Value The reversion value (expected future sales price) is estimated by capitalizing the year eight net operating income, after adjusting for tenant improvements and leasing commissions. The terminal capitalization rate is expected to be in the 7.5% to 8.5% range. The subject property is in a good location and is one of the better quality office buildings in the area. The property is currently 22 years old. Selling expenses, including commissions and closing costs, are estimated to be 3% of the gross sales and proceeds. This estimate is reasonable considering the size and value of the subject property Discounted Cash Flow Analysis The subject property is a modem office building constructed of very good quality materials and is well maintained. In addition, it is located in close proximity to major roadways. Further, future construction of office buildings is expected to be minimal and new generation buildings are experiencing high occupancies (91%). The subject property is currently below stabilized occupancy because of the unfinished space. Given these considerations, an annual end-point property (e.g. unlevered) discount rate of 12.0% is considered appropriate. Real Estax M Inbox (3, X M Inbox (3,1 x My Drive REE proje x M Inbox (3, X Cengag SD/Downloads/WashingtonTower%20(2).pdf Complete Guide... D OPRA Non-Profes... D Subscriber Agree... Learning f Home & Learning Center -... FIU Vacancy and Credit Loss To account for vacancy loss, a 7% allowance is applied to the property's potential gross revenue. This allowance will be taken only if the deduction made for vacant periods occurring between leases is less than this amount. The Credit and Collection Loss is expected to be 2% of potential gross income. SF 3.750 From 6/05 To 5/10 Rent per SF $17.75 Rent Roll Suite Tenant 100 Around the World Travel Management Group First National Corp. 125 1,040 1/04 12/08 $19.50 Other terms Expense Stop of $5.25 per SF Expense Stop of 5.90 per SF Expense Stop of $6.10 per SF 140 6,200 8/06 8/07 8/08 8/09 8/10 9/07 7/07 $19.50 7/08 5% increase 7/19 5% increase 7/10 4% increase 7/11 4% increase 8/10 $21. 00 200 5,400 B Temp 2 Perm Agency E-Z Credit Union ase year Expense Stop Net Lease 250 5,610 23,000 Floors 3&5 Buy a House Realtor 7/03 12/06 1208 12/10 12/12 6/09 S12.50 11/08 $22.00 1110 $23.00 11/12 S24.00 11/14 $25.00 Expense Stop of S5.70 per SE 25% rental abatement for months 27-38 Base Year Expense Stop 400 Proposed Tenant 3.000 12/07 11/10 100% of market rent Notes for Rent Roll: Management Group has notified management that they are vacating at the end of their current lease. Absorption Given the recent leasing of Suite 200, Temp 2 Perm Agency, the property is 75% occupied. Currently, 12.000 SF is unfinished (slab) and vacant. This space is not included in the rent roll. Additionally, another 3,000 SF (already shown on the rent roll) is second-generation space, which is currently vacant. The building has an excellent location and is a very good quality Class B office building. In the analysis of the subject property, an absorption rate of 2,000 SF per quarter is reasonable for the unfinished areas considering the amount and location of the space at the subject property. The unfinished area is available at the beginning of the analysis with absorption projected to begin July 2009. To prepare this currently vacant first generation space for Occupancy, a S20.00/SF tenant improvement allowance is assumed. Also, a 5% leasing commission is assigned to each 2,000 SF office. Lease terms will be 5 years and rent will be 100% of current market rent. * inbox (9, X M Inbox (3,1 x My Drive x FREE proje x M Inbox pads/WashingtonTower%20(2).pdf Guide... DOPRA Non-Profes... D Subscriber Agree... Learning F Home & Learni 1/4 CASE STUDY: WASHINGTON TOWER Property Analysis Data Washington Tower is a 60,000 SF office building located at 140 Washington Avenue, Houston, TX. The subject property was constructed in 1985. You are to perform a five-year holding period investment analysis of the subject property. The analysis start date is December 1, 2008. The overall rate of inflation is expected to be 3% annually. Reimbursement calculations will be performed on a calendar basis while other revenues and expenses will be inflated on a fiscal basis. Operating expenses are 100% fixed unless noted otherwise. The purchase price of the property is $7.8M. Miscellaneous Revenues In addition to base rent, revenue is derived from roof antennae fees and from parking. Roof antennae fees are expected to be $45,000 for year one and are expected to increase 2.5% per year. The building has 250 parking spaces to rent at $25/month. Projected Recoverable Expenses Real estate taxes are estimated at $1.75 per square foot in year 1. Thereafter, the tax liability is expected to increase at the overall rate of inflation. Insurance coverage includes fires, extended coverage, liability and other space coverage required by this property type. This expense is estimated at $0.18 per square foot initially and is expected to increase at the overall rate of inflation over the expected holding period. Maintenance & Repairs are $1.85 per square foot for year 1 and are expected to increase at the overall rate of inflation during the holding period. These expenses include all interior and exterior maintenance and repairs, contracts pertaining to repairs such as elevator repairs, mechanical equipment, etc. Janitorial expenses are estimated at $95.000 for year 1. These expenses are expected to increase 4% per year. Utilities include electricity, water and sewer. The current cost is $0.95/SF at 100% occupancy. It is estimated that 35% of the first year's utility cost would still be incurred by the property if it were totally vacant. Utility costs are expected to increase at the overall rate of inflation Roads, Grounds and Security typically includes all salary related items for grounds (including landscaping maintenance, and security as well as outside contract services. The roads/grounds/security expense is currently 50.45/SF and is expected to increase at the overall rate of inflation over the expected holding period. Projected Non-Recoverable Expenses Management and Administrative Expenses are projected at 4% of effective gross revenue (equal to historical amounts). Analysis of this expense consisted of interviews with representatives of major office building management companies Capital Expenditures The subject property's roof is partially defective and will need major repair in October 2010. Current estimates from contractors indicate the expense will total approximately $195,000 in current dollars. This expense is expected to increase 5% per year. H34 Excel File Edit View Insert Format Tools Data Window Help Washington Tower Q- Search Sheet Home Insert Page Layout Formulas Data Review View P , Calibri (Body) - 10 AA = = 0 . Conditional Formatting Paste Format as Table BI UAB. 70 BI ULAZ Number Cell Styles x fx A M 1 OPERATIONS 4 5 6 REVERSION 2 Potential Gross Income PG $1,334,000 $1,374,020 $1,374,020 $1,374,020 $1,374,020 $1,374,020 Sales Price SP $9.391.828.43 3 Vacancy Loss VC $120,060 $123,662 $123.562 $123,662 $123,662 $123,562 Sales Exp -SE $281.754.85 4 Miscellaneous Income +MI $120,000 $121,125 $122,278 $123,460 $124,572 $125,913 Net Sales Price WASP $9,110,073.57 5 Effective Gross Income =EGI $1,213,940 $1,250,358 $1,250,358 51,250,358 $1,250,358 $1,250,358 6 Operating Expenses -OE $425,750 $439,473 $453,645 $468,282 $483 399 $499,012 7 Net Operating Income =NOI $788,190 $810,886 $796,714 $782,077 $756,960 5751,346 9 Price 12% $8,481,030 10 -DS -BTCF 22% $403,418 $384,772 $403 418 $407468 $403.418 $393,296 S403.418 $378,659 $403 418 $363.542 Net Sales Price Mortgage+PP BTCF-Reversion NSP $9.110,074 DS55.260.013 =BTCF $3,850,060 11 Mortgage Option: A 12 Debt Service 13 BTCF-Operations 15 Levered Retum 16 17 Mortgage Option: B 18 Debt Service 19 BTCF-Operations 21 Levered Return 22 23 Mortgage Option: C 24 Debt Service 25 BTCF-Operations 27 Levered Return US =BTCF 25% $380,250 $407,940 $380,250 $430,636 $380,250 $416,464 $380,250 $401,827 $380,250 $386,710 Net Sales Price Mortgage PP BTCF-Reversion NSP D S - BTCF S9.110.074 $6075500 $3.084574 -DS -BTCF 23% $540,000 $248,190 $540,000 $270,886 $540,000 $256,714 $540,000 $242.077 $540,000 $226,960 Net Sales Price Mortgage.pp BTCF Reversion NSP US BTCF $9110074 $6.000.000 $3,110,074 Washington Tower BTCF RentRollAndExpenses Financing Alternatives Partnership Waterfall falu - A Ready x M Inbox (3, M Inbox (3,1 x My Drive * REE proje * M Inbox (3, ! oads/WashingtonTower%20(2).pdf Guide... DOPRA Non-Profes... D Subscriber Agree... eLearning f Home Learning Center - Questions: Ignoring financing alternatives, is this property a good investment? What purchase price provides the owner with the 12.0% unlevered required rate of return? You have three financing alternatives. a. A 70% loan/value ratio loan with a 6.25% annual interest rate with monthly payments, a 30 year amortization schedule with one discount point, 2% other financing costs, and a 3% prepayment penalty. The market required rate of return on after debt, before tax equity for 70% L/V ratio loans is 14%. b. A 75% loan/value ratio loan with an 6.5% annual interest rate with monthly interest only payments for five years, one discount point, 2% other financing costs, and a 3% prepayment penalty. The loan begins to amortize after the initial five-year period. The amortization period is 25 years. The market required rate of return on after debt, before tax equity for 75% L/V ratio loans is 16%. c. An 80% loan/value ratio loan with monthly payments of $41,500 and a balloon payment of $6M at the end of the five-year holding period. The loan also has two discount points and 2% other financing costs. The market required rate of return on after debt, before tax equity for 80% L/V ratio loans of this type is 18%. Which financing alternative, if any, should you use? You are planning to structure the acquisition as a partnership with two other investors using the most favorable financing option. You are the general partner and plan to contribute 20% of the required equity. The remaining equity will be divided equally between the two limited partners-Bill Jones and Mary Smith. The distributions will be structured differently. Bill wants current income while Mary wants capital appreciation. You propose to give Bill a 9% cumulative preferred retum on all operating year cash flows plus 60% of any excess cash. Any unpaid return will accumulate at 10% per vear. Mr. Jones will receive 20% of the BTCF from the sale of the property. Mary Smith is willing to forego current income in exchange for 50% before tax cash flow from the sale of the property. The general partner must cover any assessments and receives all residual distributions. What are the expected partnership returns? Is this structure appropriate for the three equity positions? Why or why not? If not, suggest a more equitably structured partnership agreement. Real Esta x M Inbox (3, X M Inbox (3, X My Drive x E REE proje x M Inbox (3, X Cer D/Downloads/WashingtonTower%20(2).pdf Complete Guide... DOPRA Non-Profes... Subscriber Agree... Learning f Home & Learning Center -... Market Data Quoted rates and actual recent lease terms at comparable office buildings were analyzed to determine current market rent. The building has two classifications of office space. One is for offices of less than 20,000 SF and the other is for offices of more than 20,000 SF. For offices less than 20,000SF: Renewal Probability: Market Rent: Months Vacant: Tenant Improvements: 70% $23.00/SF for new tenants $20.00/SF for renewing tenants 4 months downtime between leases A $10.00/SF tenant improvement allowance for renewing tenants and $12.00/SF allowance for new tenants occupying previously fitted out space. Initialew leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Base Year Stop 5 Years Leasing Commissions: Reimbursements: Term Lengths: For offices more than 20,000SF: Renewal Probability: Market Rent: Months Vacant: Tenant Improvements: 85% $21.00/SF for new tenants $19.00/SF for renewing tenants 6 months downtime between leases An $8.00/SF tenant improvement allowance for renewing tenants and $11.00/SF allowance for new tenants occupying previously fitted out space. Initialew leasing commissions are estimated at 4%. Renewing tenants require a 2% leasing commission Base Year Stop Lensing Commissions: Reimbursements Term Length: 10 Years Terminal Value The reversion value (expected future sales price) is estimated by capitalizing the year eight net operating income, after adjusting for tenant improvements and leasing commissions. The terminal capitalization rate is expected to be in the 7.5% to 8.5% range. The subject property is in a good location and is one of the better quality office buildings in the area. The property is currently 22 years old. Selling expenses, including commissions and closing costs, are estimated to be 3% of the gross sales and proceeds. This estimate is reasonable considering the size and value of the subject property Discounted Cash Flow Analysis The subject property is a modem office building constructed of very good quality materials and is well maintained. In addition, it is located in close proximity to major roadways. Further, future construction of office buildings is expected to be minimal and new generation buildings are experiencing high occupancies (91%). The subject property is currently below stabilized occupancy because of the unfinished space. Given these considerations, an annual end-point property (e.g. unlevered) discount rate of 12.0% is considered appropriate. Real Estax M Inbox (3, X M Inbox (3,1 x My Drive REE proje x M Inbox (3, X Cengag SD/Downloads/WashingtonTower%20(2).pdf Complete Guide... D OPRA Non-Profes... D Subscriber Agree... Learning f Home & Learning Center -... FIU Vacancy and Credit Loss To account for vacancy loss, a 7% allowance is applied to the property's potential gross revenue. This allowance will be taken only if the deduction made for vacant periods occurring between leases is less than this amount. The Credit and Collection Loss is expected to be 2% of potential gross income. SF 3.750 From 6/05 To 5/10 Rent per SF $17.75 Rent Roll Suite Tenant 100 Around the World Travel Management Group First National Corp. 125 1,040 1/04 12/08 $19.50 Other terms Expense Stop of $5.25 per SF Expense Stop of 5.90 per SF Expense Stop of $6.10 per SF 140 6,200 8/06 8/07 8/08 8/09 8/10 9/07 7/07 $19.50 7/08 5% increase 7/19 5% increase 7/10 4% increase 7/11 4% increase 8/10 $21. 00 200 5,400 B Temp 2 Perm Agency E-Z Credit Union ase year Expense Stop Net Lease 250 5,610 23,000 Floors 3&5 Buy a House Realtor 7/03 12/06 1208 12/10 12/12 6/09 S12.50 11/08 $22.00 1110 $23.00 11/12 S24.00 11/14 $25.00 Expense Stop of S5.70 per SE 25% rental abatement for months 27-38 Base Year Expense Stop 400 Proposed Tenant 3.000 12/07 11/10 100% of market rent Notes for Rent Roll: Management Group has notified management that they are vacating at the end of their current lease. Absorption Given the recent leasing of Suite 200, Temp 2 Perm Agency, the property is 75% occupied. Currently, 12.000 SF is unfinished (slab) and vacant. This space is not included in the rent roll. Additionally, another 3,000 SF (already shown on the rent roll) is second-generation space, which is currently vacant. The building has an excellent location and is a very good quality Class B office building. In the analysis of the subject property, an absorption rate of 2,000 SF per quarter is reasonable for the unfinished areas considering the amount and location of the space at the subject property. The unfinished area is available at the beginning of the analysis with absorption projected to begin July 2009. To prepare this currently vacant first generation space for Occupancy, a S20.00/SF tenant improvement allowance is assumed. Also, a 5% leasing commission is assigned to each 2,000 SF office. Lease terms will be 5 years and rent will be 100% of current market rent. * inbox (9, X M Inbox (3,1 x My Drive x FREE proje x M Inbox pads/WashingtonTower%20(2).pdf Guide... DOPRA Non-Profes... D Subscriber Agree... Learning F Home & Learni 1/4 CASE STUDY: WASHINGTON TOWER Property Analysis Data Washington Tower is a 60,000 SF office building located at 140 Washington Avenue, Houston, TX. The subject property was constructed in 1985. You are to perform a five-year holding period investment analysis of the subject property. The analysis start date is December 1, 2008. The overall rate of inflation is expected to be 3% annually. Reimbursement calculations will be performed on a calendar basis while other revenues and expenses will be inflated on a fiscal basis. Operating expenses are 100% fixed unless noted otherwise. The purchase price of the property is $7.8M. Miscellaneous Revenues In addition to base rent, revenue is derived from roof antennae fees and from parking. Roof antennae fees are expected to be $45,000 for year one and are expected to increase 2.5% per year. The building has 250 parking spaces to rent at $25/month. Projected Recoverable Expenses Real estate taxes are estimated at $1.75 per square foot in year 1. Thereafter, the tax liability is expected to increase at the overall rate of inflation. Insurance coverage includes fires, extended coverage, liability and other space coverage required by this property type. This expense is estimated at $0.18 per square foot initially and is expected to increase at the overall rate of inflation over the expected holding period. Maintenance & Repairs are $1.85 per square foot for year 1 and are expected to increase at the overall rate of inflation during the holding period. These expenses include all interior and exterior maintenance and repairs, contracts pertaining to repairs such as elevator repairs, mechanical equipment, etc. Janitorial expenses are estimated at $95.000 for year 1. These expenses are expected to increase 4% per year. Utilities include electricity, water and sewer. The current cost is $0.95/SF at 100% occupancy. It is estimated that 35% of the first year's utility cost would still be incurred by the property if it were totally vacant. Utility costs are expected to increase at the overall rate of inflation Roads, Grounds and Security typically includes all salary related items for grounds (including landscaping maintenance, and security as well as outside contract services. The roads/grounds/security expense is currently 50.45/SF and is expected to increase at the overall rate of inflation over the expected holding period. Projected Non-Recoverable Expenses Management and Administrative Expenses are projected at 4% of effective gross revenue (equal to historical amounts). Analysis of this expense consisted of interviews with representatives of major office building management companies Capital Expenditures The subject property's roof is partially defective and will need major repair in October 2010. Current estimates from contractors indicate the expense will total approximately $195,000 in current dollars. This expense is expected to increase 5% per year