Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Fund Management - SIP

    Uploaded by

    Zen Tradz
    This document summarizes a 5 quarter investment portfolio with quarterly SIP amounts of ₹5000. It tracks the total investment, fund allocation, returns and rebalancing. In the first scenario, the initial capital of ₹100,000 was allocated 80% to the base fund and 20% to the balancing fund. Over the 5 quarters, the total investment grew 27.5% to ₹175,000. In the second scenario with the initial capital fully allocated to the base fund, the total investment grew 22.7% over the same period. The portfolio was rebalanced periodically to maintain the target allocations.

    Copyright:

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

    Fund Management - SIP

    Uploaded by

    Zen Tradz
    26 views6 pages
    This document summarizes a 5 quarter investment portfolio with quarterly SIP amounts of ₹5000. It tracks the total investment, fund allocation, returns and rebalancing. In the first scenario, the initial capital of ₹100,000 was allocated 80% to the base fund and 20% to the balancing fund. Over the 5 quarters, the total investment grew 27.5% to ₹175,000. In the second scenario with the initial capital fully allocated to the base fund, the total investment grew 22.7% over the same period. The portfolio was rebalanced periodically to maintain the target allocations.

    Original Description:

    test

    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 summarizes a 5 quarter investment portfolio with quarterly SIP amounts of ₹5000. It tracks the total investment, fund allocation, returns and rebalancing. In the first scenario, the initial capital of ₹100,000 was allocated 80% to the base fund and 20% to the balancing fund. Over the 5 quarters, the total investment grew 27.5% to ₹175,000. In the second scenario with the initial capital fully allocated to the base fund, the total investment grew 22.7% over the same period. The portfolio was rebalanced periodically to maintain the target allocations.

    Copyright:

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

    Fund Management - SIP

    Uploaded by

    Zen Tradz
    This document summarizes a 5 quarter investment portfolio with quarterly SIP amounts of ₹5000. It tracks the total investment, fund allocation, returns and rebalancing. In the first scenario, the initial capital of ₹100,000 was allocated 80% to the base fund and 20% to the balancing fund. Over the 5 quarters, the total investment grew 27.5% to ₹175,000. In the second scenario with the initial capital fully allocated to the base fund, the total investment grew 22.7% over the same period. The portfolio was rebalanced periodically to maintain the target allocations.

    Copyright:

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

    Intial Capital ₹ 100,000 Report

    Base Fund 80% ₹ 80,000 No of Quarters


    Balancing Fund 20% ₹ 20,000 Total Investment
    Monthly SIP Amount 5000 Current Value
    Quarterly Installments 3 Absolute Returns
    Annual Money Fund
    Returns 6% CAGR

    Beginning of Quarter
    Sub-Total ₹ 60,000 ₹ 15,000

    Quarter Fund-Investment Fund-RebalancSIP-Fund SIP-Rebal Total-Fund


    Q1 ₹ 80,000 ₹ 20,000 ₹ 12,000 ₹ 3,000 ₹ 92,000
    Q2 ₹ 87,400 ₹ 23,345 ₹ 12,000 ₹ 3,000 ₹ 99,400
    Q3 ₹ 101,290 ₹0 ₹ 12,000 ₹ 3,000 ₹ 113,290
    Q4 ₹ 144,658 ₹0 ₹ 12,000 ₹ 3,000 ₹ 156,658
    Q5 ₹ 152,827.41 ₹ 38,206.85 ₹ 12,000 ₹ 3,000 ₹ 164,827
    Report
    5
    ₹ 175,000
    ₹ 223,135
    27.5%

    21.5%

    arter End

    Rebalance-
    Total-Rebal Total -investment Total-Inv Total-Rebal Fund Returns Returns Revised-Fund
    ₹ 23,000 ₹ 115,000 80% 20% -5.0% 1.50% ₹ 87,400
    ₹ 26,345 ₹ 125,745 79% 21% -25.0% 1.50% ₹ 74,550
    ₹ 3,000 ₹ 116,290 97% 3% 25.0% 1.50% ₹ 141,613
    ₹ 3,000 ₹ 159,658 98% 2% 20.0% 1.50% ₹ 187,989
    ₹ 41,207 ₹ 206,034 80% 20% 10.0% 1.50% ₹ 181,310
    End of Quarter Calculation

    Delta (Fund Revised-


    Revised-Rebal Revised-Inv value) Revised-Inv Rebal Comments
    ₹ 23,345 ₹ 110,745 -₹ 4,255 79% 21% Move the balance amount to Fund
    ₹ 26,740 ₹ 101,290 -₹ 24,455 74% 26% value
    ₹ 3,045 ₹ 144,658 ₹ 28,368 98% 2% >20%
    Rebalance
    CAGRtoand
    80%-20% back.
    after that you can
    ₹ 3,045 ₹ 191,034 ₹ 31,377 98% 2% re-balance back
    ₹ 41,825 ₹ 223,135 ₹ 17,101 81% 19%
    Intial Capital ₹ 100,000 Report
    Base Fund 100% ₹ 100,000 No of Quarters
    Balancing Fund 0% ₹0 Total Investment
    Monthly SIP Amount 5000 Current Value
    Quarterly Installments 3 Absolute Returns
    Annual Money Fund
    Returns 6% CAGR

    Beginning of Quarter
    Sub-Total ₹ 75,000 ₹0

    Quarter Fund-Investment Fund-RebalancSIP-Fund SIP-Rebal Total-Fund


    Q1 ₹ 100,000 ₹0 ₹ 15,000 ₹0 ₹ 115,000
    Q2 ₹ 109,250 ₹0 ₹ 15,000 ₹0 ₹ 124,250
    Q3 ₹ 93,188 ₹0 ₹ 15,000 ₹0 ₹ 108,188
    Q4 ₹ 135,234 ₹0 ₹ 15,000 ₹0 ₹ 150,234
    Q1 ₹ 180,281 ₹0 ₹ 15,000 ₹0 ₹ 195,281
    Report
    5
    ₹ 175,000
    ₹ 214,809
    22.7%

    17.8%

    arter End

    Rebalance-
    Total-Rebal Total -investment Total-Inv Total-Rebal Fund Returns Returns Revised-Fund
    ₹0 ₹ 115,000 100% 0% -5.0% ₹ 109,250
    ₹0 ₹ 124,250 100% 0% -25.0% ₹ 93,188
    ₹0 ₹ 108,188 100% 0% 25.0% ₹ 135,234
    ₹0 ₹ 150,234 100% 0% 20.0% ₹ 180,281
    ₹0 ₹ 195,281 100% 0% 10.0% ₹ 214,809
    End of Quarter Calculation

    Delta (Fund Revised-


    Revised-Rebal Revised-Inv value) Revised-Inv Rebal Comments
    ₹0 ₹ 109,250 -₹ 5,750 100% 0%
    ₹0 ₹ 93,188 -₹ 31,063 100% 0%
    ₹0 ₹ 135,234 ₹ 27,047 100% 0%
    ₹0 ₹ 180,281 ₹ 30,047 100% 0%
    ₹0 ₹ 214,809 ₹ 19,528 100% 0%

    You might also like