Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the table suppose you have sold all 30 shares of WFC on February 1, 2022, and kept the proceeds in cash for

   

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%

Step by Step Solution

3.50 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

To calculate the adjusted portfolio returns and the total geometric return after selling all 30 shar... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Finance questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago

Question

Which signal is used to resume the execution of a process?

Answered: 1 week ago