도심임대사업투자분석

소개글

도심임대사업투자분석 엑셀시트입니다.

목차

Yeild
Risk

본문내용

EGI 4,190 4,337 4,489 4,646 4,809 4,977 5,151 5,331 5,518 5,711
Base Rent 4,320 4,471 4,628 4,790 4,957 5,131 5,310 5,496 5,689 5,888
Vacancy 130 134 139 144 149 154 159 165 171 177

Operating Expense 512 532 552 574 597 621 646 672 700 729
Maintenance 32 35 38 42 46 51 56 62 68 75
Management Cost 480 497 514 532 551 570 590 611 632 654

NOI 3,679 3,805 3,936 4,072 4,211 4,356 4,505 4,659 4,818 4,982

Depreciation 350 350 350 350 350 350 350 350 350 350
Debt Service 2,020 2,020 2,020 2,020 2,020 2,020 2,020 2,020 2,020 2,020
Principle 116 127 140 154 170 186 205 226 248 273
Interest 1,904 1,893 1,880 1,866 1,851 1,834 1,815 1,795 1,772 1,747
Interest Income(6%/Y) 54 58 62 67 71 76 81 86 91 96

NIBT 1,478 1,621 1,769 1,922 2,082 2,248 2,421 2,600 2,787 2,981
Corp. Tax 455 499 545 592 641 692 746 801 858 918

Net Cash Flow -12,696 1,257 1,344 1,434 1,526 1,621 1,719 1,820 1,924 2,030 25,949

NOI Rate 87.79% 87.74% 87.69% 87.64% 87.58% 87.52% 87.46% 87.39% 87.32% 87.24%
NOI / Pyung 0.523 0.541 0.559 0.578 0.598 0.619 0.640 0.662 0.684 0.708

참고 자료

없음