Laguna Majestic >>Tools

1. INPUTS		KEY FIGURES
   Principal amount:		Annual loan payments:
   Annual interest rate:		Monthly payments:
   Loan period in years:		Interest in first calendar year:
   Base year of loan:		Interest over term of loan:
   Base month of loan:	January February March April May June July August September October November December	Sum of all payments:

   
   

   PAYMENTS IN FIRST 12 MONTHS

   Year	Month	Beginning Balance	Payments	Principal	Interest	Cumulative Principal	Cumulative Interest	Ending

   
   
   

   YEARLY SCHEDULE OF BALANCES AND PAYMENTS

   Year	Beginning Balance	Payments	Principal	Interest	Cumulative Principal	Cumulative Interest	Ending

   
   
   
2. The Loan Eligibility Calculator below helps you assess the Loan Amount you are eligible for.
   
   

   Applicants Gross Monthly Income
   Co-Applicants Gross Monthly Income
   Other Loans
   Other Deductions
   Interest Rate (in %)
   Loan tenure (in months)
   EMI
   Eligibility Loan Amount

3. RESTS MONTHLY	1	2	3	4	5	6	7	8	9	10	11	12	13
   RATE	7.00%	7.25%	7.50%	7.75%	8.00%	8.25%	8.50%	8.75%	9.00%	9.25%	9.50%	9.75%	10.00%
   1	8652.675	8664.204	8675.742	8687.288	8698.843	8710.406	8721.978	8733.559	8745.178	8756.745	8768.351	8779.966	8791.589
   2	4477.258	4488.600	4499.959	4511.336	4522.729	4534.140	4545.567	4557.012	4568.474	4579.953	4591.449	4602.962	4614.493
   3	3087.710	3099.153	3110.622	3122.116	3133.637	3145.182	3156.754	3168.351	3179.973	3191.621	3203.295	3214.994	3226.719
   4	2394.624	2406.240	2417.890	2429.574	2441.292	2453.044	2464.830	2476.650	2488.504	2500.392	2512.314	2524.269	2524.269
   5	1980.120	1991.936	2003.795	2015.696	2027.639	2039.625	2051.653	2063.723	2075.836	2087.990	2100.186	2112.424	2124.704
   6	1704.901	1716.931	1729.011	1741.142	1753.324	1765.556	1777.838	1790.171	1802.554	1814.986	1827.469	1840.002	1852.584
   7	1509.268	1521.518	1533.828	1546.195	1558.621	1571.106	1583.649	1598.249	1608.908	1621.624	1634.398	1647.230	1647.230
   8	1363.372	1375.846	1388.387	1400.994	1413.668	1426.407	1439.213	1452.084	1465.020	1478.022	1491.089	1504.220	1517.416
   9	1250.628	1263.328	1276.102	1288.950	1301.871	1314.867	1327.935	1341.077	1354.291	1367.577	1380.936	1394.367	1407.869
   10	1161.085	1174.010	1187.018	1200.106	1213.276	1226.526	1239.857	1253.268	1266.758	1280.327	1293.976	1307.702	1321.507
   11	1088.410	1101.561	1114.801	1128.129	1141.545	1155.048	1168.639	1182.317	1196.080	1209.930	1223.865	1237.884	1251.988
   12	1028.381	1041.756	1055.228	1068.792	1082.453	1096.207	1110.056	1123.997	1138.031	1152.156	1166.373	1180.681	1195.078
   13	978.074	991.671	1005.370	1019.172	1033.074	1047.077	1061.179	1075.381	1089.681	1104.078	1118.572	1133.163	1147.848
   14	935.401	949.218	963.143	977.177	991.318	1005.566	1019.919	1034.376	1048.938	1063.602	1078.368	1093.235	1108.203
   15	898.828	912.863	927.012	941.276	955.652	970.140	984.740	999.449	1014.267	1029.192	1044.225	1059.363	1074.605
   16	867.208	881.458	895.828	910.317	924.925	939.650	954.491	969.447	984.516	999.697	1014.990	1030.392	1045.902
   17	839.661	854.122	868.709	883.421	898.257	913.214	928.292	943.489	958.804	974.235	989.781	1005.440	1021.210
   18	815.502	830.172	844.973	859.904	874.963	890.148	905.457	926.890	936.445	952.119	967.911	983.820	999.844
   19	794.192	809.068	824.079	839.224	854.501	869.909	885.446	901.109	916.897	932.808	948.840	964.991	981.259
   20	775.299	790.376	805.593	820.949	836.440	852.066	867.823	883.711	899.726	915.867	932.131	948.517	965.022

4. SQ Centimeter :
   SQ Inch :
   SQ Feet :
   SQ Yard :
   SQ Meter :
   SQ Kilometer :
   SQ Mile :
   Acre :
   Hectare :