to home page  Home   E-Mail  SiteTree (all case studies)    HomePage    Index (this case study)    MV    AVI    ALTI    Format420    Format418    Format424    Format426    Format421    Format409    Format410    Format401    Format423    Format413    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format407    Format408    Format415    Format416    Format417   

MXD Proposal, Scenario 2-A:Phase 1: Hotel

Schedule *: Operating Cash Flow

Annual

  Total 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000
CAPITAL ACCOUNTS                      
Capital Replacement                      
Ending Value 29,494,309                   29,494,309
Capital Before Financing -1464856 -30959165                 29,494,309
Principal Flows 9,594,108 24,868,000                 -15273892
Equity Cash Flow 8,129,251 -6091165                 14,220,416
Subtotal: CAPITAL ACCOUNTS 45,752,811 -12182330                 57,935,141
                       
OPERATING ACCOUNTS                      
Income 124,900,336 4,599,656 10,551,371 11,910,855 12,387,289 12,882,780 13,398,092 13,934,015 14,491,376 15,071,031 15,673,872
Expense -102337443 -5495395 -8493854 -9588238 -9971767 -10370638 -10785464 -11216882 -11665558 -12132180 -12617467
Net Avail. for DS 22,562,893 -895740 2,057,517 2,322,617 2,415,521 2,512,142 2,612,628 2,717,133 2,825,818 2,938,851 3,056,405
Debt Service -18451787 -971147 -1942293 -1942293 -1942293 -1942293 -1942293 -1942293 -1942293 -1942293 -1942293
Ground Rent                      
Participation                      
Cash Flow 4,111,106 -1866887 115224 380323 473228 569849 670335 774840 883525 996558 1,114,112
Amortization 2,538,108 82243 177298 195863 216373 239030 264059 291710 322255 356000 393277
Earnings BNCC 6,649,214 -1784643 292522 576186 689601 808878 934394 1,066,549 1,205,780 1,352,557 1,507,389
Depreciation -13432312 -1130119 -2119790 -1879020 -1707042 -1584200 -1346300 -1108400 -954848 -801296 -801296
Taxable Income -6783098 -2914762 -1827268 -1302834 -1017441 -775322 -411907 -41851 250932 551261 706093
Subtotal: OPERATING ACCOUNTS 19,757,016 -10376794 -1189273 673459 1,543,467 2,340,226 3,393,543 4,474,820 5,416,988 6,390,489 7,090,092
                       
Total 65,509,828 -22559124 -1189273 673459 1,543,467 2,340,226 3,393,543 4,474,820 5,416,988 6,390,489 65,025,234



 Home   E-Mail  home at CD root