Question

In: Accounting

1a. You have been asked to develop a pro forma statement of cash flow for an...

1a. You have been asked to develop a pro forma statement of cash flow for an office plaza. The information given to you is listed below:

Property Information:

               Age                                                                                        8 years

               Rentable Space                                                                 300,000 sq.ft.

                # Stories                                                                              15

                # Tenants                                                                            40

    Financial Information:

                Base Rent Avg.                                                                  $20 per sq.ft.

                Other Income/Parking                                                   $1.50 per sq.ft.

                Expenses Recoverable from Tenants                       $2.50 per sq.ft.

                Current Vacancy                                                               equals to 5% of base rents

                Expenses

                Mgmt./Admin./Security                                                $695,000

                Property Taxes                                                                  $675,000

                Insurance                                                                            $430,000

                General Operations/Leasing Expense                      $667,000

                Utilities                                                                                 $1,159,100

                Janitorial/Cleaning                                                           $489,000

                Business Taxes                                                                  $110,000

                Other  

                Recurring CAPEX/Improvement Allowance           $700,000

   

   What is the net operating income for the office plaza based on the pro forma statement of cash flow for a base year you developed?

A. $1,074,900

B. $1,974,900

C. $1,524,900

D. $2,274,900

1b. A building owner is evaluating the following alternatives for leasing space in an office building for the next five years (using a 5% discount rate):

  1. Net lease with steps. Rent will be $10/ square foot the first year and will increase by $1.50 per square foot each year until the end of the lease.
  2. Net lease with CPI adjustments. The rent will be $12 /square foot the first year. After the first year, the rent will be increased by the amount of any increase in the CPI. The CPI is expected to increase 4% per year.
  3. Gross lease. Rent will be $28/square foot each year with the lessor responsible for payment of all operating expense. Expenses are estimated to be $10 during the first year and increase by $1 per year thereafter.
  4. Gross lease with expense stop and CPI adjustment. Rent will be $20 the first year and increase by the full amount of any change in the CPI after the first year with an expense stop at $10/square foot. The CPI and operating expenses are assumed to change by the same amount as outlined in II and III.

What is the effective rent to the owner (after expenses) for Net lease with CPI adjustments?

A. 13.00/ square foot

B. 56.06/ square foot

C. 12.95/ square foot

D. 14.22/ square foot

Solutions

Expert Solution

Q1 :

Answer : ( B ) $ 1,9 74,900

Q2 :


Related Solutions

Develop a pro forma set of income and cash flow statements for a wind energy plant...
Develop a pro forma set of income and cash flow statements for a wind energy plant with the following parameters, and calculate the plant’s NPV, IRR and LCOE: -Overnight capital costs are $1.2 million, all incurred in Year 0. There is no land acquisition cost assumed here. -The plant has a salvage value of $200,000 at the end of the plant’s life -Annual revenues from spot market sales are $400,000. -Annual operating costs are $30,000. -The plant qualifies for the...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for three years to calculate the the NPV and IRR. Assess project feasibility using NPV and IRR method. Company is Z-energy For the data part you can refer to the Yahoo finance or assume any relevant data according to the company
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for three years to calculate the the NPV and IRR. Assess project feasibility using NPV and IRR method. Company is Z-energy For the data part you can refer to the Yahoo finance or assume any relevant data according to the company
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s Oil Service Company: Actual Sales 3rd QTR                    Estimated Sales 4th QTR July        $1,200,000                               Oct.                $3,000,000 Aug.       $1,400,000                              Nov. $5,000,000 Sept.     $1,600,000                              Dec.                $7,000,000 ****************************************************************** Actual Purchases 3rd QTR             Estimated Purchases 4th QTR July       $1,000,000                              Oct.                  $3,000,000 Aug.      $1,500,000                               Nov.    $4,000,000 Sept.     $2,000,000                               Dec.               $1,000,000 __________________________________________________________________ One-half (50 percent) of the sales each month are...
Develop a pro forma income statement and balance sheet for the company given below. Use the...
Develop a pro forma income statement and balance sheet for the company given below. Use the following assumptions in making your pro forma: Currently, fixed assets are at full capacity Each asset grows proportionally with sales Payables and accruals grow proportionally with sales 2017’s profit margin (2.52%) and dividend payout (30%) will be maintained in 2018 Sales are projected to increase by $500 million (25%) Interest payments will not change (this is not realistic, but will save you some steps)...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
You have developed the following pro forma income statement for your​ corporation:   LOADING.... It represents the...
You have developed the following pro forma income statement for your​ corporation:   LOADING.... It represents the most recent​ year's operations, which ended yesterday. Your supervisor in the​ controller's office has just handed you a memorandum asking for written responses to the following​ questions: a.  If sales should increase by 25 ​percent, by what percent would earnings before interest and taxes and net income​ increase? b.  If sales should decrease by 25 ​percent, by what percent would earnings before interest and...
Describe the Pro Forma statement and the percent of sales method for future cash needs. What...
Describe the Pro Forma statement and the percent of sales method for future cash needs. What are the pros and cons of each method? Which method would you prefer to use and why?
2) What are the major differences between a “Pro Forma” Income Statement and a Cash Budget...
2) What are the major differences between a “Pro Forma” Income Statement and a Cash Budget (another name for this is Cumulative Cash Flow Statement). What would be the significance for each to a perspective lender?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT