Dear, Kindly help me to answer this questions with formula please

Q1. The data shown below Project A 18 T 0 1 2 3 Project B 6 2 2 2 4 5 0 0 5 6 7 8 9 10 2 2 6 0 0 7 8 The example shows the expected cash flows of two hypothetical projects. The cash flows are expressed in nominal terms, i.e. the expected money values to be received in the future. These values correspond to the profits expected in the future time periods. Given a discount rate of 10%, find: a) The net present value (NPV) of each project. b) Suppose Project A was considered the riskier and, as a consequence, the discount rate for this project was set at 16% (Project B remains at 10%) which project should be undertaken if they are mutually exclusive. c) Would your decision still hold if Project A were discounted at 18%? Q2. Calculate Regression equation. Calculate R2 the coefficient of determination: Temp (OC) Sales (L) 15 272 16 282 20 315 18 289 21 320 19 301 Q3. Problem: The table below shows the volume of sales ('000) of a firm over three years. Use time series decomposition to forecast for the four quarters in year 2013. Q1 Q2 Q3 Q4 2010 87.5 73.2 64.8 88.5 2011 90.3 76.0 69.2 94.7 2012 93.9 78.4 72.0 100.3 I Q4. After organising 150 concerts, Krazy Konzerts Ltd. (KK) has lost its principal backer and is now negotiating with Virginia Records for future funding. You have a meeting with Virginia's Chief Executive, Richard Pickle. You must demonstrate to him that KK is a low-risk, successful operation. Prepare the statistical data for your meeting. Hints: 1. Identify the problem 2. Gather the data 3. Calculate the descriptive statistics 4. Check the distribution. 5. Calculate the Z-statistic. 6. Transform Z-value(s) into probability