Excel Model For Aircraft Lease Rent Calculation

Rental Loan Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper
Particulars	Opening balance	Coupon income	Interest Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	Closing Balance
11/30/2018	27,300,000	355,879	159,250	27,103,371
12/31/2018	27,103,371	355,879	158,103	26,905,594
1/31/2019	26,905,594	355,879	156,949	26,706,664
2/28/2019	26,706,664	355,879	155,789	26,506,574
3/31/2019	26,506,574	355,879	154,622	26,305,316
4/30/2019	26,305,316	355,879	153,448	26,102,884
5/31/2019	26,102,884	355,879	152,267	25,899,272
6/30/2019	25,899,272	355,879	151,079	25,694,472
7/31/2019	25,694,472	355,879	149,884	25,488,477
8/31/2019	25,488,477	355,879	148,683	25,281,280
9/30/2019	25,281,280	355,879	147,474	25,072,875
10/31/2019	25,072,875	355,879	146,258	24,863,254
11/30/2019	24,863,254	355,879	145,036	24,652,410
12/31/2019	24,652,410	355,879	143,806	24,440,337
1/31/2020	24,440,337	355,879	142,569	24,227,026
2/29/2020	24,227,026	355,879	141,324	24,012,471
3/31/2020	24,012,471	355,879	140,073	23,796,664
4/30/2020	23,796,664	355,879	138,814	23,579,599
5/31/2020	23,579,599	355,879	137,548	23,361,267
6/30/2020	23,361,267	355,879	136,274	23,141,662
7/31/2020	23,141,662	355,879	134,993	22,920,776
8/31/2020	22,920,776	355,879	133,705	22,698,601
9/30/2020	22,698,601	355,879	132,409	22,475,130
10/31/2020	22,475,130	355,879	131,105	22,250,356
11/30/2020	22,250,356	355,879	129,794	22,024,270
12/31/2020	22,024,270	355,879	128,475	21,796,866
1/31/2021	21,796,866	355,879	127,148	21,568,135
2/28/2021	21,568,135	355,879	125,814	21,338,069
3/31/2021	21,338,069	355,879	124,472	21,106,662
4/30/2021	21,106,662	355,879	123,122	20,873,905
5/31/2021	20,873,905	355,879	121,764	20,639,790
6/30/2021	20,639,790	355,879	120,399	20,404,310
7/31/2021	20,404,310	355,879	119,025	20,167,455
8/31/2021	20,167,455	355,879	117,643	19,929,220
9/30/2021	19,929,220	355,879	116,254	19,689,594
10/31/2021	19,689,594	355,879	114,856	19,448,571
11/30/2021	19,448,571	355,879	113,450	19,206,141
12/31/2021	19,206,141	355,879	112,036	18,962,298
1/31/2022	18,962,298	355,879	110,613	18,717,032
2/28/2022	18,717,032	355,879	109,183	18,470,335
3/31/2022	18,470,335	355,879	107,744	18,222,199
4/30/2022	18,222,199	355,879	106,296	17,972,616
5/31/2022	17,972,616	355,879	104,840	17,721,577
6/30/2022	17,721,577	355,879	103,376	17,469,074
7/31/2022	17,469,074	355,879	101,903	17,215,097
8/31/2022	17,215,097	355,879	100,421	16,959,639
9/30/2022	16,959,639	355,879	98,931	16,702,691
10/31/2022	16,702,691	355,879	97,432	16,444,244
11/30/2022	16,444,244	355,879	95,925	16,184,290
12/31/2022	16,184,290	355,879	94,408	15,922,819
1/31/2023	15,922,819	355,879	92,883	15,659,822
2/28/2023	15,659,822	355,879	91,349	15,395,292
3/31/2023	15,395,292	355,879	89,806	15,129,219
4/30/2023	15,129,219	355,879	88,254	14,861,593
5/31/2023	14,861,593	355,879	86,693	14,592,406
6/30/2023	14,592,406	355,879	85,122	14,321,649
7/31/2023	14,321,649	355,879	83,543	14,049,313
8/31/2023	14,049,313	355,879	81,954	13,775,388
9/30/2023	13,775,388	355,879	80,356	13,499,865
10/31/2023	13,499,865	355,879	78,749	13,222,735
11/30/2023	13,222,735	355,879	77,133	12,943,988
12/31/2023	12,943,988	355,879	75,507	12,663,615
1/31/2024	12,663,615	355,879	73,871	12,381,607
2/29/2024	12,381,607	355,879	72,226	12,097,954
3/31/2024	12,097,954	355,879	70,571	11,812,646
4/30/2024	11,812,646	355,879	68,907	11,525,674
5/31/2024	11,525,674	355,879	67,233	11,237,027
6/30/2024	11,237,027	355,879	65,549	10,946,697
7/31/2024	10,946,697	355,879	63,856	10,654,674
8/31/2024	10,654,674	355,879	62,152	10,360,947
9/30/2024	10,360,947	355,879	60,439	10,065,506
10/31/2024	10,065,506	355,879	58,715	9,768,342
11/30/2024	9,768,342	355,879	56,982	9,469,445
12/31/2024	9,469,445	355,879	55,238	9,168,804
1/31/2025	9,168,804	355,879	53,485	8,866,409
2/28/2025	8,866,409	355,879	51,721	8,562,251
3/31/2025	8,562,251	355,879	49,946	8,256,318
4/30/2025	8,256,318	355,879	48,162	7,948,600
5/31/2025	7,948,600	355,879	46,367	7,639,088
6/30/2025	7,639,088	355,879	44,561	7,327,770
7/31/2025	7,327,770	355,879	42,745	7,014,636
8/31/2025	7,014,636	355,879	40,919	6,699,675
9/30/2025	6,699,675	355,879	39,081	6,382,877
10/31/2025	6,382,877	355,879	37,233	6,064,231
11/30/2025	6,064,231	355,879	35,375	5,743,727
12/31/2025	5,743,727	355,879	33,505	5,421,353
1/31/2026	5,421,353	355,879	31,625	5,097,098
2/28/2026	5,097,098	355,879	29,733	4,770,952
3/31/2026	4,770,952	355,879	27,831	4,442,903
4/30/2026	4,442,903	355,879	25,917	4,112,940
5/31/2026	4,112,940	355,879	23,992	3,781,053
6/30/2026	3,781,053	355,879	22,056	3,447,230
7/31/2026	3,447,230	355,879	20,109	3,111,459
8/31/2026	3,111,459	355,879	18,150	2,773,730
9/30/2026	2,773,730	355,879	16,180	2,434,031
10/31/2026	2,434,031	355,879	14,199	2,092,350
11/30/2026	2,092,350	355,879	12,205	1,748,676
12/31/2026	1,748,676	355,879	10,201	1,402,997
1/31/2027	1,402,997	355,879	8,184	1,055,302
2/28/2027	1,055,302	355,879	6,156	705,579
3/31/2027	705,579	355,879	4,116	353,815
4/30/2027	353,815	355,879	2,064	0

