Report on Application of Advanced Functions of Excel

ACC SYSTEMS AND PROCESSES

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
Q1 Naming cells and spreadsheets..............................................................................................1
Q2 Negative numbers..................................................................................................................2
Q3 Separation of data entry and report areas...............................................................................2
Q4 IF Statement...........................................................................................................................4
Q5 Periodic systems....................................................................................................................4
Q6 Worksheet and financial reports............................................................................................6
Q7 LIFO AND FIFO.......................................................................................................................8
Q8 BRS..........................................................................................................................................10
Q 9.................................................................................................................................................10
Q10 Methods of estimating bad debts.......................................................................................11
Q11 Evaluaitng firm financial position.....................................................................................12
Q 12...............................................................................................................................................12
Q13................................................................................................................................................13
Business which are part of Wesfarmers.....................................................................................13
Summary to Vikram on investment decisions...........................................................................14
CONCLUSION..............................................................................................................................14
REFERENCES..............................................................................................................................15

INTRODUCTION
Accounting is one of field which is growing at fast rate across the globe. In the current
report advanced functions of excel are applied on data set and on that basis it is identified
whether trial balance is accurate or not. Apart from this, analysis of Wesfarmers is done in the
report and on that basis investment recommendation is given in the report.
Q1 Naming cells and spreadsheets
Naming cells and spreadsheets is the one of the most important and valuable feature in
excel. Usually, when any formula is inserted in to excel sheet names such as C3, C10 and D40
like are observed in formula (Ball, 2013). Those who developed a model in excel very well
familiar with variables but those who first time view that model can not understand it in single
view. In order to sort out this problem ceels are named so that anyone can easily understand
model.
It can be seen from above image that instead of cell names liability and owners equity are in the
formula. This is the example of naming cells and spreadsheet.
1 | P a g e

Q2 Negative numbers
Negative numbers can be displayed in brackets or parenthesis in excel. In excel version
2013 simply one can go to data format dialog box in home tab and can select brackets in
accounting option. By doing so negative numbers can be shown in brackets in excel. Brackets
are usually used in excel to reflect negative numbers because in report when any data is printed it
is not possible to pay clear attention on all negative values. Thus, in order to solve this problem
bracket is shown in excel.
Q3 Separation of data entry and report areas
In modelling that is done in excel simply data entry and report areas are prepared
separately. This is because in data entry part all modeling inputs are mentioned and if required
interrelationship is establsihed among them (Banerjee, 2010). Inputs that are in the data entry
areas are used in modeling process and same are considered for computing values in report area.
It can be said that there is significence of separation of data entry and report area because both
give different sort of information to the users of finanaicial model.
Input sheet
inventory cost % 10%
Sales revenue
10000
0
inventory cost 10000
expenses % 60%
Profit 50000
Output area
change in % of inventory cost
change
in % of
expense
s 50000.00 50% 60% 70% 80%
10% 60000 50000 40000 30000
20% 70000 60000 50000 40000
30% 80000 70000 60000 50000
40% 90000 80000 70000 60000
2 | P a g e