CF Class Work till 30 dec2018.xlsx - WACC Yes Ko Wd Wp We Kd Kp Ke Wd X Kd We X Ke 35 15 50 6 9 13.25 CAPM Ko(WAC Wd*Kd Wp*Kp We*Ke 10.08 PV FV NPER

CF Class Work till 30 dec2018.xlsx - WACC Yes Ko Wd Wp We...

This preview shows page 1 - 18 out of 132 pages.

WACC Ko Wd X Kd + We X Ke Wd 35% Wp 15% We 50% Yes Kd 6% Kp 9% Ke 13.25% CAPM Ko (WAC) Wd*Kd + Wp *Kp + We*Ke 10.08%
Image of page 1
PV -385.4 FV 1000 NPER 10 Rate 10% Sales 550 1000 Debt 1000 Opex 500 500 Interest 100 EBIT 50 500 Int 100 0 Pref Share Capital 1000 EBT -50 500 Div Rate 9% Tax @ 40% 0 200 EAT 85 300 Less: Pref Div 63 Poft Available for ESH 22 Less: Equity Div Retained Earnings
Image of page 2
Risk-free Rate Rf + b(RP) 6% + Risk Premim Rf + b(Rm-Rf) Nifty 12% Infosys 6% + 6%*1.3 beta 1.3 7.80% Zylog 6% + 6%*2.5 beta 2.5 21% Nifty beta 1 risk premium 6%
Image of page 3
A B EBIT 500 300 Tax Rate 40% 40% NOPAT 300 180 Equity 1000 1000 Debt 500 500 CE 1500 1500 WACC 10% 12% 180 EVA 150 0
Image of page 4
Date Infy Nifty 10/31/2013 11/30/2013 282.1859 6304 12/31/2013 299.6285 6089.5 0.500 1/31/2014 309.6463 6276.95 2/28/2014 265.7641 6704.2 3/31/2014 257.5065 6696.4 SLOPE 4/30/2014 237.9636 7229.95 5/31/2014 295.6028 7611.35 6/30/2014 305.7811 7721.3 7/31/2014 326.7696 7954.35 8/31/2014 340.2944 7964.8 9/30/2014 367.8516 8322.2 10/31/2014 421.7021 8588.25 11/30/2014 381.5864 8282.7 12/31/2014 414.3464 8808.9 1/31/2015 438.3054 8844.6 2/28/2015 429.136 8491 3/31/2015 375.7242 8181.5 4/30/2015 391.3749 8433.65 5/31/2015 380.8412 8368.5 6/30/2015 456.5033 8532.85 7/31/2015 463.857 7948.95 8/31/2015 492.4879 7948.9 9/30/2015 481.2559 8065.8 10/31/2015 469.6619 7935.25 11/30/2015 477.2169 7946.35 12/31/2015 502.904 7563.55 1/31/2016 467.9999 6987.05 2/29/2016 525.9576 7738.4 3/31/2016 521.554 7849.8 4/30/2016 539.06 8160.1 5/31/2016 505.4511 8287.75 6/30/2016 474.5193 8638.5 7/31/2016 457.7277 8786.2 8/31/2016 457.8161 8611.15 9/30/2016 440.7814 8638 10/31/2016 440.4289 8224.5 11/30/2016 456.2528 8185.8 12/31/2016 419.2325 8561.3 1/31/2017 457.0655 8879.6 2/28/2017 461.5124 9173.75 3/31/2017 414.8758 9304.05 4/30/2017 441.106 9621.25 5/31/2017 422.3702 9520.9 6/30/2017 470.7366 10077.1 7/31/2017 425.93 9917.9 8/31/2017 418.9239 9788.6
Image of page 5
9/30/2017 429.1422 10335.3 10/31/2017 467.2649 10226.55 11/30/2017 498.8356 10530.7 12/31/2017 550.6316 11027.7 1/31/2018 561.3307 10492.85 2/28/2018 541.7995 10113.7 3/31/2018 574.2078 10739.35 4/30/2018 589.6701 10736.15 5/31/2018 625.7645 10714.3 6/30/2018 675.1972 11356.5 7/31/2018 712.7878 11680.5 8/31/2018 722.1855 10930.45 9/30/2018 679.0057 10386.6 10/31/2018 620.75 10526.75 11/22/2018 620.75 10526.75 Ave Retur Risk CV CAGR
Image of page 6
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 0 100 200 300 400 500 600 700 800 Chart Title Infy
Image of page 7
100 Year 1 10% 110 2 12% 123.2 3 13% 139.216 4 15% 160.0984 5 20% 192.1181 92.11808 9964402318 92% 18.42% 100 Year 1 13.95% 113.9498 2 13.95% 129.8456 3 13.95% 147.9588 4 13.95% 168.5988 5 13.95% 192.1181 [email protected]
Image of page 8
1.10 1.12 1.13 1.15 1.20 13.95%
Image of page 9
Years CF 0 -1000 1 250 2 250 3 250 4 250 5 250
Image of page 10
Simple Inter Open Int Closin 0 1 1000 100 1,100 ₹ 262.43 1 2 1000 100 1,200 2 3 1000 100 1,300 ₹ 3,214.90 3 4 1000 100 1,400 5 1000 100 1,500 Home Loan 500 Rate Compound Inter No. of Years Open Int Closin EAI 1 1000 100 1,100 2 1,100 110 1,210 3 1,210 121 1,331 4 1,331 133 1,464 1 5 1,464 146 1,611 2 611 3 4 5 6
Image of page 11
₹ 500 ₹ 666 3 Year Beg Bal 500 ₹ 605 2 1 5,000,000 500 ₹ 550 1 2 4,931,606 ₹ 0 ₹ 0 0 3 4,857,741 ₹ 1,820.50 ₹ 1,821 4 4,777,966 5 4,691,809 5000000 6 4,598,760 8% 7 4,498,267 25 8 4,389,735 ₹ 468,394 9 4,272,520 10 4,145,927 11 4,009,208 Dec-18 -1000 12 3,861,550 Jun-19 Yearly ₹ 1,331 13 3,702,080 Dec-19 Semi Annual ₹ 1,340 14 3,529,853 Jun-20 Quarterkly ₹ 1,345 15 3,343,847 Dec-20 Monthly ₹ 1,348 16 3,142,961 Jun-21 Daily ₹ 1,350 17 2,926,004 Dec-21 ? 18 2,691,691 19 2,438,632 20 2,165,329 21 1,870,161 22 1,551,380 23 1,207,096 24 835,270 25 433,698
Image of page 12
8% EAI Interst Principal Clo Bal 468,394 400,000 68,394 4,931,606 468,394 394,528 73,865 4,857,741 468,394 388,619 79,775 4,777,966 468,394 382,237 86,157 4,691,809 468,394 375,345 93,049 4,598,760 468,394 367,901 100,493 4,498,267 468,394 359,861 108,533 4,389,735 468,394 351,179 117,215 4,272,520 468,394 341,802 126,592 4,145,927 468,394 331,674 136,720 4,009,208 468,394 320,737 147,657 3,861,550 468,394 308,924 159,470 3,702,080 468,394 296,166 172,227 3,529,853 468,394 282,388 186,006 3,343,847 468,394 267,508 200,886 3,142,961 468,394 251,437 216,957 2,926,004 468,394 234,080 234,314 2,691,691 468,394 215,335 253,059 2,438,632 468,394 195,091 273,303 2,165,329 468,394 173,226 295,168 1,870,161 468,394 149,613 318,781 1,551,380 468,394 124,110 344,283 1,207,096 468,394 96,568 371,826 835,270 468,394 66,822 401,572 433,698 468,394 34,696 433,698 -0
Image of page 13
Current Age 35 Retirement 60 ₹ 169,318 Current Salary 100000 ₹ 17,691,699 Current Expenses 60000 If I retire today I need 50000 Long term Inflaton Rate 5% ₹ 1,467,345 Return on Savings 10% Life Age 80 ₹ 25,529
Image of page 14
Role of Finance Manager Invesotr Reporting Finance / Capital Raising Short Term Finacial Managemtn Kiran Kumar K V Forms of Business Org 9964402318 Sole Proprietor Family Owned Partnership Private Limited Company Public Limited Copany LLP OPC Fin Stymt Analysis 1. Horizontal Analysis Com[parative Stmt 2. Vertical Analtysis Common Size Stmet 3. Ratio Analysi Profitability, iquidity, Effficiency, Solevency, Market Sentimens [email protected]
Image of page 15
Share Capital 2450000 Sales 6500000 Reserves 515000 Expenses 5200000 L:oans 1325000 Depreciati 287500 Current Liabilties 346000 Interst 132500 Fixed Assets 2875000 Tax 25% Curren Assets 854000 Investments 907000
Image of page 16
Multistep Income Stmt 2018 Revenues 6500000 100
Image of page 17
Image of page 18

You've reached the end of your free preview.

Want to read all 132 pages?

  • Fall '15
  • Financial Ratio, CF

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture