F ABOLOUS

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 14

FABULOUS INDUSTRIES

PROJECTED PROFIT AND LOSS ACCOUNT


ProjecteProjecteProjecteProjecteProjecteProjecteProjected
Sr. No Particulars 2021-222022-232023-242024-252025-262026-272027-28
Income:
Sales:
Sales: 476.00 499.80 480.25 464.26 468.91 487.66 512.04
Less:GST 18% 85.68 89.96 86.45 83.57 84.40 87.78 92.17
Net Sales 390.32 409.84 393.81 380.70 384.50 399.88 419.88
Job Work Receipts 978.00 987.78 ### ### ### ### ###
Less:GST@18% 176.04 177.80 186.69 194.22 200.05 206.05 212.23
Net Labour Charges ### ### ### ### ### ### ###
Total Net Sales ### ### ### ### ### ### ###
Total Receipts 1544.4 ### ### ### ### ### ###
Diff. in stock-Finished Good 0 0.00 0.00 0.00 0.00 0.00 0.00
Total ### ### ### ### ### ### ###
A. DIRECT EXPENSES:
1.Purchase
Opening Stock 0.00 56 61.60 67.76 74.54 81.99 90.19
Add:Purchases 425 434.35 479.96 530.35 586.04 647.57 715.57
Less:Closing Stock 56 61.60 67.76 74.54 81.99 90.19 99.21
Consumption 369 428.75 473.80 523.58 578.59 639.37 706.55
Transport and hamali 4.25 4.675 5.14 5.66 6.22 6.84 7.53
Wages 198.00 217.80 239.58 263.54 289.89 318.88 350.77
Total Direct Expenses 571.25 651.23 718.52 792.77 874.70 965.10 ###
Gross Profit 973.11 924.19 899.15 861.18 821.25 785.58 746.35
Gross Profit Ratio 63.01 58.66 55.58 52.07 48.42 44.87 41.21
B. INDIRECT EXPENSES:
1 Admnistrative Expenses:
Salaries 24.26 26.69 29.35 32.29 35.52 39.07 42.98
Sundry Exp 0.96 1.06 1.16 1.28 1.41 1.55 1.70
Travelling and conveyance 0.65 0.72 0.79 0.87 0.95 1.05 1.15
Electricity 35.26 38.79 42.66 46.93 51.62 56.79 62.47
Telephone expenses 1.02 1.12 1.23 1.36 1.49 1.64 1.81
Miscelleneous expenses 2.59 2.85 3.13 3.45 3.79 4.17 4.59
Insurance 1.25 1.38 1.51 1.66 1.83 2.01 2.21
Sub Total 65.99 72.59 79.85 87.83 96.62 106.28 116.91
2 Selling Expenses: 3.26 3.59 3.94 4.34 4.77 5.25 5.78
Sub Total 3.26 3.59 3.94 4.34 4.77 5.25 5.78
3 Bank Interest
Bank Interest- Term Loan 440.86 426.06 409.80 391.93 372.28 350.68 326.93
Bank Interest-CC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub Total 440.86 426.06 409.80 391.93 372.28 350.68 326.93
4 Depreciation 499.28 450.89 407.31 368.03 332.63 300.72 271.14
Total Indirect Expenses ### 953.13 900.90 852.12 806.29 762.92 720.76
NET PROFIT -36.27 -28.94 -1.75 9.05 14.96 22.66 25.59
NET PROFIT RATIO -2.35 -1.84 -0.11 0.55 0.88 1.29 1.41
FABULOUS INDUSTRIES
PROJECTED BALANCE SHEET
Actual Estimate Projected Projecte Projected ProjectedProjected
Sr. Particulars 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28
LIABILITIES:
Proprietors Capital:
Opening Balance 2017.61 1980.08 1949.77 1946.50 1953.89 1967.02 1987.66
Add:Capital Introduced 0
Less:Withdrawal 1.25 1.38 1.51 1.66 1.83 2.01 2.21
Profit/(Loss) -36.27 -28.94 -1.75 9.05 14.96 22.66 25.59
Closing Balance 1980.08 1949.77 1946.50 1953.89 1967.02 1987.66 2011.04

Secured Loans and advan


