Spreadsheet: 104223d1301883726-layout-of-values-within-a-amortization-schedule-table-student-loan-calc
Sheet: Estimate 2

Est #2 Assumes a larger min payment by [NAME] and [NAME] |  |  |  |  |  | Enter a range of 5-30 yrs in cell to right | 30
 |  | 224.03 |  |  |  | Total of principal & Interest
Year # | Date | Scheduled Payment Joe | Scheduled Payment [NAME] | Total Actual Payment
 | 2011-07-01 00:00:00
 | 2011-08-01 00:00:00
 | 2011-09-01 00:00:00
 | 2011-10-01 00:00:00
 | 2011-11-01 00:00:00
 | 2011-12-01 00:00:00
 | 2012-01-01 00:00:00
 | 2012-02-01 00:00:00
 | 2012-03-01 00:00:00
 | 2012-04-01 00:00:00
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
1 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
 | 2013-01-01 00:00:00
 | 2013-02-01 00:00:00
 | 2013-03-01 00:00:00
 | 2013-04-01 00:00:00
 | 2013-05-01 00:00:00
 | 2013-06-01 00:00:00
 | 2013-07-01 00:00:00
 | 2013-08-01 00:00:00
 | 2013-09-01 00:00:00
 | 2013-10-01 00:00:00
 | 2013-11-01 00:00:00
 | 2013-12-01 00:00:00
 | 2014-01-01 00:00:00
 | 2014-02-01 00:00:00
 | 2014-03-01 00:00:00
 | 2014-04-01 00:00:00
 | 2014-05-01 00:00:00
 | 2014-06-01 00:00:00
 | 2014-07-01 00:00:00
 | 2014-08-01 00:00:00
 | 2014-09-01 00:00:00
 | 2014-10-01 00:00:00
 | 2014-11-01 00:00:00
 | 2014-12-01 00:00:00
 | 2015-01-01 00:00:00
 | 2015-02-01 00:00:00
 | 2015-03-01 00:00:00
 | 2015-04-01 00:00:00
 | 2015-05-01 00:00:00
 | 2015-06-01 00:00:00
 | 2015-07-01 00:00:00
 | 2015-08-01 00:00:00
 | 2015-09-01 00:00:00
 | 2015-10-01 00:00:00
 | 2015-11-01 00:00:00
 | 2015-12-01 00:00:00
 | 2016-01-01 00:00:00
 | 2016-02-01 00:00:00
 | 2016-03-01 00:00:00
 | 2016-04-01 00:00:00
 | 2016-05-01 00:00:00
 | 2016-06-01 00:00:00
 | 2016-07-01 00:00:00
 | 2016-08-01 00:00:00
 | 2016-09-01 00:00:00
 | 2016-10-01 00:00:00
 | 2016-11-01 00:00:00
 | 2016-12-01 00:00:00
 | 2017-01-01 00:00:00
 | 2017-02-01 00:00:00
 | 2017-03-01 00:00:00
 | 2017-04-01 00:00:00
 | 2017-05-01 00:00:00
 | 2017-06-01 00:00:00
 | 2017-07-01 00:00:00
 | 2017-08-01 00:00:00
 | 2017-09-01 00:00:00
 | 2017-10-01 00:00:00
 | 2017-11-01 00:00:00
 | 2017-12-01 00:00:00
 | 2018-01-01 00:00:00
 | 2018-02-01 00:00:00
 | 2018-03-01 00:00:00
 | 2018-04-01 00:00:00
 | 2018-05-01 00:00:00
 | 2018-06-01 00:00:00
 | 2018-07-01 00:00:00
 | 2018-08-01 00:00:00
 | 2018-09-01 00:00:00
 | 2018-10-01 00:00:00
 | 2018-11-01 00:00:00
 | 2018-12-01 00:00:00
 | 2019-01-01 00:00:00
 | 2019-02-01 00:00:00
 | 2019-03-01 00:00:00
 | 2019-04-01 00:00:00
 | 2019-05-01 00:00:00
 | 2019-06-01 00:00:00
 | 2019-07-01 00:00:00
 | 2019-08-01 00:00:00
 | 2019-09-01 00:00:00
 | 2019-10-01 00:00:00
 | 2019-11-01 00:00:00
 | 2019-12-01 00:00:00
 | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00
 | 2020-04-01 00:00:00
 | 2020-05-01 00:00:00
 | 2020-06-01 00:00:00
 | 2020-07-01 00:00:00
 | 2020-08-01 00:00:00
 | 2020-09-01 00:00:00
 | 2020-10-01 00:00:00
 | 2020-11-01 00:00:00
 | 2020-12-01 00:00:00
 | 2021-01-01 00:00:00
 | 2021-02-01 00:00:00
 | 2021-03-01 00:00:00
 | 2021-04-01 00:00:00
 | 2021-05-01 00:00:00
 | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00
 | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
 | 2023-01-01 00:00:00
 | 2023-02-01 00:00:00
 | 2023-03-01 00:00:00
 | 2023-04-01 00:00:00
 | 2023-05-01 00:00:00
 | 2023-06-01 00:00:00
 | 2023-07-01 00:00:00
 | 2023-08-01 00:00:00
 | 2023-09-01 00:00:00
 | 2023-10-01 00:00:00
 | 2023-11-01 00:00:00
 | 2023-12-01 00:00:00
 | 2024-01-01 00:00:00
 | 2024-02-01 00:00:00
 | 2024-03-01 00:00:00
 | 2024-04-01 00:00:00
 | 2024-05-01 00:00:00
 | 2024-06-01 00:00:00
 | 2024-07-01 00:00:00
 | 2024-08-01 00:00:00
 | 2024-09-01 00:00:00
 | 2024-10-01 00:00:00
 | 2024-11-01 00:00:00
 | 2024-12-01 00:00:00
 | 2025-01-01 00:00:00
 | 2025-02-01 00:00:00
 | 2025-03-01 00:00:00
 | 2025-04-01 00:00:00
 | 2025-05-01 00:00:00
 | 2025-06-01 00:00:00
 | 2025-07-01 00:00:00
 | 2025-08-01 00:00:00
 | 2025-09-01 00:00:00
 | 2025-10-01 00:00:00
 | 2025-11-01 00:00:00
 | 2025-12-01 00:00:00
 | 2026-01-01 00:00:00
 | 2026-02-01 00:00:00
 | 2026-03-01 00:00:00
 | 2026-04-01 00:00:00
 | 2026-05-01 00:00:00
 | 2026-06-01 00:00:00
 | 2026-07-01 00:00:00
 | 2026-08-01 00:00:00
 | 2026-09-01 00:00:00
 | 2026-10-01 00:00:00
 | 2026-11-01 00:00:00
 | 2026-12-01 00:00:00
 | 2027-01-01 00:00:00
 | 2027-02-01 00:00:00
 | 2027-03-01 00:00:00
 | 2027-04-01 00:00:00
 | 2027-05-01 00:00:00
 | 2027-06-01 00:00:00
 | 2027-07-01 00:00:00
 | 2027-08-01 00:00:00
 | 2027-09-01 00:00:00
 | 2027-10-01 00:00:00
 | 2027-11-01 00:00:00
 | 2027-12-01 00:00:00
 | 2028-01-01 00:00:00
 | 2028-02-01 00:00:00
 | 2028-03-01 00:00:00
 | 2028-04-01 00:00:00
 | 2028-05-01 00:00:00
 | 2028-06-01 00:00:00
 | 2028-07-01 00:00:00
 | 2028-08-01 00:00:00
 | 2028-09-01 00:00:00
 | 2028-10-01 00:00:00
 | 2028-11-01 00:00:00
 | 2028-12-01 00:00:00
 | 2029-01-01 00:00:00
 | 2029-02-01 00:00:00
 | 2029-03-01 00:00:00
 | 2029-04-01 00:00:00
 | 2029-05-01 00:00:00
 | 2029-06-01 00:00:00
 | 2029-07-01 00:00:00
 | 2029-08-01 00:00:00
 | 2029-09-01 00:00:00
 | 2029-10-01 00:00:00
 | 2029-11-01 00:00:00
 | 2029-12-01 00:00:00
 | 2030-01-01 00:00:00
 | 2030-02-01 00:00:00
 | 2030-03-01 00:00:00
 | 2030-04-01 00:00:00
 | 2030-05-01 00:00:00
 | 2030-06-01 00:00:00
 | 2030-07-01 00:00:00
 | 2030-08-01 00:00:00
 | 2030-09-01 00:00:00
 | 2030-10-01 00:00:00
 | 2030-11-01 00:00:00
 | 2030-12-01 00:00:00
 | 2031-01-01 00:00:00
 | 2031-02-01 00:00:00
 | 2031-03-01 00:00:00
 | 2031-04-01 00:00:00
 | 2031-05-01 00:00:00
 | 2031-06-01 00:00:00
 | 2031-07-01 00:00:00
 | 2031-08-01 00:00:00
 | 2031-09-01 00:00:00
 | 2031-10-01 00:00:00
 | 2031-11-01 00:00:00
 | 2031-12-01 00:00:00
 | 2032-01-01 00:00:00
 | 2032-02-01 00:00:00
 | 2032-03-01 00:00:00
 | 2032-04-01 00:00:00
 | 2032-05-01 00:00:00
 | 2032-06-01 00:00:00
 | 2032-07-01 00:00:00
 | 2032-08-01 00:00:00
 | 2032-09-01 00:00:00
 | 2032-10-01 00:00:00
 | 2032-11-01 00:00:00
 | 2032-12-01 00:00:00
 | 2033-01-01 00:00:00
 | 2033-02-01 00:00:00
 | 2033-03-01 00:00:00
 | 2033-04-01 00:00:00
 | 2033-05-01 00:00:00
 | 2033-06-01 00:00:00
 | 2033-07-01 00:00:00
 | 2033-08-01 00:00:00
 | 2033-09-01 00:00:00
 | 2033-10-01 00:00:00
 | 2033-11-01 00:00:00
 | 2033-12-01 00:00:00
 | 2034-01-01 00:00:00
 | 2034-02-01 00:00:00
 | 2034-03-01 00:00:00
 | 2034-04-01 00:00:00
 | 2034-05-01 00:00:00
 | 2034-06-01 00:00:00
 | 2034-07-01 00:00:00
 | 2034-08-01 00:00:00
 | 2034-09-01 00:00:00
 | 2034-10-01 00:00:00
 | 2034-11-01 00:00:00
 | 2034-12-01 00:00:00
 | 2035-01-01 00:00:00
 | 2035-02-01 00:00:00
 | 2035-03-01 00:00:00
 | 2035-04-01 00:00:00
 | 2035-05-01 00:00:00
 | 2035-06-01 00:00:00
 | 2035-07-01 00:00:00
 | 2035-08-01 00:00:00
 | 2035-09-01 00:00:00
 | 2035-10-01 00:00:00
 | 2035-11-01 00:00:00
 | 2035-12-01 00:00:00
 | 2036-01-01 00:00:00
 | 2036-02-01 00:00:00
 | 2036-03-01 00:00:00
 | 2036-04-01 00:00:00
 | 2036-05-01 00:00:00
 | 2036-06-01 00:00:00
 | 2036-07-01 00:00:00
 | 2036-08-01 00:00:00
 | 2036-09-01 00:00:00
 | 2036-10-01 00:00:00
 | 2036-11-01 00:00:00
 | 2036-12-01 00:00:00
 | 2037-01-01 00:00:00
 | 2037-02-01 00:00:00
 | 2037-03-01 00:00:00
 | 2037-04-01 00:00:00
 | 2037-05-01 00:00:00
 | 2037-06-01 00:00:00
 | 2037-07-01 00:00:00
 | 2037-08-01 00:00:00
 | 2037-09-01 00:00:00
 | 2037-10-01 00:00:00
 | 2037-11-01 00:00:00
 | 2037-12-01 00:00:00
 | 2038-01-01 00:00:00
 | 2038-02-01 00:00:00
 | 2038-03-01 00:00:00
 | 2038-04-01 00:00:00
 | 2038-05-01 00:00:00
 | 2038-06-01 00:00:00
 | 2038-07-01 00:00:00
 | 2038-08-01 00:00:00
 | 2038-09-01 00:00:00
 | 2038-10-01 00:00:00
 | 2038-11-01 00:00:00
 | 2038-12-01 00:00:00
 | 2039-01-01 00:00:00
 | 2039-02-01 00:00:00
 | 2039-03-01 00:00:00
 | 2039-04-01 00:00:00
 | 2039-05-01 00:00:00
 | 2039-06-01 00:00:00
 | 2039-07-01 00:00:00
 | 2039-08-01 00:00:00
 | 2039-09-01 00:00:00
 | 2039-10-01 00:00:00
 | 2039-11-01 00:00:00
 | 2039-12-01 00:00:00
 | 2040-01-01 00:00:00
 | 2040-02-01 00:00:00
 | 2040-03-01 00:00:00
 | 2040-04-01 00:00:00
 | 2040-05-01 00:00:00
 | 2040-06-01 00:00:00
 | 2040-07-01 00:00:00
 | 2040-08-01 00:00:00
 | 2040-09-01 00:00:00
 | 2040-10-01 00:00:00
 | 2040-11-01 00:00:00
 | 2040-12-01 00:00:00
 | 2041-01-01 00:00:00
 | 2041-02-01 00:00:00
 | 2041-03-01 00:00:00
 | 2041-04-01 00:00:00
 | 2041-05-01 00:00:00
 | 2041-06-01 00:00:00
 | 2041-07-01 00:00:00