Information Systems Example

Information Systems Example Information Systems â€" Assignment Example > 7. *(View Excel sheet named Summery)8. *(View Excel sheet named Chart)9. *(View Excel sheet named Resource Sector)10. Click on the the summery sheet and then click on the button named PrintReport to print. b. click on the sheet named Table and then click on the button named PrintReport to print. 11. Report. REPORT COMPARING THE PROFITABILITY OF SHARES FROM RESOURCE SECTORThe shares purchased from the resource sector include the shares from RIO Resources, the BHP Resources and the Fortescue Resources. This is shown in the table below: -Table 1ShareCost ofpurchased sharesCost ofSalesProfitTotalDividendsPercentageof initialInvestmentRIO $5,160.00 $8,299 $3,139 $49.27 61.79%BHP $10,942.50 $10,950 $7.5 $8708.01%Fortescue $10,100.00 $10,300 $200 $3055.0%The shares in the resource sector traded well over the two-year holding period, RIO Resources earned a total of $49.27 dividends for 100 shares and the Market Value (M. V) of $82.99 per share. This lead to 61.79% total return of the init ial investment. The graph below clearly compares the three sharesGraph 1.Bar graph for different shares in the resource sector against percentage of initial investmentInterpretationComparing the RIO share with other companies in the same sector, it comes out clearly that RIO resources share had the highest percentage of annual return irrespective of the little amount invested. The predominantly striking feature of the graph above is that the RIO shares fared well in the market compared to the other two, on the contrary, it has not been well with the Fortesque shares because their percentage remained low over the whole period. A side by side analysis of the three shares, Fortescue share had the least annual return during the two-year holding period. It is also noted that all the three shares in the resource sector were profitable. Knowing the share prices in the market and their market performance is crucial to succeeding on the stock market, it is therefore important to access and analyse the rate of annual return per share in order to know the shares do be re-invested and those to be disposed. Graphical representation of such data makes it easy to analyse these reports for easy decision making. Microsoft excel therefore plays a very important role in tabulation and graphical data presentation and analysis. It also provides formulas and functions for easy calculation. References Aronoff, C. E., and John, L. W. (1992) Family Business Succession: The Final Test of Greatness. Business Owner Resources. Bruce, J. Feibel, (2003), Investment Performance Measurement. New York. Durham University (2010) Introduction to using macros in Microsof Excel. [Internet] available from http: //www. dur. ac. uk/resources/its/info/guides/39Excel2003Macros. pdf (accessed on 07/08/2011) TechUcomp, Inc. (2010) Advanced Excel [Internet]. Available from: http: //www. teachucomp. com[Accessed 07/08/2011].