finance department
DESCRIPTION
The function of the finance department in a company..............TRANSCRIPT
![Page 1: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/1.jpg)
![Page 2: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/2.jpg)
![Page 3: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/3.jpg)
The department responsible for all of the money coming into the business and going out of
the business.
This includes: Employee wages, petty cash, paying suppliers and receiving money from customers.
![Page 4: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/4.jpg)
Description Quantity Unit Price Cost
100
TOTAL COST
INVOICE
XYZ CompanyNo17, Rani Towers,Chennai - 600020
e-mail : [email protected]
Telephone: +91-4562-223381, 224481
Phone : +(91)-9442620881, 9443280881
Invoice Number 000821
To: XYZ SUPPLIES83 Ashok nagarChennai-600002
Tyres 30.00 3000.00 Tubes 150 45.00 5250.00
8250.00
![Page 5: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/5.jpg)
The finance department of the XYZ company
uses the spreadsheet for saving the information about the transactions and about the employees attendence.
Hence the spreadsheet plays a vital role in the company.
![Page 6: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/6.jpg)
Introduction to Spreadsheet
Spreadsheet is used in the
financial department
![Page 7: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/7.jpg)
A spreadsheet is made up of rows and columns of cells. These cells contain formulae or numbers.
![Page 8: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/8.jpg)
Active Cell
Active Cell Columns
Rows Cells
![Page 9: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/9.jpg)
WHY TO USE A SPREADSHEET
Spreadsheets are used for anything in the Finance Department where calculations are made eg:-
Calculation of employees’wages
![Page 10: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/10.jpg)
•A combination of values or cell references and mathematical operators
•Mathematical Operators: + - * /
•Formulas begin with an equal sign
•The actual formula displays in the entry bar
•The results of the formula display in the cell
![Page 11: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/11.jpg)
Examples of formulas:•Add cells B4, C4, D4, and E4: =B4+C4+D4+E4
•Subtract cell F10 from cell F9: =F9-F10
•Multiply cells A3 and A4: =A3*A4
•Divide cell D5 by cell D6 =D5/D6
Always use cell references instead of value in your formulas! That way, when the values change the formulas gets updated.
![Page 12: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/12.jpg)
These are the functions of the finance department in R K BAJAJ
Preparation of budget appropriation of accounts surrender and savings Control of expenditure Administration of Taxes raising capital to support company
operations and investments
![Page 13: Finance department](https://reader035.vdocuments.us/reader035/viewer/2022062307/556258a3d8b42a1b4b8b5436/html5/thumbnails/13.jpg)
Thank you