Loan Transactions with Random Dates for the First and Last Periodic Instalments

Table 1

Year
0	—	—	1	—	—	—	—	10,000.00	—	0.027	0.00000000	−1.0000	−1.00000000
1	0.090	1,028.41	0.973	302.43	725.97	900.00	−174.03	10,174.03	−174.03	0.003	0.09000300	−0.8972	−0.90565101
2	0.090	1,028.41	0.970	31.72	996.68	915.66	81.02	10,093.01	−93.01	0.002	0.09000082	−0.6238	−0.65485853
3	0.090	1,028.41	0.968	24.73	1,003.68	908.37	95.31	9,997.70	2.30	0.006	0.09000018	−0.4175	−0.46560336
4	0.090	1,028.41	0.962	63.37	965.03	899.79	65.24	9,932.46	67.54	0.002	0.09000002	−0.2801	−0.33958092
5	0.090	1,028.41	0.961	18.85	1,009.56	893.92	115.64	9,816.82	183.18	0.002	0.09000039	−0.1874	−0.25447806
6	0.092	1,028.41	0.958	26.26	1,002.15	903.15	99.00	9,717.82	282.18	0.002	0.09008141	−0.1227	−0.19515267
7	0.092	1,028.41	0.956	23.76	1,004.65	894.04	110.61	9,607.21	392.79	0.003	0.09018338	−0.0760	−0.15244166
8	0.092	1,028.41	0.953	33.69	994.72	883.86	110.86	9,496.35	503.65	0.003	0.09028461	−0.0414	−0.12081321
9	0.092	1,028.41	0.950	36.70	991.71	873.66	118.05	9,378.31	621.69	0.002	0.09037839	−0.0152	−0.09682451
10	0.092	1,028.41	0.948	25.27	1,003.14	862.80	140.33	9,237.97	762.03	0.006	0.09046314	0.0051	−0.07825809
11	0.094	1,028.41	0.942	61.69	966.72	868.37	98.35	9,139.63	860.37	0.005	0.09056098	0.0211	−0.06365777
12	0.094	1,028.41	0.937	49.86	978.55	859.12	119.42	9,020.20	979.80	0.004	0.09066211	0.0339	−0.05200513
13	0.094	1,028.41	0.933	42.50	985.90	847.90	138.00	8,882.20	1,117.80	0.004	0.09076140	0.0443	−0.04258561
14	0.094	1,028.41	0.929	44.90	983.51	834.93	148.58	8,733.62	1,266.38	0.007	0.09085626	0.0528	−0.03488642
15	0.094	1,028.41	0.922	69.18	959.22	820.96	138.26	8,595.36	1,404.64	0.008	0.09094591	0.0598	−0.02853251
16	0.096	1,028.41	0.914	79.71	948.70	825.15	123.54	8,471.81	1,528.19	0.005	0.09103827	0.0657	−0.02325159
17	0.096	1,028.41	0.909	55.55	972.86	813.29	159.57	8,312.25	1,687.75	0.007	0.09113056	0.0706	−0.01882948
18	0.096	1,028.41	0.902	74.77	953.64	797.98	155.66	8,156.58	1,843.42	0.008	0.09122069	0.0747	−0.01510148
19	0.096	1,028.41	0.893	83.72	944.69	783.03	161.66	7,994.93	2,005.07	0.008	0.09130762	0.0783	−0.01193991
20	0.096	1,028.41	0.885	76.36	952.05	767.51	184.54	7,810.39	2,189.61	0.007	0.09139037	0.0813	−0.00924402
21	0.098	1,028.41	0.878	70.79	957.62	765.42	192.20	7,618.19	2,381.81	0.010	0.09147319	0.0839	−0.00693800
22	0.098	1,028.41	0.868	94.58	933.83	746.58	187.25	7,430.95	2,569.05	0.013	0.09155462	0.0861	−0.00495742
23	0.098	1,028.41	0.855	124.58	903.82	728.23	175.59	7,255.35	2,744.65	0.014	0.09163378	0.0881	−0.00324911
24	0.098	1,028.41	0.842	129.93	898.48	711.02	187.46	7,067.90	2,932.10	0.015	0.09171007	0.0898	−0.00177052
25	0.098	1,028.41	0.826	142.00	886.41	692.65	193.76	6,874.14	3,125.86	0.016	0.09178320	0.0913	−0.00048669
26	0.100	1,028.41	0.811	146.05	882.36	687.41	194.95	6,679.20	3,320.80	0.015	0.09185509	0.0925	0.00062937
27	0.100	1,028.41	0.795	142.36	886.05	667.92	218.13	6,461.07	3,538.93	0.016	0.09192508	0.0937	0.00160219
28	0.100	1,028.41	0.779	148.43	879.97	646.11	233.87	6,227.20	3,772.80	0.018	0.09199282	0.0947	0.00245216
29	0.100	1,028.41	0.761	162.41	866.00	622.72	243.28	5,983.92	4,016.08	0.021	0.09205796	0.0955	0.00319648
30	0.100	1,028.41	0.740	187.46	840.95	598.39	242.55	5,741.37	4,258.63	0.021	0.09212048	0.0963	0.00384945
31	0.102	1,028.41	0.719	184.06	844.35	585.62	258.73	5,482.64	4,517.36	0.025	0.09218121	0.0970	0.00442246
32	0.102	1,028.41	0.694	221.15	807.25	559.23	248.02	5,234.62	4,765.38	0.026	0.09224012	0.0976	0.00492590
33	0.102	1,028.41	0.668	225.53	802.88	533.93	268.94	4,965.68	5,034.32	0.023	0.09229675	0.0982	0.00536908
34	0.102	1,028.41	0.645	194.32	834.09	506.50	327.59	4,638.08	5,361.92	0.020	0.09235114	0.0986	0.00575961
35	0.102	1,028.41	0.625	161.70	866.70	473.08	393.62	4,244.47	5,755.53	0.030	0.09240311	0.0991	0.00610425
36	0.104	1,028.41	0.595	239.89	788.51	441.42	347.09	3,897.38	6,102.62	0.035	0.09245328	0.0995	0.00640813
37	0.104	1,028.41	0.559	272.79	755.61	405.33	350.29	3,547.09	6,452.91	0.028	0.09250167	0.0998	0.00667620
38	0.104	1,028.41	0.531	207.30	821.11	368.90	452.21	3,094.88	6,905.12	0.035	0.09254793	0.1001	0.00691309
39	0.104	1,028.41	0.496	241.80	786.60	321.87	464.74	2,630.14	7,369.86	0.042	0.09259223	0.1004	0.00712242
40	0.104	1,028.41	0.454	265.68	762.73	273.53	489.20	2,140.95	7,859.05	0.044	0.09263450	0.1006	0.00730756
41	0.106	1,028.41	0.410	254.26	774.15	226.94	547.21	1,593.74	8,406.26	0.045	0.09267501	0.1008	0.00747114
42	0.106	1,028.41	0.366	215.33	813.08	168.94	644.14	949.59	9,050.41	0.110	0.09271390	0.1010	0.00761559
43	0.106	1,028.41	0.256	450.99	577.42	100.66	476.76	472.83	9,527.17	0.126	0.09275098	0.1012	0.00774331
44	0.106	1,028.41	0.130	505.46	522.95	50.12	472.83	0.00	10,000.00	0.130	0.09278623	0.1014	0.00785631
Total		45,249.90	—	6,213.85	39,036.05	29,036.05	10,000.00	—	—	—	—	—	—