PLEASE USE EXCEl FORMULAS IF POSSIBLE.

PLEASE EXPLAIN EVERYTHING WITH DETAIL- THANK YOU

HORIZON VALUE: (A)$51.47, (B)$36.06, (C)$61.76, (D)$43.75

CURRENT INTRINSIC VALUE: (A)$32.96, (B)$36.31, (C)$35.22, (D)$12.04

DIVIDEND YIELD: (A)8.63%, (B)0.00%, (C)10.79%, (D)9.23%

CAPITAL GAINS YIELD: (A)51.47%, (B)28.18%, (C)12.80%, (D)35.22%

Galaxy Corp. is expected to generate a free cash flow (FCF) of $9,745.00 million this year (FCF1 = $9,745.00 million), and the FCF is expected to grow at a rate of 23.80% over the following two years (FCF2 and FCF). After the third year, however, the FCF is expected to grow at a constant rate of 3.54% per year, which will last forever (FCF4). If Galaxy Corp.'s weighted average cost of capital (WACC) is 10.62%, what is the current total firm value of Galaxy Corp.? $29,702.22 million $229,275.24 million O $191,062.70 million O $248,125.10 million Galaxy Corp.'s debt has a market value of $143,297 million, and Galaxy Corp. has no preferred stock. If Galaxy Corp. has 450ilion shares of common stock outstanding, what is Galaxy Corp.'s estimated intrinsic value per share of common stock? $116.76 O $106.15 $105.15 $318.44