Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    Compound Vs Simple Interest 8% Per Year For 40 Years

    Uploaded by

    Ranjit R

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Compound Vs Simple Interest 8% Per Year For 40 Years

    Uploaded by

    Ranjit R
    34 views4 pages

    Original Title

    simple_vs_compound_interest

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    34 views4 pages

    Compound Vs Simple Interest 8% Per Year For 40 Years

    Uploaded by

    Ranjit R

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 4

    PV 500000

    Rate 8%

    Period FV (Simple Interest) FV (Compound Interest) Pick a Year: 20


    0 500,000.00 500,000.00
    1 540,000.00 540,000.00
    Compound vs Simple I

    Future Value
    2 580,000.00 583,200.00 X Y
    8% per year for 40 Yea
    3 620,000.00 629,856.00 20.00
    12,000,000 0.00
    4 660,000.00 680,244.48 20.00 ###
    10,000,000
    5 700,000.00 734,664.04 20.00 ###
    6 740,000.00 793,437.16
    8,000,000
    7 780,000.00 856,912.13
    8 820,000.00 925,465.11 6,000,000
    9 860,000.00 999,502.31
    10 900,000.00 1,079,462.50 4,000,000
    11 940,000.00 1,165,819.50
    2,3
    2,000,000
    12 980,000.00 1,259,085.06 1,3
    13 1,020,000.00 1,359,811.86
    0
    14 1,060,000.00 1,468,596.81 0 5 10 15 20
    15 1,100,000.00 1,586,084.56
    16 1,140,000.00 1,712,971.32 FV (Simple Interest)
    Column F Years
    17 1,180,000.00 1,850,009.03
    18 1,220,000.00 1,998,009.75
    19 1,260,000.00 2,157,850.53
    20 1,300,000.00 2,330,478.57 This workbook is Copyright © 2007 by Timothy R. M
    21 1,340,000.00 2,516,916.86
    22 1,380,000.00 2,718,270.21 Please visit http://www.tvmcalcs.com/ for free time v
    calculator, and Microsoft Excel tutorials.
    23 1,420,000.00 2,935,731.82
    24 1,460,000.00 3,170,590.37
    25 1,500,000.00 3,424,237.60
    26 1,540,000.00 3,698,176.61
    27 1,580,000.00 3,994,030.73
    28 1,620,000.00 4,313,553.19
    29 1,660,000.00 4,658,637.45
    30 1,700,000.00 5,031,328.44
    31 1,740,000.00 5,433,834.72
    32 1,780,000.00 5,868,541.50
    33 1,820,000.00 6,338,024.82
    34 1,860,000.00 6,845,066.80
    35 1,900,000.00 7,392,672.15
    36 1,940,000.00 7,984,085.92
    37 1,980,000.00 8,622,812.79
    38 2,020,000.00 9,312,637.82
    39 2,060,000.00 10,057,648.84
    40 2,100,000.00 10,862,260.75
    Compound vs Simple Interest
    8% per year for 40 Years

    2,330,479
    1,300,000

    10 15 20 25 30 35 40

    FV (Simple Interest) FV (Compound Interest)


    Column F Years

    ght © 2007 by Timothy R. Mayes, Ph.D.

    mcalcs.com/ for free time value of money, financial


    Excel tutorials.
    20

    You might also like