Spreadsheet: david_delainey__8063__Walton Cashflow Model 070600
Sheet: Debt Amortization

DOYLE I, LLC
Debt Amortization
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029
TOTAL ANNUAL DEBT AMORTIZATION |  |  | 6.55 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 8
Beginning Balance |  |  | 117411.7639951783 | 116191.4533470055 | 111124.3978036098 | 105746.4097408572 | 100038.4092353552 | 93980.14555186631 | 87550.12529813607 | 80725.53617104629 | 73482.16602356151 | 65794.31696533594 | 57634.71419222858 | 48974.40922127377 | 39782.67718780585 | 30026.90784037078 | 19672.48984669857 | 8682.688000279239
Interest |  |  | 1761.176459927675 | 6858.892889005982 | 6547.960369649132 | 6217.947926899769 | 5867.684748912876 | 5495.928178671511 | 5101.359305311965 | 4682.578284916969 | 4238.099374176179 | 3766.345659294399 | 3265.64346144694 | 2734.216398933821 | 2170.179084966682 | 1571.530438729532 | 936.1465859824226 | 261.7733240209595
Principal |  |  | 1220.310648172763 | 5067.055543395768 | 5377.988062752618 | 5708.000505501982 | 6058.263683488874 | 6430.02025373024 | 6824.589127089786 | 7243.370147484781 | 7687.849058225572 | 8159.602773107352 | 8660.30497095481 | 9191.732033467928 | 9755.769347435067 | 10354.41799367222 | 10989.80184641933 | 8682.688000280354
Total Debt Service |  |  | 2981.487108100438 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 11925.94843240175 | 8944.461324301312
Ending Balance |  |  | 116191.4533470055 | 111124.3978036098 | 105746.4097408572 | 100038.4092353552 | 93980.14555186631 | 87550.12529813607 | 80725.53617104629 | 73482.16602356151 | 65794.31696533594 | 57634.71419222858 | 48974.40922127377 | 39782.67718780585 | 30026.90784037078 | 19672.48984669857 | 8682.688000279239 | -1.11504050437361e-09
Average Life (years) |  |  | 9.596657574740416
EBITDA/Debt Service
PATRONAGE CAPITAL CALCULATION
Patronage Capital Return | 6077.414832624079 |  |  | 241.2165826121299 | 467.0704777003834 | 445.5499027869652 | 422.7187248613197 | 398.4971282000025 | 372.8004363020111 | 345.538815867432 | 316.6169627483871 | 285.9337687743923 | 253.3819682873813 | 218.8477631507113 | 182.210424921218 | 143.3418727935487 | 102.1062258413042 | 161.7378633948666 | 200.1730618715928 | 190.9499583372707 | 181.1651677977084 | 170.7844835142868 | 159.7716155580048 | 148.0880639431851 | 135.692984035023 | 122.5430437604538 | 108.5922721231634 | 93.79189849316197 | 78.09018210909345 | 61.43223119723515 | 43.75981107484466 | 25.01114056700058
Percentage of Prior Year's Interest Payment |  |  |  | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 |  | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03