Report on Use of MS Excel in Corporate World

15 Pages3296 Words110 Views

Added on 2020-06-05

Report on Use of MS Excel in Corporate World

Added on 2020-06-05

BookmarkRelated Documents

DEVELOP AND USECOMPLEX SPREADSHEET

Report on Use of MS Excel in Corporate World_1

Table of ContentsINTRODUCTION...........................................................................................................................2TASK 1............................................................................................................................................2TASK 2............................................................................................................................................6Advanced functions of spreadsheet software applications..........................................................6Impact of formatting and designing on presentation and readability of data...............................7Organizational requirements for ergonomics, work period and breaks and conservations techniques.....................................................................................................................................7WRITTEN/VERBAL QUESTIONS...............................................................................................91. Steps to develop a spreadsheet.................................................................................................92. Requirements to develop a linked spreadsheet........................................................................93. Steps involved in automating and standardizing spreadsheet..................................................94. Basic process to use spreadsheet............................................................................................105. Steps to present numerical data in graphical form.................................................................106. Relative and absolute cell reference.......................................................................................117. Data entry...............................................................................................................................118. Common type of charts and graphs........................................................................................11CONCLUSION..............................................................................................................................11REFERENCES..............................................................................................................................13

Report on Use of MS Excel in Corporate World_2

INTRODUCTIONIn real world, managers need to carry out various calculations to examine relevantinformation and data set for the purpose of rationale decisions. The current report aims atidentifying the practical use of MS Excel in the corporate world. The assignment will criticallyinvestigate the use of different features of MS Excel to assess that how it can be use foranalytical purpose and data visualization. Despite this, ergonomics requirements in workplacesettings that every entity must follow will be discuss. In addition, various ways to save excessiveenergy consumption will be present. TASK 1Spreadsheet development: A spreadsheet has been design to examine the informationpresented in the income statement of ABC Ltd. For such purpose, various formulas had used anda column graph had designed to clearly present summarized details.Formula used in Excel creation:Net sales = Sales – Sales return and allowance = F6 – F7Cost of Goods sold = Opening stock + Purchase + Fright inward – closing inventory = F11 + F14 – F15 Gross profit (Loss) = Net sales – Cost of goods sold= F8 - F16Total Expenses = Sum (F21:F35)Net Operating Income = Gross profit – Total expenses F18 – F36Earnings before tax = Net operating income + Interest received – Interest paid= F38 + F42 – F4 Corporation tax rate = Earnings before tax * 27.5%

Report on Use of MS Excel in Corporate World_3

Net profit = Earnings before tax – Tax= F45 – F46Macro feature used for computing net profit using the same formula applied for the net sales. Income StatementFor the Year Ended 31st March 2017Particulars Amount RevenueGross Sales $ 34,000.00 Less: sales return and allowance $ 2,600.00 Net Sales $ 31,400.00 Cost of Goods SoldBeginning Inventory $ 12,000.00 Add: Purchase $ 8,000.00 Add: Fright inward $ 200.00 $ 20,200.00 Less: Ending inventory $ 2,000.00 Cost of Goods Sold $ 18,200.00 Gross Profit (Loss) $ 13,200.00 Expenses:Advertising $ 900.00 Bank Charges $ 200.00 Commissions $ 150.00 Delivery Expenses $ 50.00 Depreciation $ 1,200.00 Insurance $ 1,000.00 Maintenance $ 180.00 Miscellaneous $ 250.00 Office Expenses $ 550.00 Postage $ 200.00 Rent $ 2,000.00 Repairs $ 800.00 Telephone $ 200.00 Utilities $ 600.00 Wages $ 2,500.00 Total Expenses $ 10,780.00 Net Operating Income $ 2,420.00

Report on Use of MS Excel in Corporate World_4

End of preview

Want to access all the pages? Upload your documents or become a member.

The naming cell reference in MS-Excel

|25

|3510

|82

Accounting: Profit and Loss, Balance Sheet, Golden Rules, Profitability Ratios, Cash Conversion Cycle

|13

|1139

|197

PGBM12 Accounting and Financial Management Assessment January 2019 cohort

|23

|4322

|184

Analysis of Woolworth's Financial Statements: Ratio, Horizontal, and Vertical Analysis

|13

|2591

|53

Calculation of Net Profit Using Naming Cell Reference

|24

|3326

|390

Accounting Systems and Processes

|28

|1766

|161

Report on Use of MS Excel in Corporate World