Question No 1: (Marks 8) Offshore Modern Products, Inc., imposes a payback cutoff of three years for its international investment projects. Company has the following two projects available: Year Cash Flow (A) Cash Flow (B) -35 000 -95 000 18 000 0 1 13 000 2 19 000 27 000 3 14 000 4 23 000 48 000 170 000 -40 000 5 -9 000 Calculate the payback period, modified internal rate of return (3 methods), net present value, profitability index of proposed projects if required return is 7%. Determine which project is better and explain why. * You should describe each step in detail and provide intermediate calculations. Add tables from Excel if necessary. * Do not delete anything from the Word file. * Be careful when rounding. Leave two decimal places. Question No 2. (Marks 8) Consider the following information: State economy of Probability of Rate of return if state occurs state of economy Stock A Stock B Stock C Boom 0.35 0.08 0.03 0.33 Bust 0.65 0.14 0.25 -0.07 1. Your portfolio is invested 30% each an A and B, and 40% in C. What is the expected return of the portfolio? 2. What is the variance of the portfolio and standard deviation? 3. If you have to choose only one type of securities (stock A, B, C) which one will you choose and why? To answer this question, you need to calculate the expected return for each stock and the standard deviation, and compare their values. * You should describe each step in detail and provide intermediate calculations. Add tables from Excel if necessary * Do not delete anything from the Word file. * Write your answers after each question. * Be careful when rounding. Leave two decimal places. Question No 3. (Marks 4) Sahara Inc., was founded nine years ago by brother and sister Fatema and Muhanad Al Balushi. The company manufactures and installs commercial heating, ventilation, and cooling units. Sahara Inc. has experience rapid growth because of a proprietary technology that increases the energy efficiency of its units. The company is equally owned by Fatema and Muhanad. The original partnership agreement between the siblings gave each 50,000 shares of stock. In the event either wished to sell stock, the shares first had to be offered to the other at a discounted price. Although neither sibling wants to sell, they have decided they should value their holdings in the company. To get started, they have gathered the following information about their main competitors: EPS DPS Earnings per share Dividend per share Arctic Inc. 50.x2 $0.16 Heating & Cooling Inc. $1.32 $0.52 Breese Inc. S-0.47 $0.40 Industry Average 50.56 $0.36 Stock price ROE R Return Required equity SI5.19 11% 10% $12.49 $11.47 513.05 139 Expert Breese Inc. negative earnings per share were the result of an accounting wright-off last year. Without the wright- off, carnings per share for the company would have been $0.97. Last year, Sahara Inc., had an EPS of $4.32 and paid dividend to Fatema and Muhanad of $54,000 each. The company also had a return on equity of 25%. The siblings believe that 20% is an appropriate required return for the company: 1. Assuming Sahara Inc., use the Zero Growth model, what is the value of share of stock today (P.)? Compare with stock prices for other companies and the industry average and give recommendations on changing dividend policy. 2. To verify the calculations, Fatema and Muhanad have hired Josh Smith as a consultant. Josh has examined the company's financial statements, as well as examining its competitors. Although Sahara Inc., currently has a technological advantage, his research indicates that other companies are investigating methods to improve efficiency Josh believes that the required return used by the company is too high. He believes the industry average required return is more appropriate. Under this assumption, what is your estimate of Sahara stock price today? Do you agree with Josh's analysis? Justify your