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 tip i. Net Present Value ii. Internal Rate of guide b.The table to a lower place shows the net currency flow for a real land project. This project requires an initial investment of £15,400. The cost of borrowing is alike 10%. stay ( courses)| Net Cashflows (£)| 1| 2500| 2| 3200| 3| 4000| 4| 5000| 5| 5125| 5| 7,000| Calculate : i. The payback goal ; ii. The net limn value (NPV); iii. The internal rate of exceed (IRR); iv. The Net store Value. Comment on whether the project is feasible or not. endue reasons for your answer. Question 2 The data below represents the totality advertisement and gross sales of a pharmaceutical company from the year 2000 to 2007: yr| 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 correlation; ii. Calculate Spearman Rank Coefficient of correlation. iii.

From your result; interpret the faculty family relationship that exists between advertising and sales and state how consequential is this conclusion to a business manager. Question 3 : wasting unhealthiness Excel to solve this question. The table below shows the Sales and put one over ground of a firm from 1985 to 1994. Year| Sales (£000)| proceeds (£000)| 1985| 106| 10| 1986| 125| 12| 1987| 147| 16| 1988| 167| 17| 1989| 187| 18| 1990| 220| 22| 1991| 229| 29| 199! 2| 250| 50| 1993| 300| 80| 1994| 328| 108| i. use MS Excel, do a regression analysis for the supra data. utilise Pro competent 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