locked
Need Principal, Interest and EMI amount for all the months. RRS feed

  • Question

  • User-508818466 posted

    Need Principal, Interest and EMI amount for all the months,

    This is scenario i need,

    Year Principal
    (A)
    Interest
    (B)
    Total Payment
    (A + B)
    Balance Loan Paid To Date
    2021 ₹ 3,703 ₹ 253 ₹ 3,956 ₹ 1,297 74.06%
    Apr ₹ 398 ₹ 42 ₹ 440 ₹ 4,602 7.96%
    May ₹ 401 ₹ 38 ₹ 440 ₹ 4,201 15.98%
    Jun ₹ 405 ₹ 35 ₹ 440 ₹ 3,796 24.07%
    Jul ₹ 408 ₹ 32 ₹ 440 ₹ 3,388 32.23%
    Aug ₹ 411 ₹ 28 ₹ 440 ₹ 2,977 40.46%
    Sep ₹ 415 ₹ 25 ₹ 440 ₹ 2,562 48.76%
    Oct ₹ 418 ₹ 21 ₹ 440 ₹ 2,144 57.12%
    Nov ₹ 422 ₹ 18 ₹ 440 ₹ 1,722 65.55%
    Dec ₹ 425 ₹ 14 ₹ 440 ₹ 1,297 74.06%
    2022 ₹ 1,297 ₹ 22 ₹ 1,319 ₹ 0 100.00%
    Jan ₹ 429 ₹ 11 ₹ 440 ₹ 868 82.63%

    Kindly help on this

    Monday, April 12, 2021 5:03 AM

All replies

  • User-1330468790 posted

    Hi pvtt0050,

     

    Could you please tell us what technologies you are using? webforms or asp.net mvc?

      

    Apart from that, please answer the following questions.

    • Where do you store the data?
    • Which columns of the data do you store?
    • Do you want to do some calculations on the page? Or you just want to fetch the data and render them on the page?

      

    Best regards,

    Sean

    Tuesday, April 13, 2021 3:40 AM
  • User-508818466 posted

    Hi Sean,

    Thanks for your response.

    I want to use webforms asp.net technology.

    and i am not storing the data anywhere. i want to calculate emi with the principal amount and interest amount for each month and show then in the format which i have provided

    Tuesday, April 13, 2021 12:44 PM
  • User409696431 posted

    If you are not storing the data anywhere, how are you getting the numbers you want to use in the calculations?

    If they are hard-coded, just hard-code the calculated results and display them in a table on the page.

    Tuesday, April 13, 2021 8:59 PM