Working Of Ubl-tfc Redemption
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Working Of Ubl-tfc Redemption as PDF for free.
More details
- Words: 758
- Pages: 5
SUKUK Tenor
8 Years
Redemption
Sixteen semi-annual installments comprising of pricnipal & profit
Profit Rate
Fixed
Principal Redemption
The instrument is structured to redeem 0.25% of principal in the first 78 months and remaining principal in three semi-annual installments of 33.25% each of the issue amount starting from 84th month
Amount of Investment No. of Units Redemption @ 13 Redemption @ 33 Profit Rate
5,000.00 1.00 0.25 33.00 8.45
Principal Redemption 1
Months
0 6 12 18 24 30 36 42 48 54 60 66 72 78 84 90 96 Total
84.50% p.a
0.96 1.00 1.04 1.09 1.13 1.18 1.23 1.23 1.23 1.23 1.23 1.23 1.23 2,133.51 2,133.51 2,133.51 6,415.58
Profit 2 211.25 220.18 229.48 239.17 249.28 259.81 270.79 270.74 270.68 270.63 270.58 270.53 270.47 270.42 180.28 90.14 3,844.43
Per Anum
Redemption
1,687.60
Zakat @ 2.5% 3
WHT @ 10.% 4
0.19 0.03 0.03 0.03 0.03 0.03 0.03 53.34 53.34 53.34 160.39
Total Redemption 5
168.76 27.07 27.07 27.06 27.06 27.05 27.05 27.04 18.03 9.01 384.44
103.07 244.86 244.82 244.77 244.72 244.67 244.63 2,323.56 2,242.43 2,161.30 8,298.83
Total Rate of Return Anualized Rate of Return
1 Principal Redemption
Principal Amount
Profit Amount
Principal amount Outstanding 6
-
5,000.00 5,211.25 5,431.43 5,660.90 5,900.08 6,149.35 6,409.16 6,407.93 6,406.70 6,405.47 6,404.24 6,403.00 6,401.77 6,400.54 4,267.03 2,133.51 -
3,844.43 6,415.58 59.92 7.49
X Redemption Rate
Half Yearly Installment
5000 X 00.25 13
= 0.96
Remening amount 3
= 1,662.50
2 Profit
Pricipal Amount 100
X Profit Rate =
3 Zakat
2.5 % on Principal Redemption
4 WHT
10 % on Profit Amount
5 Total Redemption
Redemption + Profit - Zakat & WHIT
6 Principal Amount
Principal Amount - Principal Redemption
Profit Amount 12
X 6 = Profit
1.75 7.64 7.64 7.64 71.32
Profit Rate Principal Investment
Period Principal Cash Flows Principal Profit Present Value of Cash Flow Bond Price
8.45% $5,000.00
0
1 0.5 $4,999.04
2 1 $4,998.08
3 1.5 $4,997.12
0.96 211.25 212.21 $(5,000.00) $203.78 $5,046.65 =sum(d19:o19)
0.96 211.17 212.13 $195.60
0.96 211.13 212.09 $187.79
$5,000.00
Calculate Bond Price using the Formula Bond Price #REF! =INT*(1-((1+DR)^(-N)))/DR+M/((1+DR)^N) Calculate Bond Price using the PV Function Bond Price #REF! =-PV(DR,N,INT,M)
=(K29/100*E22)/12*6
4 2 $4,996.15
5 2.5 $4,995.19
6 3 $4,994.23
7 3.5 $4,993.27
8 4 $4,992.31
9 4.5 $4,991.35
10 5 $4,990.39
0.96 211.09 212.05 $180.29
0.96 211.05 212.01 $173.09
0.96 211.01 211.97 $166.18
0.96 210.97 211.93 $159.54
0.96 210.93 211.89 $153.17
0.96 210.88 211.84 $147.06
0.96 210.84 211.80 $141.18
11 5.5 $4,989.43
12 6 $4,988.47
13 6.5 $4,987.51
14 7 $4,986.55
15 7.5 $3,324.05
16 8 $1,661.54
0.96 210.80 211.76 $135.55
0.96 210.76 211.72 $130.13
0.96 210.72 211.68 $124.94
1,662.50 210.68 1,873.19 $1,061.63
1,662.50 140.44 1,802.95 $981.21
1,662.50 70.20 1,732.71 $905.50
Total
5,000.00 3,163.92
Redemption of United Bank Ltd., TFCs Tenor
8 Years
Redemption
Sixteen semi-annual installments comprising of pricnipal & profit
Profit Rate
Fixed
Principal Redemption
The instrument is structured to redeem 0.25% of principal in the first 78 months and remaining principal in three semi-annual installments of 33.25% each of the issue amount starting from 84th month
Amount of Investment No. of Units Redemption @ 13 Redemption @ 33 Profit Rate
5,000.00 1.00 0.25 33.00 8.45 Per Anum
Principal Redemption 1
Months
0 6 12 18 24 30 36 42 48 54 60 66 72 78 84 90 96 Total
84.50% p.a
0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 1,662.50 1,662.50 1,662.50 5,000.00
Profit 2 211.25 211.21 211.17 211.13 211.09 211.05 211.01 210.97 210.93 210.88 210.84 210.80 210.76 210.72 140.48 70.24 3,164.53
Zakat @ 2.5% 3
WHT @ 10.% 4
0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 41.56 41.56 41.56 125.00
Total Redemption 5
21.13 21.12 21.12 21.11 21.11 21.10 21.10 21.10 21.09 21.09 21.08 21.08 21.08 21.07 14.05 7.02 316.45
191.06 191.03 190.99 190.95 190.92 190.88 190.84 190.81 190.77 190.73 190.70 190.66 190.62 1,810.59 1,747.38 1,684.16 7,723.08
Total Rate of Return Anualized Rate of Return
1 Principal Redemption
Principal Amount
X
Principal amount Outstanding 6 5,000.00 4,999.04 4,998.08 4,997.12 4,996.15 4,995.19 4,994.23 4,993.27 4,992.31 4,991.35 4,990.39 4,989.43 4,988.47 4,987.51 3,325.01 1,662.50 -
3,164.53 5,000.00 63.29 7.91
Redemption Rate
Half Yearly Installment
5000 X 00.25 13
= 0.96
Remening amount 3
= 1,662.50
2 Profit
Pricipal Amount 100
X Profit Rate =
3 Zakat
2.5 % on Principal Redemption
4 WHT
10 % on Profit Amount
5 Total Redemption
Redemption + Profit - Zakat & WHIT
6 Principal Amount
Principal Amount - Principal Redemption
Profit Amount 12
X 6 = Profit
3.82 7.64 7.64 7.64 7.64 7.64 7.64 71.32
8 Years
Redemption
Sixteen semi-annual installments comprising of pricnipal & profit
Profit Rate
Fixed
Principal Redemption
The instrument is structured to redeem 0.25% of principal in the first 78 months and remaining principal in three semi-annual installments of 33.25% each of the issue amount starting from 84th month
Amount of Investment No. of Units Redemption @ 13 Redemption @ 33 Profit Rate
5,000.00 1.00 0.25 33.00 8.45
Principal Redemption 1
Months
0 6 12 18 24 30 36 42 48 54 60 66 72 78 84 90 96 Total
84.50% p.a
0.96 1.00 1.04 1.09 1.13 1.18 1.23 1.23 1.23 1.23 1.23 1.23 1.23 2,133.51 2,133.51 2,133.51 6,415.58
Profit 2 211.25 220.18 229.48 239.17 249.28 259.81 270.79 270.74 270.68 270.63 270.58 270.53 270.47 270.42 180.28 90.14 3,844.43
Per Anum
Redemption
1,687.60
Zakat @ 2.5% 3
WHT @ 10.% 4
0.19 0.03 0.03 0.03 0.03 0.03 0.03 53.34 53.34 53.34 160.39
Total Redemption 5
168.76 27.07 27.07 27.06 27.06 27.05 27.05 27.04 18.03 9.01 384.44
103.07 244.86 244.82 244.77 244.72 244.67 244.63 2,323.56 2,242.43 2,161.30 8,298.83
Total Rate of Return Anualized Rate of Return
1 Principal Redemption
Principal Amount
Profit Amount
Principal amount Outstanding 6
-
5,000.00 5,211.25 5,431.43 5,660.90 5,900.08 6,149.35 6,409.16 6,407.93 6,406.70 6,405.47 6,404.24 6,403.00 6,401.77 6,400.54 4,267.03 2,133.51 -
3,844.43 6,415.58 59.92 7.49
X Redemption Rate
Half Yearly Installment
5000 X 00.25 13
= 0.96
Remening amount 3
= 1,662.50
2 Profit
Pricipal Amount 100
X Profit Rate =
3 Zakat
2.5 % on Principal Redemption
4 WHT
10 % on Profit Amount
5 Total Redemption
Redemption + Profit - Zakat & WHIT
6 Principal Amount
Principal Amount - Principal Redemption
Profit Amount 12
X 6 = Profit
1.75 7.64 7.64 7.64 71.32
Profit Rate Principal Investment
Period Principal Cash Flows Principal Profit Present Value of Cash Flow Bond Price
8.45% $5,000.00
0
1 0.5 $4,999.04
2 1 $4,998.08
3 1.5 $4,997.12
0.96 211.25 212.21 $(5,000.00) $203.78 $5,046.65 =sum(d19:o19)
0.96 211.17 212.13 $195.60
0.96 211.13 212.09 $187.79
$5,000.00
Calculate Bond Price using the Formula Bond Price #REF! =INT*(1-((1+DR)^(-N)))/DR+M/((1+DR)^N) Calculate Bond Price using the PV Function Bond Price #REF! =-PV(DR,N,INT,M)
=(K29/100*E22)/12*6
4 2 $4,996.15
5 2.5 $4,995.19
6 3 $4,994.23
7 3.5 $4,993.27
8 4 $4,992.31
9 4.5 $4,991.35
10 5 $4,990.39
0.96 211.09 212.05 $180.29
0.96 211.05 212.01 $173.09
0.96 211.01 211.97 $166.18
0.96 210.97 211.93 $159.54
0.96 210.93 211.89 $153.17
0.96 210.88 211.84 $147.06
0.96 210.84 211.80 $141.18
11 5.5 $4,989.43
12 6 $4,988.47
13 6.5 $4,987.51
14 7 $4,986.55
15 7.5 $3,324.05
16 8 $1,661.54
0.96 210.80 211.76 $135.55
0.96 210.76 211.72 $130.13
0.96 210.72 211.68 $124.94
1,662.50 210.68 1,873.19 $1,061.63
1,662.50 140.44 1,802.95 $981.21
1,662.50 70.20 1,732.71 $905.50
Total
5,000.00 3,163.92
Redemption of United Bank Ltd., TFCs Tenor
8 Years
Redemption
Sixteen semi-annual installments comprising of pricnipal & profit
Profit Rate
Fixed
Principal Redemption
The instrument is structured to redeem 0.25% of principal in the first 78 months and remaining principal in three semi-annual installments of 33.25% each of the issue amount starting from 84th month
Amount of Investment No. of Units Redemption @ 13 Redemption @ 33 Profit Rate
5,000.00 1.00 0.25 33.00 8.45 Per Anum
Principal Redemption 1
Months
0 6 12 18 24 30 36 42 48 54 60 66 72 78 84 90 96 Total
84.50% p.a
0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 1,662.50 1,662.50 1,662.50 5,000.00
Profit 2 211.25 211.21 211.17 211.13 211.09 211.05 211.01 210.97 210.93 210.88 210.84 210.80 210.76 210.72 140.48 70.24 3,164.53
Zakat @ 2.5% 3
WHT @ 10.% 4
0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 41.56 41.56 41.56 125.00
Total Redemption 5
21.13 21.12 21.12 21.11 21.11 21.10 21.10 21.10 21.09 21.09 21.08 21.08 21.08 21.07 14.05 7.02 316.45
191.06 191.03 190.99 190.95 190.92 190.88 190.84 190.81 190.77 190.73 190.70 190.66 190.62 1,810.59 1,747.38 1,684.16 7,723.08
Total Rate of Return Anualized Rate of Return
1 Principal Redemption
Principal Amount
X
Principal amount Outstanding 6 5,000.00 4,999.04 4,998.08 4,997.12 4,996.15 4,995.19 4,994.23 4,993.27 4,992.31 4,991.35 4,990.39 4,989.43 4,988.47 4,987.51 3,325.01 1,662.50 -
3,164.53 5,000.00 63.29 7.91
Redemption Rate
Half Yearly Installment
5000 X 00.25 13
= 0.96
Remening amount 3
= 1,662.50
2 Profit
Pricipal Amount 100
X Profit Rate =
3 Zakat
2.5 % on Principal Redemption
4 WHT
10 % on Profit Amount
5 Total Redemption
Redemption + Profit - Zakat & WHIT
6 Principal Amount
Principal Amount - Principal Redemption
Profit Amount 12
X 6 = Profit
3.82 7.64 7.64 7.64 7.64 7.64 7.64 71.32
Related Documents
Working Of Ubl-tfc Redemption
May 2020 8
The Purpose Of Redemption
June 2020 11
The Nature Of Redemption
October 2019 29
Shawshank Redemption
October 2019 14
Gackt - Redemption
November 2019 22
Redemption Song
July 2020 3More Documents from "Bill McLella"
Working Of Ubl-tfc Redemption
May 2020 8
Term Report - Final Mbr
May 2020 11
Edu Def.docx
June 2020 15
Assigmnet Cost
May 2020 10