thumb up will be provided for a complete formula but not excel , thank you so much

Silicon Co. is a start-up company. It is now considering going ahead with one of the following projects next month. The details about the two mutually exclusive projects are as follows: Project A The initial cost is $1,500,000. In return, the company forecast year-end cash inflow of $600,000 from year 1 to year 3. The cash flow will drop to $400,000 in year 4. Project B The initial cost is $1,800,000. The company forecasts to receive $500,000, $550,000, $400,000 and $1,200,000 from year 1 to 4 respectively. Assume that the required yearly return of both projects are 5%

Instead of choosing one out of the two projects, Silicon Co. has just realized that they can implement projects A and B simultaneously if they install a new machine. The installation cost is $200,000. Explain whether Silicon Co. should install this new machine. (Hint: Justify your answer base on the NPV of the two projects.)

Sam has $10,000 and is considering investing in two stocks - HSCC and Sixcent. The table below shows the returns of the stocks under different possible scenarios: State of Affair Probability HSCC Sixcent Pandemic (long period of lockdown) 0.25 2% 20% Pandemic (short period of lockdown) 0.3 5% 10% No Pandemic 0.45 18% 2%

Determine if the two stocks are overpriced or underpriced and which (if any) should be purchased. (4 marks) f) Sixcent is having higher beta while HSCC is having smaller standard deviation. Explain why the results of beta and standard deviation can be different even though both of them are measuring risk.