$(10$ pts$.)$ Based on the data in the spreadsheet file FIL $242$ HW $1$ Fall $2024.$xlsx for Dollar Tree $($DLTR$)$:

a$.$ Calculate the return relatives for each year starting in $1996.$ Use two decimal places.

b$.$ Calculate the arithmetic and geometric means for these price relatives, using three decimal places.

c$.$ Calculate the cumulative wealth index as of the end of year $2022,$ assuming an initial investment of $$1,000$ and $$10,000.$ State the answers without decimal places.

The Data Numbers for this one is Date Price

Dec$-951\mathrm{.}63$

Dec$-963\mathrm{.}78$

Dec$-976\mathrm{.}13$

Dec$-989\mathrm{.}71$

Dec$-9910\mathrm{.}76$

Dec$-008\mathrm{.}17$

Dec$-0110\mathrm{.}30$

Dec$-028\mathrm{.}19$

Dec$-0310\mathrm{.}02$

Dec$-049\mathrm{.}59$

Dec$-057\mathrm{.}98$

Dec$-0610\mathrm{.}03$

Dec$-078\mathrm{.}64$

Dec$-0813\mathrm{.}90$

Dec$-0916\mathrm{.}10$

Dec$-1028\mathrm{.}04$

Dec$-1141\mathrm{.}56$

Dec$-1240\mathrm{.}56$

Dec$-1356\mathrm{.}42$

Dec$-1470\mathrm{.}38$

Dec$-1577\mathrm{.}22$

Dec$-1677\mathrm{.}18$

Dec$-17107\mathrm{.}31$

Dec$-1890\mathrm{.}32$

Dec$-1994\mathrm{.}05$

Dec$-20108\mathrm{.}04$

Dec$-21140\mathrm{.}52$

Dec$-22141\mathrm{.}44$

$(15$ pts$.)$ PepsiCo's $($ticker symbol $=$ PEP$)$ December ending prices $($adjusted for stock splits and dividends$)$

and its annual dividend are given in the file FIL $242$ HW $1$ Fall $2024.$xlsx$.$ Use three decimal places and

calculate results in decimal form $($not percentages$).$ You will need the $2012$ price to calculate the $2013$

return. For each year $2013-2022$:

a$.$ Calculate as column $D$ the return relative for the price change only.

b$.$ Calculate as column E the return based on price change only.

c$.$ Calculate as column $F$ the return relative based on price change and dividends.

d$.$ Calculate as column $G$ the return based on price change and dividends.

e$.$ Calculate the arithmetic and geometric means for $2013-2022$ for price change only and for total

return.

f$.$ Calculate the ending wealth as of December $31,2022,$ for $$1$ invested in PepsiCo stock at the

beginning of $2013.$

g$.$ Calculate the standard deviation of the returns for the years $2013-2022.($Note: Use the total returns

and not the return relatives.$)$

the data prices and dividends for this one is

Date Price Dividends

$12/31/201268\mathrm{.}43$

$12/31/201382\mathrm{.}942\mathrm{.}2400$

$12/31/201494\mathrm{.}562\mathrm{.}5325$

$12/31/201599\mathrm{.}922\mathrm{.}7625$

$12/30/2016104\mathrm{.}632\mathrm{.}9600$

$12/29/2017119\mathrm{.}923\mathrm{.}1675$

$12/31/2018110\mathrm{.}483\mathrm{.}5875$

$12/31/2019136\mathrm{.}673\mathrm{.}7925$

$12/31/2020148\mathrm{.}304\mathrm{.}0225$

$12/31/2021173\mathrm{.}714\mathrm{.}2475$

$12/30/2022180\mathrm{.}664\mathrm{.}5250$