A.What is Apple Inc. stock price from 2015-2019?
B.What is Apple Inc. dividends paid from 2015-2019?
C.What is Apple Inc. total return to holders from 2015-2019?
D.What is Apple Inc. average change over 4 years?
E.What is the Dow Jones index at FYE from 2015-2019?
F.What is the total return on index from 2015 - 2019?
G.What is the average change over 4 years?
H.What is the S & P 500 index at FYE from 2015-2019?
I.What is the total return on index from 2015-2019?
J.What is the average change over 4 year?
K.What are the trends you see in your numbers?
If a person invested $1,l} in each of the 3 items, how much would the investment grow to over the same periods of 4 veers? Fiscal Years 215 2MB 2131? 2D1E Zing-last ___Chosen Co. i _ _ _ _ ___Dow Jones 'I _ _ _ _ S 3; F' sou 1,l}{] Graph the change in value over the 4 years for the 3 different investments. COMMENTS: Comment on the trends you see in vour numbers and graph. 1) Billy Bob deposits $2000.00 in an account that pays 4.25% compounded annually. How much will BB have in his account in 10 years? $2,000.00 4.25% 10 a) Solve using algebra: Using a ' mark, copy the formula used in a (cell F11) here: b) Solve using Excel functions; Using a ' mark, copy the formula used in cell F15 here: 2) Fifteen years ago, Bob purchased an investment for $1,500. If the investment averaged 6% per year return. How much is the investment worth today? Identify variables given; a) Solve problem by referencing the cell addresses of variables you have identified; Answer3) A $1000 deposit in an account earns interest at an annual nominal rate of 8.00%. Interest is compounded monthly in the account. How much money will be in the account at the end of the 10th year? Identify variables given; a) Solve the problem using the cells above. Answer II b) What is the EAR of the rate above compounded monthly? 4) A zero-coupon bond matures in 10 years and will be worth $1000.00 to the holder. If the bond was purchased 10 years ago, and yielded a return of 5% per year, how much did the holder pay for the bond? (Assume annual compounding, and answer to the nearest cent-$0.01).5) Big Corporation had the following sales over the last 4 years; Year Sales (in 0005) 225.00 2 236.25 243.125 4 248.00 a) What was the growth rate in sales between years 1 & 2; b) What is the growth rate in sales between years 3 & 4; c) What is the average annual growth rate for these years? (hint: this is a geometric mean) 6) Calculate the EAR for the following annual nominal rates; Annual Rt. Compounding/yr 10.000% semi-annual 9.875% monthly 9.625% daily7) Complete the missing variables in the table below; Annual nominal Cmpdyear # years 1%/yr (nom) PV FV H H 10.0% $ 1,000.00 5 10.0% $ 1,000.00 10 10.0% $ 1,000.00 1 10 5.0% $ 1,000.00 4 5 10.0% $ 1,000.00 12 5 10.0% $ 1,000.00 10 5.00% $2,000.00 10 10.00% $2,000.00 5 10.00% $2,000.00 4 5 10.00% $2,000.00 12 10.00% $2,000.00 5 $ 1,000.00 $1,338.23 1 10 $ 1,000.00 $1,480.24 12 10 $ 1,000.00 $ 2,451.36 1 8.00% S 1.00 2.00
