logo

Assignment on Masters in Professional Accounting

   

Added on  2020-04-01

35 Pages2802 Words85 Views
Running head: MASTERS IN PROFESSIONAL ACCOUNTINGMasters in Professional AccountingName of the Student:Name of the University:Course Code:
Assignment on Masters in Professional Accounting_1
MASTERS IN PROFESSIONAL ACCOUNTINGAnswer to Question 1Cell NameHere, in the above diagram it is showing that total net profit is equal to operating profitminus taxes paid by the organization. Net profit = Operating profit – Taxes paidIn the above screenshot, it is shown that Cell D34 is renamed as Net profit.
Assignment on Masters in Professional Accounting_2
MASTERS IN PROFESSIONAL ACCOUNTINGHere also Cell D9 is denoted as Gross margin which is equal to net sales – cost of goodssold.Gross Margin = Net sales- Cost of goods sold
Assignment on Masters in Professional Accounting_3
MASTERS IN PROFESSIONAL ACCOUNTINGAnswer to Question 2Negative ValueIn the above screenshot, it is showing that figures in red color with brackets are denoted asnegative figures. Here in the operating profit figures are in -$1,509 in brackets showing negativeoperating profit or operating loss for the organization.
Assignment on Masters in Professional Accounting_4
MASTERS IN PROFESSIONAL ACCOUNTINGAnswer to Question 3In the spreadsheet, there are two parts – one is the data area and another is report. Theformulae used for the calculation are given in the report section. List of data in an excel sheet isstored successively in the information region though in the estimation done by a person of thegathered information after execution of different formulae that additionally incorporates IFcapacities is done is report territory. Thus, just by changing the information, comparative factorsare figured utilizing the report territory in an exceed expectations sheet. It can be taken as an example, in which the region where the information in regards tocosts and deals are recorded with its esteems is called as information territory. In actuality, forthe computation of net salary by and individual in view of the given information, expansion ofone section ought to be finished with the usage of the recipe to register the net wage easily. Thiscan be effortlessly perceived by the underneath given print screens.Step 1
Assignment on Masters in Professional Accounting_5
MASTERS IN PROFESSIONAL ACCOUNTINGStep 2
Assignment on Masters in Professional Accounting_6
MASTERS IN PROFESSIONAL ACCOUNTINGAnswer to Question 4IF Function
Assignment on Masters in Professional Accounting_7
MASTERS IN PROFESSIONAL ACCOUNTINGAs indicated by the previously mentioned YouTube video in regards to IF work isdemonstrating the genuine capacity and utility of that system. According to the video, the IFwork is demonstrating a particular situation made in the information table regarding whether it isvalid or it is false. This specific site interface is legitimately clarifying the whole capacity withthe assistance of cursor.Answer to question 5Periodic systemsPeriodic inventory system is one of the stock frameworks that update stock toward thefinish of every timeframe. This stock framework helps in monitoring stock on occasionalessential (Drury, 2013). No exertion is really required for keeping refreshed information recordsof either stock or cost of merchandise sold. This stock framework records the diary sectionstoward the finish of bookkeeping period.Example
Assignment on Masters in Professional Accounting_8

End of preview

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

Related Documents
Assignment Accounting Systems and Processes
|32
|2765
|33

Assignment on Accounting Systems & Processes
|38
|2799
|39

Accounting Information System
|34
|2547
|259

Accounting System and Process - Assignment
|18
|1449
|30

University Name and ID Assignment Task Number
|21
|1375
|144

The naming cell reference in MS-Excel
|25
|3510
|82