put py file into c:\yourpython37\Lib\ folder how to use:

Principle = 1000000
annum interest rate = 15%
tenor = 60 month

call function : from HP_schedule_mth import hpbymonth as hp hp(1000000,.15,60) /* result Period,PrincPay,IntPay,installment,PrincBalance,Eir

0, 0, 0, 0, 1000000, 0.02057044689094744

1, 8596.21979408634, 20570.44689094744, 29166.666667, 991403.780206, 0.02057044689094744

2, 8773.047876823504, 20393.618808210278, 29166.666667, 982630.732329, 0.02057044689094744

3, 8953.51339224544, 20213.15329278834, 29166.666667, 973677.218937, 0.02057044689094744

4, 9137.691163968015, 20028.975521065768, 29166.666667, 964539.527773, 0.02057044689094744

5, 9325.657554762296, 19841.009130271486, 29166.666667, 955213.870218, 0.02057044689094744

6, 9517.490498215695, 19649.176186818087, 29166.666667, 945696.37972, 0.02057044689094744

7, 9713.269531044334, 19453.39715398945, 29166.666667, 935983.110189, 0.02057044689094744

8, 9913.07582607014, 19253.590858963642, 29166.666667, 926070.034363, 0.02057044689094744

9, 10116.992225876249, 19049.674459157533, 29166.666667, 915953.042137, 0.02057044689094744

10, 10325.103277154765, 18841.563407879017, 29166.666667, 905627.93886, 0.02057044689094744

11, 10537.495265761023, 18629.17141927276, 29166.666667, 895090.443594, 0.02057044689094744

12, 10754.256252488969, 18412.410432544813, 29166.666667, 884336.187342, 0.02057044689094744

13, 10975.476109582429, 18191.190575451354, 29166.666667, 873360.711232, 0.02057044689094744

14, 11201.24655799746, 17965.420127036323, 29166.666667, 862159.464674, 0.02057044689094744

15, 11431.661205431152, 17735.00547960263, 29166.666667, 850727.803469, 0.02057044689094744

16, 11666.815585132776, 17499.851099901007, 29166.666667, 839060.987884, 0.02057044689094744

17, 11906.807195513225, 17259.859489520557, 29166.666667, 827154.180688, 0.02057044689094744

18, 12151.73554056928, 17014.931144464503, 29166.666667, 815002.445147, 0.02057044689094744

19, 12401.7021711394, 16764.96451389438, 29166.666667, 802600.742976, 0.02057044689094744

20, 12656.810727008171, 16509.85595802561, 29166.666667, 789943.932249, 0.02057044689094744

21, 12917.166979876862, 16249.49970515692, 29166.666667, 777026.765269, 0.02057044689094744

22, 13182.878877217918, 15983.787807815865, 29166.666667, 763843.886392, 0.02057044689094744

23, 13454.05658703152, 15712.610098002262, 29166.666667, 750389.829805, 0.02057044689094744

24, 13730.812543522856, 15435.854141510927, 29166.666667, 736659.017261, 0.02057044689094744

25, 14013.261493718941, 15153.405191314841, 29166.666667, 722645.755767, 0.02057044689094744

26, 14301.520545044446, 14865.146139989336, 29166.666667, 708344.235222, 0.02057044689094744

27, 14595.709213876075, 14570.957471157708, 29166.666667, 693748.526008, 0.02057044689094744

28, 14895.949475095824, 14270.717209937959, 29166.666667, 678852.576533, 0.02057044689094744

29, 15202.365812663518, 13964.300872370264, 29166.666667, 663650.21072, 0.02057044689094744

30, 15515.085271229662, 13651.58141380412, 29166.666667, 648135.125449, 0.02057044689094744

31, 15834.23750881001, 13332.429176223772, 29166.666667, 632300.88794, 0.02057044689094744

32, 16159.954850543636, 13006.711834490146, 29166.666667, 616140.933089, 0.02057044689094744

33, 16492.37234355685, 12674.294341476932, 29166.666667, 599648.560745, 0.02057044689094744

34, 16831.627812955714, 12335.038872078068, 29166.666667, 582816.932932, 0.02057044689094744

35, 17177.861918970317, 11988.804766063467, 29166.666667, 565639.071013, 0.02057044689094744

36, 17531.218215274523, 11635.448469759262, 29166.666667, 548107.852798, 0.02057044689094744

37, 17891.84320850543, 11274.823476528354, 29166.666667, 530216.009589, 0.02057044689094744

38, 18259.886419007154, 10906.780266026628, 29166.666667, 511956.12317, 0.02057044689094744

39, 18635.500442824068, 10531.166242209714, 29166.666667, 493320.622727, 0.02057044689094744

40, 19018.84101496941, 10147.825670064374, 29166.666667, 474301.781712, 0.02057044689094744

41, 19410.067073995204, 9756.599611038579, 29166.666667, 454891.714638, 0.02057044689094744

42, 19809.34082789055, 9357.32585714323, 29166.666667, 435082.37381, 0.02057044689094744

43, 20216.827821335344, 8949.838863698438, 29166.666667, 414865.545989, 0.02057044689094744

44, 20632.697004337555, 8533.969680696227, 29166.666667, 394232.848985, 0.02057044689094744

45, 21057.120802282287, 8109.545882751497, 29166.666667, 373175.728183, 0.02057044689094744

46, 21490.27518742189, 7676.391497611892, 29166.666667, 351685.452996, 0.02057044689094744

47, 21932.33975183659, 7234.3269331971915, 29166.666667, 329753.113244, 0.02057044689094744

48, 22383.497781895956, 6783.1689031378255, 29166.666667, 307369.615462, 0.02057044689094744

49, 22843.93633425209, 6322.730350781693, 29166.666667, 284525.679128, 0.02057044689094744

50, 23313.84631339601, 5852.82037163777, 29166.666667, 261211.832815, 0.02057044689094744

51, 23793.422550809435, 5373.244134224347, 29166.666667, 237418.410264, 0.02057044689094744

52, 24282.863885744726, 4883.8027992890575, 29166.666667, 213135.546378, 0.02057044689094744

53, 24782.37324766654, 4384.293437367245, 29166.666667, 188353.17313, 0.02057044689094744

54, 25292.157740389302, 3874.50894464448, 29166.666667, 163061.01539, 0.02057044689094744

55, 25812.42872794544, 3354.2379570883427, 29166.666667, 137248.586662, 0.02057044689094744

56, 26343.401922220015, 2823.264762813768, 29166.666667, 110905.18474, 0.02057044689094744

57, 26885.297472387923, 2281.369212645861, 29166.666667, 84019.887268, 0.02057044689094744

58, 27438.340056190995, 1728.3266288427894, 29166.666667, 56581.547212, 0.02057044689094744

59, 28002.75897309262, 1163.907711941162, 29166.666667, 28578.788239, 0.02057044689094744

60, 28578.78823934863, 587.8784456851553, 29166.666667, -0.0, 0.02057044689094744

*/