Column A Column B Column C Column D Column E Column F Column G
Row 1   AMOUNT BORROWED AS OF 2015 AT AGE 21:   Row 1
Row 2   INTEREST RATE %:   Row 2
Row 3   PERIOD FACTOR / FREQUENCY OF PAYMENTS (NUMBER OF TIMES PER YEAR): 12 52 360   Row 3
Row 4 Year End-of-Year Life of the Loan (Years) Compounding Frequency Choices for Cell C3 Above:
360 = Daily
52 = Weekly
12 = Monthly
4 = Quarterly
2 = Semi-annually
1 = Yearly
Monthly Payment Required to Pay Off Debt with Interest (Compounded Monthly) within the Given Number of Years Weekly Payment Required to Pay Off Debt with Interest (Compounded Weekly) within the Given Number of Years Daily Payment Required to Pay Off Debt with Interest (Compounded Daily, or Equivalent to 12 Months at 30 Days Per Month) within the Given Number of Years Example Age (Years Old) Row 4
Row 5 2015 1 21 Row 5
Row 6 2016 2 22 Row 6
Row 7 2017 3 23 Row 7
Row 8 2018 4 24 Row 8
Row 9 2019 5 25 Row 9
Row 10 2020 6 26 Row 10
Row 11 2021 7 27 Row 11
Row 12 2022 8 28 Row 12
Row 13 2023 9 29 Row 13
Row 14 2024 10 30 Row 14
Row 15 2025 11 31 Row 15
Row 16 2026 12 32 Row 16
Row 17 2027 13 33 Row 17
Row 18 Enter a year: 34 Row 18
Column A Column B Column C Column D Column E Column F Column G