Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Mp2 Investment

    Uploaded by

    Wenard Troll
    This document outlines the terms of a multi-purpose loan of ₱30,000 with an annual interest rate of 10.5% to be paid over 24 monthly installments. It then provides two scenarios modeling how the loan proceeds could be invested at a 7% annual dividend rate and compares the ending balances under each scenario.

    Copyright:

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

    Mp2 Investment

    Uploaded by

    Wenard Troll
    10 views3 pages
    This document outlines the terms of a multi-purpose loan of ₱30,000 with an annual interest rate of 10.5% to be paid over 24 monthly installments. It then provides two scenarios modeling how the loan proceeds could be invested at a 7% annual dividend rate and compares the ending balances under each scenario.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the terms of a multi-purpose loan of ₱30,000 with an annual interest rate of 10.5% to be paid over 24 monthly installments. It then provides two scenarios modeling how the loan proceeds could be invested at a 7% annual dividend rate and compares the ending balances under each scenario.

    Copyright:

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

    Mp2 Investment

    Uploaded by

    Wenard Troll
    This document outlines the terms of a multi-purpose loan of ₱30,000 with an annual interest rate of 10.5% to be paid over 24 monthly installments. It then provides two scenarios modeling how the loan proceeds could be invested at a 7% annual dividend rate and compares the ending balances under each scenario.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    MULTI PURPOSE LOAN @ 10.

    5% per Annum

    Principal 30,000.00
    Interest Rate (Annual % / 12) 0.87%
    Period (months) 24.00

    Monthly Amortization) 1,391.28


    ICR ₱33,390.75

    30,000.00
    1 1,391.28 262.50 1,128.78 28,871.22
    2 1,391.28 252.62 1,138.66 27,732.56
    3 1,391.28 242.66 1,148.62 26,583.94
    4 1,391.28 232.61 1,158.67 25,425.27
    5 1,391.28 222.47 1,168.81 24,256.46
    6 1,391.28 212.24 1,179.04 23,077.42
    7 1,391.28 201.93 1,189.35 21,888.07
    8 1,391.28 191.52 1,199.76 20,688.31

    9 1,391.28 181.02 1,210.26 19,478.05


    10 1,391.28 170.43 1,220.85 18,257.20
    11 1,391.28 159.75 1,231.53 17,025.67
    12 1,391.28 148.97 1,242.31 15,783.36
    13 1,391.28 138.10 1,253.18 14,530.18
    14 1,391.28 127.14 1,264.14 13,266.04
    15 1,391.28 116.08 1,275.20 11,990.84
    16 1,391.28 104.92 1,286.36 10,704.48
    17 1,391.28 93.66 1,297.62 9,406.86
    18 1,391.28 82.31 1,308.97 8,097.89
    19 1,391.28 70.86 1,320.42 6,777.46
    20 1,391.28 59.30 1,331.98 5,445.49
    21 1,391.28 47.65 1,343.63 4,101.85
    22 1,391.28 35.89 1,355.39 2,746.46
    23 1,391.28 24.03 1,367.25 1,379.21
    24 1,391.28 12.07 1,379.21 - 0.00

    33,390.75 3,390.75 30,000.00 357,514.28


    MP2 Investment @ 7% dividend per annum
    *ASSUMING ALL INVESTEMENT COMES FROM MPL LOAN

    Accumulated
    Proceed from Loan Dividend @ 7% Investment

    Year 1 30,000.00 2,100.00 32,100.00


    Year 2 2,247.00 34,347.00
    Year 3 30,000.00 4,504.29 68,851.29
    Year 4 4,819.59 73,670.88
    Year 5 30,000.00 7,256.96 110,927.84

    TOTAL 90,000.00 20,927.84 110,927.84

    INTEREST EXPENSE FROM LOAN - 10,172.25 - 10,172.25

    GRAND TOTAL 90,000.00 10,755.59 100,755.59

    MP2 Investment @ 7% dividend per annum


    *INVEST FROM MPL AND VOLUNTARY QTRLY PAYMENT

    Voluntary Qrtly Accumulated


    Proceed from Loan Payment Dividend @ 7% Investment

    Year 1 30,000.00 2,100.00 32,100.00


    Q1 2,000.00 34,100.00
    Q2 2,000.00 2,000.00
    Q3 2,000.00 2,000.00
    Q4 2,000.00 2,000.00
    Year 2 140.00 140.00
    Q1 2,000.00 140.00 2,140.00
    Q2 2,000.00 105.00 2,105.00
    Q3 2,000.00 70.00 2,070.00
    Q4 2,000.00 35.00 2,035.00
    Year 3 30,000.00 2,109.80 32,109.80
    Q1 2,000.00 140.00 2,140.00
    Q2 2,000.00 105.00 2,105.00
    Q3 2,000.00 70.00 2,070.00
    Q4 2,000.00 35.00 2,035.00
    Year 4 2,247.69 2,247.69
    Q1 2,000.00 140.00 2,140.00
    Q2 2,000.00 105.00 2,105.00
    Q3 2,000.00 70.00 2,070.00
    Q4 2,000.00 35.00 2,035.00
    Year 5 30,000.00 2,257.34 32,257.34
    Q1 2,000.00 140.00 2,140.00
    Q2 2,000.00 105.00 2,105.00
    Q3 2,000.00 70.00 2,070.00
    Q4 2,000.00 35.00 2,035.00
    -
    TOTAL 90,000.00 40,000.00 9,904.82 32,257.34

    INTEREST EXPENSE FROM LOAN - 10,172.25 - 10,172.25

    GRAND TOTAL 90,000.00 40,000.00 - 267.43 22,085.09

    You might also like