Hello,
I need to find out how do I contracts a table via table function in excel, it should calculate the Cost of Capital on Growth Rate, NPV and IRR.
Every time when I am trying to use the table function it bounces me back and saying that it does not exist, but then how do you account for all these numbers?
p.s. the information is taken from "Free Cash Flow" table
It looks like that,
(X-axis) Cost of Capital:
5% 10% 15% 20% 25% 30%
(Y-axis) Growth Rate:
5% - - - - - -
10% - - - - - -
15% - - - - - -
20% - - - - - -
25% - - - - - -
30% - - - - - -
I need to find out how do I contracts a table via table function in excel, it should calculate the Cost of Capital on Growth Rate, NPV and IRR.
Every time when I am trying to use the table function it bounces me back and saying that it does not exist, but then how do you account for all these numbers?
p.s. the information is taken from "Free Cash Flow" table
It looks like that,
(X-axis) Cost of Capital:
5% 10% 15% 20% 25% 30%
(Y-axis) Growth Rate:
5% - - - - - -
10% - - - - - -
15% - - - - - -
20% - - - - - -
25% - - - - - -
30% - - - - - -