Question

In: Finance

Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $  ...

Potential Gross Income 100,000 sq. ft for the coming year

average rent $15.00 per ft.

$   1,500,000

Less Vacancy Allowance (average 8%)

$     (120,000)

Effective Gross Income

$   1,380,000

Cleaning expenses (5% of net rev)

$      (69,000)

Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft.

$      (80,000)

Management & Maintenance (11% of revenue)

$    (151,800)

Reserve for Replacement (savings for major repairs)

$      (50,000)

Property Taxes ($0.10 per $100 of R.C.)

$          (4,000)

$    (354,800)

Estimated Net Operating Income

$   1,025,200

What is the NPV of this investment at a discount rate of 12% ? (use purcahse price of 9,500,00)

Solutions

Expert Solution

NPV of the investment = Present value of estimated Net Operating Income - Purchase price

Present value of estimated net operating income = Estimated net operating income / (1 + Discount rate)

= $1,025,200 / (1 + 12%)

= $1,025,200 / 1.12

= $915,357.143

NPV of the investment = $915,357.143 - $9,500,000

= $(-8,584,642.86)


Related Solutions

Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $  ...
Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10 per $100 of R.C.) $          (4,000) $    (354,800) Estimated Net...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider the following pro forma for the next 4questionsPotential Gross Income 100,000 sq. ft...
Consider the following pro forma for the next 4 questions Potential Gross Income 100,000 sq. ft for the coming year average rent $15.00 per ft. $   1,500,000 Less Vacancy Allowance (average 8%) $     (120,000) Effective Gross Income $   1,380,000 Cleaning expenses (5% of net rev) $      (69,000) Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. $      (80,000) Management & Maintenance (11% of revenue) $    (151,800) Reserve for Replacement (savings for major repairs) $      (50,000) Property Taxes ($0.10...
Consider a 100,000 sq. ft. building that will be acquired (at price $0) and demolished by...
Consider a 100,000 sq. ft. building that will be acquired (at price $0) and demolished by local government at the end of 15 years.  Assume the building is fully leased building under an absolute net lease structure (all expenses paid by tenant); Consider 2 leases:       15 year lease at $15/ft./yr.       5 year lease at $15/ft./yr. Suppose that $15 is the market rate and that the forecasted rent growth rate is 0% . Also suppose that the discount rate for contractual lease...
Average area covered by a can of 1-gallon paint is 513.3 sq ft with a variance...
Average area covered by a can of 1-gallon paint is 513.3 sq ft with a variance of 992.25 sq ft. Ascertain the probability that the mean area covered by a sample of 40 of these 1-gallon cans will be between 510 to 520 sq ft?
Market rent is currently $50/sqft per year for 100,000 sqft. Market rent increases 2% annually. Vacancy...
Market rent is currently $50/sqft per year for 100,000 sqft. Market rent increases 2% annually. Vacancy is 7% of PGI each year. Operating expenses are $30/sqft per year and increasing by 3$ annually. Create the pro forma cash flow statement for the next five years showing PGI, EGI, and NOI.
You currently pay $10,000 per year in rent to a landlord for a $100,000 house, which...
You currently pay $10,000 per year in rent to a landlord for a $100,000 house, which you are considering purchasing. You can qualify for a loan of $80,000 at 9% if you put $20,000 down on the house. To raise money for the down payment, you would have to liquidate stock earning you a 15% return. We neglect other concerns, like closing costs, capital gains, and tax consequences of owning. 1. Explain the concept of opportunity cost. 2. Explain the...
a. What is the Potential Gross Income (PGI)? b. What is the Effective Gross Income (EGI)?
Given the following: Number of Units                     125 Vacancy Rate                          5% Monthly Rent                          $1,000 Operating Expenses                $800,000 Collection Loss                       2% Debt Service                            $360,000 Calculate on an Annual Basis: (There are no negative numbers in this answer) a. What is the Potential Gross Income (PGI)? b. What is the Effective Gross Income (EGI)? c. What is the Net Operating Income (NOI)? d. What is the Before Tax Cash Flow (BTCF)? e. Utilizing a capitalization rate of 9.5%, what is the estimated value...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT