Discounted Cash Flow [2964]

Home  Previous  Next

 

 

 

 

 

 

 

Item

Year 1

Year 2

Year 3

Year 4

Year 5

Reversion

Potential Gross Income

$1,762,500

$1,797,750

$1,833,705

$1,870,379

$1,907,787

$1,945,942

 Less: Allowances

141,000

143,820

146,696

149,630

152,623

155,675

 Add: Other Income

84,000

85,680

87,394

89,141

90,924

92,743

Effective Gross Income

$1,705,500

$1,739,610

$1,774,402

$1,809,890

$1,846,088

$1,883,010

Operating Expenses

 

 

 

 

 

 

Management

$51,975

$53,015

$54,075

$55,156

$56,259

$57,385

Utilities

277,200

282,744

288,399

294,167

300,050

306,051

Taxes

259,875

265,073

270,374

275,781

281,297

286,923

Insurance

60,638

61,851

63,088

64,350

65,637

66,949

Janitorial

86,625

88,358

90,125

91,927

93,766

95,641

Office

43,313

44,179

45,063

45,964

46,883

47,821

Repairs/Maintenance

103,950

106,029

108,150

110,313

112,519

114,769

Reserves

133,322

133,322

133,322

66,661

66,661

66,661

Total Operating Expense

$1,016,898

$1,034,570

$1,052,594

$1,004,318

$1,023,072

$1,042,200

 

 

 

 

 

 

 

Net Operating Income

$688,602

$705,040

$721,808

$805,572

$823,016

$840,810

Reversion Cap Rate

 

 

 

 

 

0.12

Reversion Value

 

 

 

 

 

$7,006,750

Discount Rate (12%)

0.892857

0.797194

0.711780

0.635518

0.567427

0.567427

Present value

$614,823

$562,054

$513,768

$511,955

$467,002

$3,975,818

Present value/cash flows

$6,645,421

 

 

 

 

Market Value (Rounded)

$6,645,000

 

 

 

 

 

 

 

 

 

 

 

 

Sale Price

$6.645,000

 

 

 

 

 

Mortgage Position

70%

$4,651,500

- Mortgage

 

 

 

Equity Position

30%

$1,993,500

- Equity

 

 

 

Mortgage Constant

0.0943929

 

 

 

 

 

Rate (7%)

 

 

 

 

 

 

Term (20 years)

 

 

 

 

 

 

Annual Debt Service

$439,069

 

 

 

 

 

Equity Dividend

$249,533

 

 

 

 

 

Equity Dividend Rate

12.52%

 

 

 

 

 

Cap Rate - Band of Investment

10.36%

 

 

 

 

 

Cap Rate - Debt Coverage Method

10.36%

 

 

 

 

 

Debt Coverage Ratio

1.57

 

 

 

 

 

Net Income Ratio

1.68

 

 

 

 

 

Operating Expense Ratio

0.60

 

 

 

 

 

 

 

 

 

 

 

 


Georgia Appraiser Home Page | Reload