Term Loan From Bank 4558.69 4394.84 4214.73 4016.74 3799.10 3559.86 3296.88
Cash credit from bank 0 0 0 0 0 0 0

Unsecured Loans And Adv


0 0 0 0 0 0 0
Sub-Total 4558.69 4394.84 4214.73 4016.74 3799.10 3559.86 3296.88

Current Liabilities:
Sundry Creditors for purchas 120.25 132.28 145.50 160.05 176.06 193.66 213.03
Provision For Expenses 1.25 1.38 1.51 1.66 1.83 2.01 2.21
Duties and taxes payable 0.5 0.55 0.61 0.67 0.73 0.81 0.89
Sub Total 122 134.2 147.62 162.38 178.62 196.48 216.13
TOTAL LIABILITIES 6660.77 6478.80 6308.84 6133.01 5944.74 5744.01 5524.05

Assets:

1 Fixed Assets:
Opening WDV 5444.42 4945.14 4494.25 4086.94 3718.92 3386.29 3085.57
Add:Additions 0 0 0 0 0 0 0
Less:Deletion/subsidy 0 0 0 0 0 0 0
Sub Total 5444.42 4945.14 4494.25 4086.94 3718.92 3386.29 3085.57
Less:Depreciation 499.28 450.89 407.31 368.03 332.63 300.72 271.14
Closing Balance( WDV) 4945.14 4494.25 4086.94 3718.92 3386.29 3085.57 2814.43

2 Investment and deposits:


Others 0 0 0 0 0 0 0
Deposits 0 0 0 0 0 0 0
Sub Total 0 0 0 0 0 0 0

3 Current Assets
i Closing Stock
a 0 0.00 0.00 0.00 0.00 0.00 0.00
b Cl. Stock 56 61.6 67.76 74.54 81.99 90.19 99.21
Sub total 56 61.6 67.76 74.54 81.99 90.19 99.21

ii Sundry Debtors for sales 1639.27 1900.56 2129.51 2312.46 2446.65 2535.46 2574.34
Cash and bank 20.36 22.40 24.64 27.10 29.81 32.79 36.07
Sub-Total 1715.63 1984.56 2221.91 2414.10 2558.45 2658.44 2709.62
TOTAL ASSETS 6660.77 6478.80 6308.85 6133.01 5944.74 5744.01 5524.05
FABULOUS INDUSTRIES
FINANCIAL ANYAYSIS

Sr. Particulars 2021-222022-232023-242024-252025-262026-272027-28


A CURRENT LIABILITIES
Bank borrowings 4707.75 4707.75 4707.75 4707.75 4707.75 4707.75 4707.75
unsecured loans and advances from
Sundry creditors and purchases 120.25 132.28 145.50 160.05 176.06 193.66 213.03
provision for outstanding expenses 0.25 0.8 0.86 0.93 1.06 1.22 1.26

Total (A) 4828.25 4840.82 4854.11 4868.73 4884.86 4902.63 4922.04


B TERM LIABILITIES
Secured loans-TL 15 4394.84 4214.73 4016.74 3799.10 3559.86 0
Unsecured loans/advances from others
Total(B) 15 4394.84 4214.73 4016.74 3799.10 3559.86 0
C NET WORTH
Capital 1980.08 1949.77 1946.50 1953.89 1967.02 1987.66 2011.04
Reserves and surplus
Total © 1980.08 1949.77 1946.50 1953.89 1967.02 1987.66 2011.04

Revaluation reserve
Net worth excluding revaluation res 1980.08 1949.77 1946.50 1953.89 1967.02 1987.66 2011.04

D TOTAL LIABILITIES(A+B+C) 6823.33 ### ### ### ### ### 6933.07

E CURRENT ASSETS
Cash and bank balance 0.29 0.54 1.21 1.38 2.25 2.38 2.38
sundry debtors for sale 1639.27 1900.56 2129.51 2312.46 2446.65 2535.46 2574.34
inventory 56 61.60 67.76 74.54 81.99 90.19 99.21
loans and advances
other current assets
TOTAL 1695.56 1962.70 2198.48 2388.38 2530.89 2628.03 2675.93

F FIXED ASSETS
Gross block 5444.42 4945.14 4494.25 4086.94 3718.92 3386.29 3085.57
less:depreciation 499.277 450.89 407.31 368.03 332.63 300.72 271.14
NET FIXED ASSETS 4945.14 4494.25 4086.94 3718.92 3386.29 3085.57 2814.43

G DEPOSITS/INVESTMENTS 0.1 0.1 0.1 0.1 0.1 0.1 0.1


H OTHER NON CURRENT ASSETS
TOTAL ASSETS(E+F+G+H) 6640.8 ### ### ### ### ### ###

FINANCIAL PERFORMANCE
Gross sales domestic 24.29 27.95 32.92 35.23 38.32 42.8 47.4
less:sales tax 0.57 0.64 0.78 0.82 0.89 1.03 1.15
Net sales 23.72 27.31 32.14 34.41 37.43 41.77 46.25

Growth(%) 0 15.13 17.69 7.06 8.78 11.59 10.73


Gross Profit 973.11 924.19 899.15 861.18 821.25 785.58 746.35
Depreciation 499.277 450.89 407.31 368.03 332.63 300.72 271.14
Taxation
Net profit -36.27 -28.94 -1.75 9.05 14.96 22.66 25.59
Purchases 14.21 15.26 16.53 18.82 20.16 23.41 26.16
Interest 440.86 426.06 409.80 391.93 372.28 350.68 326.93
PBDIT 5.92 6.95 6.78 6.83 7.35 7.93 8.61

RATIO ANALYSIS
Current Ratio 0.35 0.41 0.45 0.49 0.52 0.54 0.54
Total Debt/Equity 3.45 3.8 2.64 1.88 1.24 0.79 0.46
TDER After considering unsecured lo 6.38 3.8 2.64 1.88 1.24 0.79 0.46
Gross profit/sales 4102.49 3384.08 2797.59 2502.69 2194.10 1880.72 1613.72
Net profit/sales -152.92 -105.97 -5.46 26.31 39.97 54.24 55.33
Debtors/sales 12.2 53.2 46.6 37.2 24.8 23.2 20.7
Creditors/purchases 25.0 38.4 38.3 38.4 38.6 43.0 43.2
Interest coverage ratio 0.01 0.02 0.02 0.02 0.02 0.02 0.03
Current assets to turnover ratio 0.01 0.01 0.01 0.01 0.02 0.02 0.02

BORROWING POWER
finished goods 0 0 0.00 0.00 0.00 0.00 0.00
raw materials and consumables 56 61.6 67.76 74.54 81.99 90.19 99.21
sundry debtors for sale 1639.27 1900.56 2129.51 2312.46 2446.65 2535.46 2574.34
Total 1695.3 ### ### ### ### ### ###
less:30%margin 508.58 588.65 659.18 716.10 758.59 787.69 802.06
1186.69 1373.51 1538.09 1670.90 1770.05 1837.95 1871.48
Drawing power 5 5 5 5 5 5 5

CC [email protected]% 0.53 0.53 0.53 0.53 0.53 0.53 0.53

DSCR
Interest 440.86 426.06 409.80 391.93 372.28 350.68 326.93
Depreciation 499.277 450.89 407.31 368.03 332.63 300.72 271.14
PAT -36.27 -28.94 -1.75 9.05 14.96 22.66 25.59
TOTAL 903.86 848.02 815.35 769.00 719.86 674.05 623.67
Interest 440.86 426.06 409.80 391.93 372.28 350.68 326.93
Term loan installments falling due w 0.99 2.14 2.38 2.65 2.94 3.27 3.64
Total 441.85 428.20 412.18 394.58 375.22 353.95 330.57

DSCR 2.05 1.98 1.98 1.95 1.92 1.90 1.89


Average DSCR 1.95
-28
FABULOUS INDUSTRIES
Projected Fixed Asset Schedule In lakhs
Building
Machiner Electricty
LAND Construc Total
Particulars y Borad
tion

15% 15% 0% 5%
2022-23
Opening Balance 4,556.00 42.56 100.00 745.86 5,444.42
Additions During The Yea - - -

Depreciation 456 6 - 37 499

Closing Balance 4,100 36 100 709 4,945


2023-24
Opening Balance 4,100 36 100 709 4,945
Additions During The Year - - -

