You are considering the purchase of an office building for $4,000,000. You anticipate $750,000 first-year gross...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are considering the purchase of an office building for $4,000,000. You anticipate $750,000 first-year gross potential income; vacancy and collection loss equal to 10% of gross potential income; miscellaneous income equal to 2% of PGI; operating expenses equal to 40% of effective gross income; and capital expenditures equal to 5% of EGI. You have arranged a mortgage loan of $2,800,000 with an annual interest rate of 6%. The loan will be amortized over 20 years with a monthly payment of $20,060. Total upfront financing cost will equal 2% of the loan amount. Fill out the cash-flow analysis below and answer/calculate the following questions. Item Potential Gross Income (PGI): Less Vacancy and Collection Loss (VC): Miscellaneous Income: = Effective Gross Income (EGI): Less Operating Expenses (OE): Less Capital Expenditures (CAPX): Amount = Net Operating Income (NOI): Less Debt Service (DS): = Before-Tax Cash Flow (BTCF): $ 1) What is the Net Operating Income (NOI)? 2) What is the CAP Rate? 3) Calculate the Effective Gross Income Multiplier (EGIM): 4) What is the required equity investment? 5) Calculate the Equity Dividend Rate (EDR): 6) Calculate the Net Income Multiplier (NIM): 7) Calculate the Operating Expense Ratio (OER): 8) Calculate the Debt Coverage Ratio (DCR): 9) Calculate the Debt Yield Ratio (DYR): 10) Calculate the Loan-to-value Ratio (LTV): You are considering the purchase of an office building for $4,000,000. You anticipate $750,000 first-year gross potential income; vacancy and collection loss equal to 10% of gross potential income; miscellaneous income equal to 2% of PGI; operating expenses equal to 40% of effective gross income; and capital expenditures equal to 5% of EGI. You have arranged a mortgage loan of $2,800,000 with an annual interest rate of 6%. The loan will be amortized over 20 years with a monthly payment of $20,060. Total upfront financing cost will equal 2% of the loan amount. Fill out the cash-flow analysis below and answer/calculate the following questions. Item Potential Gross Income (PGI): Less Vacancy and Collection Loss (VC): Miscellaneous Income: = Effective Gross Income (EGI): Less Operating Expenses (OE): Less Capital Expenditures (CAPX): Amount = Net Operating Income (NOI): Less Debt Service (DS): = Before-Tax Cash Flow (BTCF): $ 1) What is the Net Operating Income (NOI)? 2) What is the CAP Rate? 3) Calculate the Effective Gross Income Multiplier (EGIM): 4) What is the required equity investment? 5) Calculate the Equity Dividend Rate (EDR): 6) Calculate the Net Income Multiplier (NIM): 7) Calculate the Operating Expense Ratio (OER): 8) Calculate the Debt Coverage Ratio (DCR): 9) Calculate the Debt Yield Ratio (DYR): 10) Calculate the Loan-to-value Ratio (LTV):
Expert Answer:
Answer rating: 100% (QA)
1 Net Operating Income NOI Potential Gross Income PGI 750000 Vacancy and Collection Loss VC 10 of PG... View the full answer
Related Book For
Microeconomics
ISBN: 9781464146978
1st Edition
Authors: Austan Goolsbee, Steven Levitt, Chad Syverson
Posted Date:
Students also viewed these finance questions
-
You are considering the purchase of an office building for $1.5 million today. Your expectations include the following: first-year potential gross income of $340,000; vacancy and collection losses...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Maria owns and runs her own online premium clothing business (sole trader) named "Maria's Clothing Solutions (MS). Her main competitor is "Brenda's Extraordinary Clothing (BC). She is interested in...
-
Two firms, the Alliance Company and the Bangor Corporation, produce vision systems. The demand curve for vision systems is P = 200,000 - 6(Q1 + Q2) where P is the price (in dollars) of a vision...
-
Analysis of flexible budgets and standard costs emphasizes the importance of a similar unit of measure for meaningful comparisons and evaluations. When Research In Motion compiles its financial...
-
For the production of ethylene glycol, how much is the economic potential per pound of ethylene glycol reduced when chlorine and caustic are used to avoid the production of ethylene oxide?
-
Higgins Company produced 50,000 units, 10,000 more than budgeted. Production data are as follows. Except for physical units, all quantities are in dollars. 1. Fill in the unknowns. 2. Give a brief...
-
a- What is the output of implementing the class Entity2 in the following code class Entity1 { public Entity1() { } System.out.println("Entity1's no-arg constructor is invoked"); } class Entity3...
-
A sky diver jumps out of a plane at a height of 5000 ft. if her parachute does not open until she reaches 1000 ft, what is her velocity at that point if air resistance is disregarded? 488 ft/s 505...
-
The Following problems will lead you to find the moment of inertia of a uniform thick spherical shell of inner radius b and mass M. (The moment of inertia of a thin spherical shell is I = 2MR/3). 8)...
-
Make a recommendation to the task force for which of the two models would be the best choice for the planning and implementation of the DEI initiative. Explain the rationale for your decision based...
-
Megan and Martha own competing hair salons that are in the same neighborhood. They are both considering offering their clients discounts in order to increase business. The payoff matrix shows their...
-
You must update the package cache after modifying sources.list or to fetch any upstream changes. You do this by running command. O apt-get sources-list O apt-get update O apt-get refresh apt-get...
-
Question 3.What are the NPV, IRR, MIRR, payback period, and discounted payback period for Boeing's new plane? A New Aircraft Project at Boeing, Inc. Boeing announced the production of a new passenger...
-
Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gas station. Susan?s problem is to decide how large her...
-
The manager for retail customers, Katie White, wants to hear your opinion regarding one business offer she has received from an entrepreneur who is starting a mobile phone app called Easy Money. The...
-
Company G has a hardware business. The balance sheet at the beginning of the financial year showed the position in Table 2.23. Show the adjustments, in the columns provided, for each of the following...
-
This information has been taken from the companys books as at 31 December 20X1, but the information below has not been allowed for. (a) Inventory at 31 December 20X1 is 20,000. (b) Plant and...
-
The information has been taken from the companys books as at 31 December 20X1, but the following has not been allowed for. (a) Inventory at the end of the year is 25,000. (b) Audit fees owing...
Study smarter with the SolutionInn App