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 of the property?

If possible, please use a financial calculator and show me how to solve as I need to learn this concept for this class.

Expert Solution


Potential Gross Income	Amount
Number of Units	125
Annual Rent	12000
(1000*12)
Total Annual Rent	1500000

Effective Gross Income	Amount
Number of Units	125
Annual Rent	12000
(1000*12)
Total Annual Rent	1500000
(-) Provision for Vacancy Loss @ 5%	75000
Actual Rental Income	1425000
(-) Collection Loss @ 2%	28500
Effective Gross Income	1396500

Net operating Income	Amount
Effective Gross Income	1396500
(-) Operating Expenses	800000
(-) Debt Services	360000
Net Operating income	236500

Before tax Cashflow will be same as the NET Operating income since we have not considered any tax or
noncash item in the calculation
Value of the Property
it will be the PV of the Future Cashflows (considered annually)
		(125 Units* 1000 Rent)
Particulars	Month	Amount	PV Factor	PV amount
Monthly Lease Rent	1	125000	0.913242	114155.250
Monthly Lease Rent	2	125000	0.834011	104251.375
Monthly Lease Rent	3	125000	0.761654	95206.75
Monthly Lease Rent	4	125000	0.695574	86946.75
Monthly Lease Rent	5	125000	0.635228	79403.5
Monthly Lease Rent	6	125000	0.580117	72514.625
Monthly Lease Rent	7	125000	0.529787	66223.375
Monthly Lease Rent	8	125000	0.483824	60478.00
Monthly Lease Rent	9	125000	0.441848	55231.00
Monthly Lease Rent	10	125000	0.403514	50439.25
Monthly Lease Rent	11	125000	0.368506	46063.25
Monthly Lease Rent	12	125000	0.336535	42066.875
		Value of Property		872980
* Only cashflows of income is considered while calculating the value of the property

jeff jeffy answered 2 years ago

Suppose that an investor is considering the purchase of an multifamily housing. The potential gross income...

Suppose that an investor is considering the purchase of an multifamily housing. The potential gross income of the first year of operations has been estimated at $550,000. To value the property, the investor assume the following factors: Rents are estimated to increase by 2.5% per year. 5.5% vacancy loss rate and no other income. The vacancy loss rate will remain constant. Fixed and variable expenses were estimated at $97,000 and $155,000, respectively. These expenses will continue to represent the same...

The airport will have an effective gross income of $30 million over the next year and...

The airport will have an effective gross income of $30 million over the next year and operating expenses that are 20% of effective gross income over the forecast horizon after being $10 million this year due to a major renovation. The effective gross income is expected to continue to grow at the rate of the local economy which is a steady 3.25%. A going-in cap rate based on some fairly stale comparables in this highly illiquid market is 6.75% and...

____ is the base used to calculate income tax. a. taxable income b. gross income c....

____ is the base used to calculate income tax. a. taxable income b. gross income c. adjusted gross income d. economic income

a. Compute Kunto’s gross income from the certificate for 2018. b. Compute Kunto’s gross income from the certificate for 2019.

On January 1, 2018, Kunto, a cash basis taxpayer, pays $46,228 for a 24-month certificate. The certificate is priced to yield 4% (the effective interest rate) with interest compounded annually. No interest is paid until maturity', when Kunto receives $50,000. In your computations:a. Compute Kunto’s gross income from the certificate for 2018.b. Compute Kunto’s gross income from the certificate for 2019.Round any amounts to the nearest dollar.

What is the effect on Belinda's gross income?

Belinda spent the last 60 days of 2018 in a nursing home. The cost of the services provided to her wras $18,000 ($300 per day). Medicare paid $8,500 toward die cost of her stay. Belinda also received $5,500 of benefits under a long-term care insurance policy she purchased. What is the effect on Belinda's gross income?

What is an explanation of the concept of gross income?

A potential client wants to know if Social Security benefits are included in his gross income...

A potential client wants to know if Social Security benefits are included in his gross income for tax purposes. Other than the amount of the Social Security benefits and excluded foreign income, what information do you need to know to make the determination? (Points will be deducted for listing items that would not be needed in making the determination.)

Given the following information, calculate the debt coverage ratio for this investment: Potential gross income: $123,500;...

Given the following information, calculate the debt coverage ratio for this investment: Potential gross income: $123,500; Vacancy rate: 5%; Net operating income: $64,975; Operating expenses: $52,350; Acquisition Price: $625,000; Debt service: $45,620. Can you teach me how to do this on excel?

What are the specific items that are included in the computation of gross income and the...

What are the specific items that are included in the computation of gross income and the specific items that are excluded from gross income. What are some of the items that are specifically included in the calculation of gross income? What items have been specifically excluded in the computation of gross income? Are you surprised by any of these items? Why do you think that Congress specifically included or excluded any of these items? Does an exclusion from income mean...

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...

Question