Take a look at this: Property Information: WEST OFFICE PLAZA Rentable Area 300,000 sq. ft. Age...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Take a look at this: Property Information: WEST OFFICE PLAZA Rentable Area 300,000 sq. ft. Age # Stories # Tenants Financial Information: Base Rent Avg. 8 years 15 40 $20 per sq. ft. Other Income/Parking/Storage $1.50 per sq. ft. Expenses Recoverable from Tenants $2.50 per sq. ft. Current Vacancy 5% Expenses: Mgmt./Admin./Security/Ownership Property Taxes Insurance General Operations/Leasing Expense/Marketing Utilities Janitorial/Cleaning Business Taxes Other: Recurring CAPEX/Improvement Allowance $695,000 $675,000 $430,000 $667,000 $1,159,100 $489,000 $110,000 $700,000 You are an adviser to a private equity client who is thinking about buying this building. This client requires an 9% IRR after taxes are taken into account, and you are nervous because this market has shown no rent or occupancy growth for the past five years (but no declines either!) You anticipate a three year holding period. Note that this is not strictly speaking a triple net lease, but there are provisions for recovering expenses from the tenants. Do not worry about the differences in cost items between this pro forma and the example in class. Every one is different. Do not include items from the class example that are not included here. There are three scenarios, 1. Flat cash flows. 2. A 1% rise in cash flows each year. 3. Scenario 1, but with an increase in the vacancy rate from 5% to 20% in year 2. (for this one, the standard formulas will not work because the cash flows are not constant, or constant growth.) What is the maximum willingness to pay for this building in each case? Provide three spreadsheets showing the pro forma for each. Take a look at this: Property Information: WEST OFFICE PLAZA Rentable Area 300,000 sq. ft. Age # Stories # Tenants Financial Information: Base Rent Avg. 8 years 15 40 $20 per sq. ft. Other Income/Parking/Storage $1.50 per sq. ft. Expenses Recoverable from Tenants $2.50 per sq. ft. Current Vacancy 5% Expenses: Mgmt./Admin./Security/Ownership Property Taxes Insurance General Operations/Leasing Expense/Marketing Utilities Janitorial/Cleaning Business Taxes Other: Recurring CAPEX/Improvement Allowance $695,000 $675,000 $430,000 $667,000 $1,159,100 $489,000 $110,000 $700,000 You are an adviser to a private equity client who is thinking about buying this building. This client requires an 9% IRR after taxes are taken into account, and you are nervous because this market has shown no rent or occupancy growth for the past five years (but no declines either!) You anticipate a three year holding period. Note that this is not strictly speaking a triple net lease, but there are provisions for recovering expenses from the tenants. Do not worry about the differences in cost items between this pro forma and the example in class. Every one is different. Do not include items from the class example that are not included here. There are three scenarios, 1. Flat cash flows. 2. A 1% rise in cash flows each year. 3. Scenario 1, but with an increase in the vacancy rate from 5% to 20% in year 2. (for this one, the standard formulas will not work because the cash flows are not constant, or constant growth.) What is the maximum willingness to pay for this building in each case? Provide three spreadsheets showing the pro forma for each.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Repeat the analysis of problem 14.7, but this time focus on the Facebook call and put options in Figure 14.1 that have a strike price of $87.50. If you use put-call parity to find the price of...
-
Prepare two income statements, one using the information in Practice 28 and the other using the information in Practice 29.
-
Calculate the molar volume of saturated liquid and the molar volume of saturated vapor by the Redlich/Kwong equation for one of the following and compare results with values found by suitable...
-
On December 31, Casper, Inc., issued \(\$ 300,000\) of eight percent, ten-year bonds for \(\$ 262,613\), yielding an effective interest rate of ten percent. Semiannual interest is payable on June 30...
-
One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $ 0.10 per part, given a fore-cast you provided of...
-
Explain the layers of multilayer perceptron and give an example. (please give answer in detail and long with example clear)
-
ONE Lemon Inc. bought equipment by paying $6,000 down and issuing the seller a 3-year, noninterest-bearing note payable in three annual end-of-year installments of $3,000 each, with 5% interest...
-
What will be the total fixed costs? What will be the total fixed period costs? What will be the total fixed product costs? What will be the variable cost per box of muesli? What will be the total...
-
The popularity of non-dairy or plant-based milk among health-conscious people has been rising over recent years, due to several factors including that it consists of much less sugar compared to...
-
Crisis of North American capitalism 1. According to Marxian theory, the relationship between the falling rate of profit, technological change and profitability are explanatory and analytical factors...
-
What outcomes does the speaker look at that appear to be tied to economic inequality How does he support his argument that these outcomes are the result of economic inequality and not about the...
-
What are the implications of urbanization for public health, and how can city planning effectively address the challenges posed by increased population density ?
-
See option montage below for Google stock expiring June 6 2014. Interpret the Greeks (Delta, Vega, Theta, Rho and Gamma) for Call and Put. Call: F0614C527500 LAST: 10.7, Chg:1.45, Bid:9.6, Ask: 10.7,...
-
Before the 1973 oil embargo and subsequent increases in the price of crude oil, gasoline usage in the United States had grown at a seasonally adjusted rate of 0.57 percent per month, with a standard...
-
American Paging, Inc., is the seventh largest paging company in the United States. In a recent balance sheet, it reported a current liability of \(\$ 8,452,379\) that was labeled Unearned Revenues...
-
What do the following terms mean? (a) term loan, (b) bonds payable, (c) trustee, (d) secured bonds, (e) serial bonds, (f) call provision, (g) convertible bonds, (h) face value, (i) coupon rate, (j)...
-
What are contingent liabilities? List three examples of contingent liabilities. When should contingent liabilities be recorded in the accounts?
Study smarter with the SolutionInn App