1 site· 5 slots available
Perm Loan
11,050,000
sized against NOI + LTV + LTC + DCR
Annual DS
757,663
P+I · MIP (if FHA)
DCR
1.15x
below 1.15x floor
LTV
57.1%
perm / post-reno value
Perm Rate
6.250%
Treasury + spread + cushion + MIP
Debt Roll Up — Deal Level · Fannie Mae Taxable
4.350%
4.320%
Changes propagate to every site's debt indices (Treasury 10Y → perm cell; SOFR → construction loan index). Per-site overrides still possible on each site's Debt tab. · Last updated 05/08/2026
Immediate (at closing)
Per-Site Loan Contribution (Fannie Mae Taxable)
| Site | Post-Reno NOI | Post-Reno Value | Max Loan (Site) | % of Total | |
|---|---|---|---|---|---|
| Cedar Grove Apartments | 899,251 | 19,985,000 | 11,405,000 | 100.0% | |
| Total Deal | 899,251 | 19,985,000 | 11,405,000 | 100.0% |
Cash Flow From Operations — Underwritten Source
Available as a source—
Fannie Mae Taxable funds at closing, so the rents are already at post-renovation levels and there is no rehab-period cash flow to pledge. Select a forward execution to use this source.
Deal-Level Sizing Summary — All Executions
| Metric | Balance Sheet | FHA 221(d)(4) | FHA 223(f) | Fannie Mae Taxable | Freddie Mac Taxable |
|---|---|---|---|---|---|
| Deal NOI | 899,251 | 899,251 | 899,251 | 899,251 | 899,251 |
| Post-Reno Value | 19,985,000 | 19,985,000 | 19,985,000 | 19,985,000 | 19,985,000 |
| Max Loan — LTV | 17,986,500 | 17,386,950 | 17,386,950 | 17,986,500 | 17,986,500 |
| Max Loan — LTC | — | 21,924,000 | — | 22,680,000 | 22,680,000 |
| Max Loan — DCR | 10,995,000 | 12,147,000 | 11,678,000 | 11,405,000 | 11,266,000 |
| Max Loan — Final | 10,995,000 | 12,147,000 | 11,678,000 | 11,405,000 | 11,266,000 |
| Annual Debt Service | 777,156 | 776,758 | 775,654 | 777,008 | 777,089 |
| Binding Constraint | DCR | DCR | DCR | DCR | DCR |
Figures are sums across all sites sized against each execution's own NOI / rate / LTV/LTC/DCR parameters. "Binding" shows the constraint that drove sizing site-by-site; MIXED means different sites hit different binding constraints.
Deal-Level Debt Terms — All Executions (editable)
All sites inherit deal-level terms
Rate Components — flow into Total Rate → mortgage constant → Max Loan DCR
| Rate Term | Balance Sheet | FHA 221(d)(4) | FHA 223(f) | Fannie Mae Taxable | Freddie Mac Taxable |
|---|---|---|---|---|---|
| Index (Treasury 10Y / override) | % | % | % | % | % |
| Rate Cushion | % | % | % | % | % |
| Lender Spread | % | % | % | % | % |
| MIP — Ongoing | — | % | % | — | — |
| Total — Interest Rate | 6.550% | 5.750% | 5.750% | 6.250% | 6.350% |
| Capitalization Rate | % | % | % | % | % |
Fees — closing costs, added to Uses
| Fee | Balance Sheet | FHA 221(d)(4) | FHA 223(f) | Fannie Mae Taxable | Freddie Mac Taxable |
|---|---|---|---|---|---|
| Orig Fee — Construction (%) | % | % | — | — | — |
| Orig Fee — Permanent (%) | % | % | % | % | % |
| MIP Upfront (%) | — | % | % | — | — |
| Application Fee ($) | |||||
| FHA Exam Fee (%) | — | % | % | — | — |
| FHA Inspection Fee (%) | — | % | % | — | — |
| GNMA Fee ($) | — | — | — |
Rate components + fees edited here apply to every site by default. To diverge one site from the deal, enable "Customize debt terms for this site" on that site's Debt tab. Rate changes cascade: Total Rate → mortgage constant → Max Loan DCR → sized perm loan → DDF flex (or acquisition-basis reduction / GP equity plug past DDF limits).
Subordinate Debt — All Sites (0 mortgages)
No subordinate debt across the deal.
Debt Service & Distributable Cash — Deal Level
| Net Operating Income | 899,251 |
| (−) First-Mortgage DS | (752,823) |
| Cash Flow After First | 146,428 |
| (−) Second DS — Cash-Pay | (—) |
| Distributable Cash (for reserves, DDF, residual receipts splits) | 146,428 |
| Notional — Second DS Accrued (residual receipts) | — |
Residual-receipts sub debt accrues interest but is not paid from operating cash. It's shown separately so the waterfall reflects actual cash-pay obligations. Distributable Cash is what's left to fund replacement reserves, DDF repayment, and investor/GP splits in the waterfall.
GP Equity (Permanent) — Deal Total
—
Sum of each site's permanent-period GP equity plug. Edit per-site on the Debt tab's Per-Site view.
Principal11,050,000
Annual Interest Rate6.250%
Amortization Term40 years
Loan Term17 years
Monthly Payment62,735
Balloon Balance9,173,493
Total Interest Paid19,062,907
Total Payments30,112,907
Construction Loan Interest998,320
Peak Construction Loan Balance14,053,532
Total Construction Draws8,247,323
Total Equity Funded20,438,550
Monthly Amortization (480 periods)
| Period | Date | Payment | Interest | Principal | Balance | Cum Int |
|---|---|---|---|---|---|---|
| 1 | 06/01/2028 | 62,735 | 57,552 | 5,183 | 11,044,817 | 57,552 |
| 2 | 07/01/2028 | 62,735 | 57,525 | 5,210 | 11,039,607 | 115,077 |
| 3 | 08/01/2028 | 62,735 | 57,498 | 5,237 | 11,034,369 | 172,575 |
| 4 | 09/01/2028 | 62,735 | 57,471 | 5,265 | 11,029,105 | 230,046 |
| 5 | 10/01/2028 | 62,735 | 57,443 | 5,292 | 11,023,813 | 287,489 |
| 6 | 11/01/2028 | 62,735 | 57,416 | 5,320 | 11,018,493 | 344,905 |
| 7 | 12/01/2028 | 62,735 | 57,388 | 5,347 | 11,013,146 | 402,293 |
| 8 | 01/01/2029 | 62,735 | 57,360 | 5,375 | 11,007,771 | 459,653 |
| 9 | 02/01/2029 | 62,735 | 57,332 | 5,403 | 11,002,368 | 516,985 |
| 10 | 03/01/2029 | 62,735 | 57,304 | 5,431 | 10,996,937 | 574,289 |
| 11 | 04/01/2029 | 62,735 | 57,276 | 5,460 | 10,991,477 | 631,565 |
| 12 | 05/01/2029 | 62,735 | 57,247 | 5,488 | 10,985,989 | 688,812 |
| 13 | 06/01/2029 | 62,735 | 57,219 | 5,517 | 10,980,473 | 746,031 |
| 14 | 07/01/2029 | 62,735 | 57,190 | 5,545 | 10,974,928 | 803,221 |
| 15 | 08/01/2029 | 62,735 | 57,161 | 5,574 | 10,969,353 | 860,382 |
| 16 | 09/01/2029 | 62,735 | 57,132 | 5,603 | 10,963,750 | 917,514 |
| 17 | 10/01/2029 | 62,735 | 57,103 | 5,632 | 10,958,118 | 974,617 |
| 18 | 11/01/2029 | 62,735 | 57,074 | 5,662 | 10,952,456 | 1,031,690 |
| 19 | 12/01/2029 | 62,735 | 57,044 | 5,691 | 10,946,765 | 1,088,734 |
| 20 | 01/01/2030 | 62,735 | 57,014 | 5,721 | 10,941,044 | 1,145,749 |
| 21 | 02/01/2030 | 62,735 | 56,985 | 5,751 | 10,935,294 | 1,202,733 |
| 22 | 03/01/2030 | 62,735 | 56,955 | 5,781 | 10,929,513 | 1,259,688 |
| 23 | 04/01/2030 | 62,735 | 56,925 | 5,811 | 10,923,702 | 1,316,612 |
| 24 | 05/01/2030 | 62,735 | 56,894 | 5,841 | 10,917,861 | 1,373,507 |
| 25 | 06/01/2030 | 62,735 | 56,864 | 5,871 | 10,911,990 | 1,430,371 |
| 26 | 07/01/2030 | 62,735 | 56,833 | 5,902 | 10,906,088 | 1,487,204 |
| 27 | 08/01/2030 | 62,735 | 56,803 | 5,933 | 10,900,155 | 1,544,006 |
| 28 | 09/01/2030 | 62,735 | 56,772 | 5,964 | 10,894,192 | 1,600,778 |
| 29 | 10/01/2030 | 62,735 | 56,741 | 5,995 | 10,888,197 | 1,657,519 |
| 30 | 11/01/2030 | 62,735 | 56,709 | 6,026 | 10,882,171 | 1,714,228 |
| 31 | 12/01/2030 | 62,735 | 56,678 | 6,057 | 10,876,114 | 1,770,906 |
| 32 | 01/01/2031 | 62,735 | 56,646 | 6,089 | 10,870,025 | 1,827,552 |
| 33 | 02/01/2031 | 62,735 | 56,615 | 6,121 | 10,863,905 | 1,884,167 |
| 34 | 03/01/2031 | 62,735 | 56,583 | 6,152 | 10,857,752 | 1,940,750 |
| 35 | 04/01/2031 | 62,735 | 56,551 | 6,184 | 10,851,568 | 1,997,301 |
| 36 | 05/01/2031 | 62,735 | 56,519 | 6,217 | 10,845,351 | 2,053,819 |
| 37 | 06/01/2031 | 62,735 | 56,486 | 6,249 | 10,839,102 | 2,110,306 |
| 38 | 07/01/2031 | 62,735 | 56,454 | 6,282 | 10,832,821 | 2,166,759 |
| 39 | 08/01/2031 | 62,735 | 56,421 | 6,314 | 10,826,506 | 2,223,180 |
| 40 | 09/01/2031 | 62,735 | 56,388 | 6,347 | 10,820,159 | 2,279,568 |
| 41 | 10/01/2031 | 62,735 | 56,355 | 6,380 | 10,813,779 | 2,335,923 |
| 42 | 11/01/2031 | 62,735 | 56,322 | 6,413 | 10,807,366 | 2,392,245 |
| 43 | 12/01/2031 | 62,735 | 56,288 | 6,447 | 10,800,919 | 2,448,533 |
| 44 | 01/01/2032 | 62,735 | 56,255 | 6,480 | 10,794,438 | 2,504,788 |
| 45 | 02/01/2032 | 62,735 | 56,221 | 6,514 | 10,787,924 | 2,561,009 |
| 46 | 03/01/2032 | 62,735 | 56,187 | 6,548 | 10,781,376 | 2,617,196 |
| 47 | 04/01/2032 | 62,735 | 56,153 | 6,582 | 10,774,794 | 2,673,349 |
| 48 | 05/01/2032 | 62,735 | 56,119 | 6,617 | 10,768,177 | 2,729,468 |
| 49 | 06/01/2032 | 62,735 | 56,084 | 6,651 | 10,761,526 | 2,785,552 |
| 50 | 07/01/2032 | 62,735 | 56,050 | 6,686 | 10,754,841 | 2,841,602 |
| 51 | 08/01/2032 | 62,735 | 56,015 | 6,720 | 10,748,120 | 2,897,617 |
| 52 | 09/01/2032 | 62,735 | 55,980 | 6,755 | 10,741,365 | 2,953,596 |
| 53 | 10/01/2032 | 62,735 | 55,945 | 6,791 | 10,734,574 | 3,009,541 |
| 54 | 11/01/2032 | 62,735 | 55,909 | 6,826 | 10,727,748 | 3,065,450 |
| 55 | 12/01/2032 | 62,735 | 55,874 | 6,862 | 10,720,887 | 3,121,324 |
| 56 | 01/01/2033 | 62,735 | 55,838 | 6,897 | 10,713,989 | 3,177,162 |
| 57 | 02/01/2033 | 62,735 | 55,802 | 6,933 | 10,707,056 | 3,232,964 |
| 58 | 03/01/2033 | 62,735 | 55,766 | 6,969 | 10,700,087 | 3,288,730 |
| 59 | 04/01/2033 | 62,735 | 55,730 | 7,006 | 10,693,081 | 3,344,459 |
| 60 | 05/01/2033 | 62,735 | 55,693 | 7,042 | 10,686,039 | 3,400,153 |
| 61 | 06/01/2033 | 62,735 | 55,656 | 7,079 | 10,678,960 | 3,455,809 |
| 62 | 07/01/2033 | 62,735 | 55,620 | 7,116 | 10,671,845 | 3,511,429 |
| 63 | 08/01/2033 | 62,735 | 55,583 | 7,153 | 10,664,692 | 3,567,011 |
| 64 | 09/01/2033 | 62,735 | 55,545 | 7,190 | 10,657,502 | 3,622,556 |
| 65 | 10/01/2033 | 62,735 | 55,508 | 7,227 | 10,650,275 | 3,678,064 |
| 66 | 11/01/2033 | 62,735 | 55,470 | 7,265 | 10,643,010 | 3,733,534 |
| 67 | 12/01/2033 | 62,735 | 55,432 | 7,303 | 10,635,707 | 3,788,967 |
| 68 | 01/01/2034 | 62,735 | 55,394 | 7,341 | 10,628,366 | 3,844,361 |
| 69 | 02/01/2034 | 62,735 | 55,356 | 7,379 | 10,620,987 | 3,899,717 |
| 70 | 03/01/2034 | 62,735 | 55,318 | 7,418 | 10,613,569 | 3,955,035 |
| 71 | 04/01/2034 | 62,735 | 55,279 | 7,456 | 10,606,113 | 4,010,314 |
| 72 | 05/01/2034 | 62,735 | 55,240 | 7,495 | 10,598,618 | 4,065,554 |
| 73 | 06/01/2034 | 62,735 | 55,201 | 7,534 | 10,591,084 | 4,120,755 |
| 74 | 07/01/2034 | 62,735 | 55,162 | 7,573 | 10,583,511 | 4,175,917 |
| 75 | 08/01/2034 | 62,735 | 55,122 | 7,613 | 10,575,898 | 4,231,039 |
| 76 | 09/01/2034 | 62,735 | 55,083 | 7,652 | 10,568,245 | 4,286,122 |
| 77 | 10/01/2034 | 62,735 | 55,043 | 7,692 | 10,560,553 | 4,341,165 |
| 78 | 11/01/2034 | 62,735 | 55,003 | 7,732 | 10,552,821 | 4,396,168 |
| 79 | 12/01/2034 | 62,735 | 54,963 | 7,773 | 10,545,048 | 4,451,131 |
| 80 | 01/01/2035 | 62,735 | 54,922 | 7,813 | 10,537,235 | 4,506,053 |
| 81 | 02/01/2035 | 62,735 | 54,881 | 7,854 | 10,529,381 | 4,560,934 |
| 82 | 03/01/2035 | 62,735 | 54,841 | 7,895 | 10,521,486 | 4,615,775 |
| 83 | 04/01/2035 | 62,735 | 54,799 | 7,936 | 10,513,551 | 4,670,574 |
| 84 | 05/01/2035 | 62,735 | 54,758 | 7,977 | 10,505,574 | 4,725,332 |
| 85 | 06/01/2035 | 62,735 | 54,717 | 8,019 | 10,497,555 | 4,780,049 |
| 86 | 07/01/2035 | 62,735 | 54,675 | 8,060 | 10,489,494 | 4,834,724 |
| 87 | 08/01/2035 | 62,735 | 54,633 | 8,102 | 10,481,392 | 4,889,356 |
| 88 | 09/01/2035 | 62,735 | 54,591 | 8,145 | 10,473,247 | 4,943,947 |
| 89 | 10/01/2035 | 62,735 | 54,548 | 8,187 | 10,465,060 | 4,998,495 |
| 90 | 11/01/2035 | 62,735 | 54,506 | 8,230 | 10,456,831 | 5,053,001 |
| 91 | 12/01/2035 | 62,735 | 54,463 | 8,273 | 10,448,558 | 5,107,463 |
| 92 | 01/01/2036 | 62,735 | 54,420 | 8,316 | 10,440,242 | 5,161,883 |
| 93 | 02/01/2036 | 62,735 | 54,376 | 8,359 | 10,431,883 | 5,216,259 |
| 94 | 03/01/2036 | 62,735 | 54,333 | 8,402 | 10,423,481 | 5,270,592 |
| 95 | 04/01/2036 | 62,735 | 54,289 | 8,446 | 10,415,035 | 5,324,881 |
| 96 | 05/01/2036 | 62,735 | 54,245 | 8,490 | 10,406,544 | 5,379,126 |
| 97 | 06/01/2036 | 62,735 | 54,201 | 8,534 | 10,398,010 | 5,433,326 |
| 98 | 07/01/2036 | 62,735 | 54,156 | 8,579 | 10,389,431 | 5,487,483 |
| 99 | 08/01/2036 | 62,735 | 54,112 | 8,624 | 10,380,807 | 5,541,594 |
| 100 | 09/01/2036 | 62,735 | 54,067 | 8,669 | 10,372,139 | 5,595,661 |
| 101 | 10/01/2036 | 62,735 | 54,022 | 8,714 | 10,363,425 | 5,649,683 |
| 102 | 11/01/2036 | 62,735 | 53,976 | 8,759 | 10,354,666 | 5,703,659 |
| 103 | 12/01/2036 | 62,735 | 53,931 | 8,805 | 10,345,861 | 5,757,589 |
| 104 | 01/01/2037 | 62,735 | 53,885 | 8,851 | 10,337,011 | 5,811,474 |
| 105 | 02/01/2037 | 62,735 | 53,839 | 8,897 | 10,328,114 | 5,865,313 |
| 106 | 03/01/2037 | 62,735 | 53,792 | 8,943 | 10,319,171 | 5,919,105 |
| 107 | 04/01/2037 | 62,735 | 53,746 | 8,990 | 10,310,182 | 5,972,851 |
| 108 | 05/01/2037 | 62,735 | 53,699 | 9,036 | 10,301,145 | 6,026,550 |
| 109 | 06/01/2037 | 62,735 | 53,652 | 9,083 | 10,292,062 | 6,080,201 |
| 110 | 07/01/2037 | 62,735 | 53,604 | 9,131 | 10,282,931 | 6,133,806 |
| 111 | 08/01/2037 | 62,735 | 53,557 | 9,178 | 10,273,753 | 6,187,363 |
| 112 | 09/01/2037 | 62,735 | 53,509 | 9,226 | 10,264,527 | 6,240,872 |
| 113 | 10/01/2037 | 62,735 | 53,461 | 9,274 | 10,255,253 | 6,294,333 |
| 114 | 11/01/2037 | 62,735 | 53,413 | 9,322 | 10,245,930 | 6,347,746 |
| 115 | 12/01/2037 | 62,735 | 53,364 | 9,371 | 10,236,559 | 6,401,110 |
| 116 | 01/01/2038 | 62,735 | 53,315 | 9,420 | 10,227,139 | 6,454,425 |
| 117 | 02/01/2038 | 62,735 | 53,266 | 9,469 | 10,217,671 | 6,507,692 |
| 118 | 03/01/2038 | 62,735 | 53,217 | 9,518 | 10,208,152 | 6,560,909 |
| 119 | 04/01/2038 | 62,735 | 53,167 | 9,568 | 10,198,585 | 6,614,076 |
| 120 | 05/01/2038 | 62,735 | 53,118 | 9,618 | 10,188,967 | 6,667,194 |
| 121 | 06/01/2038 | 62,735 | 53,068 | 9,668 | 10,179,299 | 6,720,261 |
| 122 | 07/01/2038 | 62,735 | 53,017 | 9,718 | 10,169,581 | 6,773,279 |
| 123 | 08/01/2038 | 62,735 | 52,967 | 9,769 | 10,159,813 | 6,826,245 |
| 124 | 09/01/2038 | 62,735 | 52,916 | 9,820 | 10,149,993 | 6,879,161 |
| 125 | 10/01/2038 | 62,735 | 52,865 | 9,871 | 10,140,122 | 6,932,025 |
| 126 | 11/01/2038 | 62,735 | 52,813 | 9,922 | 10,130,200 | 6,984,838 |
| 127 | 12/01/2038 | 62,735 | 52,761 | 9,974 | 10,120,227 | 7,037,600 |
| 128 | 01/01/2039 | 62,735 | 52,710 | 10,026 | 10,110,201 | 7,090,309 |
| 129 | 02/01/2039 | 62,735 | 52,657 | 10,078 | 10,100,123 | 7,142,967 |
| 130 | 03/01/2039 | 62,735 | 52,605 | 10,130 | 10,089,993 | 7,195,572 |
| 131 | 04/01/2039 | 62,735 | 52,552 | 10,183 | 10,079,809 | 7,248,124 |
| 132 | 05/01/2039 | 62,735 | 52,499 | 10,236 | 10,069,573 | 7,300,623 |
| 133 | 06/01/2039 | 62,735 | 52,446 | 10,290 | 10,059,284 | 7,353,068 |
| 134 | 07/01/2039 | 62,735 | 52,392 | 10,343 | 10,048,941 | 7,405,460 |
| 135 | 08/01/2039 | 62,735 | 52,338 | 10,397 | 10,038,544 | 7,457,799 |
| 136 | 09/01/2039 | 62,735 | 52,284 | 10,451 | 10,028,092 | 7,510,083 |
| 137 | 10/01/2039 | 62,735 | 52,230 | 10,506 | 10,017,587 | 7,562,312 |
| 138 | 11/01/2039 | 62,735 | 52,175 | 10,560 | 10,007,027 | 7,614,487 |
| 139 | 12/01/2039 | 62,735 | 52,120 | 10,615 | 9,996,411 | 7,666,607 |
| 140 | 01/01/2040 | 62,735 | 52,065 | 10,671 | 9,985,741 | 7,718,672 |
| 141 | 02/01/2040 | 62,735 | 52,009 | 10,726 | 9,975,015 | 7,770,681 |
| 142 | 03/01/2040 | 62,735 | 51,953 | 10,782 | 9,964,233 | 7,822,634 |
| 143 | 04/01/2040 | 62,735 | 51,897 | 10,838 | 9,953,394 | 7,874,531 |
| 144 | 05/01/2040 | 62,735 | 51,841 | 10,895 | 9,942,500 | 7,926,372 |
| 145 | 06/01/2040 | 62,735 | 51,784 | 10,951 | 9,931,548 | 7,978,156 |
| 146 | 07/01/2040 | 62,735 | 51,727 | 11,008 | 9,920,540 | 8,029,882 |
| 147 | 08/01/2040 | 62,735 | 51,669 | 11,066 | 9,909,474 | 8,081,552 |
| 148 | 09/01/2040 | 62,735 | 51,612 | 11,123 | 9,898,351 | 8,133,164 |
| 149 | 10/01/2040 | 62,735 | 51,554 | 11,181 | 9,887,169 | 8,184,718 |
| 150 | 11/01/2040 | 62,735 | 51,496 | 11,240 | 9,875,930 | 8,236,213 |
| 151 | 12/01/2040 | 62,735 | 51,437 | 11,298 | 9,864,632 | 8,287,650 |
| 152 | 01/01/2041 | 62,735 | 51,378 | 11,357 | 9,853,275 | 8,339,029 |
| 153 | 02/01/2041 | 62,735 | 51,319 | 11,416 | 9,841,859 | 8,390,348 |
| 154 | 03/01/2041 | 62,735 | 51,260 | 11,476 | 9,830,383 | 8,441,608 |
| 155 | 04/01/2041 | 62,735 | 51,200 | 11,535 | 9,818,848 | 8,492,808 |
| 156 | 05/01/2041 | 62,735 | 51,140 | 11,595 | 9,807,253 | 8,543,947 |
| 157 | 06/01/2041 | 62,735 | 51,079 | 11,656 | 9,795,597 | 8,595,027 |
| 158 | 07/01/2041 | 62,735 | 51,019 | 11,716 | 9,783,880 | 8,646,046 |
| 159 | 08/01/2041 | 62,735 | 50,958 | 11,778 | 9,772,103 | 8,697,003 |
| 160 | 09/01/2041 | 62,735 | 50,896 | 11,839 | 9,760,264 | 8,747,900 |
| 161 | 10/01/2041 | 62,735 | 50,835 | 11,901 | 9,748,363 | 8,798,734 |
| 162 | 11/01/2041 | 62,735 | 50,773 | 11,962 | 9,736,401 | 8,849,507 |
| 163 | 12/01/2041 | 62,735 | 50,710 | 12,025 | 9,724,376 | 8,900,217 |
| 164 | 01/01/2042 | 62,735 | 50,648 | 12,087 | 9,712,289 | 8,950,865 |
| 165 | 02/01/2042 | 62,735 | 50,585 | 12,150 | 9,700,138 | 9,001,450 |
| 166 | 03/01/2042 | 62,735 | 50,522 | 12,214 | 9,687,925 | 9,051,972 |
| 167 | 04/01/2042 | 62,735 | 50,458 | 12,277 | 9,675,647 | 9,102,430 |
| 168 | 05/01/2042 | 62,735 | 50,394 | 12,341 | 9,663,306 | 9,152,824 |
| 169 | 06/01/2042 | 62,735 | 50,330 | 12,406 | 9,650,901 | 9,203,153 |
| 170 | 07/01/2042 | 62,735 | 50,265 | 12,470 | 9,638,431 | 9,253,418 |
| 171 | 08/01/2042 | 62,735 | 50,200 | 12,535 | 9,625,895 | 9,303,619 |
| 172 | 09/01/2042 | 62,735 | 50,135 | 12,600 | 9,613,295 | 9,353,753 |
| 173 | 10/01/2042 | 62,735 | 50,069 | 12,666 | 9,600,629 | 9,403,823 |
| 174 | 11/01/2042 | 62,735 | 50,003 | 12,732 | 9,587,897 | 9,453,826 |
| 175 | 12/01/2042 | 62,735 | 49,937 | 12,798 | 9,575,099 | 9,503,763 |
| 176 | 01/01/2043 | 62,735 | 49,870 | 12,865 | 9,562,234 | 9,553,633 |
| 177 | 02/01/2043 | 62,735 | 49,803 | 12,932 | 9,549,302 | 9,603,437 |
| 178 | 03/01/2043 | 62,735 | 49,736 | 12,999 | 9,536,303 | 9,653,172 |
| 179 | 04/01/2043 | 62,735 | 49,668 | 13,067 | 9,523,236 | 9,702,841 |
| 180 | 05/01/2043 | 62,735 | 49,600 | 13,135 | 9,510,101 | 9,752,441 |
| 181 | 06/01/2043 | 62,735 | 49,532 | 13,203 | 9,496,897 | 9,801,973 |
| 182 | 07/01/2043 | 62,735 | 49,463 | 13,272 | 9,483,625 | 9,851,436 |
| 183 | 08/01/2043 | 62,735 | 49,394 | 13,341 | 9,470,284 | 9,900,830 |
| 184 | 09/01/2043 | 62,735 | 49,324 | 13,411 | 9,456,873 | 9,950,154 |
| 185 | 10/01/2043 | 62,735 | 49,255 | 13,481 | 9,443,392 | 9,999,409 |
| 186 | 11/01/2043 | 62,735 | 49,184 | 13,551 | 9,429,841 | 10,048,593 |
| 187 | 12/01/2043 | 62,735 | 49,114 | 13,621 | 9,416,220 | 10,097,707 |
| 188 | 01/01/2044 | 62,735 | 49,043 | 13,692 | 9,402,528 | 10,146,749 |
| 189 | 02/01/2044 | 62,735 | 48,971 | 13,764 | 9,388,764 | 10,195,721 |
| 190 | 03/01/2044 | 62,735 | 48,900 | 13,835 | 9,374,928 | 10,244,621 |
| 191 | 04/01/2044 | 62,735 | 48,828 | 13,907 | 9,361,021 | 10,293,448 |
| 192 | 05/01/2044 | 62,735 | 48,755 | 13,980 | 9,347,041 | 10,342,204 |
| 193 | 06/01/2044 | 62,735 | 48,683 | 14,053 | 9,332,988 | 10,390,886 |
| 194 | 07/01/2044 | 62,735 | 48,609 | 14,126 | 9,318,862 | 10,439,496 |
| 195 | 08/01/2044 | 62,735 | 48,536 | 14,199 | 9,304,663 | 10,488,031 |
| 196 | 09/01/2044 | 62,735 | 48,462 | 14,273 | 9,290,389 | 10,536,493 |
| 197 | 10/01/2044 | 62,735 | 48,387 | 14,348 | 9,276,042 | 10,584,881 |
| 198 | 11/01/2044 | 62,735 | 48,313 | 14,423 | 9,261,619 | 10,633,193 |
| 199 | 12/01/2044 | 62,735 | 48,238 | 14,498 | 9,247,122 | 10,681,431 |
| 200 | 01/01/2045 | 62,735 | 48,162 | 14,573 | 9,232,548 | 10,729,593 |
| 201 | 02/01/2045 | 62,735 | 48,086 | 14,649 | 9,217,899 | 10,777,679 |
| 202 | 03/01/2045 | 62,735 | 48,010 | 14,725 | 9,203,174 | 10,825,689 |
| 203 | 04/01/2045 | 62,735 | 47,933 | 14,802 | 9,188,372 | 10,873,622 |
| 204 | 05/01/2045 | 62,735 | 47,856 | 14,879 | 9,173,493 | 10,921,478 |
| 205 | 06/01/2045 | 62,735 | 47,779 | 14,957 | 9,158,536 | 10,969,257 |
| 206 | 07/01/2045 | 62,735 | 47,701 | 15,035 | 9,143,502 | 11,016,958 |
| 207 | 08/01/2045 | 62,735 | 47,622 | 15,113 | 9,128,389 | 11,064,580 |
| 208 | 09/01/2045 | 62,735 | 47,544 | 15,192 | 9,113,197 | 11,112,124 |
| 209 | 10/01/2045 | 62,735 | 47,465 | 15,271 | 9,097,927 | 11,159,588 |
| 210 | 11/01/2045 | 62,735 | 47,385 | 15,350 | 9,082,577 | 11,206,973 |
| 211 | 12/01/2045 | 62,735 | 47,305 | 15,430 | 9,067,146 | 11,254,278 |
| 212 | 01/01/2046 | 62,735 | 47,225 | 15,511 | 9,051,636 | 11,301,503 |
| 213 | 02/01/2046 | 62,735 | 47,144 | 15,591 | 9,036,045 | 11,348,647 |
| 214 | 03/01/2046 | 62,735 | 47,063 | 15,672 | 9,020,372 | 11,395,710 |
| 215 | 04/01/2046 | 62,735 | 46,981 | 15,754 | 9,004,618 | 11,442,691 |
| 216 | 05/01/2046 | 62,735 | 46,899 | 15,836 | 8,988,782 | 11,489,590 |
| 217 | 06/01/2046 | 62,735 | 46,817 | 15,919 | 8,972,863 | 11,536,407 |
| 218 | 07/01/2046 | 62,735 | 46,734 | 16,002 | 8,956,862 | 11,583,140 |
| 219 | 08/01/2046 | 62,735 | 46,650 | 16,085 | 8,940,777 | 11,629,791 |
| 220 | 09/01/2046 | 62,735 | 46,567 | 16,169 | 8,924,608 | 11,676,357 |
| 221 | 10/01/2046 | 62,735 | 46,482 | 16,253 | 8,908,355 | 11,722,839 |
| 222 | 11/01/2046 | 62,735 | 46,398 | 16,338 | 8,892,018 | 11,769,237 |
| 223 | 12/01/2046 | 62,735 | 46,313 | 16,423 | 8,875,595 | 11,815,550 |
| 224 | 01/01/2047 | 62,735 | 46,227 | 16,508 | 8,859,087 | 11,861,777 |
| 225 | 02/01/2047 | 62,735 | 46,141 | 16,594 | 8,842,493 | 11,907,918 |
| 226 | 03/01/2047 | 62,735 | 46,055 | 16,681 | 8,825,812 | 11,953,973 |
| 227 | 04/01/2047 | 62,735 | 45,968 | 16,767 | 8,809,045 | 11,999,940 |
| 228 | 05/01/2047 | 62,735 | 45,880 | 16,855 | 8,792,190 | 12,045,821 |
| 229 | 06/01/2047 | 62,735 | 45,793 | 16,943 | 8,775,247 | 12,091,613 |
| 230 | 07/01/2047 | 62,735 | 45,704 | 17,031 | 8,758,217 | 12,137,318 |
| 231 | 08/01/2047 | 62,735 | 45,616 | 17,120 | 8,741,097 | 12,182,934 |
| 232 | 09/01/2047 | 62,735 | 45,527 | 17,209 | 8,723,888 | 12,228,460 |
| 233 | 10/01/2047 | 62,735 | 45,437 | 17,298 | 8,706,590 | 12,273,897 |
| 234 | 11/01/2047 | 62,735 | 45,347 | 17,388 | 8,689,202 | 12,319,244 |
| 235 | 12/01/2047 | 62,735 | 45,256 | 17,479 | 8,671,723 | 12,364,500 |
| 236 | 01/01/2048 | 62,735 | 45,165 | 17,570 | 8,654,153 | 12,409,665 |
| 237 | 02/01/2048 | 62,735 | 45,074 | 17,662 | 8,636,491 | 12,454,739 |
| 238 | 03/01/2048 | 62,735 | 44,982 | 17,753 | 8,618,738 | 12,499,721 |
| 239 | 04/01/2048 | 62,735 | 44,889 | 17,846 | 8,600,892 | 12,544,610 |
| 240 | 05/01/2048 | 62,735 | 44,796 | 17,939 | 8,582,953 | 12,589,406 |
| 241 | 06/01/2048 | 62,735 | 44,703 | 18,032 | 8,564,920 | 12,634,109 |
| 242 | 07/01/2048 | 62,735 | 44,609 | 18,126 | 8,546,794 | 12,678,718 |
| 243 | 08/01/2048 | 62,735 | 44,515 | 18,221 | 8,528,574 | 12,723,233 |
| 244 | 09/01/2048 | 62,735 | 44,420 | 18,316 | 8,510,258 | 12,767,652 |
| 245 | 10/01/2048 | 62,735 | 44,324 | 18,411 | 8,491,847 | 12,811,977 |
| 246 | 11/01/2048 | 62,735 | 44,228 | 18,507 | 8,473,340 | 12,856,205 |
| 247 | 12/01/2048 | 62,735 | 44,132 | 18,603 | 8,454,737 | 12,900,337 |
| 248 | 01/01/2049 | 62,735 | 44,035 | 18,700 | 8,436,037 | 12,944,372 |
| 249 | 02/01/2049 | 62,735 | 43,938 | 18,798 | 8,417,239 | 12,988,310 |
| 250 | 03/01/2049 | 62,735 | 43,840 | 18,895 | 8,398,344 | 13,032,150 |
| 251 | 04/01/2049 | 62,735 | 43,741 | 18,994 | 8,379,350 | 13,075,891 |
| 252 | 05/01/2049 | 62,735 | 43,642 | 19,093 | 8,360,257 | 13,119,533 |
| 253 | 06/01/2049 | 62,735 | 43,543 | 19,192 | 8,341,065 | 13,163,076 |
| 254 | 07/01/2049 | 62,735 | 43,443 | 19,292 | 8,321,773 | 13,206,519 |
| 255 | 08/01/2049 | 62,735 | 43,343 | 19,393 | 8,302,380 | 13,249,862 |
| 256 | 09/01/2049 | 62,735 | 43,242 | 19,494 | 8,282,886 | 13,293,104 |
| 257 | 10/01/2049 | 62,735 | 43,140 | 19,595 | 8,263,291 | 13,336,244 |
| 258 | 11/01/2049 | 62,735 | 43,038 | 19,697 | 8,243,594 | 13,379,282 |
| 259 | 12/01/2049 | 62,735 | 42,935 | 19,800 | 8,223,794 | 13,422,217 |
| 260 | 01/01/2050 | 62,735 | 42,832 | 19,903 | 8,203,891 | 13,465,049 |
| 261 | 02/01/2050 | 62,735 | 42,729 | 20,007 | 8,183,885 | 13,507,778 |
| 262 | 03/01/2050 | 62,735 | 42,624 | 20,111 | 8,163,774 | 13,550,402 |
| 263 | 04/01/2050 | 62,735 | 42,520 | 20,216 | 8,143,558 | 13,592,922 |
| 264 | 05/01/2050 | 62,735 | 42,414 | 20,321 | 8,123,237 | 13,635,336 |
| 265 | 06/01/2050 | 62,735 | 42,309 | 20,427 | 8,102,811 | 13,677,645 |
| 266 | 07/01/2050 | 62,735 | 42,202 | 20,533 | 8,082,278 | 13,719,847 |
| 267 | 08/01/2050 | 62,735 | 42,095 | 20,640 | 8,061,638 | 13,761,942 |
| 268 | 09/01/2050 | 62,735 | 41,988 | 20,748 | 8,040,890 | 13,803,930 |
| 269 | 10/01/2050 | 62,735 | 41,880 | 20,856 | 8,020,034 | 13,845,809 |
| 270 | 11/01/2050 | 62,735 | 41,771 | 20,964 | 7,999,070 | 13,887,580 |
| 271 | 12/01/2050 | 62,735 | 41,662 | 21,073 | 7,977,997 | 13,929,242 |
| 272 | 01/01/2051 | 62,735 | 41,552 | 21,183 | 7,956,814 | 13,970,794 |
| 273 | 02/01/2051 | 62,735 | 41,442 | 21,293 | 7,935,520 | 14,012,236 |
| 274 | 03/01/2051 | 62,735 | 41,331 | 21,404 | 7,914,116 | 14,053,567 |
| 275 | 04/01/2051 | 62,735 | 41,219 | 21,516 | 7,892,600 | 14,094,786 |
| 276 | 05/01/2051 | 62,735 | 41,107 | 21,628 | 7,870,972 | 14,135,894 |
| 277 | 06/01/2051 | 62,735 | 40,995 | 21,741 | 7,849,231 | 14,176,888 |
| 278 | 07/01/2051 | 62,735 | 40,881 | 21,854 | 7,827,378 | 14,217,770 |
| 279 | 08/01/2051 | 62,735 | 40,768 | 21,968 | 7,805,410 | 14,258,537 |
| 280 | 09/01/2051 | 62,735 | 40,653 | 22,082 | 7,783,328 | 14,299,190 |
| 281 | 10/01/2051 | 62,735 | 40,538 | 22,197 | 7,761,131 | 14,339,729 |
| 282 | 11/01/2051 | 62,735 | 40,423 | 22,313 | 7,738,818 | 14,380,151 |
| 283 | 12/01/2051 | 62,735 | 40,306 | 22,429 | 7,716,389 | 14,420,457 |
| 284 | 01/01/2052 | 62,735 | 40,190 | 22,546 | 7,693,844 | 14,460,647 |
| 285 | 02/01/2052 | 62,735 | 40,072 | 22,663 | 7,671,181 | 14,500,719 |
| 286 | 03/01/2052 | 62,735 | 39,954 | 22,781 | 7,648,399 | 14,540,673 |
| 287 | 04/01/2052 | 62,735 | 39,835 | 22,900 | 7,625,500 | 14,580,509 |
| 288 | 05/01/2052 | 62,735 | 39,716 | 23,019 | 7,602,481 | 14,620,225 |
| 289 | 06/01/2052 | 62,735 | 39,596 | 23,139 | 7,579,342 | 14,659,821 |
| 290 | 07/01/2052 | 62,735 | 39,476 | 23,259 | 7,556,082 | 14,699,297 |
| 291 | 08/01/2052 | 62,735 | 39,355 | 23,381 | 7,532,701 | 14,738,651 |
| 292 | 09/01/2052 | 62,735 | 39,233 | 23,502 | 7,509,199 | 14,777,884 |
| 293 | 10/01/2052 | 62,735 | 39,110 | 23,625 | 7,485,574 | 14,816,995 |
| 294 | 11/01/2052 | 62,735 | 38,987 | 23,748 | 7,461,826 | 14,855,982 |
| 295 | 12/01/2052 | 62,735 | 38,864 | 23,872 | 7,437,955 | 14,894,846 |
| 296 | 01/01/2053 | 62,735 | 38,739 | 23,996 | 7,413,959 | 14,933,585 |
| 297 | 02/01/2053 | 62,735 | 38,614 | 24,121 | 7,389,838 | 14,972,199 |
| 298 | 03/01/2053 | 62,735 | 38,489 | 24,246 | 7,365,592 | 15,010,688 |
| 299 | 04/01/2053 | 62,735 | 38,362 | 24,373 | 7,341,219 | 15,049,050 |
| 300 | 05/01/2053 | 62,735 | 38,236 | 24,500 | 7,316,719 | 15,087,286 |
| 301 | 06/01/2053 | 62,735 | 38,108 | 24,627 | 7,292,092 | 15,125,394 |
| 302 | 07/01/2053 | 62,735 | 37,980 | 24,756 | 7,267,336 | 15,163,374 |
| 303 | 08/01/2053 | 62,735 | 37,851 | 24,885 | 7,242,452 | 15,201,224 |
| 304 | 09/01/2053 | 62,735 | 37,721 | 25,014 | 7,217,438 | 15,238,945 |
| 305 | 10/01/2053 | 62,735 | 37,591 | 25,144 | 7,192,293 | 15,276,536 |
| 306 | 11/01/2053 | 62,735 | 37,460 | 25,275 | 7,167,018 | 15,313,996 |
| 307 | 12/01/2053 | 62,735 | 37,328 | 25,407 | 7,141,611 | 15,351,324 |
| 308 | 01/01/2054 | 62,735 | 37,196 | 25,539 | 7,116,071 | 15,388,520 |
| 309 | 02/01/2054 | 62,735 | 37,063 | 25,672 | 7,090,399 | 15,425,583 |
| 310 | 03/01/2054 | 62,735 | 36,929 | 25,806 | 7,064,593 | 15,462,512 |
| 311 | 04/01/2054 | 62,735 | 36,795 | 25,940 | 7,038,653 | 15,499,307 |
| 312 | 05/01/2054 | 62,735 | 36,660 | 26,076 | 7,012,577 | 15,535,967 |
| 313 | 06/01/2054 | 62,735 | 36,524 | 26,211 | 6,986,366 | 15,572,490 |
| 314 | 07/01/2054 | 62,735 | 36,387 | 26,348 | 6,960,018 | 15,608,878 |
| 315 | 08/01/2054 | 62,735 | 36,250 | 26,485 | 6,933,533 | 15,645,128 |
| 316 | 09/01/2054 | 62,735 | 36,112 | 26,623 | 6,906,910 | 15,681,240 |
| 317 | 10/01/2054 | 62,735 | 35,973 | 26,762 | 6,880,148 | 15,717,213 |
| 318 | 11/01/2054 | 62,735 | 35,834 | 26,901 | 6,853,247 | 15,753,048 |
| 319 | 12/01/2054 | 62,735 | 35,694 | 27,041 | 6,826,205 | 15,788,742 |
| 320 | 01/01/2055 | 62,735 | 35,553 | 27,182 | 6,799,023 | 15,824,295 |
| 321 | 02/01/2055 | 62,735 | 35,412 | 27,324 | 6,771,700 | 15,859,706 |
| 322 | 03/01/2055 | 62,735 | 35,269 | 27,466 | 6,744,234 | 15,894,976 |
| 323 | 04/01/2055 | 62,735 | 35,126 | 27,609 | 6,716,625 | 15,930,102 |
| 324 | 05/01/2055 | 62,735 | 34,982 | 27,753 | 6,688,872 | 15,965,084 |
| 325 | 06/01/2055 | 62,735 | 34,838 | 27,897 | 6,660,975 | 15,999,922 |
| 326 | 07/01/2055 | 62,735 | 34,693 | 28,043 | 6,632,932 | 16,034,615 |
| 327 | 08/01/2055 | 62,735 | 34,547 | 28,189 | 6,604,743 | 16,069,161 |
| 328 | 09/01/2055 | 62,735 | 34,400 | 28,336 | 6,576,408 | 16,103,561 |
| 329 | 10/01/2055 | 62,735 | 34,252 | 28,483 | 6,547,925 | 16,137,813 |
| 330 | 11/01/2055 | 62,735 | 34,104 | 28,631 | 6,519,293 | 16,171,917 |
| 331 | 12/01/2055 | 62,735 | 33,955 | 28,781 | 6,490,513 | 16,205,871 |
| 332 | 01/01/2056 | 62,735 | 33,805 | 28,930 | 6,461,582 | 16,239,676 |
| 333 | 02/01/2056 | 62,735 | 33,654 | 29,081 | 6,432,501 | 16,273,330 |
| 334 | 03/01/2056 | 62,735 | 33,503 | 29,233 | 6,403,268 | 16,306,833 |
| 335 | 04/01/2056 | 62,735 | 33,350 | 29,385 | 6,373,884 | 16,340,183 |
| 336 | 05/01/2056 | 62,735 | 33,197 | 29,538 | 6,344,346 | 16,373,381 |
| 337 | 06/01/2056 | 62,735 | 33,043 | 29,692 | 6,314,654 | 16,406,424 |
| 338 | 07/01/2056 | 62,735 | 32,889 | 29,846 | 6,284,808 | 16,439,313 |
| 339 | 08/01/2056 | 62,735 | 32,733 | 30,002 | 6,254,806 | 16,472,046 |
| 340 | 09/01/2056 | 62,735 | 32,577 | 30,158 | 6,224,648 | 16,504,623 |
| 341 | 10/01/2056 | 62,735 | 32,420 | 30,315 | 6,194,332 | 16,537,043 |
| 342 | 11/01/2056 | 62,735 | 32,262 | 30,473 | 6,163,859 | 16,569,305 |
| 343 | 12/01/2056 | 62,735 | 32,103 | 30,632 | 6,133,227 | 16,601,409 |
| 344 | 01/01/2057 | 62,735 | 31,944 | 30,791 | 6,102,436 | 16,633,353 |
| 345 | 02/01/2057 | 62,735 | 31,784 | 30,952 | 6,071,484 | 16,665,136 |
| 346 | 03/01/2057 | 62,735 | 31,622 | 31,113 | 6,040,372 | 16,696,759 |
| 347 | 04/01/2057 | 62,735 | 31,460 | 31,275 | 6,009,097 | 16,728,219 |
| 348 | 05/01/2057 | 62,735 | 31,297 | 31,438 | 5,977,659 | 16,759,516 |
| 349 | 06/01/2057 | 62,735 | 31,134 | 31,602 | 5,946,057 | 16,790,650 |
| 350 | 07/01/2057 | 62,735 | 30,969 | 31,766 | 5,914,291 | 16,821,619 |
| 351 | 08/01/2057 | 62,735 | 30,804 | 31,932 | 5,882,359 | 16,852,423 |
| 352 | 09/01/2057 | 62,735 | 30,637 | 32,098 | 5,850,261 | 16,883,060 |
| 353 | 10/01/2057 | 62,735 | 30,470 | 32,265 | 5,817,996 | 16,913,530 |
| 354 | 11/01/2057 | 62,735 | 30,302 | 32,433 | 5,785,563 | 16,943,832 |
| 355 | 12/01/2057 | 62,735 | 30,133 | 32,602 | 5,752,961 | 16,973,965 |
| 356 | 01/01/2058 | 62,735 | 29,963 | 32,772 | 5,720,189 | 17,003,929 |
| 357 | 02/01/2058 | 62,735 | 29,793 | 32,943 | 5,687,247 | 17,033,721 |
| 358 | 03/01/2058 | 62,735 | 29,621 | 33,114 | 5,654,132 | 17,063,342 |
| 359 | 04/01/2058 | 62,735 | 29,449 | 33,287 | 5,620,846 | 17,092,791 |
| 360 | 05/01/2058 | 62,735 | 29,275 | 33,460 | 5,587,386 | 17,122,066 |
| 361 | 06/01/2058 | 62,735 | 29,101 | 33,634 | 5,553,752 | 17,151,167 |
| 362 | 07/01/2058 | 62,735 | 28,926 | 33,809 | 5,519,942 | 17,180,093 |
| 363 | 08/01/2058 | 62,735 | 28,750 | 33,986 | 5,485,957 | 17,208,843 |
| 364 | 09/01/2058 | 62,735 | 28,573 | 34,163 | 5,451,794 | 17,237,415 |
| 365 | 10/01/2058 | 62,735 | 28,395 | 34,340 | 5,417,454 | 17,265,810 |
| 366 | 11/01/2058 | 62,735 | 28,216 | 34,519 | 5,382,934 | 17,294,026 |
| 367 | 12/01/2058 | 62,735 | 28,036 | 34,699 | 5,348,235 | 17,322,062 |
| 368 | 01/01/2059 | 62,735 | 27,855 | 34,880 | 5,313,355 | 17,349,917 |
| 369 | 02/01/2059 | 62,735 | 27,674 | 35,061 | 5,278,294 | 17,377,591 |
| 370 | 03/01/2059 | 62,735 | 27,491 | 35,244 | 5,243,050 | 17,405,082 |
| 371 | 04/01/2059 | 62,735 | 27,308 | 35,428 | 5,207,622 | 17,432,390 |
| 372 | 05/01/2059 | 62,735 | 27,123 | 35,612 | 5,172,010 | 17,459,513 |
| 373 | 06/01/2059 | 62,735 | 26,938 | 35,798 | 5,136,212 | 17,486,450 |
| 374 | 07/01/2059 | 62,735 | 26,751 | 35,984 | 5,100,228 | 17,513,202 |
| 375 | 08/01/2059 | 62,735 | 26,564 | 36,172 | 5,064,057 | 17,539,765 |
| 376 | 09/01/2059 | 62,735 | 26,375 | 36,360 | 5,027,697 | 17,566,140 |
| 377 | 10/01/2059 | 62,735 | 26,186 | 36,549 | 4,991,147 | 17,592,326 |
| 378 | 11/01/2059 | 62,735 | 25,996 | 36,740 | 4,954,408 | 17,618,322 |
| 379 | 12/01/2059 | 62,735 | 25,804 | 36,931 | 4,917,477 | 17,644,126 |
| 380 | 01/01/2060 | 62,735 | 25,612 | 37,123 | 4,880,353 | 17,669,738 |
| 381 | 02/01/2060 | 62,735 | 25,419 | 37,317 | 4,843,037 | 17,695,157 |
| 382 | 03/01/2060 | 62,735 | 25,224 | 37,511 | 4,805,526 | 17,720,381 |
| 383 | 04/01/2060 | 62,735 | 25,029 | 37,706 | 4,767,819 | 17,745,409 |
| 384 | 05/01/2060 | 62,735 | 24,832 | 37,903 | 4,729,916 | 17,770,242 |
| 385 | 06/01/2060 | 62,735 | 24,635 | 38,100 | 4,691,816 | 17,794,877 |
| 386 | 07/01/2060 | 62,735 | 24,437 | 38,299 | 4,653,517 | 17,819,313 |
| 387 | 08/01/2060 | 62,735 | 24,237 | 38,498 | 4,615,019 | 17,843,550 |
| 388 | 09/01/2060 | 62,735 | 24,037 | 38,699 | 4,576,321 | 17,867,587 |
| 389 | 10/01/2060 | 62,735 | 23,835 | 38,900 | 4,537,420 | 17,891,422 |
| 390 | 11/01/2060 | 62,735 | 23,632 | 39,103 | 4,498,318 | 17,915,054 |
| 391 | 12/01/2060 | 62,735 | 23,429 | 39,306 | 4,459,011 | 17,938,483 |
| 392 | 01/01/2061 | 62,735 | 23,224 | 39,511 | 4,419,500 | 17,961,707 |
| 393 | 02/01/2061 | 62,735 | 23,018 | 39,717 | 4,379,783 | 17,984,725 |
| 394 | 03/01/2061 | 62,735 | 22,811 | 39,924 | 4,339,859 | 18,007,537 |
| 395 | 04/01/2061 | 62,735 | 22,603 | 40,132 | 4,299,727 | 18,030,140 |
| 396 | 05/01/2061 | 62,735 | 22,394 | 40,341 | 4,259,386 | 18,052,535 |
| 397 | 06/01/2061 | 62,735 | 22,184 | 40,551 | 4,218,835 | 18,074,719 |
| 398 | 07/01/2061 | 62,735 | 21,973 | 40,762 | 4,178,073 | 18,096,692 |
| 399 | 08/01/2061 | 62,735 | 21,761 | 40,974 | 4,137,099 | 18,118,453 |
| 400 | 09/01/2061 | 62,735 | 21,547 | 41,188 | 4,095,911 | 18,140,000 |
| 401 | 10/01/2061 | 62,735 | 21,333 | 41,402 | 4,054,509 | 18,161,333 |
| 402 | 11/01/2061 | 62,735 | 21,117 | 41,618 | 4,012,891 | 18,182,450 |
| 403 | 12/01/2061 | 62,735 | 20,900 | 41,835 | 3,971,056 | 18,203,351 |
| 404 | 01/01/2062 | 62,735 | 20,683 | 42,053 | 3,929,003 | 18,224,033 |
| 405 | 02/01/2062 | 62,735 | 20,464 | 42,272 | 3,886,732 | 18,244,497 |
| 406 | 03/01/2062 | 62,735 | 20,243 | 42,492 | 3,844,240 | 18,264,740 |
| 407 | 04/01/2062 | 62,735 | 20,022 | 42,713 | 3,801,527 | 18,284,762 |
| 408 | 05/01/2062 | 62,735 | 19,800 | 42,936 | 3,758,591 | 18,304,562 |
| 409 | 06/01/2062 | 62,735 | 19,576 | 43,159 | 3,715,432 | 18,324,138 |
| 410 | 07/01/2062 | 62,735 | 19,351 | 43,384 | 3,672,048 | 18,343,489 |
| 411 | 08/01/2062 | 62,735 | 19,125 | 43,610 | 3,628,438 | 18,362,614 |
| 412 | 09/01/2062 | 62,735 | 18,898 | 43,837 | 3,584,601 | 18,381,513 |
| 413 | 10/01/2062 | 62,735 | 18,670 | 44,065 | 3,540,535 | 18,400,182 |
| 414 | 11/01/2062 | 62,735 | 18,440 | 44,295 | 3,496,240 | 18,418,623 |
| 415 | 12/01/2062 | 62,735 | 18,210 | 44,526 | 3,451,715 | 18,436,832 |
| 416 | 01/01/2063 | 62,735 | 17,978 | 44,758 | 3,406,957 | 18,454,810 |
| 417 | 02/01/2063 | 62,735 | 17,745 | 44,991 | 3,361,967 | 18,472,555 |
| 418 | 03/01/2063 | 62,735 | 17,510 | 45,225 | 3,316,742 | 18,490,065 |
| 419 | 04/01/2063 | 62,735 | 17,275 | 45,461 | 3,271,281 | 18,507,339 |
| 420 | 05/01/2063 | 62,735 | 17,038 | 45,697 | 3,225,584 | 18,524,377 |
| 421 | 06/01/2063 | 62,735 | 16,800 | 45,935 | 3,179,648 | 18,541,177 |
| 422 | 07/01/2063 | 62,735 | 16,561 | 46,175 | 3,133,474 | 18,557,738 |
| 423 | 08/01/2063 | 62,735 | 16,320 | 46,415 | 3,087,059 | 18,574,058 |
| 424 | 09/01/2063 | 62,735 | 16,078 | 46,657 | 3,040,402 | 18,590,137 |
| 425 | 10/01/2063 | 62,735 | 15,835 | 46,900 | 2,993,502 | 18,605,972 |
| 426 | 11/01/2063 | 62,735 | 15,591 | 47,144 | 2,946,358 | 18,621,563 |
| 427 | 12/01/2063 | 62,735 | 15,346 | 47,390 | 2,898,969 | 18,636,909 |
| 428 | 01/01/2064 | 62,735 | 15,099 | 47,636 | 2,851,332 | 18,652,008 |
| 429 | 02/01/2064 | 62,735 | 14,851 | 47,885 | 2,803,448 | 18,666,858 |
| 430 | 03/01/2064 | 62,735 | 14,601 | 48,134 | 2,755,314 | 18,681,460 |
| 431 | 04/01/2064 | 62,735 | 14,351 | 48,385 | 2,706,929 | 18,695,810 |
| 432 | 05/01/2064 | 62,735 | 14,099 | 48,637 | 2,658,292 | 18,709,909 |
| 433 | 06/01/2064 | 62,735 | 13,845 | 48,890 | 2,609,402 | 18,723,754 |
| 434 | 07/01/2064 | 62,735 | 13,591 | 49,145 | 2,560,258 | 18,737,345 |
| 435 | 08/01/2064 | 62,735 | 13,335 | 49,401 | 2,510,857 | 18,750,679 |
| 436 | 09/01/2064 | 62,735 | 13,077 | 49,658 | 2,461,200 | 18,763,757 |
| 437 | 10/01/2064 | 62,735 | 12,819 | 49,916 | 2,411,283 | 18,776,575 |
| 438 | 11/01/2064 | 62,735 | 12,559 | 50,176 | 2,361,107 | 18,789,134 |
| 439 | 12/01/2064 | 62,735 | 12,297 | 50,438 | 2,310,669 | 18,801,432 |
| 440 | 01/01/2065 | 62,735 | 12,035 | 50,700 | 2,259,968 | 18,813,466 |
| 441 | 02/01/2065 | 62,735 | 11,771 | 50,965 | 2,209,004 | 18,825,237 |
| 442 | 03/01/2065 | 62,735 | 11,505 | 51,230 | 2,157,774 | 18,836,742 |
| 443 | 04/01/2065 | 62,735 | 11,238 | 51,497 | 2,106,277 | 18,847,981 |
| 444 | 05/01/2065 | 62,735 | 10,970 | 51,765 | 2,054,512 | 18,858,951 |
| 445 | 06/01/2065 | 62,735 | 10,701 | 52,035 | 2,002,477 | 18,869,651 |
| 446 | 07/01/2065 | 62,735 | 10,430 | 52,306 | 1,950,172 | 18,880,081 |
| 447 | 08/01/2065 | 62,735 | 10,157 | 52,578 | 1,897,594 | 18,890,238 |
| 448 | 09/01/2065 | 62,735 | 9,883 | 52,852 | 1,844,742 | 18,900,121 |
| 449 | 10/01/2065 | 62,735 | 9,608 | 53,127 | 1,791,614 | 18,909,729 |
| 450 | 11/01/2065 | 62,735 | 9,331 | 53,404 | 1,738,211 | 18,919,061 |
| 451 | 12/01/2065 | 62,735 | 9,053 | 53,682 | 1,684,528 | 18,928,114 |
| 452 | 01/01/2066 | 62,735 | 8,774 | 53,962 | 1,630,567 | 18,936,888 |
| 453 | 02/01/2066 | 62,735 | 8,493 | 54,243 | 1,576,324 | 18,945,380 |
| 454 | 03/01/2066 | 62,735 | 8,210 | 54,525 | 1,521,799 | 18,953,590 |
| 455 | 04/01/2066 | 62,735 | 7,926 | 54,809 | 1,466,990 | 18,961,516 |
| 456 | 05/01/2066 | 62,735 | 7,641 | 55,095 | 1,411,895 | 18,969,157 |
| 457 | 06/01/2066 | 62,735 | 7,354 | 55,382 | 1,356,514 | 18,976,510 |
| 458 | 07/01/2066 | 62,735 | 7,065 | 55,670 | 1,300,843 | 18,983,576 |
| 459 | 08/01/2066 | 62,735 | 6,775 | 55,960 | 1,244,883 | 18,990,351 |
| 460 | 09/01/2066 | 62,735 | 6,484 | 56,251 | 1,188,632 | 18,996,835 |
| 461 | 10/01/2066 | 62,735 | 6,191 | 56,544 | 1,132,088 | 19,003,025 |
| 462 | 11/01/2066 | 62,735 | 5,896 | 56,839 | 1,075,249 | 19,008,922 |
| 463 | 12/01/2066 | 62,735 | 5,600 | 57,135 | 1,018,114 | 19,014,522 |
| 464 | 01/01/2067 | 62,735 | 5,303 | 57,433 | 960,681 | 19,019,825 |
| 465 | 02/01/2067 | 62,735 | 5,004 | 57,732 | 902,949 | 19,024,828 |
| 466 | 03/01/2067 | 62,735 | 4,703 | 58,032 | 844,917 | 19,029,531 |
| 467 | 04/01/2067 | 62,735 | 4,401 | 58,335 | 786,582 | 19,033,932 |
| 468 | 05/01/2067 | 62,735 | 4,097 | 58,638 | 727,944 | 19,038,028 |
| 469 | 06/01/2067 | 62,735 | 3,791 | 58,944 | 669,000 | 19,041,820 |
| 470 | 07/01/2067 | 62,735 | 3,484 | 59,251 | 609,749 | 19,045,304 |
| 471 | 08/01/2067 | 62,735 | 3,176 | 59,559 | 550,190 | 19,048,480 |
| 472 | 09/01/2067 | 62,735 | 2,866 | 59,870 | 490,320 | 19,051,345 |
| 473 | 10/01/2067 | 62,735 | 2,554 | 60,181 | 430,139 | 19,053,899 |
| 474 | 11/01/2067 | 62,735 | 2,240 | 60,495 | 369,644 | 19,056,139 |
| 475 | 12/01/2067 | 62,735 | 1,925 | 60,810 | 308,834 | 19,058,065 |
| 476 | 01/01/2068 | 62,735 | 1,609 | 61,127 | 247,707 | 19,059,673 |
| 477 | 02/01/2068 | 62,735 | 1,290 | 61,445 | 186,262 | 19,060,963 |
| 478 | 03/01/2068 | 62,735 | 970 | 61,765 | 124,497 | 19,061,933 |
| 479 | 04/01/2068 | 62,735 | 648 | 62,087 | 62,410 | 19,062,582 |
| 480 | 05/01/2068 | 62,735 | 325 | 62,410 | — | 19,062,907 |
| Total | 30,112,907 | 19,062,907 | 11,050,000 | 9,173,493 | 19,062,907 | |
Annual Summary (41 years)
| Year | Payments | Interest | Principal | Balance | Cum Int |
|---|---|---|---|---|---|
| 2028 | 439,147 | 402,293 | 36,854 | 11,013,146 | 402,293 |
| 2029 | 752,823 | 686,441 | 66,381 | 10,946,765 | 1,088,734 |
| 2030 | 752,823 | 682,172 | 70,651 | 10,876,114 | 1,770,906 |
| 2031 | 752,823 | 677,627 | 75,195 | 10,800,919 | 2,448,533 |
| 2032 | 752,823 | 672,791 | 80,032 | 10,720,887 | 3,121,324 |
| 2033 | 752,823 | 667,643 | 85,180 | 10,635,707 | 3,788,967 |
| 2034 | 752,823 | 662,164 | 90,659 | 10,545,048 | 4,451,131 |
| 2035 | 752,823 | 656,333 | 96,490 | 10,448,558 | 5,107,463 |
| 2036 | 752,823 | 650,126 | 102,697 | 10,345,861 | 5,757,589 |
| 2037 | 752,823 | 643,521 | 109,302 | 10,236,559 | 6,401,110 |
| 2038 | 752,823 | 636,490 | 116,333 | 10,120,227 | 7,037,600 |
| 2039 | 752,823 | 629,007 | 123,815 | 9,996,411 | 7,666,607 |
| 2040 | 752,823 | 621,043 | 131,779 | 9,864,632 | 8,287,650 |
| 2041 | 752,823 | 612,567 | 140,256 | 9,724,376 | 8,900,217 |
| 2042 | 752,823 | 603,545 | 149,277 | 9,575,099 | 9,503,763 |
| 2043 | 752,823 | 593,944 | 158,879 | 9,416,220 | 10,097,707 |
| 2044 | 752,823 | 583,724 | 169,098 | 9,247,122 | 10,681,431 |
| 2045 | 752,823 | 572,848 | 179,975 | 9,067,146 | 11,254,278 |
| 2046 | 752,823 | 561,271 | 191,551 | 8,875,595 | 11,815,550 |
| 2047 | 752,823 | 548,950 | 203,872 | 8,671,723 | 12,364,500 |
| 2048 | 752,823 | 535,837 | 216,986 | 8,454,737 | 12,900,337 |
| 2049 | 752,823 | 521,880 | 230,943 | 8,223,794 | 13,422,217 |
| 2050 | 752,823 | 507,025 | 245,797 | 7,977,997 | 13,929,242 |
| 2051 | 752,823 | 491,215 | 261,607 | 7,716,389 | 14,420,457 |
| 2052 | 752,823 | 474,388 | 278,435 | 7,437,955 | 14,894,846 |
| 2053 | 752,823 | 456,479 | 296,344 | 7,141,611 | 15,351,324 |
| 2054 | 752,823 | 437,417 | 315,405 | 6,826,205 | 15,788,742 |
| 2055 | 752,823 | 417,130 | 335,693 | 6,490,513 | 16,205,871 |
| 2056 | 752,823 | 395,537 | 357,285 | 6,133,227 | 16,601,409 |
| 2057 | 752,823 | 372,556 | 380,266 | 5,752,961 | 16,973,965 |
| 2058 | 752,823 | 348,097 | 404,726 | 5,348,235 | 17,322,062 |
| 2059 | 752,823 | 322,064 | 430,759 | 4,917,477 | 17,644,126 |
| 2060 | 752,823 | 294,357 | 458,466 | 4,459,011 | 17,938,483 |
| 2061 | 752,823 | 264,868 | 487,955 | 3,971,056 | 18,203,351 |
| 2062 | 752,823 | 233,481 | 519,341 | 3,451,715 | 18,436,832 |
| 2063 | 752,823 | 200,077 | 552,746 | 2,898,969 | 18,636,909 |
| 2064 | 752,823 | 164,523 | 588,300 | 2,310,669 | 18,801,432 |
| 2065 | 752,823 | 126,682 | 626,140 | 1,684,528 | 18,928,114 |
| 2066 | 752,823 | 86,408 | 666,415 | 1,018,114 | 19,014,522 |
| 2067 | 752,823 | 43,543 | 709,280 | 308,834 | 19,058,065 |
| 2068 | 313,676 | 4,842 | 308,834 | — | 19,062,907 |
| Total | 30,112,907 | 19,062,907 | 11,050,000 | 9,173,493 | 19,062,907 |
Subordinate Amortization
No subordinate mortgages. Add via the Subordinate Debt panel below.
Subordinate / Soft Debt (0/4) — Deal Level
LP-secured: stays on the deal across site activation toggles. Waterfall: DDF first, first mortgage next, subordinates by ascending position last.
No deal-level subordinate debt. Click "+ Add Soft Loan" to add a county HOME, HCD NPLH/HHAP/IIG, AHSC, city soft loan, etc.