Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    Krishna's Financial

    Uploaded by

    Kalyan Mukkamula
    This document summarizes the costs of purchasing a house for Rs. 8,25,00,000. It details that the buyer will need to make a down payment of 20% (Rs. 1,71,76,650) and take out a bank loan for the remaining 80% (Rs. 6,87,06,600) at an interest rate of 9.75%. It then provides a debt amortization schedule showing the decreasing loan balance over the course of 25 years as equal installments are paid each year towards interest and principal.

    Copyright:

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

    Krishna's Financial

    Uploaded by

    Kalyan Mukkamula
    30 views3 pages
    This document summarizes the costs of purchasing a house for Rs. 8,25,00,000. It details that the buyer will need to make a down payment of 20% (Rs. 1,71,76,650) and take out a bank loan for the remaining 80% (Rs. 6,87,06,600) at an interest rate of 9.75%. It then provides a debt amortization schedule showing the decreasing loan balance over the course of 25 years as equal installments are paid each year towards interest and principal.

    Original Title

    Krishna's financial

    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 the costs of purchasing a house for Rs. 8,25,00,000. It details that the buyer will need to make a down payment of 20% (Rs. 1,71,76,650) and take out a bank loan for the remaining 80% (Rs. 6,87,06,600) at an interest rate of 9.75%. It then provides a debt amortization schedule showing the decreasing loan balance over the course of 25 years as equal installments are paid each year towards interest and principal.

    Copyright:

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

    Krishna's Financial

    Uploaded by

    Kalyan Mukkamula
    This document summarizes the costs of purchasing a house for Rs. 8,25,00,000. It details that the buyer will need to make a down payment of 20% (Rs. 1,71,76,650) and take out a bank loan for the remaining 80% (Rs. 6,87,06,600) at an interest rate of 9.75%. It then provides a debt amortization schedule showing the decreasing loan balance over the course of 25 years as equal installments are paid each year towards interest and principal.

    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

    Area (sft) 1100

    Price (Rs.. Psf) 7500


    Cost of the house 8250000
    Stamp duty @3% 247500 3%
    brokarage @1% 82500 1%
    Closing fees 8250 0.10%
    All in cost 8588250

    Funded by
    Down Payment 1717650 20%
    Bank Payment 6870600 9.75%

    Buy a house Y0 Y1 Y2 Y3 Y4 Y5
    Down payment -1717650
    Interest on loan

    Debt Amortisation schedule


    Loan- Opening balance 6870600 6798067 6718463 6631096 6535212
    Loan- Closing balance 6870600 6798067 6718463 6631096 6535212 6429979
    Installment 742416.3 742416.3 742416.3 742416.3 742416.3
    Interest 669883.5 662811.6 655050.1 646531.9 637183.2
    Principle repaid 72532.77 79604.71 87366.17 95884.38 105233.1
    Y6 Y7 Y8 Y9 Y10 Y11 Y12 Y13 Y14 Y15

    6429979 6314486 6187732 6048619 5895943 5728381 5544482 5342653 5121146 4878041
    6314486 6187732 6048619 5895943 5728381 5544482 5342653 5121146 4878041 4611234
    742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3
    626922.9 615662.3 603303.8 589740.4 574854.5 558517.2 540587 520908.7 499311.7 475609
    115493.3 126753.9 139112.4 152675.9 167561.8 183899.1 201829.2 221507.6 243104.6 266807.3
    Y16 Y17 Y18 Y19 Y20 Y21 Y22 Y23 Y24 Y25

    4611234 4318413 3997042 3644337 3257244 2832409 2366152 1854436 1292827 676461.3
    4318413 3997042 3644337 3257244 2832409 2366152 1854436 1292827 676461.3 -4E-08
    742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3 742416.3
    449595.3 421045.2 389711.6 355322.9 317581.3 276159.8 230699.8 180807.5 126050.6 65954.98
    292821 321371 352704.7 387093.4 424835 466256.4 511716.4 561608.8 616365.6 676461.3

    You might also like