Write an excel formula to find: Determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013. Price On: 1/2/2013 $70.8412/31/2014 $104.57Growth 47.61%
Q: FedEx stock ended year 2019 with a stock price of $106 per share. It paid $3.00 in dividends during…
A: Price in 2019 = $106 Price in 2020 = $235 Dividend in 2020 = $3
Q: If you started with 100 shares of stock at $48 per share and participated fully in the DRIP, how…
A: An automated reinvestment plan (ARP) is a strategy for investing big profits or stocks…
Q: Am I correct in my calculations: Suppose that in July 2013, Nike Inc. had EPS of $2.28 and a book…
A: Checking your Caluclations
Q: Using the stock table for Dell Technologies below, calculate the earnings per share. Round your…
A: EPS: EPS stands for Earnings per share. It tells about the profit earned on each share. EPS = […
Q: Given above is the historical data of Jollibee Food Corporation's (JFC) stock price. You invested…
A: Number of shares = Total InvestmentMarket Price per share Return on Investment = ( Selling Price -…
Q: Financial information for Forever 18 includes the following selected data: ($ in millions) 2024…
A: Solution 2a: 2024 2023 Net Income $160.00 $171.00 Less: Dividend on Preferred Stock $22.00…
Q: Based on the following stock price and shares outstanding information, use the Dow Jones industrial…
A: An increase in the number of shares of stock issued by a corporation does not result in a change in…
Q: Mithril Capital had the following six end-of-year share prices: 2015 2016 2017 2018 2019 2020 Price…
A: Given Information End of Year share Prices of Year 2015,2016,2017,2018,2019 and 2020 are…
Q: Using the stock table for Dell Technologies below, calculate the earnings per share. Round your…
A: Earning per share measures the profitability for the shareholders it means how much the shareholders…
Q: Coronado Corporation had net income of $2060000 and paid dividends to common stockholders of $296000…
A:
Q: Calculate the current value of the stock based on the following information. The company paid…
A: Gordon's growth model is one of the most commonly used variations of the dividend discount model.…
Q: he following information is available for Evans Corporation: 2021…
A: Solution: Return on common stockholder's equity = (Net Income -Preferred dividends) / average…
Q: What is the most likely price for which Facebook would sell, using the 2014 financial data and…
A: Given, Stock Price of Facebook = $83 No. of Total shares outstanding = 2.8 Billion Most Likely…
Q: Financial information for Forever 18 includes the following selected data:($ in millions)…
A: Financial ratio analysis: It can be defined as an analysis tool that is based upon the relative…
Q: A company has earnings of $3.18 per share. The benchmark PE for the company is 18. What stock price…
A: Given:Earnings = $3.18PE = 18
Q: Use the following information in the table below to answer the question: Blanc Blanc Financial Year…
A: The accounting return on equity (ROE) is calculated as net income divided by average shareholder…
Q: Consider the following price and dividend data for General Electric Company: VIT Date Price ($)…
A: Total yield = ((Sale price – Purchase price) + Dividend) / Purchase price *100 = ((Sale price (Jan…
Q: At the April 2015 stock price of $14.59, the market values zulily at $1.86B. This is a big drop from…
A: An asset seems to be a thing that will have some economic worth to a firm and may be utilized to…
Q: Daniel invested $1,000 in large U.S. stocks at the beginning of 2012. This investment earned 15.30…
A: Return rate in 2012 = 15.30% Return rate in 2013 = 33.20% Return rate in 2014 = 12.25% Return rate…
Q: Selected information for Brain Corporation is as follows:…
A: The rate of return is calculated as net income for the year divided by average stockholder equity
Q: XYZ stock price and dividend history are as follows: Year…
A: Arithmetic average return is defined as the return on the reinvestment, which is calculated by sum…
Q: An investor purchased Alphabet stock (GOOG) at $337.95 per share on October 31, 2012. The closing…
A: Given: Investment purchases on October 31 ,2012 = $337.95Closing price of stock…
Q: ou found the following stock quote for DRK Enterprises, Inc., at your favorite website
A: a. Stock price = Dividend / Dividend yield = $0.83 / 0.0140 = $59.29
Q: You bought a stock on 1 January 2018 for $135.5 and below are the year-end price data and annual…
A: Given: Date Closing price Annual dividend 31-Dec-17 $135.50 $3.60 31-Dec-18 $138.20 $3.65…
Q: You've collected the following information from your favorite financial website. (The number next to…
A: From the above able: The Dividend yield of Candy galore=1.5% Annual Dividend=$0.32
Q: An investor purchased 200 shares of a stock at $60/share on January 1, 2012, then sold 100 shares…
A: Financial management consists of directing, planning, organizing and controlling of financial…
Q: Use the portion of the stock table shown below to answer the questions that follow. Round dollar…
A: loss= sale price - purchase price
Q: Use the portion of the stock table shown below to answer the questions that follow. Round dollar…
A: i. given ' dividend=0.99 number of shares= 610 total dividend = dividend x number of shares total…
Q: Calculate closing stock if the opening stock is $49 million and change in stock is $5 million
A: Here in this question, we are required to calculate closing stock. We can formulate change in…
Q: What is Milson's rate of return on common stock equity for 2021?
A: Return on Common Equity = Net Income for Common Stockholders / Average Common Equity Net Income for…
Q: Holland Corporation's annual report is as follows. March 31, 2023 March 31, 2024 Net Income…
A: Common stockholders are the owners of the company. They have voting rights. They are able to get…
Q: Use the stock table below to answer parts a through g. Assume that the data for Company XYZ stock…
A: The opening price of the stock is 14.88. Closing price of the stock is 15.65.
Q: Compute the following ratios for 2021 and 2022. 2022 2021 Profit margin…
A: Profit margin = Net Income / net sales, Gross profit rate = Gross profit / Net sales, Asset Turnover…
Q: mark up
A: Mark up % = ((Selling price - Cost )/Cost) * 100
Q: Answer the Question based on the data given below; OPENING STOCK OMR 25000 CLOSING STOCK OMR 35000…
A: The correct option is b. OMR 30000
Q: Go to Yahoo.com’s financial website and enter Apple, Inc.’s stock symbol, AAPL. Answer the following…
A: As you have posted a question with multiple subparts, we will solve the first three sub-parts for…
Q: What does that analysis suggest to you?
A: Investors have different ways to find the theoretical price of a stock. Out of this one, the…
Q: Use the following information for Questions 6–8.Information concerning O’Sadnick, Inc., on December…
A: Price/earnings ratio for 2013 = Market price per share / Earnings per share = 16.00 / 4.00 = 4.0…
Q: answer the questions
A: Formula:
Q: Answer the questions based on the Data Table.
A: (1) Calculation of the EPS:EPS can be calculated by the following formula:EPS = (Net Income –…
Q: In 2024, the company declares cash dividends of $46,000. How much of the dividend goes to…
A: Given information is: Preferred Stock—6%, $12 Par Value; 8,500 shares authorized, 7,000 shares…
Q: Sterling Trust has the following classes of stock: (Click the icon to view the data.) Read the…
A: Dividends if declared by the company needs o be first paid to preference stockholders and the…
Q: Use the following information for Short Exercises S15-6 through S15-10. Accel’s Companies, a home…
A: Earnings per share: Earnings per share help to measure the profitability of a company. Earnings per…
Q: Triumph's has 40,000 common shares outstanding during 2018. Requirement 1. Compute earnings per…
A: The following computations are done for Triumph's Companies.
Q: Suppose a stock you bought one year ago at $102.65 recently paid you a dividend of $3.17. You sold…
A: Holding period return can be defined as the total return generated over from a security over a…
Q: a. Compute the number of common shares outstanding at the end of each fiscal year. Estimate the…
A: a. 2014 2,765 2013 2,746.80 2014 Average 2,853.40 b. 2014 55.18 2013 54.12 c.…
Q: Nissan Company gave out 45 pesos dividend per share for its common stock. The market value of the…
A: Stock Yield ratio = Dividend per share/ Market Price per share
Write an excel formula to find:
Determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013.
Price On:
1/2/2013 $70.84
12/31/2014 $104.57
Growth 47.61%
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div)Div Yld %PE Ratio Close PriceNet ChgHiLo77.40 10.43 Palm Coal 0.362.6 6 13.90 –0.24 55.81 33.42 Lake Lead Grp 1.543.8 10 40.43 –0.01 131.08 70.25 SIR 2.753.1 10 89.12 3.07 50.24 13.95 DR Dime 0.805.2 6 15.43 –0.26 35.00 20.74 Candy Galore 0.321.5 28 ?? 0.18 According to your research, the growth rate in dividends for SIR for the next five years is expected to be 21 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.75 percent indefinitely. Assume investors require a return of 15 percent on SIR stock. Requirement 1:According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations. Round your…You've collected the following information from your favorite financial website. 52-Week Price Div Yld PE Close Net Ratio Price Chg Hi Lo Stock (Div) % 77.40 10.43 Palm Coal .36 2.6 6 13.90 .24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 -.01 130.93 69.50 SIR 2.00 2.2 10 88.97 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 -.26 .18 35.30 20.77 Candy Galore 0.35 1.5 28 ?? a. Using the dividend yield, calculate the closing price for Candy Galore on this day. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Assume the actual closing price for Candy Galore was $23.02. Your research projects a 4.75 percent dividend growth rate for Candy Galore. What is the required return for the stock using the dividend discount model and the actual stock price? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Stock price b. Required return %You bought a stock on 1 January 2018 for $135.5 and below are the year-end price data and annual dividends for the stock: Date Closing Price Annual Dividend 31 December 2017 135.5 3.6 31 December 2018 138.2 3.65 31 December 2019 136.8 3.5 31 December 2020 140.7 3.7 What is the standard deviation of returns on this stock over the 2018-2020 period? 0.0173 0.0005 0.0009 0.0212 O 0.0303
- You've collected the following information from your favorite financial website. 52-Week Price Div PE Close Net Hi Lo Stock (Div) Yld % Ratio Price Chg 77.40 10.43 Palm Coal 0.36 2.6 6 13.90 -0.24 Lake Lead Grp 55.81 33.42 3.8 10 40.43 -0.01 1.54 131.04 70.05 SIR 2.55 2.9 10 89.08 3.07 50.24 13.95 DR Dime 0.80 5.2 6 15.43 -0.26 Candy Galore 35.00 20.74 1.5 28 ?? 0.18 0.32 According to your research, the growth rate in dividends for SIR for the next five years is expected to be 21 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.75 percent indefinitely. Assume investors require a return of 14 percent on SIR stock. (Hint: the number after the company's name above is DO.) Requirement 1: According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) Current stock priceUsing the stock table for Dell Technologies below, calculate the earnings per share. Round your answer to the nearest cent.Do not include the $ in your answer.Dell TechnologiesDVMT$66.26$66.40-$66.96$42.02-568.25NameSymbolCloseDay Range52-Week RangeVolumeP/EDividendDividend YieldEPS895,028103.53$0.000%?You've collected the following information from your favorite financial website. 52-Week Price Div PE Close Net Hi Lo Yld % Ratio Price Stock (Div) Palm Coal .42 Chg 78.00 10.49 2.9 6 14.50 -.24 Lake Lead Grp 55.81 33.42 3.8 40.43 -.01 130.93 69.50 SIR 2.00 2.2 88.97 3.07 50.24 13.95 DR Dime .80 5.2 15.43 -.26 35.00 20.74 Candy Galore .32 1.5 ?? .18 According to your research, the growth rate in dividends for Palm Coal for the previous 10 years has been 4 percent. If investors feel this growth rate will continue, what is the required return for Palm Coal stock? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Required return % 1.54 6068 10 10 28
- You've collected the following information from your favorite financial website. 52-Week Price Div PE Close Net Hi Lo Yld % Ratio Price Chg Stock (Div) Palm Coal .36 77.40 10.43 2.6 6 13.90 -.24 Lake Lead Grp 56.26 33.87 4.9 10 40.88 -.01 130.93 69.50 SIR 2.00 2.2 10 88.97 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 -.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 Find the quote for the Lake Lead Group. Assume that the dividend is constant. a. What was the highest dividend yield over the past year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What was the lowest dividend yield over the past year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Highest dividend yield % b. Lowest dividend yield % 1.99Help Save & Exit Submit You purchased a stock at a price of $53.12. The stock paid a dividend of $2.15 per share and the stock price at the end of the year is $59.47. What is the capital gains yield? Multiple Choice 10.68% 11.95% 4.05% 16.00% 10.14% 18 of 40 Next > ( PrevGiven the following price and dividend information, calculate the $1 invested equivalent. (Round to 4 decimals) Stock: MSFT Year Price Dividend 2017 $ 64.65 2018 $ 95.01 $ 1.72 2019 $ 104.43 $ 1.89 2020 $107.23 $ 2.09 2021 $231.96 $ 2.30 2022 $310.98 $ 2.54 2023 $ 247.81 $ 3.00
- You've collected the following information from your favorite financial website. 52-Week Price Div PE Close Net Hi Lo Stock (Div) Yld % Ratio Price Chg 77.40 10.43 Palm Coal .36 2.6 6 13.90 -.24 Lake Lead Grp 55.81 33.42 3.8 10 40.43 -.01 130.94 69.55 SIR 2.05 2.3 10 88.98 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 -.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends for SIR for the next five years is expected to be 20 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.25 percent indefinitely. Assume investors require a return of 12 percent on SIR stock. According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Current stock price Based on these assumptions, is the stock currently overvalued, undervalued, or correctly valued? Stock currently 1.54You've collected the following information from your favorite financial website. 52-Week Price Div PE Close Net Hi Lo Yld % Ratio Price Chg Stock (Div) Palm Coal .36 77.40 10.43 2.6 6 13.90 -.24 Lake Lead Grp 55.81 33.42 3.8 10 40.43 -.01 130.94 69.55 SIR 2.05 2.3 10 88.98 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 -.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends for SIR for the next five years is expected to be 20 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.25 percent indefinitely. Assume investors require a return of 12 percent on SIR stock. According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) X Answer is complete but not entirely correct. Current stock price $ 21.33 X 1.54cks A and B have the following historical returns: Year 2016 2017 2018 2019 2020 Stock A's Returns, ra (17.90%) 30.00 13.25 (3.50) 29.75 Stock B's Returns, ra (14.20%) 22.70 a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places. Stock A 39.50 (7.10) 10.70 Stock B b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock 8. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign. Year 2016 2017 2018 2019 2020 What would the average return on the portfolio have been during this period? Round your answer to two decimal places. Portfolio CV e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? ele Calculate the standard deviation of returns for each stock and for the portfolio. Hound your answers to two decimal places.…