Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    SLS Excel Spreadsheet For PT

    Uploaded by

    elliottchewyinyi
    Something

    Copyright:

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

    SLS Excel Spreadsheet For PT

    Uploaded by

    elliottchewyinyi
    13 views4 pages
    Something

    Original Title

    SLS Excel Spreadsheet for PT

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Something

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views4 pages

    SLS Excel Spreadsheet For PT

    Uploaded by

    elliottchewyinyi
    Something

    Copyright:

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

    Compound Interest Calculator

    Principal ($) 1000

    Interest Rate (%) 400%

    Year Total Amount($)

    1 1,040.00

    2 1,081.60

    3 1,124.86

    4 1,169.86

    5 1,216.65

    6 1,265.32

    7 1,315.93

    8 1,368.57

    9 1,423.31

    10 1,480.24

    11 1,539.45

    12 1,601.03
    13 1,665.07
    14 1,731.68
    15 1,800.94
    16 1,872.98
    17 1,947.90
    18 2,025.82
    19 2,106.85
    20 2,191.12
    21 2,278.77
    22 2,369.92
    23 2,464.72
    24 2,563.30
    25 2,665.84
    26 2,772.47
    27 2,883.37
    28 2,998.70
    29 3,118.65
    30 3,243.40
    31 3,373.13
    32 3,508.06
    33 3,648.38
    34 3,794.32
    35 3,946.09
    36 4,103.93
    37 4,268.09
    38 4,438.81
    39 4,616.37
    40 4,801.02
    41 4,993.06
    42 5,192.78
    43 5,400.50
    44 5,616.52
    45 5,841.18
    46 6,074.82
    47 6,317.82
    48 6,570.53
    49 6,833.35
    50 7,106.68
    51 7,390.95
    52 7,686.59
    53 7,994.05
    54 8,313.81
    55 8,646.37
    56 8,992.22
    57 9,351.91
    58 9,725.99
    59 10,115.03
    60 10,519.63
    61 10,940.41
    62 11,378.03
    63 11,833.15
    64 12,306.48
    65 12,798.74
    66 13,310.68
    67 13,843.11
    68 14,396.84
    69 14,972.71
    70 15,571.62
    71 16,194.48
    72 16,842.26
    73 17,515.95
    74 18,216.59
    75 18,945.25
    76 19,703.06
    77 20,491.19
    78 21,310.83
    Instructions
    Step 1: Key in the two main inputs (i.e. Principal and
    interest rate) we will be using in our calculations, into cells
    D4 and D6 respectively.

    Step 2: Insert the formula below into cell D9 to obtain the


    total amount Shane will have at the end of Year 1. The
    formula should reference cells B9, $D$4 and $D$6.

    Step 3: Extend and duplicate the calculations to more


    rows by highlighting cells B9 to D9, then click on the
    square at the bottom right corner and drag downwards to
    extend the highlighted box e.g., to row 20. You may wish
    to add more rows to reach the targeted value.

    Step 4: Upload the completed excel file in SLS Activity 1


    Q1.

    Step 5: Answer Q2 in SLS Activity 1 Q2.

    You might also like