Download the Excel spreadsheet from the LMS. It contains historical monthly prices and dividends (paid at the end of the month) for Telstra stock (Ticker: TLS) over a five-year period. For this period, calculate: 1. The return for each month
Question
Download the Excel spreadsheet from the LMS. It contains historical monthly prices and dividends (paid at the end of the month) for Telstra stock (Ticker: TLS) over a five-year period. For this period, calculate:
- The return for each month
Solution
I'm sorry for the confusion, but as a text-based AI, I don't have the ability to download or access files from external sources, including Excel spreadsheets. However, I can guide you on how to calculate the return for each month using Excel.
Here are the steps:
-
First, you need to calculate the monthly returns. If the prices are in column B (starting in row 2), you could calculate the return from the first month to the second month in cell C3 with the formula
=(B3-B2+B2)/B2. This formula subtracts the previous month's price from the current month's price, adds any dividends, and then divides by the previous month's price to get the return. -
Then, you can copy this formula down column C to calculate the return for each subsequent month.
Remember to replace B2 and B3 with the actual cells where your data is located.
Similar Questions
Date TTM Net Income LT Investments & Debt Return on Investment2023-09-30 $93.90B $262.66B 38.53%2023-06-30 $88.52B $248.21B 38.03%2023-03-31 $84.80B $236.65B 37.84%2022-12-31 $82.82B $227.26B 38.04%2022-09-30 $84.66B $218.94B 39.75%2022-06-30 $83.38B $213.57B 39.95%2022-03-31 $81.94B $211.10B 40.29%2021-12-31 $78.63B $208.27B 39.97%2021-09-30 $74.28B $202.02B 38.89%2021-06-30 $69.92B $192.06B 37.67%2021-03-31 $64.23B $184.51B 35.28%2020-12-31 $60.16B $185.37B 33.37%2020-09-30 $56.15B $180.45B 31.67%2020-06-30 $52.96B $177.88B 30.21%2020-03-31 $51.96B $177.36B 30.02%2019-12-31 $49.32B $173.47B 29.17%2019-09-30 $45.69B $172.54B 27.49%2019-06-30 $42.96B $168.99B 26.52%2019-03-31 $40.93B $161.45B 25.83%2018-12-31 $38.88B $161.78B 24.88%2018-09-30 $37.31B $155.70B 24.26%2018-06-30 $35.06B $154.96B 22.43%2018-03-31 $32.36B $152.72B 20.41%2017-12-31 $30.79B $151.71B 19.63%2017-09-30 $30.02B $165.90B 19.89%2017-06-30 $29.03B $163.78B 20.43%2017-03-31 $30.32B $145.95B 23.45%2016-12-31 $28.88B $128.12B 23.72%2016-09-30 $27.00B $130.53B 22.68%2016-06-30 $26.08B $112.55B 23.13%2016-03-31 $15.05B $115.70B 13.49%2015-12-31 $16.36B $117.46B 14.59%2015-09-30 $18.11B $105.26B 16.42%2015-06-30 $18.16B $107.89B 16.34%2015-03-31 $26.70B $117.78B 23.89%2014-12-31 $27.08B $110.14B 24.77%2014-09-30 $27.27B $108.64B 25.19%2014-06-30 $27.76B $110.43B 26.53%2014-03-31 $27.35B $108.10B 27.37%2013-12-31 $27.99B $105.78B 29.44%2013-09-30 $27.79B $94.27B 30.97%2013-06-30 $26.76B $91.55B 31.19%2013-03-31 $20.88B $88.64B 25.41%2012-12-31 $19.65B $84.52B 24.50%2012-09-30 $19.87B $78.55B 25.45%2012-06-30 $21.76B $77.08B 28.54%2012-03-31 $27.74B $80.60B 37.37%2011-12-31 $27.08B $76.05B 38.44%2011-09-30 $27.25B $71.32B 41.31%2011-06-30 $27.16B $69.00B 43.61%2011-03-31 $26.92B $65.37B 46.57%2010-12-31 $26.38B $58.15B 49.01%2010-09-30 $26.73B $56.61B 52.11%2010-06-30 $24.10B $51.11B 49.80%2010-03-31 $22.16B $49.46B 47.71%2009-12-31 $21.42B $48.03B 62.87%
The Group is provided with the last 5-year financial information of NTPC Limited along with their approximately last 5 years share prices.Click here to access the excel. Click here to access the 5-year financial information of NTPC(Use Capital Assets Pricing Model (CAPM) to estimate its cost of Equity – Cost of Equity = Risk-Free Rate+(Market Rate - Risk-Free Rate) x Beta; For Market Return use BSE SENSEX (data is provided) and take risk-free rate as 6.65% per annum. For calculating the Market Annual Return from Daily returns, use 250 as the number of working days. Also, use the following formula to calculate return from pricesReturn = [(Price today – Price of the previous day)/ Price of the previous day]Required:a) Valuation of the Company using Dividend Discount Model (use only constant growth model) Dividend Data is given in the attached EXCEL file. While calculating the intrinsic value of NTPC share, use the formula g = Return on Equity ´Retention Rate to calculate the growth rate. After the calculation of the growth rate then compute valuation using the Dividend Discount Model.
Networks Ltd is experiencing a period of rapid growth. Earnings and dividends are expected to grow at a rate of 18% during the next two years, 15% in the third, and then at a constant rate of 6 per cent thereafter. Networks’ last dividend, which has just been paid, was $0.115. If the required return on the shares is 12%, what is the price of the share today?
Telstra Group Ltd:Provide a summary for the source of financing capital structure for your firm. This may include (but not limited to): book value of total debt, book value of total equity, and the ratio between these two (debt equity ratio). Note that some firms (not common) may not have any debt (zero debt firm).
(Note: Use Python to solve this question). Use the yfinance library to extract daily stock price data for the firm Tesla (Ticker: TSLA). Use Adjusted Close prices to calculate continuously compounded returns. What would have been by July 30th, 2021, the value of a $10,000 investment in the company on the first trading day of January 2021? $9,398.95 $9,416.66 $10,601.04 $9,254.58
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.