RESONANTPROFORMA
v2.305.0.0 · 26-0613
Cedar Grove Apartments·v
SCN
MS auth not configured
InputPulldownDerivedRead-onlyProgrammaticAuto-fillOverriddenTCAC AppDisabledAnswer
Sources − Uses0feasible
Debt Coverage Ratio1.150≥ 1.15
Tiebreaker22.162%rank 6 of 8 · At-Risk
Win Probability0% / 0%vs cutoff (0.6109) / vs simulator
Deferred Developer Fee1.52MMno escape valve
DealDashboardInputsRent RollOperating ExpensesDebt ExecutionNOICosts & BasisTimelineInvestor IRR9% ApplicationPoints SystemTiebreakerCompetition
1 site· 5 slots available
Y1 NOI
871,251
post-reno, net of reserves
Y1 Debt Service
757,663
amortizing first mortgage
Y1 DCR
1.15x
< 1.15 floor
Y1 Replacement Reserve
28,000
deducted before NOI
Y15 NOI
1,125,146
after escalation to exit
NOI Roll-up — Deal Level (50 Year)
Years shown:
Line ItemEsc %PUPY202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055
Income
Gross Potential Rent - Residential2.50%11,504920,340943,348966,932991,1061,015,8831,041,2801,067,3121,093,9951,121,3451,149,3791,178,1131,207,5661,237,7551,268,6991,300,4161,332,9271,366,2501,400,4061,435,4161,471,3021,508,0841,545,7861,584,4311,624,0421,664,6431,706,2591,748,9151,792,6381,837,4541,883,391
Vacancy Loss3.00%-345(27,610)(28,300)(29,008)(29,733)(30,476)(31,238)(32,019)(32,820)(33,640)(34,481)(35,343)(36,227)(37,133)(38,061)(39,012)(39,988)(40,987)(42,012)(43,062)(44,139)(45,243)(46,374)(47,533)(48,721)(49,939)(51,188)(52,467)(53,779)(55,124)(56,502)
Rental Assistance Overhang - HAP / PBV2.50%6,275501,984514,534527,397540,582554,096567,949582,148596,701611,619626,909642,582658,647675,113691,990709,290727,023745,198763,828782,924802,497822,559843,123864,201885,806907,951930,650953,917977,7641,002,2091,027,264
Vacancy Loss - Rental Assistance Overhang3.00%-188(15,060)(15,436)(15,822)(16,217)(16,623)(17,038)(17,464)(17,901)(18,349)(18,807)(19,277)(19,759)(20,253)(20,760)(21,279)(21,811)(22,356)(22,915)(23,488)(24,075)(24,677)(25,294)(25,926)(26,574)(27,239)(27,920)(28,617)(29,333)(30,066)(30,818)
Subtotal: Net Rental Income17,2461,379,6541,414,1461,449,4991,485,7371,522,8801,560,9521,599,9761,639,9751,680,9751,722,9991,766,0741,810,2261,855,4821,901,8691,949,4151,998,1512,048,1052,099,3072,151,7902,205,5852,260,7242,317,2422,375,1732,434,5532,495,4162,557,8022,621,7472,687,2912,754,4732,823,335
Other Income2.50%26921,50022,03722,58823,15323,73224,32524,93325,55726,19626,85127,52228,21028,91529,63830,37931,13831,91732,71533,53334,37135,23036,11137,01437,93938,88839,86040,85641,87842,92543,998
Vacancy Loss3.00%-8(645)(661)(678)(695)(712)(730)(748)(767)(786)(806)(826)(846)(867)(889)(911)(934)(958)(981)(1,006)(1,031)(1,057)(1,083)(1,110)(1,138)(1,167)(1,196)(1,226)(1,256)(1,288)(1,320)
Subtotal: Other Income26120,85521,37621,91122,45923,02023,59624,18524,79025,41026,04526,69627,36428,04828,74929,46830,20430,95931,73332,52733,34034,17335,02835,90336,80137,72138,66439,63140,62141,63742,678
Total: Net Income17,5061,400,5091,435,5221,471,4101,508,1951,545,9001,584,5481,624,1611,664,7651,706,3851,749,0441,792,7701,837,5901,883,5291,930,6181,978,8832,028,3552,079,0642,131,0402,184,3172,238,9242,294,8982,352,2702,411,0772,471,3542,533,1372,596,4662,661,3782,727,9122,796,1102,866,013
Expense
Administrative
6250-002Credit Services3.50%54004144284434594754925095275455645846046266476706947187437697968248538829139459781,0131,0481,085
6311-000Office Supplies3.50%564,5004,6584,8214,9895,1645,3455,5325,7255,9266,1336,3486,5706,8007,0387,2847,5397,8038,0768,3598,6518,9549,2679,5929,92810,27510,63511,00711,39211,79112,203
6311-001Telephone3.50%453,6003,7263,8563,9914,1314,2764,4254,5804,7414,9065,0785,2565,4405,6305,8276,0316,2426,4616,6876,9217,1637,4147,6737,9428,2208,5088,8059,1149,4339,763
6311-002Internet3.50%97007257507768038318608919229549871,0221,0581,0951,1331,1731,2141,2561,3001,3461,3931,4421,4921,5441,5981,6541,7121,7721,8341,898
6311-003Postage3.50%119009319649981,0331,0691,1061,1451,1851,2271,2701,3141,3601,4081,4571,5081,5611,6151,6721,7301,7911,8531,9181,9862,0552,1272,2012,2782,3582,441
6340-000Legal3.50%504,0004,1404,2854,4354,5904,7514,9175,0895,2675,4525,6425,8406,0446,2566,4756,7016,9367,1797,4307,6907,9598,2388,5268,8249,1339,4539,78410,12610,48110,848
6350-000Audit & Tax Returns3.50%1008,0008,2808,5708,8709,1809,5019,83410,17810,53410,90311,28511,68012,08912,51212,95013,40313,87214,35714,86015,38015,91816,47517,05217,64918,26718,90619,56820,25320,96121,695
6390-000Payroll Administrative Expense3.50%131,0001,0351,0711,1091,1481,1881,2291,2721,3171,3631,4111,4601,5111,5641,6191,6751,7341,7951,8571,9231,9902,0592,1322,2062,2832,3632,4462,5322,6202,712
6390-004Travel3.50%86506736967217467727998278568869179499821,0171,0521,0891,1271,1671,2071,2501,2931,3391,3851,4341,4841,5361,5901,6461,7031,763
6390-005Staff Training & Compliance3.50%191,5001,5521,6071,6631,7211,7821,8441,9081,9752,0442,1162,1902,2672,3462,4282,5132,6012,6922,7862,8842,9853,0893,1973,3093,4253,5453,6693,7973,9304,068
6390-015Software3.50%443,5003,6223,7493,8814,0164,1574,3024,4534,6094,7704,9375,1105,2895,4745,6655,8646,0696,2816,5016,7296,9647,2087,4607,7217,9928,2718,5618,8609,1719,492
Staff Payroll + PM Fee (derived)3.50%1,253100,255103,764107,396111,155115,045119,072123,239127,553132,017136,638141,420146,370151,493156,795162,283167,963173,841179,926186,223192,741199,487206,469213,695221,175228,916236,928245,220253,803262,686271,880
Subtotal: Administrative1,613129,005133,520138,194143,030148,037153,218158,580164,131169,875175,821181,975188,344194,936201,759208,820216,129223,693231,523239,626248,013256,693265,678274,976284,600294,561304,871315,542326,586338,016349,847
Utilities
6450-000Electricity3.50%1139,0009,3159,6419,97810,32810,68911,06311,45111,85112,26612,69513,14013,60014,07614,56815,07815,60616,15216,71717,30317,90818,53519,18419,85520,55021,26922,01422,78423,58224,407
6451-000Water3.50%23118,50019,14819,81820,51121,22921,97222,74123,53724,36125,21426,09627,00927,95528,93329,94630,99432,07933,20134,36435,56636,81138,09939,43340,81342,24243,72045,25046,83448,47350,170
6452-000Gas3.50%23118,50019,14819,81820,51121,22921,97222,74123,53724,36125,21426,09627,00927,95528,93329,94630,99432,07933,20134,36435,56636,81138,09939,43340,81342,24243,72045,25046,83448,47350,170
6453-000Sewer3.50%38831,00032,08533,20834,37035,57336,81838,10739,44140,82142,25043,72945,25946,84348,48350,18051,93653,75455,63557,58259,59861,68363,84266,07768,39070,78373,26175,82578,47981,22584,068
6454-000Trash3.50%35028,00028,98029,99431,04432,13133,25534,41935,62436,87138,16139,49740,87942,31043,79145,32346,91048,55250,25152,01053,83055,71457,66459,68261,77163,93366,17168,48770,88473,36575,933
Derived3.50%0
Subtotal: Utilities1,313105,000108,675112,479116,415120,490124,707129,072133,589138,265143,104148,113153,297158,662164,215169,963175,912182,069188,441195,036201,863208,928216,240223,809231,642239,749248,141256,826265,815275,118284,747
Operating & Maintenance
6515-000Supplies - Janitorial3.50%64504664824995165345535735936136356576807047287547808088368658959279599931,0271,0631,1011,1391,1791,220
6515-001Supplies - Repair3.50%695,5005,6935,8926,0986,3116,5326,7616,9987,2427,4967,7588,0308,3118,6028,9039,2149,5379,87110,21610,57410,94411,32711,72312,13412,55812,99813,45313,92414,41114,915
6515-003Supplies - Plumbing3.50%352,8002,8982,9993,1043,2133,3263,4423,5623,6873,8163,9504,0884,2314,3794,5324,6914,8555,0255,2015,3835,5715,7665,9686,1776,3936,6176,8497,0887,3367,593
6515-004Supplies - Landscaping3.50%64504664824995165345535735936136356576807047287547808088368658959279599931,0271,0631,1011,1391,1791,220
6515-005Supplies - Electrical3.50%119009319649981,0331,0691,1061,1451,1851,2271,2701,3141,3601,4081,4571,5081,5611,6151,6721,7301,7911,8531,9181,9862,0552,1272,2012,2782,3582,441
6520-000Contract - Janitorial3.50%4300311321333344356369382395409423438453469486503520538557577597618639662685709734759786814
6520-001Contract - Repair3.50%564,5004,6584,8214,9895,1645,3455,5325,7255,9266,1336,3486,5706,8007,0387,2847,5397,8038,0768,3598,6518,9549,2679,5929,92810,27510,63511,00711,39211,79112,203
6520-002Contract - Pest Control3.50%564,5004,6584,8214,9895,1645,3455,5325,7255,9266,1336,3486,5706,8007,0387,2847,5397,8038,0768,3598,6518,9549,2679,5929,92810,27510,63511,00711,39211,79112,203
6520-003Contract - Plumbing3.50%564,5004,6584,8214,9895,1645,3455,5325,7255,9266,1336,3486,5706,8007,0387,2847,5397,8038,0768,3598,6518,9549,2679,5929,92810,27510,63511,00711,39211,79112,203
6520-004Contract - Landscaping3.50%14411,50011,90212,31912,75013,19713,65814,13614,63115,14315,67316,22216,79017,37717,98518,61519,26719,94120,63921,36122,10922,88323,68324,51225,37026,25827,17728,12929,11330,13231,187
6520-005Contract - Electrical3.50%231,8001,8631,9281,9962,0662,1382,2132,2902,3702,4532,5392,6282,7202,8152,9143,0163,1213,2303,3433,4613,5823,7073,8373,9714,1104,2544,4034,5574,7164,881
6520-006Contract - HVAC3.50%453,6003,7263,8563,9914,1314,2764,4254,5804,7414,9065,0785,2565,4405,6305,8276,0316,2426,4616,6876,9217,1637,4147,6737,9428,2208,5088,8059,1149,4339,763
6520-008Contract - Security Alarm/Fire Protection3.50%433,4003,5193,6423,7703,9024,0384,1794,3264,4774,6344,7964,9645,1385,3175,5045,6965,8966,1026,3156,5376,7657,0027,2477,5017,7638,0358,3168,6078,9099,220
6520-009Security Services3.50%937,4007,6597,9278,2058,4928,7899,0969,4159,74410,08510,43810,80411,18211,57311,97812,39812,83113,28113,74514,22714,72415,24015,77316,32516,89717,48818,10018,73419,38920,068
6570-000Vehicle & Maint. Equipment Repair3.50%54004144284434594754925095275455645846046266476706947187437697968248538829139459781,0131,0481,085
6590-003Decorating3.50%14411,50011,90212,31912,75013,19713,65814,13614,63115,14315,67316,22216,79017,37717,98518,61519,26719,94120,63921,36122,10922,88323,68324,51225,37026,25827,17728,12929,11330,13231,187
6590-OTHOther (Misc Maintenance)3.50%352,8002,8982,9993,1043,2133,3263,4423,5623,6873,8163,9504,0884,2314,3794,5324,6914,8555,0255,2015,3835,5715,7665,9686,1776,3936,6176,8497,0887,3367,593
Maintenance Payroll (derived)3.50%70256,16058,12660,16062,26664,44566,70069,03571,45173,95276,54079,21981,99284,86287,83290,90694,08897,381100,789104,317107,968111,747115,658119,706123,895128,232132,720137,365142,173147,149152,299
Subtotal: Operating & Maintenance1,531122,460126,746131,182135,774140,526145,444150,535155,803161,256166,900172,742178,788185,045191,522198,225205,163212,344219,776227,468235,430243,670252,198261,025270,161279,616289,403299,532310,016320,866332,097
Taxes & Insurance
6720-000Property & Liability Insurance3.50%1,20096,00099,360102,838106,437110,162114,018118,009122,139126,414130,838135,417140,157145,063150,140155,395160,833166,463172,289178,319184,560191,020197,705204,625211,787219,200226,872234,812243,030251,537260,340
6790-000Misc. Taxes, Licenses & Permits3.50%735,8006,0036,2136,4316,6566,8897,1307,3797,6377,9058,1818,4688,7649,0719,3889,71710,05710,40910,77311,15111,54111,94512,36312,79513,24313,70714,18714,68315,19715,729
Property Tax, net of exemption (derived)2.00%0
Payroll Tax + WC + Health (derived)3.50%53742,99344,49846,05547,66749,33551,06252,84954,69956,61458,59560,64662,76864,96567,23969,59372,02874,54977,15879,85982,65485,54788,54191,64094,84798,167101,603105,159108,840112,649116,592
Subtotal: Taxes & Insurance1,810144,793149,861155,106160,535166,153171,969177,988184,217190,665197,338204,245211,393218,792226,450234,376242,579251,069259,856268,951278,365288,107298,191308,628319,430330,610342,181354,158366,553379,383392,661
Supportive Services
Derived3.50%0
Subtotal: Supportive Services0
Financial Expense
Derived3.50%0
Subtotal: Financial Expense0
Total: Operating Expenses6,266501,258518,802536,960555,754575,205595,338616,174637,741660,061683,164707,074731,822757,436783,946811,384839,782869,175899,596931,082963,670997,3981,032,3071,068,4381,105,8331,144,5371,184,5961,226,0571,268,9691,313,3831,359,351
NOI Before Replacement Reserve11,241899,251916,720934,450952,441970,695989,2101,007,9871,027,0251,046,3231,065,8811,085,6961,105,7681,126,0941,146,6721,167,4991,188,5731,209,8891,231,4451,253,2351,275,2551,297,4991,319,9631,342,6391,365,5201,388,6001,411,8701,435,3211,458,9431,482,7271,506,661
Replacement Reserve3.00%-350(28,000)(28,840)(29,705)(30,596)(31,514)(32,460)(33,433)(34,436)(35,470)(36,534)(37,630)(38,759)(39,921)(41,119)(42,353)(43,623)(44,932)(46,280)(47,668)(49,098)(50,571)(52,088)(53,651)(55,260)(56,918)(58,626)(60,385)(62,196)(64,062)(65,984)
Net Operating Income10,891871,251887,880904,744921,845939,181956,750974,554992,5881,010,8541,029,3471,048,0661,067,0091,086,1721,105,5531,125,1461,144,9491,164,9571,185,1651,205,5671,226,1571,246,9281,267,8751,288,9881,310,2601,331,6821,353,2441,374,9361,396,7471,418,6651,440,677
RA Overhang - HCV2.50%80164,05665,65767,29968,98170,70672,47374,28576,14278,04679,99781,99784,04786,14888,30290,50992,77295,09197,46999,905102,403104,963107,587110,277113,034115,860118,756121,725124,768127,887131,085
Total - Rental Subsidy Overhang80164,05665,65767,29968,98170,70672,47374,28576,14278,04679,99781,99784,04786,14888,30290,50992,77295,09197,46999,905102,403104,963107,587110,277113,034115,860118,756121,725124,768127,887131,085
Balance - Cash Flow11,691935,307953,537972,043990,8261,009,8861,029,2241,048,8391,068,7311,088,9001,109,3441,130,0631,151,0561,172,3201,193,8551,215,6561,237,7221,260,0491,282,6341,305,4721,328,5601,351,8911,375,4621,399,2651,423,2941,447,5421,472,0001,496,6611,521,5151,546,5521,571,762
Amortizing Debt Service
First Mortgage - Interest(688,812)(684,695)(680,313)(675,649)(670,685)(665,401)(659,778)(653,793)(647,424)(640,644)(633,429)(625,749)(617,576)(608,876)(599,617)(589,763)(579,275)(568,112)(556,231)(543,586)(530,127)(515,803)(500,557)(484,331)(467,061)(448,681)(429,118)(408,296)(386,136)(362,550)
First Mortgage - Principal(64,011)(68,128)(72,510)(77,174)(82,138)(87,421)(93,044)(99,029)(105,399)(112,178)(119,394)(127,074)(135,247)(143,946)(153,205)(163,060)(173,548)(184,711)(196,592)(209,237)(222,696)(237,020)(252,265)(268,492)(285,761)(304,142)(323,705)(344,526)(366,687)(390,273)
First Mortgage - MIP
Sub 1 Mortgage - Interest
Sub 1 Mortgage - Principal
Sub 1 Mortgage - MIP
Sub 2 Mortgage - Interest
Sub 2 Mortgage - Principal
Sub 2 Mortgage - MIP
Sub 3 Mortgage - Interest
Sub 3 Mortgage - Principal
Sub 3 Mortgage - MIP
Sub 4 Mortgage - Interest
Sub 4 Mortgage - Principal
Sub 4 Mortgage - MIP
Total Debt Service(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)(752,823)
Cash Flow Net of Debt Service & Reserves118,428135,057151,922169,022186,358203,928221,731239,766258,031276,524295,244314,186333,350352,730372,324392,127412,135432,342452,744473,334494,106515,052536,165557,437578,859600,421622,113643,924665,842687,855
Debt Coverage Ratio111111111111111222222222222222
Residual Receipts Debt Service (accrued)
Deferred Developer Fee
Deferred Developer Fee (Beginning)1,523,6341,449,5221,355,5811,240,7821,104,056944,290760,331550,979314,98751,062
Annual Interest4.00%60,94557,98154,22349,63144,16237,77230,41322,03912,5992,042
Payment Applied(135,057)(151,922)(169,022)(186,358)(203,928)(221,731)(239,766)(258,031)(276,524)(53,104)
Total Outstanding DDF P&I1,523,6341,449,5221,355,5811,240,7821,104,056944,290760,331550,979314,98751,062
Resonant Proforma v2.305.0.0 · 26-0613 · feasibility + competitiveness, simultaneouslyAuto-saves to localStorage on every change
ƒClick any computed value to see its formula, inputs, and dependents. Toggle ↳ Arrows to overlay precedent/dependent connections.