Depreciation 410 5 - 35 451

Closing Balance 3,690 31 100 673 4,494


2024-25
Opening Balance 3,690 31 100 673 4,494
-
Depreciation 369 5 - 34 407
-
Closing Balance 3,321 26 100 639 4,087
2025-26 -
Opening Balance 3,321 26 100 639 4,087
-
Depreciation 332 4 - 32 368
-
Closing Balance 2,989 22 100 608 3,719
2026-27 -
Opening Balance 2,989 22 100 608 3,719
-
Depreciation 299 3 - 30 333
-
Closing Balance 2,690 19 100 577 3,386
2027-28 -
Opening Balance 2,690 19 100 577 3,386
-
Depreciation 269 3 - 29 301
-
2,421 16 100 548 3,086
2028-29 -
Opening Balance 2,421 16 100 548 3,086
-
Depreciation 242 2 - 27 271
-
2,179 14 100 521 2,814
FABULOUS INDUSTRIES
Repayment schedule of Loan & Interest
Repayable in Monthly Installment without Moratorium
Bank Loan - For Interest ### EMI CALCULATION
KVIB/ KVIC - LOAN AVAILED ###
Total Bank Loan ### 120 EMI ###
Rate of Int. 9.50
Interest
Principle 9.50% Principle
Year Month Outstanding p.a. Installment Repaid Balance

1 1 470,774,500 3,726,965 4,915,944 1,188,979 469,585,521


