Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    College Savings Calculator

    Uploaded by

    srinaldy

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    College Savings Calculator

    Uploaded by

    srinaldy
    33 views1 page

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    33 views1 page

    College Savings Calculator

    Uploaded by

    srinaldy

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 1

    College Savings Calculator

    HELP © 2009 Vertex42 LLC


    Name Dion
    Totals as of Year … 15
    Current Age of Child 6 Total Costs $ 205,800.00
    Initial Savings 2,000.00 Total Interest Earned $ 10,708.56
    Annual Interest Rate 4.25% Total Invested $ 218,000.00

    Scheduled Deposits Solving For Zero Balance


    Years to Make Deposits 15 Year of Last Payment 15
    Deposit Amount 1,200.00 Last Payment $ 20,000.00
    Deposit Frequency Monthly Prior Year Balance $ 27,883.08
    Additional Annual Deposits 0.00 NET $ 7,883.08

    $40,000
    End-of-Year Balance
    $35,000 Frequency Periods
    $30,000 Annually 1
    Semi-Annually 2
    $25,000
    Quarterly 4
    $20,000 Bi-Monthly 6
    Monthly 12
    $15,000
    Semi-Monthly 24
    $10,000 Bi-Weekly 26
    $5,000 Weekly 52
    Daily 365
    $- Grade
    1 2 3 4 5 6 7 8 9 10 11 12 C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 - - - - -
    Yearly Schedule
    School Costs This Interest Scheduled Extra Annual End of Year
    Year Age Year Year Earned Deposits Deposits Balance
    1 6 1 10,800.00 0.00 14,400.00 5,600.00
    2 7 2 10,800.00 0.00 14,400.00 9,200.00
    3 8 3 10,800.00 0.00 14,400.00 12,800.00
    4 9 4 10,800.00 370.51 14,400.00 16,770.51
    5 10 5 10,800.00 542.59 14,400.00 20,913.10
    6 11 6 10,800.00 722.12 14,400.00 25,235.22
    7 12 7 12,000.00 857.42 14,400.00 28,492.64
    8 13 8 12,000.00 998.59 14,400.00 31,891.23
    9 14 9 12,000.00 1,145.88 14,400.00 35,437.11
    10 15 10 15,000.00 1,169.54 14,400.00 36,006.64
    11 16 11 15,000.00 1,194.22 14,400.00 36,600.86
    12 17 12 15,000.00 1,219.97 14,400.00 37,220.83
    13 18 C-1 20,000.00 1,030.15 14,400.00 32,650.98
    14 19 C-2 20,000.00 832.10 14,400.00 27,883.08
    15 20 C-3 20,000.00 625.47 14,400.00 22,908.56
    16 21 C-4 992.80 0.00 23,901.36
    17 22 C-5 1,035.83 0.00 24,937.19
    18 23 C-6 1,080.72 0.00 26,017.91
    19 24 C-7 1,127.56 0.00 27,145.47
    20 25 C-8 1,176.42 0.00 28,321.89
    21 26 - 1,227.41 0.00 29,549.30
    22 27 - 1,280.60 0.00 30,829.90
    23 28 - 1,336.10 0.00 32,166.00
    24 29 - 1,394.00 0.00 33,560.00
    25 30 - 1,454.41 0.00 35,014.41

    Page 1 of 1

    You might also like