PROBLEM $1$

Inputs

Beta

Dividend

Outputs

Required return

Intrinsic value

Over or under valued

PROBLEM $2$

Inputs

Beta

Div $2020$

Growth rate

Outputs

Div $2021$

r

IV

Over or under valued PROBLEM $3$

Inputs

EPS

Dividend

DPO

ROE

Beta

P$/$E

Outputs

Average DPO

Growth rate

Required return

Average P$/$E

EPS

$2025$

$2026$

$2027$

Dividend

Sale price

Total cash flow

NPV

Over or under valuedTo complete this homework, you will use Tab $1$ of the M$4$ submission template. Once you have completed Tab $1,$ you will copy it to Tab $2.$ Once you've copied your answers to Tab $2,$ you will click on "Formulas," then on "Show Formulas."

The homework must be completed according to the Principles of Spreadsheet Design.

Remember that you are graded on the assignment as well as your accuracy in using the Principles

of Spreadsheet Design.

Esco Technologies has paid a $$0\mathrm{.}32$ per share dividend annual since $2010.$ Its current

beta is $1\mathrm{.}05.$ Find Esco's intrinsic value. If its current price is $$5\mathrm{.}11$ per share, is the

stock over or under valued?

Use the Non$-$zero Growth Model to find the intrinsic value of Jefferies Financial Group's

stock. Its current dividend is $$1\mathrm{.}44,$ its dividend grow rate is $15\%,$ and it has a beta of

$1\mathrm{.}25.$ If its current price is $$30\mathrm{.}21,$ is it over or under valued?

Use the Combined Dividends & Earnings Model to find Whirlpool's intrinsic value. Use

the historical information in the chart to find the average DPO, the growth rate, the

required return, and the average $\frac{P}{E}.$ Then use that information to forecast the cash flows

for $2025-2027.$ average DPO $\{$:$)$

If its currently selling for $$100$ a share, is it over or under valued?