Aircraft lender Loan
Particulars	Opening balance	Interest	Closing Balance
11/30/2018	8,819,952	66,150	8,886,101
12/31/2018	8,886,101	66,646	8,952,747
1/31/2019	8,952,747	67,146	9,019,893
2/28/2019	9,019,893	67,649	9,087,542
3/31/2019	9,087,542	68,157	9,155,699
4/30/2019	9,155,699	68,668	9,224,366
5/31/2019	9,224,366	69,183	9,293,549
6/30/2019	9,293,549	69,702	9,363,251
7/31/2019	9,363,251	70,224	9,433,475
8/31/2019	9,433,475	70,751	9,504,226
9/30/2019	9,504,226	71,282	9,575,508
10/31/2019	9,575,508	71,816	9,647,324
11/30/2019	9,647,324	72,355	9,719,679
12/31/2019	9,719,679	72,898	9,792,577
1/31/2020	9,792,577	73,444	9,866,021
2/29/2020	9,866,021	73,995	9,940,016
3/31/2020	9,940,016	74,550	10,014,566
4/30/2020	10,014,566	75,109	10,089,676
5/31/2020	10,089,676	75,673	10,165,348
6/30/2020	10,165,348	76,240	10,241,588
7/31/2020	10,241,588	76,812	10,318,400
8/31/2020	10,318,400	77,388	10,395,788
9/30/2020	10,395,788	77,968	10,473,757
10/31/2020	10,473,757	78,553	10,552,310
11/30/2020	10,552,310	79,142	10,631,452
12/31/2020	10,631,452	79,736	10,711,188
1/31/2021	10,711,188	80,334	10,791,522
2/28/2021	10,791,522	80,936	10,872,458
3/31/2021	10,872,458	81,543	10,954,002
4/30/2021	10,954,002	82,155	11,036,157
5/31/2021	11,036,157	82,771	11,118,928
6/30/2021	11,118,928	83,392	11,202,320
7/31/2021	11,202,320	84,017	11,286,337
8/31/2021	11,286,337	84,648	11,370,985
9/30/2021	11,370,985	85,282	11,456,267
10/31/2021	11,456,267	85,922	11,542,189
11/30/2021	11,542,189	86,566	11,628,756
12/31/2021	11,628,756	87,216	11,715,971
1/31/2022	11,715,971	87,870	11,803,841
2/28/2022	11,803,841	88,529	11,892,370
3/31/2022	11,892,370	89,193	11,981,563
4/30/2022	11,981,563	89,862	12,071,424
5/31/2022	12,071,424	90,536	12,161,960
6/30/2022	12,161,960	91,215	12,253,175
7/31/2022	12,253,175	91,899	12,345,073
8/31/2022	12,345,073	92,588	12,437,662
9/30/2022	12,437,662	93,282	12,530,944
10/31/2022	12,530,944	93,982	12,624,926
11/30/2022	12,624,926	94,687	12,719,613
12/31/2022	12,719,613	95,397	12,815,010
1/31/2023	12,815,010	96,113	12,911,123
2/28/2023	12,911,123	96,833	13,007,956
3/31/2023	13,007,956	97,560	13,105,516
4/30/2023	13,105,516	98,291	13,203,807
5/31/2023	13,203,807	99,029	13,302,836
6/30/2023	13,302,836	99,771	13,402,607
7/31/2023	13,402,607	100,520	13,503,127
8/31/2023	13,503,127	101,273	13,604,400
9/30/2023	13,604,400	102,033	13,706,433
10/31/2023	13,706,433	102,798	13,809,231
11/30/2023	13,809,231	103,569	13,912,800
12/31/2023	13,912,800	104,346	14,017,146
1/31/2024	14,017,146	105,129	14,122,275
2/29/2024	14,122,275	105,917	14,228,192
3/31/2024	14,228,192	106,711	14,334,904
4/30/2024	14,334,904	107,512	14,442,415
5/31/2024	14,442,415	108,318	14,550,733
6/30/2024	14,550,733	109,131	14,659,864
7/31/2024	14,659,864	109,949	14,769,813
8/31/2024	14,769,813	110,774	14,880,587
9/30/2024	14,880,587	111,604	14,992,191
10/31/2024	14,992,191	112,441	15,104,632
11/30/2024	15,104,632	113,285	15,217,917
12/31/2024	15,217,917	114,134	15,332,052
1/31/2025	15,332,052	114,990	15,447,042
2/28/2025	15,447,042	115,853	15,562,895
3/31/2025	15,562,895	116,722	15,679,616
4/30/2025	15,679,616	117,597	15,797,214
5/31/2025	15,797,214	118,479	15,915,693
6/30/2025	15,915,693	119,368	16,035,060
7/31/2025	16,035,060	120,263	16,155,323
8/31/2025	16,155,323	121,165	16,276,488
9/30/2025	16,276,488	122,074	16,398,562
10/31/2025	16,398,562	122,989	16,521,551
11/30/2025	16,521,551	123,912	16,645,463
12/31/2025	16,645,463	124,841	16,770,304
1/31/2026	16,770,304	125,777	16,896,081
2/28/2026	16,896,081	126,721	17,022,802
3/31/2026	17,022,802	127,671	17,150,473
4/30/2026	17,150,473	128,629	17,279,101
5/31/2026	17,279,101	129,593	17,408,694
6/30/2026	17,408,694	130,565	17,539,260
7/31/2026	17,539,260	131,544	17,670,804
8/31/2026	17,670,804	132,531	17,803,335
9/30/2026	17,803,335	133,525	17,936,860
10/31/2026	17,936,860	134,526	18,071,387
11/30/2026	18,071,387	135,535	18,206,922
12/31/2026	18,206,922	136,552	18,343,474
1/31/2027	18,343,474	137,576	18,481,050
2/28/2027	18,481,050	138,608	18,619,658
3/31/2027	18,619,658	139,647	18,759,305
4/30/2027	18,759,305	140,695	(0)

