WACC & TERMINAL Growth rate -Two variable data table query

nn186
Posts: 1
Joined: Mon Nov 30, 2015 8:13 am

WACC & TERMINAL Growth rate -Two variable data table query

Postby nn186 » Fri Oct 14, 2016 10:41 am

Hi,

I was trying for two variable data table but it is not working. I am using WHAT If analysis.
Attached PPT for expected results.

Can you suggest .
Attached excel sheet prepared by me.

Thanks & Best Regards,

Sachin
9890949485
Attachments
two_variable_data_table.xls
(14.5 KiB) Downloaded 38 times
dcf.ppt
(104 KiB) Downloaded 34 times

edupristine
Finance Junkie
Posts: 722
Joined: Wed Apr 09, 2014 6:28 am

Re: WACC & TERMINAL Growth rate -Two variable data table query

Postby edupristine » Thu Oct 20, 2016 11:23 am

Hi
In this you have to link the formula of cell (E13,E22).
you can find it by the 'what if Analysis' section 'goal seek', set the cell value with the formula you want.


Return to “Open Source Financial Modeling”



Disclaimer

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.