Finance department
Download as PPT, PDF
2 likes1,083 views
The finance department is responsible for managing all money coming into and going out of the business. This includes employee wages, petty cash, paying suppliers, and receiving money from customers. The finance department of XYZ company uses spreadsheets to save transaction and employee attendance information. Spreadsheets play a vital role in the company by allowing calculations like employee wage calculations. The functions of the finance department at RK Bajaj include preparing budgets, controlling expenditures, administering taxes, and raising capital to support company operations and investments.
Finance department
- 1. 油
- 2. 油
- 3. 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.
- 4. INVOICE XYZ Company No17, Rani Towers, Chennai - 600020 e-mail : d10997@baldealer.com Telephone: +91-4562-223381, 224481 Phone : +(91)-9442620881, 9443280881 Invoice Number 000821 To: XYZ SUPPLIES 83 Ashok nagar Chennai- 600002 Tyres 30.00 3000.00 Tubes 150 45.00 5250.00 8250.00 Description Quantity Unit Price Cost 100 TOTAL COST
- 5. 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.
- 6. Introduction to Spreadsheet Spreadsheet is used in the financial department
- 7. A spreadsheet is made up of rows and columns of cells. These cells contain formulae or numbers.
- 8. Active Cell Active Cell Columns Rows Cells
- 9. WHY TO USE A SPREADSHEET Spreadsheets are used for anything in the Finance Department where calculations are made eg:- Calculation of employeeswages
- 10. 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
- 11. 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.
- 12. 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
- 13. Thank you