Question: Please provide specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Q2: The year-by-year annual returns after the World War II are provided on the

Please provide specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable.

Q2: The year-by-year annual returns after the World War II are provided on the Excel answer sheet, the tab Case 3. Use =AVERAGE function to compute the post-WW2 1946-2018 average return for S&P stock market index (Rm) and for US risk-free T-bill (Rf), respectively. With such Rm and Rf amounts, and if Microthins stock beta = 1.25 (based on the period of 1946-2018), what shall be the required return amount on Microthin stock if you apply the CAPM formula?

Q3: Based on your answers to Q1 and Q2, and apply both NPV and IRR rules, has your Microthin stock investment over the "Dec 2014 Dec 2018 period been good or bad?

The TABS are correct there should only be 2.

Please provide specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Q2:

The year-by-year annual returns after the World War II are provided on

Post-Wwii Annual Returns: S& P Year son Porrhe Stocks TBAN 1946 -8.4396 1947 5.2006 0.5706 1948 5.7096 1949 18 3096 1.1096 1950 30.816 1951 23.6896 1.489 1952 1 18.159 1.679 1953 -1 2196 1954 152.5696 1955 32.6096 1.6696 1956 1957 -10.4696 3.236 1958 43.7206 1.7896 1959 12.06% 3.26% 1960 0.349 3.0506 1961 26.6490 1962 1 -8810 2.780 1963 22.61 3.1196 1964 16.42063.5196 1965 12 40963.9096 -9.976 1967 23 806 4.3396 1968 10.9196 5.2696 1969 -8.24966.5696 1970 3.5696 6.6996 1971 14.220 4.5496 18. 769 3.9596 1973 -143106 6.7396 1974 -25.90 7.7896 1975 37.00965.9996 1976 23.839% 4.9706 1977 -6980 1978 6.519% 6.9396 1966 1981 3.20 14 20 6.159 1984 1985 5 819 1987 1988 1959 1990 1991 31-459 -3.056 30.239 37 2016 22689 33. LOS 1996 1997 S0209 20 39 PODO 2001 -11. SSG 21.972 28369 2003 2004 2019 2005 159 2010 2011 2012 ook O 050 0219 2014 2015 2016 201T 1216 119 vewage 10329 4.0196 Q1: What should be the IRR during the "December 2014 - December 2018" period for your Microthin stock investment? 2018 Particulars Buy Shares Dividend on Shares Sale of shares Net Cash Flow IRR NPV 2014 2015 2016 2017 $ (630,000.00) $(405,000.00 $ 11,700.00 S 8,600.00 $ 17,500.00 $ 290,000.00 $ 200,000.00 S (630,000.00) $ 301.700.00 S (396,400.00) S 217,500.00 6.46% (S146,337.37) $ $ $ 13,000.00 650,000.00 663,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. We are given the information that...

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Please show how to do this in excel and...

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() whenever applicable. Please show excel formulas. We are given...

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(), =IRR(), =AVERAGE(), =YIELD() Case Three (16 pts) We are given the information that...

We are given the information that Microthins stock price was $21 in December 2012, $29 in December 2013, $27 in December 2014, $20 in December 2015, and $26 in December 2016. It also pays annual...

its one whole problem We are given the information that Microthin's stock price was $21 in December 2016, $29 in December 2017, S27 in December 2018, $20 in December 2019, and $26 in December 2020....

We are given the information that Microthin's stock price was $21 in December 2015, $29 in December 2016, $27 in December 2017, $20 in December 2018, and $26 in December 2019.It also pays annual...

Case Three (16 pts) We are given the information that Microthins stock price was $21 in December 2014, $29 in December 2015, $27 in December 2016, $20 in December 2017, and $26 in December 2018. It...

ASSESSMENT INSTRUMENT BUS 330 Road King Trucks Introduction Michael Livingston has recently been hired as the CEO of Road King Trucks, Inc.Previously he had been the marketing manager for a large...

We are given the information that Microthins stock price was $21 in December 2012, $29 in December 2013, $27 in December 2014, $20 in December 2015, and $26 in December 2016. It also pays annual...

Considering the following information for a project: Activity Crash Time (weeks) A B C D E F G H I Immediate Predecessor - A B C F G D. E Normal Time (weeks) 4 5 6 8 5 8 4 5 3 2 4 5 4 2 7 3 4 3 Crash...

According to the Center on Budget and Policy Priorities article Curbing Flexible Spending Accounts Could Help Pay for Health Care Reform (revised June 10, 2009), flexible-spending accounts encourage...

Sam and Susan Scully have two children ages 4 and 2. They are 35 years old. Sam works full-time and earns $95,000 p.a. and does not expect further promotions, but does expect his salary will keep...

, ( + ) . 20 , . Ex1-data.xlsx, 1 1. , , , , , , , Excel ( ). 2. . ; 3. , . R2 . 5%, excel () . . ; 4. 150 50 . 500 90 ; ; 5. , 2, ( ) 2005 2019. , , 2020. (ii) =0,8, . 2020;

What do they need to do differently?

How is trade involved in a brands IMC?

What are the important keys to identifying IMC opportunities for a brand?