Book
Book
Book
1.011063
RETURN INDEX
Chart Title
15.0000
-10.1074 -3.907
10.0000
-5.4228 -5.174
5.0000
7.0295 9.468
-0.5599 3.948 0.0000
1 2 3 4 5 6 7 8 9 10 1
-7.1983 -3.553
-5.0000
-0.4264 4.728
-10.0000
12.3847 3.671
-3.1213 -3.441 -15.0000
1.01106318998 1.011063
101%
Title
6 7 8 9 10 11
Column J
INVOICE NO INVOICE DATEDUE DATE AMT TODAY DATE
1 12/28/2022 4/28/2023 2500 3/15/2024 CURRENT 0
2 11/5/2022 1/30/2023 9850 3/15/2024 CURRENT 0
3 10/30/2022 1/30/2023 7500 3/15/2024 CURRENT 0
4 10/26/22 1/26/2023 3500 3/15/2024 CURRENT 0
5 10/29/22 2/28/2023 7750 3/15/2024 CURRENT 0
6 10/25/22 2/25/2023 10250 3/15/2024 CURRENT 0
7 10/28/22 2/28/2023 14500 3/15/2024 CURRENT 0
8 11/27/22 3/30/2023 6100 3/15/2024 CURRENT 0
9 11/20/22 4/25/2023 12250 3/15/2024 CURRENT 0
10 12/20/22 4/20/2023 3250 3/15/2024 CURRENT 0
BELOW 0 BELOW 0-31 BELOW 31-60 BELOW 60-90 ABOVE 90
-322 2500
-410 9850
-410 7500
-414 3500
-381 7750
-384 10250
-381 14500
-351 6100
-325 12250
-330 3250
TOTAL 77450
MAX 77450 0 0 0 0
MIN 0
PROJEC INITIALNPV ACCEPT ANNUAL CAPITAL REQUIREMENT
A 100000 - 1 100000
B 1000000 - 1 1000000
C 500000 - 1 500000
D 30000 - 1 30000
E 10000 - 1 10000
F 30000 - 1 30000
G 900000 - 1 900000
H 2000000 - 1 2000000
I 300000 - 1 300000
J 60000 - 1 60000
K 600000 - 1 600000
L 400000 - 1 400000
M 500000 - 1 500000
N 10000 - 1 10000
6440000 6440000
yes
72316125
NPV CAITAL TEQIREMENT
₹ 3,367,080 6440000
₹ 5,299,641 6340000 10%
₹ 4,829,605 5340000
₹ 4,812,566 4840000
₹ 5,263,822 4810000
₹ 5,780,204 Err:522
₹ 6,328,225 Err:522
₹ 6,061,047 Err:522
₹ 4,667,152 Err:522
₹ 4,833,867 Err:522
₹ 5,257,254 Err:522
₹ 5,182,979 Err:522
₹ 5,301,277 Err:522
₹ 5,331,405 Err:522
Source of Funds Amount
(Rs)
Equity share capital 20,00,000
10% PreferShares 2,000,000
10% Debentures 10,00,000
Determine the Cost of Capital of equity, Cost of Preference Shares, Cost of Debt and Weighted Average
The floatation cost for preference share issue was estimated @ 5%. Find Cost of Preference Capital
if these shares were issued at par.
The next expected dividend for equity shares is Rs 1.50, the dividend is expected to grow @7%, the
market price per share is Rs 20.
(c) The tax rate applicable to the company in case of debentures is 50%, find the cost of debt if they
were issued at 10% premium.
1,900,000
200000
10.526%