Equity lender Loan
Particulars	Opening balance	Coupon income	Interest	Closing Balance
11/30/2018	6,380,048	59,807	69,117	6,389,358
12/31/2018	6,389,358	59,807	69,218	6,398,769
1/31/2019	6,398,769	59,807	69,320	6,408,282
2/28/2019	6,408,282	59,807	69,423	6,417,898
3/31/2019	6,417,898	59,807	69,527	6,427,619
4/30/2019	6,427,619	59,807	69,633	6,437,444
5/31/2019	6,437,444	59,807	69,739	6,447,376
6/30/2019	6,447,376	59,807	69,847	6,457,416
7/31/2019	6,457,416	59,807	69,955	6,467,564
8/31/2019	6,467,564	59,807	70,065	6,477,822
9/30/2019	6,477,822	59,807	70,176	6,488,192
10/31/2019	6,488,192	59,807	70,289	6,498,674
11/30/2019	6,498,674	59,807	70,402	6,509,269
12/31/2019	6,509,269	59,807	70,517	6,519,979
1/31/2020	6,519,979	59,807	70,633	6,530,805
2/29/2020	6,530,805	59,807	70,750	6,541,748
3/31/2020	6,541,748	59,807	70,869	6,552,810
4/30/2020	6,552,810	59,807	70,989	6,563,992
5/31/2020	6,563,992	59,807	71,110	6,575,295
6/30/2020	6,575,295	59,807	71,232	6,586,720
7/31/2020	6,586,720	59,807	71,356	6,598,270
8/31/2020	6,598,270	59,807	71,481	6,609,944
9/30/2020	6,609,944	59,807	71,608	6,621,745
10/31/2020	6,621,745	59,807	71,736	6,633,673
11/30/2020	6,633,673	59,807	71,865	6,645,731
12/31/2020	6,645,731	59,807	71,995	6,657,919
1/31/2021	6,657,919	59,807	72,127	6,670,240
2/28/2021	6,670,240	59,807	72,261	6,682,694
3/31/2021	6,682,694	59,807	72,396	6,695,283
4/30/2021	6,695,283	59,807	72,532	6,708,008
5/31/2021	6,708,008	59,807	72,670	6,720,871
6/30/2021	6,720,871	59,807	72,809	6,733,873
7/31/2021	6,733,873	59,807	72,950	6,747,017
8/31/2021	6,747,017	59,807	73,093	6,760,302
9/30/2021	6,760,302	59,807	73,237	6,773,732
10/31/2021	6,773,732	59,807	73,382	6,787,307
11/30/2021	6,787,307	59,807	73,529	6,801,029
12/31/2021	6,801,029	59,807	73,678	6,814,900
1/31/2022	6,814,900	59,807	73,828	6,828,921
2/28/2022	6,828,921	59,807	73,980	6,843,094
3/31/2022	6,843,094	59,807	74,134	6,857,420
4/30/2022	6,857,420	59,807	74,289	6,871,902
5/31/2022	6,871,902	59,807	74,446	6,886,541
6/30/2022	6,886,541	59,807	74,604	6,901,338
7/31/2022	6,901,338	59,807	74,764	6,916,295
8/31/2022	6,916,295	59,807	74,927	6,931,415
9/30/2022	6,931,415	59,807	75,090	6,946,698
10/31/2022	6,946,698	59,807	75,256	6,962,147
11/30/2022	6,962,147	59,807	75,423	6,977,764
12/31/2022	6,977,764	59,807	75,592	6,993,549
1/31/2023	6,993,549	59,807	75,763	7,009,505
2/28/2023	7,009,505	59,807	75,936	7,025,635
3/31/2023	7,025,635	59,807	76,111	7,041,939
4/30/2023	7,041,939	59,807	76,288	7,058,419
5/31/2023	7,058,419	59,807	76,466	7,075,079
6/30/2023	7,075,079	59,807	76,647	7,091,918
7/31/2023	7,091,918	59,807	76,829	7,108,940
8/31/2023	7,108,940	59,807	77,014	7,126,147
9/30/2023	7,126,147	59,807	77,200	7,143,540
10/31/2023	7,143,540	59,807	77,388	7,161,121
11/30/2023	7,161,121	59,807	77,579	7,178,893
12/31/2023	7,178,893	59,807	77,771	7,196,857
1/31/2024	7,196,857	59,807	77,966	7,215,016
2/29/2024	7,215,016	59,807	78,163	7,233,372
3/31/2024	7,233,372	59,807	78,362	7,251,927
4/30/2024	7,251,927	59,807	78,563	7,270,682
5/31/2024	7,270,682	59,807	78,766	7,289,641
6/30/2024	7,289,641	59,807	78,971	7,308,805
7/31/2024	7,308,805	59,807	79,179	7,328,177
8/31/2024	7,328,177	59,807	79,389	7,347,758
9/30/2024	7,347,758	59,807	79,601	7,367,552
10/31/2024	7,367,552	59,807	79,815	7,387,560
11/30/2024	7,387,560	59,807	80,032	7,407,785
12/31/2024	7,407,785	59,807	80,251	7,428,229
1/31/2025	7,428,229	59,807	80,472	7,448,894
2/28/2025	7,448,894	59,807	80,696	7,469,784
3/31/2025	7,469,784	59,807	80,923	7,490,899
4/30/2025	7,490,899	59,807	81,151	7,512,244
5/31/2025	7,512,244	59,807	81,383	7,533,819
6/30/2025	7,533,819	59,807	81,616	7,555,629
7/31/2025	7,555,629	59,807	81,853	7,577,675
8/31/2025	7,577,675	59,807	82,091	7,599,959
9/30/2025	7,599,959	59,807	82,333	7,622,485
10/31/2025	7,622,485	59,807	82,577	7,645,255
11/30/2025	7,645,255	59,807	82,824	7,668,271
12/31/2025	7,668,271	59,807	83,073	7,691,537
1/31/2026	7,691,537	59,807	83,325	7,715,055
2/28/2026	7,715,055	59,807	83,580	7,738,828
3/31/2026	7,738,828	59,807	83,837	7,762,858
4/30/2026	7,762,858	59,807	84,098	7,787,149
5/31/2026	7,787,149	59,807	84,361	7,811,703
6/30/2026	7,811,703	59,807	84,627	7,836,523
7/31/2026	7,836,523	59,807	84,896	7,861,611
8/31/2026	7,861,611	59,807	85,167	7,886,972
9/30/2026	7,886,972	59,807	85,442	7,912,607
10/31/2026	7,912,607	59,807	85,720	7,938,520
11/30/2026	7,938,520	59,807	86,001	7,964,713
12/31/2026	7,964,713	59,807	86,284	7,991,191
1/31/2027	7,991,191	59,807	86,571	8,017,955
2/28/2027	8,017,955	59,807	86,861	8,045,009
3/31/2027	8,045,009	59,807	87,154	8,072,356
4/30/2027	8,072,356	59,807	87,451	0