Graphs in MS Excel to Avoid Heavy Calculations 

Home  More Videos 

Ekta Why do you need to determine the cost of capital using data of comparable firms? Because that is the correct way of figuring out the 'market' or real cost of capital. Once that is determined you can find out whether your cashflow forecasts will create value for your customer. Based on this data you can convince investors to invest in your company or get loans from banks. From the data provoded by the question you can easily calculate the Rate of return on Equity using the formula: Return on Equity (Re) = Risk Free Rate (Rf) + Market Risk Premium (Rm  Rf) * Beta of Equity Once the Re has been calculated you can use the equation below to calculate the Return on Asset (Ra): Re = Ra + D/E [Ra  Rd] Re: we just calculated it; D/E is given; Rd is given at 7% However the process of calculation is tedious and error prone. Also you need to format the Ra values appropriately to work faster. You can make the calculations relatively simpler and quicker if you plot the given values of the Beta of Equities and the D/E ratios. Extending the graph appropriately gives you the Beta of Equity at D/E=0. Now the equation Re = Ra + D/E [Ra  Rd] becomes Re = Ra Using the above formula Re = Rf + (RmRf) * Beta of equity, we get Ra immediately. The picture below also depicts the solution: Watch the video below to learn how to use graphs in MS Excel to avoid heavy calculations: 