Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to calculate the part shown in yellow, just tell me the formula. thank you 130 4 x B G L 0 Yr Yr 90.3%

image text in transcribed

How to calculate the part shown in yellow, just tell me the formula. thank you

130 4 x B G L 0 Yr Yr 90.3% Yr 2 91.5% % Yr 3 92.7% Yr 4 93.8% Yr 5 94.0% Occupancy 100.00% Gross Potential Revenue Less: VICE Rental Income 52,740,200 SO 52,740,200 52,849,808 S276,431 52,573,377 Monthly Rent S800 $1.050 $1,300 $ $1,550 $1,159 52,963,800 S251,923 52,711,877 53,082,352 $225,012 52,857,341 53.205.646 $198,70 53,006,896 Num of Units 43 67 45 42 197 53,333,872 $200,032 53,133,840 Potential Rent $34,400 $70,350 $58,500 $65,100 $228, 350 Parking Income Other Income SB2,740 S22,800 $81,885 $77,703 $23,712 SB6,277 S25,647 S90,793 S26,673 $94.626 S27,740 A . Assumptions: 2 3 INCOME: 4. Unit Type 5 Studio 1 BR 7 2BRIBA B 2BR/2BA Total 10 11 Parking Income 12 Other Income 13 14 15 EXPENSES: 16 Management Pee 17 Repair & Maintenance 1a Landscaping 19 Snow Ranoval 20 Property Taxes 21 Insurance 22 Utilities 23 Marketing Total income $2,845,740 $2,674, 791 52,818,423 $2,969,265 $35 per ocupied unit $1,900 per month $3,124,362 53, 124,362 $3,256,205 $113,967 $109,621 3.50% of total income S40 per unit per ma 53.000 per month 53,000 per month for Nov-Mar $230,000 S150,000 $4,700 per month $2,000 per month Expenses Management Fee Repairs & Maintenance Landscaping Snow Removal Property Tunes Insumo Lilities Marketing Total Expenses $99,601 $94.560 $ $36.000 SI5,000 S230,000 S] 50,000 SS6,400 S24,000 $705,561 593,615 $97,397 $37,000 SI5,450 S236,900 $154,500 S58,092 S24,720 $717,756 398,645 S100, 315 $38,192 $ SI5,914 S244,007 $159,135 S59.35 S25,462 $741,50E S103,924 $103,328 $39,338 S16,391 $ S251,327 $ 8163,909 S61,630 S26,225 $766,073 $109,353 S106,428 $411,518 S16,883 S256,867 S168,826 S6,479 S27,012 8791,366 SI2,389 S266,633 $173,891 S6,33 $27.823 8816,141 Net Operating Income $2,140, 129 $1,957,085 $ $2,076,915 $2,203, 191 $2.332.996 $2,439,765 4.00% per you 3.00% per year Yr Yr ! Yr 2 Yr 3 Yr 4 Yr 5 25 Revenue Increases 26 Experise Intereses 27 28 Disposition Cup Rate 29 30 Discount Rate 31 32 Purchase Price 10.00% % Purchase Price Operating Income Disposition Amount $56,500,000 Total Cash Flow IRR NPV 35 35 37 39 40 130 4 x B G L 0 Yr Yr 90.3% Yr 2 91.5% % Yr 3 92.7% Yr 4 93.8% Yr 5 94.0% Occupancy 100.00% Gross Potential Revenue Less: VICE Rental Income 52,740,200 SO 52,740,200 52,849,808 S276,431 52,573,377 Monthly Rent S800 $1.050 $1,300 $ $1,550 $1,159 52,963,800 S251,923 52,711,877 53,082,352 $225,012 52,857,341 53.205.646 $198,70 53,006,896 Num of Units 43 67 45 42 197 53,333,872 $200,032 53,133,840 Potential Rent $34,400 $70,350 $58,500 $65,100 $228, 350 Parking Income Other Income SB2,740 S22,800 $81,885 $77,703 $23,712 SB6,277 S25,647 S90,793 S26,673 $94.626 S27,740 A . Assumptions: 2 3 INCOME: 4. Unit Type 5 Studio 1 BR 7 2BRIBA B 2BR/2BA Total 10 11 Parking Income 12 Other Income 13 14 15 EXPENSES: 16 Management Pee 17 Repair & Maintenance 1a Landscaping 19 Snow Ranoval 20 Property Taxes 21 Insurance 22 Utilities 23 Marketing Total income $2,845,740 $2,674, 791 52,818,423 $2,969,265 $35 per ocupied unit $1,900 per month $3,124,362 53, 124,362 $3,256,205 $113,967 $109,621 3.50% of total income S40 per unit per ma 53.000 per month 53,000 per month for Nov-Mar $230,000 S150,000 $4,700 per month $2,000 per month Expenses Management Fee Repairs & Maintenance Landscaping Snow Removal Property Tunes Insumo Lilities Marketing Total Expenses $99,601 $94.560 $ $36.000 SI5,000 S230,000 S] 50,000 SS6,400 S24,000 $705,561 593,615 $97,397 $37,000 SI5,450 S236,900 $154,500 S58,092 S24,720 $717,756 398,645 S100, 315 $38,192 $ SI5,914 S244,007 $159,135 S59.35 S25,462 $741,50E S103,924 $103,328 $39,338 S16,391 $ S251,327 $ 8163,909 S61,630 S26,225 $766,073 $109,353 S106,428 $411,518 S16,883 S256,867 S168,826 S6,479 S27,012 8791,366 SI2,389 S266,633 $173,891 S6,33 $27.823 8816,141 Net Operating Income $2,140, 129 $1,957,085 $ $2,076,915 $2,203, 191 $2.332.996 $2,439,765 4.00% per you 3.00% per year Yr Yr ! Yr 2 Yr 3 Yr 4 Yr 5 25 Revenue Increases 26 Experise Intereses 27 28 Disposition Cup Rate 29 30 Discount Rate 31 32 Purchase Price 10.00% % Purchase Price Operating Income Disposition Amount $56,500,000 Total Cash Flow IRR NPV 35 35 37 39 40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Planning

Authors: Michael A Dalton, Joseph Gillice

3rd Edition

1936602091, 9781936602094

More Books

Students also viewed these Finance questions

Question

8.1 Define ethics.

Answered: 1 week ago