Based on the table suppose you have sold all 30 shares of WFC on February 1,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Based on the table suppose you have sold all 30 shares of WFC on February 1, 2022, and kept the proceeds in cash for the rest of the time period. Make the adjustment to the Portfolio returns evaluation and calculate Total Geometric Return over this time period that reflects WFC shares sale. (note: you have 2 tables in excel with the same set up, so you can keep one table for the original portfolio performance and one for the portfolio with the trade). # of shares-> Date 8/1/2021 9/1/2021 10/1/2021 25 JNJ 169.90 159.43 160.79 11/1/2021 153.93 12/1/2021 169.98 1/1/2022 171.19 2/1/2022 3/1/2022 4/1/2022 5/1/2022 163.52 177.23 180.46 176.13 30 WFC 44.88 45.77 50.46 47.13 47.51 53.27 52.84 48.20 43.39 42.34 15 CAT 207.70 189.09 200.95 191.50 204.76 199.63 186.68 221.76 209.54 205.21 Cash Portfolio 8,709.34 8,195.19 8,547.68 8,134.43 8,746.04 8,872.27 8,473.56 9,202.99 8,956.31 8,751.56 R(P) -5.90% 4.30% -4.83% 7.52% 1.44% -4.49% 8.61% -2.68% -2.29% Based on the table suppose you have sold all 30 shares of WFC on February 1, 2022, and kept the proceeds in cash for the rest of the time period. Make the adjustment to the Portfolio returns evaluation and calculate Total Geometric Return over this time period that reflects WFC shares sale. (note: you have 2 tables in excel with the same set up, so you can keep one table for the original portfolio performance and one for the portfolio with the trade). # of shares-> Date 8/1/2021 9/1/2021 10/1/2021 25 JNJ 169.90 159.43 160.79 11/1/2021 153.93 12/1/2021 169.98 1/1/2022 171.19 2/1/2022 3/1/2022 4/1/2022 5/1/2022 163.52 177.23 180.46 176.13 30 WFC 44.88 45.77 50.46 47.13 47.51 53.27 52.84 48.20 43.39 42.34 15 CAT 207.70 189.09 200.95 191.50 204.76 199.63 186.68 221.76 209.54 205.21 Cash Portfolio 8,709.34 8,195.19 8,547.68 8,134.43 8,746.04 8,872.27 8,473.56 9,202.99 8,956.31 8,751.56 R(P) -5.90% 4.30% -4.83% 7.52% 1.44% -4.49% 8.61% -2.68% -2.29%
Expert Answer:
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Evenflow Power Co. is considering a new project that is a little riskier than the current operations of the company. Thus, management has decided to add an additional 1.5% to the company's overall...
-
Calculate the net present value (NPV) for the following 20-year projects. Comment on the acceptability of each. Assume that the firm has an opportunity cost of 14%. a. Initial investment is $10,000;...
-
Happy Trails has this information for its manufacturing: Its income statement under absorption costing is: Prepare an income statement with variable costing and a reconciliation statement between...
-
Africa offers a fast growing and exciting mobile phone market, with more than 50% growth per year since 2002. More than 28% of African consumers own mobile phones; a larger market than North America....
-
The following data were taken from the balance sheet accounts of Wickham Corporation on December 31, 2010. Prepare the required journal entries for the following unrelated items. (a) A 5% stock...
-
Student Name: Anthony Jedruczek (Please PRINT your name) Assume that Q-Caf has the following transactions related to the sale of coffee beans during the month of October, 2023. Oct 1 Oct 5 Oct 15 Oct...
-
Bobby's Bistro, a 24 hour, 7 days per week operation, specializes in a Super Deal Meal selling for a price in dollars and cents equal to twice the first two digits of your AUID divided by 10 (for...
-
A chemistry graduate student is studying the rate of this reaction: He fills a reaction vessel with H 3 PO 4 and measures its concentration as the reaction proceeds: Use the data to answer the...
-
explain why monetary autonomy is impossible on its own with a fixed exchange rate using IS/LM or the trilemma, and why monetary policy must accompany fiscal policy with a fixed exchange rate
-
what happens to the demand and the demand curve for beef if more people decide to become vegans ?
-
What happens if a toaster company makes 10,000 toasters to sell for $80 and they only sell 7,000? What would they do with the other 3,000 toasters?
-
Calculate the impulse experienced when a 68 kg person lands on firm ground after jumping from a height of 2.5 m Express your answer using two significant figures. J = Submit Part B Favg Submit Part...
-
suppose you are at a bundle, such that MRS>MRT, how should you change your consumption so as to maximize utility subject to your budget constraint?
-
An inductor and a resistor are connected in series across an AC source as in the figure below. Immediately after the switch is closed, which of the following statements is true? (Select all that...
-
Eleni Cabinet Company sold 2,200 cabinets during 2011 at $160 per cabinet. Its beginning inventory on January 1 was 130 cabinets at $56. Purchases made during the year were as follows: February . 225...
-
Three years of combined data for two firms appear below (in millions). One of these firms is FedEx, a relatively high-growth firm that provides courier services, and the other is Kellogg Company, a...
-
Alfa Romeo incurs direct cash costs of $30,000 in manufacturing a red convertible automobile during 2016. Assume that it incurs all of these costs in cash. Alfa Romeo sells this automobile to you on...
-
Selected data for The Hershey Company for Year 1 through Year 3 appear in Exhibit 4.29. REQUIRED a. Compute ROA and its decomposition for Year 2 and Year 3. Assume a tax rate of 35%.b. Compute ROCE...
-
The following table shows the interest rates on the fixed and floating borrowing choices available to three firms. Firms A and B want to be exposed to a floating interest rate while Firm C would...
-
Futures contracts are standardized contracts for the delivery of a specified quantity of a commodity or financial instrument on a prearranged future date, at an agreed- upon price. They are a bet on...
-
Derivatives transfer risk from one person or firm to another. They can be used in any combination to unbundle risks and resell them.
Study smarter with the SolutionInn App