In this CT assignment, we will use R software to analyze a dataset GoogleAmazonStock.xlsx.It contains daily closing stock prices for Google and Amazon from 8/22/2017 to 8/22/2018. When we examine stock prices (or other financial assets) we often transform them into a (simple) return series. The return series are computed by the formula: (present price/past price) - 1. The dataset contains both stock prices and return series.1. Using R, construct time series (line) plots for both stock prices and return series. R functions ts.plot or plot can create the plot. Describe the patterns and compare the plots. 2. Based on the return series, can we claim that the mean Amazon return series is higher than that of Google?a. What would be an appropriate test of the claim above? Explain. b. Write the null and alternative hypotheses. c. Using R, perform the test. d. Write the decision in the problem context.Take the screenshots of the R graphs and output as well as the code. Paste them into a Word document along with your answers to the questions above. Clearly label the questions and answers. Submit the Word file in Canvas.

The requirements are including in files

Answers must be entered in Excel with work shown6. Determine the present values if $5,000 is received in the future (i.e., at the end of each indicated time period) in each of the following situations:a. 5 percent for ten years b.7 percent for seven years c.9 percent for four years 9. Assume you are planning to invest $5,000 each year for six years and will earn 10 percent per year. Determine the future value of this annuity if your first $5,000 is invested at the end of the first year. 10. Determine the present value now of an investment of $3,000 made one year from now and an additional $3,000 made two years from now if the annual discount rate is 4 percent. 11. What is the present value of a loan that calls for the payment of $500 per year for six years if the discount rate is 10 percent and the first payment will be made one year from now? How would your answer change if the $500 per year occurred for ten years? 12 Determine the annual payment on a $500,000, 12 percent business loan from a commercial bank that is to be amortized over a five-year period. 13 Determine the annual payment on a $15,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan. 15 Assume a bank loan requires an interest payment of $85 per year and a principal payment of $1,000 at the end of the loan's eight-year life.a. At what amount could this loan be sold for to another bank if loans of similar quality carried an 8.5 percent interest rate? That is, what would be the present value of this loan? b.Now, if interest rates on other similar-quality loans are 10 percent, what would be the present value of this loan? c. What would be the present value of the loan if the interest rate is 8 percent on similar-quality loans?