logo

Comparison of Company A and Company B Financial Position

   

Added on  2019-10-30

22 Pages2540 Words123 Views
 | 
 | 
 | 
1)In Ms-excel there is not necessary to make cell referencing. One can make documentwithout using cell referencing and put formulas with the default cell reference use by theexcel i.e. column name then row name. Formulas by using default cell referencing, looklike A4-F6 or G7*K2 etc. However, one can make cell referencing by own and ensuremore effective presentation of excel document. Formulas after cell referencing look likeliabilities- assets = equity. Such type of formulas ensures better understanding hence cellreferencing used in making excel document.Spreadsheet example
Comparison of Company A and Company B Financial Position_1

2)Negative numbers can be presented in brackets by converting number formatting fromgeneral to custom. Accountants display negative numbers in brackets because itrepresents a better presentation and removes misleading which may inure due to hyphensor a simple sign of dash.Spreadsheet example
Comparison of Company A and Company B Financial Position_2

3)Accountants use spreadsheets for making accounting calculations. Every calculation hassome know facts and some facts which derived from the known facts. Accounts separatedata area from the report area because this helps them in separating the know facts andfacts which derived from the known facts. In addition to this such type of presentationenhance the quality of presentation.Spreadsheet Example
Comparison of Company A and Company B Financial Position_3

4)“IF” is a logical function given by the MS-excel. “IF” gives results as per the satisfactionof function. One more extension is given by MS-excel regarding this function is “IF thenElse” This faction provide results as per satisfaction and non-satisfaction of function.Spreadsheet Example
Comparison of Company A and Company B Financial Position_4

5)Inventory can be recorded by the organization by using any of two inventory systems.Periodic inventory system inventory, Inventory account does not update by theorganization regularly. In place of inventory account Sales and purchases accountsupdated by the organization regularly and at the end of period inventory account updatedand closing stock calculated [ CITATION Ste07 \l 1033 ]. This inventory system cannot apply where real time inventory system is followed [ CITATIONPer13 \l 1033 ]. This system increases the frauds because those can only be deducted at the endof the period. However, this system is economical and needs a lower cost of implementation.For example, if 20 units of goods purchased by the merchandiser then such purchase underperiodic inventory system recorded in the purchase account and not in the inventory account. 6)Hand written solution
Comparison of Company A and Company B Financial Position_5

Make it yourself by coping spreadsheet solutionSpreadsheet Example
Comparison of Company A and Company B Financial Position_6

End of preview

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

Related Documents
Wesfarmers Financial Analysis Report
|20
|1554
|34

Wesfarmers Group Financial Analysis and Recommendations
|20
|1489
|267

(Solved) Accounting System and Process- Assignment
|18
|2992
|39

Wesfarmers Limited Investment Analysis
|32
|2765
|33

Wesfarmers Financial Analysis Report
|18
|1449
|30

Wesfarmers Financial Analysis Report
|20
|1507
|35