2 469,585,521 3,717,552 4,915,944 1,198,392 468,387,130
3 468,387,130 3,708,065 4,915,944 1,207,879 467,179,251
4 467,179,251 3,698,502 4,915,944 1,217,441 465,961,810
5 465,961,810 3,688,864 4,915,944 1,227,079 464,734,731
6 464,734,731 3,679,150 4,915,944 1,236,794 463,497,937
7 463,497,937 3,669,359 4,915,944 1,246,585 462,251,352
8 462,251,352 3,659,490 4,915,944 1,256,454 460,994,898
9 460,994,898 3,649,543 4,915,944 1,266,401 459,728,498
10 459,728,498 3,639,517 4,915,944 1,276,426 458,452,072
11 458,452,072 3,629,412 4,915,944 1,286,531 457,165,540
12 457,165,540 3,619,227 4,915,944 1,296,716 455,868,824
Total ### 58,991,323 ###
2 1 455,868,824 3,608,962 4,915,944 1,306,982 454,561,842
2 454,561,842 3,598,615 4,915,944 1,317,329 453,244,513
3 453,244,513 3,588,186 4,915,944 1,327,758 451,916,755
4 451,916,755 3,577,674 4,915,944 1,338,269 450,578,486
5 450,578,486 3,567,080 4,915,944 1,348,864 449,229,622
6 449,229,622 3,556,401 4,915,944 1,359,542 447,870,080
7 447,870,080 3,545,638 4,915,944 1,370,305 446,499,774
8 446,499,774 3,534,790 4,915,944 1,381,154 445,118,621
9 445,118,621 3,523,856 4,915,944 1,392,088 443,726,533
10 443,726,533 3,512,835 4,915,944 1,403,108 442,323,424
11 442,323,424 3,501,727 4,915,944 1,414,216 440,909,208
12 440,909,208 3,490,531 4,915,944 1,425,412 439,483,796
Total ### 58,991,323 ###
3 1 439,483,796 3,479,247 4,915,944 1,436,697 438,047,099
2 438,047,099 3,467,873 4,915,944 1,448,071 436,599,028
3 436,599,028 3,456,409 4,915,944 1,459,535 435,139,493
4 435,139,493 3,444,854 4,915,944 1,471,089 433,668,404
5 433,668,404 3,433,208 4,915,944 1,482,735 432,185,669
6 432,185,669 3,421,470 4,915,944 1,494,474 430,691,195
7 430,691,195 3,409,639 4,915,944 1,506,305 429,184,890
8 429,184,890 3,397,714 4,915,944 1,518,230 427,666,661
9 427,666,661 3,385,694 4,915,944 1,530,249 426,136,411
10 426,136,411 3,373,580 4,915,944 1,542,364 424,594,048
11 424,594,048 3,361,370 4,915,944 1,554,574 423,039,474
12 423,039,474 3,349,063 4,915,944 1,566,881 421,472,593
Total ### 58,991,323 ###
4 1 421,472,593 3,336,658 4,915,944 1,579,286 419,893,307
2 419,893,307 3,324,155 4,915,944 1,591,788 418,301,519
3 418,301,519 3,311,554 4,915,944 1,604,390 416,697,129
4 416,697,129 3,298,852 4,915,944 1,617,091 415,080,038
5 415,080,038 3,286,050 4,915,944 1,629,893 413,450,145
6 413,450,145 3,273,147 4,915,944 1,642,797 411,807,348
7 411,807,348 3,260,142 4,915,944 1,655,802 410,151,546
8 410,151,546 3,247,033 4,915,944 1,668,910 408,482,636
9 408,482,636 3,233,821 4,915,944 1,682,123 406,800,513
10 406,800,513 3,220,504 4,915,944 1,695,439 405,105,073
11 405,105,073 3,207,082 4,915,944 1,708,862 403,396,212
12 403,396,212 3,193,553 4,915,944 1,722,390 401,673,821
Total ### 58,991,323 ###
5 1 401,673,821 3,179,918 4,915,944 1,736,026 399,937,796
2 399,937,796 3,166,174 4,915,944 1,749,769 398,188,026
3 398,188,026 3,152,322 4,915,944 1,763,622 396,424,405
4 396,424,405 3,138,360 4,915,944 1,777,584 394,646,821
5 394,646,821 3,124,287 4,915,944 1,791,656 392,855,165
6 392,855,165 3,110,103 4,915,944 1,805,840 391,049,325
7 391,049,325 3,095,807 4,915,944 1,820,136 389,229,188
8 389,229,188 3,081,398 4,915,944 1,834,546 387,394,642
9 387,394,642 3,066,874 4,915,944 1,849,069 385,545,573
10 385,545,573 3,052,236 4,915,944 1,863,708 383,681,865
11 383,681,865 3,037,481 4,915,944 1,878,462 381,803,403
12 381,803,403 3,022,610 4,915,944 1,893,333 379,910,070
Total ### 58,991,323 ###
6 1 379,910,070 3,007,621 4,915,944 1,908,322 378,001,748
2 378,001,748 2,992,514 4,915,944 1,923,430 376,078,318
3 376,078,318 2,977,287 4,915,944 1,938,657 374,139,662
4 374,139,662 2,961,939 4,915,944 1,954,005 372,185,657
5 372,185,657 2,946,470 4,915,944 1,969,474 370,216,183
6 370,216,183 2,930,878 4,915,944 1,985,065 368,231,118
7 368,231,118 2,915,163 4,915,944 2,000,781 366,230,337
8 366,230,337 2,899,324 4,915,944 2,016,620 364,213,717
9 364,213,717 2,883,359 4,915,944 2,032,585 362,181,132
10 362,181,132 2,867,267 4,915,944 2,048,676 360,132,456
11 360,132,456 2,851,049 4,915,944 2,064,895 358,067,561
12 358,067,561 2,834,702 4,915,944 2,081,242 355,986,319
Total ### 58,991,323 ###
7 1 355,986,319 2,818,225 4,915,944 2,097,719 353,888,601
2 353,888,601 2,801,618 4,915,944 2,114,325 351,774,275
3 351,774,275 2,784,880 4,915,944 2,131,064 349,643,211
4 349,643,211 2,768,009 4,915,944 2,147,935 347,495,277
5 347,495,277 2,751,004 4,915,944 2,164,939 345,330,337
6 345,330,337 2,733,865 4,915,944 2,182,078 343,148,259
7 343,148,259 2,716,590 4,915,944 2,199,353 340,948,906
8 340,948,906 2,699,179 4,915,944 2,216,765 338,732,141
9 338,732,141 2,681,629 4,915,944 2,234,314 336,497,827
10 336,497,827 2,663,941 4,915,944 2,252,002 334,245,824
11 334,245,824 2,646,113 4,915,944 2,269,831 331,975,994
12 331,975,994 2,628,143 4,915,944 2,287,800 329,688,194
Total ### 58,991,323 ###
8 1 329,688,194 2,610,032 4,915,944 2,305,912 327,382,282
2 327,382,282 2,591,776 4,915,944 2,324,167 325,058,115
3 325,058,115 2,573,377 4,915,944 2,342,567 322,715,548
4 322,715,548 2,554,831 4,915,944 2,361,112 320,354,436
5 320,354,436 2,536,139 4,915,944 2,379,804 317,974,631
6 317,974,631 2,517,299 4,915,944 2,398,644 315,575,987
7 315,575,987 2,498,310 4,915,944 2,417,634 313,158,353
8 313,158,353 2,479,170 4,915,944 2,436,773 310,721,580
9 310,721,580 2,459,879 4,915,944 2,456,064 308,265,516
10 308,265,516 2,440,435 4,915,944 2,475,508 305,790,008
11 305,790,008 2,420,838 4,915,944 2,495,106 303,294,902
12 303,294,902 2,401,085 4,915,944 2,514,859 300,780,043
Total ### 58,991,323 ###
9 1 300,780,043 2,381,175 4,915,944 2,534,768 298,245,275
2 298,245,275 2,361,108 4,915,944 2,554,835 295,690,440
3 295,690,440 2,340,883 4,915,944 2,575,061 293,115,379
4 293,115,379 2,320,497 4,915,944 2,595,447 290,519,932
5 290,519,932 2,299,949 4,915,944 2,615,994 287,903,938
6 287,903,938 2,279,240 4,915,944 2,636,704 285,267,234
7 285,267,234 2,258,366 4,915,944 2,657,578 282,609,656
8 282,609,656 2,237,326 4,915,944 2,678,617 279,931,039
9 279,931,039 2,216,121 4,915,944 2,699,823 277,231,216
10 277,231,216 2,194,747 4,915,944 2,721,196 274,510,020
11 274,510,020 2,173,204 4,915,944 2,742,739 271,767,280
12 271,767,280 2,151,491 4,915,944 2,764,453 269,002,828
Total ### 58,991,323 ###
10 1 269,002,828 2,129,606 4,915,944 2,786,338 266,216,490
2 266,216,490 2,107,547 4,915,944 2,808,396 263,408,094
3 263,408,094 2,085,314 4,915,944 2,830,629 260,577,464
4 260,577,464 2,062,905 4,915,944 2,853,039 257,724,426
5 257,724,426 2,040,318 4,915,944 2,875,625 254,848,800
6 254,848,800 2,017,553 4,915,944 2,898,391 251,950,410
7 251,950,410 1,994,607 4,915,944 2,921,336 249,029,074
8 249,029,074 1,971,480 4,915,944 2,944,463 246,084,610
9 246,084,610 1,948,170 4,915,944 2,967,774 243,116,837
10 243,116,837 1,924,675 4,915,944 2,991,269 240,125,568
11 240,125,568 1,900,994 4,915,944 3,014,949 237,110,619
12 237,110,619 1,877,126 4,915,944 3,038,818 234,071,801
Total ### 58,991,323 ###
11 1 234,071,801 1,853,068 4,915,944 3,062,875 231,008,926
2 231,008,926 1,828,821 4,915,944 3,087,123 227,921,803
3 227,921,803 1,804,381 4,915,944 3,111,563 224,810,240
4 224,810,240 1,779,748 4,915,944 3,136,196 221,674,045
5 221,674,045 1,754,920 4,915,944 3,161,024 218,513,021
6 218,513,021 1,729,895 4,915,944 3,186,049 215,326,972
7 215,326,972 1,704,672 4,915,944 3,211,272 212,115,700
8 212,115,700 1,679,249 4,915,944 3,236,694 208,879,006
9 208,879,006 1,653,625 4,915,944 3,262,318 205,616,688
10 205,616,688 1,627,799 4,915,944 3,288,145 202,328,543
11 202,328,543 1,601,768 4,915,944 3,314,176 199,014,367
12 199,014,367 1,575,530 4,915,944 3,340,413 195,673,954
Total ### 58,991,323 ###
12 1 195,673,954 1,549,085 4,915,944 3,366,858 192,307,096
2 192,307,096 1,522,431 4,915,944 3,393,512 188,913,583
3 188,913,583 1,495,566 4,915,944 3,420,378 185,493,206
4 185,493,206 1,468,488 4,915,944 3,447,456 182,045,750
5 182,045,750 1,441,196 4,915,944 3,474,748 178,571,002
6 178,571,002 1,413,687 4,915,944 3,502,256 175,068,746
7 175,068,746 1,385,961 4,915,944 3,529,983 171,538,763
8 171,538,763 1,358,015 4,915,944 3,557,928 167,980,835
9 167,980,835 1,329,848 4,915,944 3,586,095 164,394,739
10 164,394,739 1,301,458 4,915,944 3,614,485 160,780,254
11 160,780,254 1,272,844 4,915,944 3,643,100 157,137,154
12 157,137,154 1,244,002 4,915,944 3,671,941 153,465,214
Total ### 58,991,323 ###
13 1 153,465,214 1,214,933 4,915,944 3,701,011 149,764,203
2 149,764,203 1,185,633 4,915,944 3,730,310 146,033,893
3 146,033,893 1,156,102 4,915,944 3,759,842 142,274,051
4 142,274,051 1,126,336 4,915,944 3,789,607 138,484,444
5 138,484,444 1,096,335 4,915,944 3,819,608 134,664,835
6 134,664,835 1,066,097 4,915,944 3,849,847 130,814,988
7 130,814,988 1,035,619 4,915,944 3,880,325 126,934,663
8 126,934,663 1,004,899 4,915,944 3,911,044 123,023,619
9 123,023,619 973,937 4,915,944 3,942,007 119,081,613
10 119,081,613 942,729 4,915,944 3,973,214 115,108,399
11 115,108,399 911,275 4,915,944 4,004,669 111,103,730
12 111,103,730 879,571 4,915,944 4,036,372 107,067,358
Total ### 58,991,323 ###
14 1 107,067,358 847,617 4,915,944 4,068,327 102,999,031
2 102,999,031 815,409 4,915,944 4,100,535 98,898,496
3 98,898,496 782,946 4,915,944 4,132,997 94,765,499
4 94,765,499 750,227 4,915,944 4,165,717 90,599,782
5 90,599,782 717,248 4,915,944 4,198,695 86,401,087
6 86,401,087 684,009 4,915,944 4,231,935 82,169,152
7 82,169,152 650,506 4,915,944 4,265,438 77,903,714
8 77,903,714 616,738 4,915,944 4,299,206 73,604,509
9 73,604,509 582,702 4,915,944 4,333,241 69,271,267
10 69,271,267 548,398 4,915,944 4,367,546 64,903,721
11 64,903,721 513,821 4,915,944 4,402,122 60,501,599
12 60,501,599 478,971 4,915,944 4,436,973 56,064,627
Total 7,988,591 58,991,323 ###
15 1 56,064,627 443,845 4,915,944 4,472,099 51,592,528
2 51,592,528 408,441 4,915,944 4,507,503 47,085,025
3 47,085,025 372,756 4,915,944 4,543,187 42,541,838
4 42,541,838 336,790 4,915,944 4,579,154 37,962,684
5 37,962,684 300,538 4,915,944 4,615,406 33,347,279
6 33,347,279 263,999 4,915,944 4,651,944 28,695,334
7 28,695,334 227,171 4,915,944 4,688,772 24,006,562
8 24,006,562 190,052 4,915,944 4,725,892 19,280,671
9 19,280,671 152,639 4,915,944 4,763,305 14,517,366
10 14,517,366 114,929 4,915,944 4,801,014 9,716,351
11 9,716,351 76,921 4,915,944 4,839,022 4,877,329
12 4,877,329 38,612 4,915,944 4,877,331 (2)
Total 2,926,693 58,991,323 ###
Principle Principle
Year Outstanding Interest Installment Repaid Balance

1 470,774,500 ### 58,991,323 ### 455,868,824

2 455,868,824 ### 58,991,323 ### 439,483,796

3 439,483,796 ### 58,991,323 ### 421,472,593

4 421,472,593 ### 58,991,323 ### 401,673,821

5 401,673,821 ### 58,991,323 ### 379,910,070

6 379,910,070 ### 58,991,323 ### 355,986,319

7 355,986,319 ### 58,991,323 ### 329,688,194

You might also like