First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2. A1 of Sheet2 is
the earning growth rate assumption, which drives all the equity valuation
calculations. In sheet1, can I input expected growth rate in A1 and get
equity value on A2 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt

You can refer to values in other sheets by including the sheetname plus
an exclamation mark before the cell reference. So, imagine you want the
cell A1 in Sheet1 to hold the growth rate - in Sheet2 wherever you need
to use this value in a calculation you would have:

Sheet1!A1

in your formulae. (Or, in Sheet2 A1 enter the formula =Sheet1!A1 to
bring that across)

Similarly, assume the results of your calculations in Sheet2 are in
cell D6, and you want this to be shown in A2 of Sheet1 - in this cell
you would have the formula:

=Sheet2!D6

If you want to put other parameters in Sheet1, then use the cells B1,
C1 etc and then change the formulae in Sheet2 to bring the values from
the appropriate cells of Sheet1.

Hope this helps.

Pete

TR wrote:
First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2. A1 of Sheet2 is
the earning growth rate assumption, which drives all the equity valuation
calculations. In sheet1, can I input expected growth rate in A1 and get
equity value on A2 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt

excuse me Pete....TR - I guess u need to make a new highlighted thread named
"PARAMETERS" that is a solver's domain and probably macros. Many will reply
to give suggestions...

"Pete_UK" wrote:

You can refer to values in other sheets by including the sheetname plus
an exclamation mark before the cell reference. So, imagine you want the
cell A1 in Sheet1 to hold the growth rate - in Sheet2 wherever you need
to use this value in a calculation you would have:

Sheet1!A1

in your formulae. (Or, in Sheet2 A1 enter the formula =Sheet1!A1 to
bring that across)

Similarly, assume the results of your calculations in Sheet2 are in
cell D6, and you want this to be shown in A2 of Sheet1 - in this cell
you would have the formula:

=Sheet2!D6

If you want to put other parameters in Sheet1, then use the cells B1,
C1 etc and then change the formulae in Sheet2 to bring the values from
the appropriate cells of Sheet1.

Hope this helps.

Pete

TR wrote:
First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2. A1 of Sheet2 is
the earning growth rate assumption, which drives all the equity valuation
calculations. In sheet1, can I input expected growth rate in A1 and get
equity value on A2 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt

Thanks, Pete_UK!

The problem I am facing is something like sensitivity analysis. I may have a
long list of possible growth rate in Sheet1. I'd like to see the different
equity prices bases on different growth assuptions. The issue is that when I
put in a new growth rate as you suggested in sheet1, the old equity price is
gone.

I understand that a table can be helpful. However, if I'd like to see the
sensitivity of growth rate on other conclusions, such as market multiples,
ranking..., I would have to build many tables. Plus, table is not desgined to
work across worksheets.

Please let me know if I misunderstood.

Thank you!


"Pete_UK" wrote:

You can refer to values in other sheets by including the sheetname plus
an exclamation mark before the cell reference. So, imagine you want the
cell A1 in Sheet1 to hold the growth rate - in Sheet2 wherever you need
to use this value in a calculation you would have:

Sheet1!A1

in your formulae. (Or, in Sheet2 A1 enter the formula =Sheet1!A1 to
bring that across)

Similarly, assume the results of your calculations in Sheet2 are in
cell D6, and you want this to be shown in A2 of Sheet1 - in this cell
you would have the formula:

=Sheet2!D6

If you want to put other parameters in Sheet1, then use the cells B1,
C1 etc and then change the formulae in Sheet2 to bring the values from
the appropriate cells of Sheet1.

Hope this helps.

Pete

TR wrote:
First of all, I don't think I am smart enough to go coding.
Being that, is there anyway to build calculation functions in Sheet2 and
list possible input in Sheet1 and automatically getting values under
different inputs?
For example, I put equity valuation calculations on Sheet2. A1 of Sheet2 is
the earning growth rate assumption, which drives all the equity valuation
calculations. In sheet1, can I input expected growth rate in A1 and get
equity value on A2 (based on the calculations on Sheet2)?
I understand that creating a table can be helpful. But Table does not work
in separate sheets. Plus, if I want other parameters in the calculations in
addition to the equity value, I have to create other tables.

Appreciate your help!

Rt