Excel Online Structured Activity: Nonconstant growth below. Open the spreadsheet and perform the required analysis to answer the question below. Nonconstant growth

Year $3$ Dividend, $D_3$

Supernormal growth rate, $g_s$

Normal growth rate, $g_n$

Required return, $r_s$

Dividends

$P_5$

Cash flows to common stockholders

PV of cash flows to common stockholders

Stock Price, $P_0$

Alternatively, using Excel NPV function:

Stock Price, $P_0$

Dividends

$P_5$

Cash flows to common stockholders

PV of cash flows to common stockholders

Stock Price, $P_0$

Alternatively, using Excel NPV function:

Stock Price, $P_0$

Open spreadsheet

If the required return on Computech is $17\%,$ what is the value of the stock today? Round your answer to the nearest cent. Do not round your intermediate calculations.

$