Book 1
AI-enhanced title
MP od Debt 12018 shaeres per loan note® 18Current share price 6growth 4%Redemption value(nominal+ 10% of Nominal value) 115Conversion value 131.399 p0*(1+g)^n*R
Year Particulars CF 0 (mp) -1201 to 5 I(1-t) 7 5 RV/CV 131.3985
Year Particulars CF 1 (mp) -1201 to 5 I(1-t) 7 5 RV/CV 131.3985
8% 0*(1+g)^n*R
DF @ 10%DCF 1 -120 3.79 26.53 0.620921 81.588139 NPV -11.88186
DF @ 5% DCF 1 -120 4.33 30.31 0.784 103.01643 NPV 13.326435
IRR 7.640% Existing ProposalSales 87600000 87600000Credit period 1 month with 1% Dis -25% 2 month 75% 1800000 10800000Avg A/R 18000000 12600000Redection 5400000
W2 calculation of Cost o Ke=Rf+B(Rm-Rf) Ke
W3 calculation of Cost o Kd=d/P0 Kd
W4 calculation of Cost o Kd=I(1-t) Kd W1 calculation of IRR (12% loan note) CF DF @10% DCF -106 1 -106 8.4 3.79 31.836 100 0.621 62.1 -12.064 CF DF @ 5% DCF -106 1 -106 8.4 4.329 36.3636 100 0.783526 78.35262 8.716217 IRR 7%
0.08696 8.69%
0.07 7%
