Question: How is this done in excel and also on a financial calculator? Suppose you invested $100 in the S&P 500 a month ago. It paid

How is this done in excel and also on a financial calculator?

Suppose you invested $100 in the S&P 500 a month ago. It paid a dividend of $1.72 today and then you sold it for $111. What was your return on the investment?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the return on investment in Excel and on a financial calculator follow these ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Describe the roles of ASIC, the AASB, the ASX and the FRC, and the relationships between these regulatory bodies.

A corporation makes an initial investment of $400,000 in a project. The expected annual cash inflows are $50,000 in the first year, increasing by $25,000 each year (i.e., $75,000 in the second year,...

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

a. Stock market index information: S&P 500 (stock) index level: Nasdaq Composite (stock) index level: b. Interest rate information : Prime rate: Federal funds rate: Commercial paper rate (90 days):...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

all of the following are my questions 4. The Mankiw-Romer- Weil (1992). A different way of formulating human capital is to assume that human capital is accumulated just like physical capital, so it...

You are among the OTC market makers in the stock of Bio-Engineering, Inc. and quote a bid of 102 1/4 and an ask of 102 1/2. Suppose that you have a zero inventory. (a) On Day 1 you receive market buy...

Suppose you invested $100 in the Ishares High Yield Fund (HYG) a month ago. It paid a dividend of $5 today and then you sold it for $97. What was your dividend yield and capital gains yield on the...

Suppose you invested $100 in the S&P 500 a month ago. It paid a dividend of $1.72 today and then you sold it for $111. What was your return on the investment?

4) Project A Project B Project C Project D Initial Investment Cash flow $21 million $12 million per year for three years $18 million $9 million per year for three years $15 million $6 million per...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Suppose that the market for painting services is perfectly competitive. Painting companies are identical; their long-run cost functions are given by TC(Q)=6Q^3-30Q^2+200Q Market demand is...

Suppose that a firm has both fixed-rate and floating-rate debt outstanding. What effect will a decline in interest rates have on the firms times-interest-earned ratio? What about the ratio of the...

La cantidad de riesgo sistemtico presente en un activo riesgoso en particular, en relacin con el riesgo sistemtico presente en un activo de riesgo promedio, se llama _________ del activo en...

a. What is the equation of the least-squares regression line relating posttest and pretest scores? Define any variables used. b. Is a linear model appropriate for describing this relationship?...

Orillia Outfitters Ltd. reported the following shareholders equity information on January 1, 2020: Contributed capital Preferred shares, $0.75, cumulative (1 year in arrears), liquidation price of...

Early in the chapter when discussing how effective advertising must take the consumers view, the following quotation was presented: Consumers dont want to be bombarded with adsthey want to be...

On March 1, 2022, Pechstein Construction Company contracted to construct a factory building for Fabrik Manufacturing Inc. for a total contract price of $8,400,000. The building was completed by...

Target Corporation prepares its financial statements according to U.S. GAAP. Targets financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

_________ Larry was hurt while playing football in his senior year in high school. Since then, he has been confi ned to a wheelchair. After receiving his college diploma, he applied for a supervision...

_________ Which of the following is the best way to describe employee-development training? a. Attracting the best people to apply for positions b. Using satisfaction surveys and employee...

What are the three main objectives of Whirlpools diversity networks?