Go to Yahoo! Finance and download the monthly stock prices for Apple (AAPL) from 1/1/2016 to 12/31/2021. (1) Sort the data in increasing order by date. (2) Calculate monthly returns using Adj. Close prices. Align the returns well with the dates. (3) Calculate the average monthly return and standard deviation of the monthly returns. (Hint: use either STDEV.S or STDEV to calculate the standard deviation.) On Excel Formulas included
Q: Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects…
A: “Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: These are the quotes from the spot market. Citigroup Credit Suisse Deutsche Bank ¥126/€ ¥108/$…
A: Triangular arbitrage is an arbitrage opportunity resulting from the pricing discrepancy of three…
Q: You have been transferred to New Mexico for your post-graduate internship. You and your spouse have…
A: Option 1:Buy a home @ $120,000Resale value @ end of year 1 = $130,000Profit = $10,000Option 2:Rent =…
Q: marillo National Bank offers you a 60-month, 0.139 APR (monthly compounding) auto loan. If you…
A: Loans are paid by monthly payments and these monthly payments carry the payment for interest and…
Q: You invest $9,000 today at an annual interest rate of 5%. How much do you expect to have 5 years…
A: P = $9,000r = 5% = 0.05n = 5
Q: mon's Hot Chicken purchased its building seven years ago at a price of $139,645. The building could…
A: Fixed assets are those assets which are fixed and not movable and value of these assets decreases…
Q: Bird Wing Bedding can lease an asset for 4 years with payments of $15,000 due at the beginning of…
A: Leasing Cost:It is the present value of the lease costs annually discounted at the borrowing…
Q: Use the following information to answer this question. Windswept, Incorporated 2022 Income Statement…
A: Here, ParticularsValues (in million $)Net sales9990Accounts receivables in the year…
Q: 3-43. An annuity fund is to be created to provide $6,000 at the end of each quarter year from ages…
A: The concept of time value of money will be used here. As per the concept of time value of money any…
Q: Which is the better buy? 4-pack of clay pots for $7.40 7-pack of clay pots for $13.17
A: We need to calculate cost per pack. Cheaper will be better to buy.Cost per pack = total cost/number…
Q: The Utah Mining Corporation is set to open a gold mine near Provo, Utah. According to the treasurer,…
A: IRR is regarded as one of the most important Capital Budgeting Techniques.Internal rate of return…
Q: weled Outlook is analyzing a proposed project with expected sales of 9,200 units, ±4 percent. The…
A: Variable cost depends on the volume and increases with increase in volume of production.
Q: Evaluate the significance of Gearing and Insolvency in cost management
A: Gearing refers to the degree of financial leverage, or the percentage of a company's assets that are…
Q: A Tediore Industries bond has an 7,5 percent coupon rate and a $1,000 face value. Interest is paid…
A: 1.Bond’s value = Present value of Interest Payments + Present value of maturity amount.2. Present…
Q: Dax Industrial Systems has stock currently priced at $50.00 per share. If investors are earning a 7%…
A: P = whereP= current stock priceD = annual dividend payment per sharer = Required return
Q: 6. A company has 2 mutually exclusive projects to consider with the following information: Project A…
A: NPV is also known as Net Present Value. It is a capital budgeting tehniques which help in decision…
Q: It is with deep regret that I inform you that your rich uncle just passed away. His money is tied up…
A: We need to calculate present value of 20000 which will you received in 5 years to compare to present…
Q: Fowler, Inc., just paid a dividend of $2.45 per share on its stock. The dividends are expected to…
A: The price of the stock is calculated using a constant growth model equation belowWhere, r is…
Q: ou make the following monthly payments. Your total net income (net of taxes) is $4,000. Calculate…
A: Savings ratio show how much income has been saved out of net income after doing all expenses and…
Q: has fisk aversion of A-4 when applied to return on wealth over a one-year horizon. She is pondering…
A: Variables in the question: S&P PortfolioHedge Fund PortfolioRisk premiums10%14%Standard…
Q: Correct! Correct! 1.88 Investor What about the degree of financial leverage? It looks like that is…
A: The combined leverage is the type of leverage which refers to the profit that is on my company due…
Q: This morning I ordered my standard coffee refill from the Global Cafe for $1.09 (it is a lot cheaper…
A: Future value is the value of future cash flows or savings when invested at an interest rate for a…
Q: Going to a bank and applying for a mortgage loan would be an example of what type of financing?…
A: A mortgage is a contract between you and a lender that provides the lender the right to repossess…
Q: Suppose that a stock price is currently 64 dollars, and it is known that at the end of each of the…
A: Put option gives the opportunity to sell stock on expiration but there is no obligation to do that…
Q: Using the data in the following table,, calculate the return for investing in Boeing stock (BA) from…
A: Calculation of realized return from January 2, 2008 to January 2, 2009:Formula used:
Q: In 2021, a standard 30-year fixed mortgage in the US could be had for somewhere around 3%. Following…
A: When the borrower borrows a loan from the lender, he has to pay a rate of interest on the borrowed…
Q: Given the cash flows below and an interest rate of 3%, solve for the PV. Round to the nearest two…
A: Present Value is a current value of future cash flow at specified rate of interest. It is help in…
Q: At 11%, at which maturities the value of $2,000 today is larger than $4,000 in the future Seleccione…
A: The concept of time value of money will be used here. As per the concept of time value of money the…
Q: You have recently adopted a child and are planning to save for her college education. You want to…
A: We need to use future value of ordinary annuity formula to calculate annual payment to achieve…
Q: oblem #7: You deposit P dollars into an account that earns a nominal rate of i compounded…
A: In simple interest there is no interest on interest and there is interest on deposit only. In…
Q: Use the following spot rates to answer the following questions. Maturity Spot rate (%) 1 year 4.93%…
A: we are given a set of spot rates for different maturities and asked to determine if there is an…
Q: Today, you start working for University of Houston as administrative staff. You decided to invest…
A: Variables in the question:DescriptionDataPMT ($)500Rate p.a.6%N (years)35
Q: d Martha are twins, and just graduated from college. They plan to retire in 40 years. To that end,…
A: In order to answer the question, we must see the amount per month invested and for the period of…
Q: (Liquidity analysis) When firms enter into loan agreements with their bank, it is very common for…
A: a.Current assets = $1,908,026,400Current liabilities = $1,362,876,000The firm's current ratio is
Q: Suppose a hedge fund manager earns 1% per trading day. There are 250 trading days per year. Answer…
A: First, we'll examine the annual return when investors are allowed to reinvest the daily earnings,…
Q: 7. Solve numerically for the proportions of each asset and for the expected return and standard…
A: As per instruction, the solution to question 7 is given below:The Optimal Risky Portfolio represents…
Q: f Joe and Mary Smith have money market accounts of $100,000, real estate holdings of $300,000, loans…
A: Money market accounts: $100,000Real estate holdings: $300,000Investments: $10,000
Q: Question 6.29 The following three sets of cash flows have the same present value: . 10,000 payable…
A: Cash flow at the end of 1 year = 10,000Cash Flow at the end of each year for 12 years = 1,200Let X =…
Q: at is the future value of $750.00 received today and deposited at 8% per year for 10 years with…
A: Future value of the amount is the amount being deposited and amount of interest accumulated over the…
Q: You can invest in taxable bonds that are paying a yield of 9.50 percent or a municipal bond paying a…
A: A security bond is a legally enforceable promise to pay the government if you or your employee…
Q: 1. Suppose the current one-year rate (one-year spot rate) and expected one-year T-bill rates over…
A: 1R1=6%,E(2r1) =7%,E(3r1) =7.5%E(4r1)=7.85%
Q: Faisal has $12,000 in his savings account and can save an additional $3,600 at the end of each year…
A: Present Value Present Value $ 12,000.00Yearly Saving $ 3,600.00Future Value $…
Q: Your corporation is currently all-equity financed with 400,000 shares of common stock selling for…
A: Earning per share is a tool to measure a company's performance so the company can able to compare…
Q: Bond Dave has a 5 percent coupon rate, makes semiannual payments, a 8 percent YTM, and 8 years to…
A: Price of the bond is the PV of all future coupons and par value discounted at the YTM. We can…
Q: Using the data in the following table,, calculate the return for investing in Boeing stock (BA) from…
A: Variables in the question: Historical Stock and Dividend Data for Boeing stock (BA)DatePrice…
Q: 3-Usine eradient, calculate the present worth of the following cash flow diagram at an 8% interest…
A: Present Value is a current value of future benefits at specified rate of interest. It is help in…
Q: We consider three zero-coupon bonds (strips) with the following features: Bond Maturity (years)…
A: 1-year bond current value = $95.422-year bond current value = $94.459-year bond current value =…
Q: AT&T stock has the following probability distribution of expected prices one year from now: State…
A: expected holding-period return on stock =
Q: Required information [The following information applies to the questions displayed below. A pension…
A: Required:Portfolio Invested in Stock =?Portfolio invested in Bond Fund =?Expected Return of Optimal…
Q: Calculate the present value of the cash flow shown below. Interest rates are 13.00% per year,…
A: The rate of return is 13%.
Go to Yahoo! Finance and download the monthly stock prices for Apple (AAPL) from 1/1/2016 to 12/31/2021.
(1) Sort the data in increasing order by date.
(2) Calculate monthly returns using Adj. Close prices. Align the returns well with the dates.
(3) Calculate the average monthly return and standard deviation of the monthly returns. (Hint: use either STDEV.S or STDEV to calculate the standard deviation.)
On Excel Formulas included
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
- Using the data in the table:, a. What was the average annual return of Microsoft stock from 2005-2017? b. What was the annual volatility for Microsoft stock from 2005-2017? a. What was the average annual return of Microsoft stock from 2005-2017? The average annual return is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Return for the S&P 500, Microsoft, and Treasury Bills, 2005-2017 S&P 500 Realized Return Microsoft Realized Return Dividends Paid* Year End 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 S&P 500 Index 1211.92 1248.29 3.00% 4.80% 1418.30 1468.36 903.25 4.70% 1.50% 0.10% 0.10% 1115.10 1257.64 1257.61 0.00% 1426.19 0.10% 1848.36 0.00% 0.00% 2058.90 2043.94 0.00% 0.20% 2238.83 2673.61 0.80% *Total dividends paid by the 500 stocks in the portfolio, based on the number of shares of each stock in the index, adjusted until the end of the year, assuming they were…Type the answers with a screen capture of chart. Produce a daily OHLC bar or Candlestick price chart on PTC us stock. Then, add (1) Two moving averages (it can be simple moving averages or exponential moving averages, with one faster and one slower). You can choose any parameter (number of days, simple or exponential) you prefer. (2) Trend lines over the period covered. It can be up trend line, down trend line or channel that you observe from the chart. (3) Technical indicator(s) such as RSI or MACD. Note: after done the drawing, capture the screen and save as picture and then work with your saved pictures. Can use ANY charting app. On the chart, 1. Identify and mark the current key support and resistance levels. They should include the immediate support/resistance level and the next support/resistance levels. "Current" means you are focusing on the current or latest price level, do not mention the support or resistance levels when the price was, say, several months ago in the earlier…You are building out your 1 x 3 point and figure chart that is currently in a column of X's with the last X at $17. When you look at the high, low, close data for today you see that the high was $17.99 and the low was $14.01. The stock closed at $15.01. What do you add to the chart for today? a. A new trend line b. You add noting to the chart c. A new column of O's to the $15 level d. A new X at $18
- (Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time Asman Salinas 1 $10 $30 2 12 27 3 11 32 4 13 34 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Question content area bottom Part 1 The rate of return you would have earned on Asman stock from time 1 to time 2 is enter your response here%. (Round to two decimal places.)From the following price data, compute the annual rates of return for Asman and Salinas. Time Asman Salinas 1 $ 10 $ 31 2 13 27 3 12 33 4 14 35 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Question content area bottom Part 1 The rate of return you would have earned on Asman stock from time 1 to time 2 is enter your response here %. (Round to two decimal places.) Part 2 The rate of return you would have earned on Asman stock from time 2 to time 3 is enter your response here %. (Round to two decimal places.) Part 3 The rate of return you would have earned on Asman stock from time 3 to time 4 is enter your response here %. (Round to two decimal places.) Part 4 The rate of return you would have earned on Salinas stock from time 1 to time 2 is enter your response here %. (Round to two decimal places.) Part 5…The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
- The following table represents the rate of returns of two stocks in different economic conditions along with their probabilities (the data are also uploaded on moodle) RATES OF RETURN ON STOCKS EXPECTED ECONOMIC PROBABILITY STOCK A STOCK B CONDITIONS RECESSION 0.55 -0.04 -0.02 STABLE 0.35 0.25 0.30 EXPANDING 0.10 0.15 0.20 Answer the following by using mathematical calculations: a) Calculate the expected rate of return for each stock respectively. Explain what the expected value implies. b) Calculate the standard deviation for each stock respectively. Explain what the standard deviation implies. c) If you were an investor in which stock you were going to invest? Justify your answer. d) Calculate the covariance between Stock A and stock B. Discuss. e) Calculate the expected return and the standard deviation of the portfolio consisting 40% in stock A and 60% in stock B. f) Discuss the risk and return associated with investing i All of your funds in stock A ii. All of your funds in stock…Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A 2010 2011 2012 2013 2014 2015 - 1% 6% 2% -5% 4% 6% Stock B 20% 9% 8% -3% - 5% 21% Print Done ☑ ClearUsing the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 20% 2013 - 1% - 13% Stock A Stock B 20% 12% - 9% Print 2012 8% 9% C Done 2014 4% - 9% 2015 11% 27% - X
- You are given the following returns on "the market" and Stock F during the last three years. We could calculate beta using data for Years 1 and 2 and then, after Year 3, calculate a new beta for Years 2 and 3. How different are those two betas, i.e., what's the value of beta 2 - beta 1? (Hint: You can find betas using the Rise-Over-Run method, or using your calculator's regression function.) Year Market Stock F 1 6.10% 19.50% 2 12.90% −3.70% 3 16.20% 21.71% A. 10.96 B. 10.91 C. 11.06 D. 11.01 E. 11.11 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.you have observed the following returns over time: Year Stock X Stock Y Market 2011 13 % 12 % 13 % 2012 18 7 10 2013 -12 -6 -10 2014 2 1 2 2015 19 9 16 Assume that the risk-free rate is 5% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. fill in the blank 4 % What is the required rate of return on Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. fill…The following are the end-of-month prices for both the Standard & Poor's 500 Index and Nike's common stock. a. Using the data in the popup window, calculate the holding-period returns for each of the months. b. Calculate the average monthly return and the standard deviation for both the S&P 500 and Nike. c. Develop a graph that shows the relationship between the Nike stock returns and the S&P 500 Index. (Show the Nike returns on the vertical axis and the S&P 500 Index returns on the horizontal axis.) d. From your graph, describe the nature of the relationship between Nike stock returns and the returns for the S&P 500 Index.