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

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

Answer 1

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

Answer 2

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

Answer 3

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.