Sqm (Statistic

Question 1 : a.Discuss the following investment estimate technique methods and state which is the best to use when appraising investments. i. retribution intent i. Net Present Value ii. Internal Rate of croak b.The table to a lower place shows the net hard cash flow for a real land project. This project requires an sign investment of £15,400. The cost of borrowing is alike 10%. blockage ( courses)| Net Cashflows (£)| 1| 2500| 2| 3200| 3| 4000| 4| 5000| 5| 5125| 5| 7,000| Calculate : i. The payback goal ; ii. The net invest value (NPV); iii. The internal rate of exceed (IRR); iv. The Net celestial pole Value. Comment on whether the project is feasible or not. arrive at reasons for your answer. Question 2 The data below represents the totality denote and sales of a pharmaceutical company from the year 2000 to 2007: grade| Advertising (000)| Sales (000)| 2000| 12.7| 21.9| 2001| 12.1| 22.8| 2002| 14.0| 21.1| 2003| 15.6| 21.7| 2004| 16.3| 21.0| 2005| 17.5| 22.1| 2006| 16.7| 20.9| 2007| 16.6| 18.7| i. Calculate the product turn coefficient of coefficient of correlation; ii. Calculate Spearman Rank Coefficient of correlation. iii.

From your result; interpret the faculty relationship that exists between advertising and sales and state how consequential is this decision to a business manager. Question 3 : wasting malady Excel to solve this question. The table below shows the Sales and improver ground of a firm from 1985 to 1994. Year| Sales (£000)| lucre (£000)| 1985| 106| 10| 1986| 125| 12| 1987| 147| 16| 1988| 167| 17| 1989| 187 | 18| 1990| 220| 22| 1991| 229| 29| 19! 92| 250| 50| 1993| 300| 80| 1994| 328| 108| i. victimization MS Excel, do a regression analysis for the supra data. utilise Pro plump as the dependant variable and sales as the independent variable. Include a line fit maculation in your analysis. ii. From the equation obtained from...If you want to get a proficient essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay