Excel Case #$2-$ Chevron Corporation $($CVX$)$ Answer Schedule Format Points available $$ Remarks Market value of equity $($market cap$)=0$ million currency, $3$ decimal places $0\mathrm{.}50$ use $12/31/24$ data provided on Data tab $-$ use value in MILLIONS Growth rate for equity $$ percentage, $2$ decimal places $1\mathrm{.}75$ use dividends for most recent six years as I have segregated on the Data tab Market price of stock $($per share$)$ currency, $2$ decimal places $0\mathrm{.}50$ use $12/31/24$ data provided on Data tab Annual dividend $$ currency, $2$ decimal places $0\mathrm{.}50$ use the most recent year on the Data tab Beta of stock $$ number, $2$ decimal places $0\mathrm{.}50$ use $12/31/24$ data provided on Data tab Risk free rate $4\mathrm{.}20\%$ percentage, $2$ decimal places Market rate of return $9\mathrm{.}90\%$ percentage, $2$ decimal places DGM cost of equity $($stock$)$ percentage, $2$ decimal places $1\mathrm{.}25$ CAPM cost of equity $($stock$)$ percentage, $2$ decimal places $1\mathrm{.}25$ Average cost of equity $$ percentage, $2$ decimal places $1\mathrm{.}00$ simple average of two methods Market value of debt $$ million currency, $3$ decimal places $0\mathrm{.}50$ use bond schedule for $12/31/24-$ use value in MILLIONS Average tax rate $$ percentage, $2$ decimal places $1\mathrm{.}00$ use average for most recent fiv calendar years $=$ there are two acceptable ways to calculate this that result in two slightly different answers Pre tax cost of debt $($bonds$)$ percentage, $2$ decimal places $3\mathrm{.}50$ use bond schedule for $12/31/24-$ use value in MILLIONS After tax cost of debt $($bonds$)$ percentage, $2$ decimal places $1\mathrm{.}25$ use bond schedule for $12/31/24-$ use value in MILLIONS Total market value of equity and debt $$ million currency, $3$ decimal places $0\mathrm{.}50$ use value in MILLIONS Weight for equity $$ number, $4$ decimal places $1\mathrm{.}25$ Weight for debt $$ number, $4$ decimal places $1\mathrm{.}25$ Weighted average cost of capital $$ percentage, $2$ decimal places $3\mathrm{.}50$ Save your file with this name format:$$ Excel Case $2$ FirstinitialLastname SectionNumber $$ Example: Excel Case $2$ MGwinn $01$W Total$$ points $20\mathrm{.}00$