Search

Ne'Maiya lrby

NI

$$

$$

File

Home

Insert

Page Layout

Formulas

Data

Review

View

Automate

Help

Aria

General

Conditional Formatting $vv$

Format as Table ${?}^2$

Insert

Delete

$$

Number

$$

Format

Font

Cells

Styles

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

$48$

A

$$uc$\mathrm{.}0$

$50$

$51$

$52$

WACC

Growth rate after the $10$th year, $g_n$

Number of common stock outstanding

Number of preferred stock

Value of nonoperating assets

Market value of debt

$8\%$

$HV$ of FCF at the end of year $10$

$PV$ of $FC{F}_{1-10}$ at year $0$

$PV$ of $HV$ at year $0$

Market value of operations

Market value of nonoperating assets

Total corporate value

Less: market value of debt

Intrinsic value of common equity

$5\%$

$20$ millions

$0$ millions

$$0$ millions

$$1,500$ millions

$6$

$66$

$67$

$68$

$69$

Intrinsic value per share

millions

#N$/$A

millions

millions

millions

millions

millions

millions

millions

A$$

ZV & Find &

Sorter Select

Filter

Editing

Sensitivity

Add$-$ins

Share

$.$

Add$-$ins

Analyze

Data

$\backslash$table$[[,$millions,$],[,$millions,$],[,$millions,#N$/$A$],[,$millions,#N$/$A$],[$millions$,$#N$/$A$,],[$millions$,$#N$/$A$,],[,$millions,#N$/$A$],[,$millions,$],[,,],[,,]]$

$\backslash$table$[[,],[,],[,],[,],[,],[,]]$

Sheet$1$

Ready if Accessibility: Good to go

Search

$w$

$$

$$

$-$

$2$:$25$ PM

$\frac{11}{22}\frac{?}{2023}$

$62F$

$$

ming

$+21$

${?}^{{?}^{?}}$

$$

$)$

X

$8$

$=$