Determine the Working Capital of the company? Show the formula and the calculation method, and explain briefly. please find attached balance sheet for your reference
BALANCE SHEET As on 10-Oct-2018 Account Details A/CCo Debit Credit ASSETS FIXED ASSETS FIXED ASSETS FIXED ASSET- OFFICE EQUIPMENTS 4 183,00 FIXED ASSET - FURNITURE & FIXTURES 247,00 FIXED ASSET - COMPUTER HARDWARE 165 353,57 FIXED ASSET - COMPUTER SOFTWARE 51 541,40 FIXED ASSET - ELECTRONIC HARDWARE 1 446,76 FIXED ASSET - ELECTRICAL HARDWARE AND FIXTURES 1 674,90 Sub Total : FIXED ASSETS 224 446,63 ACCUMULATED DEPRECIATION ACCUMULATED DEPRECIATION - OFFICE EQUIPMENTS 304,17 ACCUMULATED DEPRECIATION - FURNITURE & FIXTURES 272,89 ACCUMULATED DEPRECIATION - COMPUTER HARDWARE 36 003,26 ACCUMULATED DEPRECIATION - COMPUTER SOFTWARE 13 380,58 ACCUMULATED DEPRECIATION - ELECTRONIC HARDWARE 2 667,51 ACCUMULATED DEPRECIATION - ELECTRICAL HARDWARE AND FC 264,51 Sub Total : ACCUMULATED DEPRECIATION 52 892,92 Sub Total : FIXED ASSETS 171 553,71 CURRENT ASSETS CASH & BANK BALANCES CASH IN HAND CASH IN HAND A/C 192 605,70 NOQODI A/C 1 999,25 E-DIRHAM A/C 1 769,59 CARD 7 803,35 Sub Total : CASH IN HAND 204 177 85 BANK BALANCES CURRENT A/C Bank 1 (AED) 3 690 347,61 Bank 1 (USD) 153 785, 94 Bank 1 (EURO 102,08 Bank 2(AED 1 51 5 248,53 Bank 3 PORT FOLIO ACCOUNT (AED 263,88 Bank 3 PORTFOLIO ACCOUNT (USD) 6,50 Sub Total : BANK BALANCES CURRENT A/C 5 359 754,54 Sub Total : CASH & BANK BALANCES INVENTORY STOCK OF OFFICE SUPPLIES 7 650,56 Sub Total : INVENTORY ADVANCES, INVESTMENTS, DEPOSITS & PREPAIDS ADVANCES ADVANCE TO STAFFBALANCE SHEET As on 10-Oct-2018 Account Details A/CCo Debit Credit Staff 5 56 Staff 2 4 953,25 Staff 3 4 318,73 Sub Total : ADVANCE TO STAFF 14 836,37 Sub Total : ADVANCES 14 836,37 INVESTMENTS XXX GOVT INT'L BONDS 1 786 985,00 YYY GOVT INT'L BONDS 1 504 813,33 XXX SECURITIES 1 863 102,22 Sub Total : INVESTMENTS $ 154 900,55 DEPOSITS ELECTRICITY DEPOSIT 6 000,00 CHILLER DEPOSIT 6 000,00 FACILITY MANAGEMENT DEPOSIT 33 000,00 Sub Total : DEPOSITS 15 000,00 PREPAID EXPENSES 19 870,52 PREPAID RENT 192 500,00 PREPAID PO BOX 249,25 PREPAID SPONSORSHIP 53 333,32 PREPAID MAINTENANCE CHARGE FOR THE SOFTWARE/SERVER . 23 959,61 PREPAID PROFESSIONAL&LEGAL FEES 88,24 Sub Total : PREPAID EXPENSES 306 100,94 INPUT TAX VAT INPUT ACCOUNT (PURCHASE/PAID) 3745,63 Sub Total : INPUT TAX 3 745,63 Sub Total : ADVANCES,INVESTMENTS, DEPOSITS & PREPAID 5 524 583,49 PREPAID LABOUR EXPENSES PREPAID TYPING JOB OFFER FEE 941,63 PREPAID TYPING ELECTRONIC PREAPPROVAL FOR WPA FEE 639,63 PREPAID PRE APPROVAL FOR WORK PERMIT PAYMENT FEES 8 288,92 PREPAID PRE APPROVAL FOR WORK PERMIT PAYMENT TYPING FE 469,45 PREPAID NEW ELECTRONIC WORK PERMIT FEE 539,72 PREPAID SUBMIT NEW ELECTRONIC WPME-WPA 540,28 PREPAID EMPLOYEE MEDICAL INSURANCE EXPENSES 9 831,95 PREPAID APPLYING NEW QUOT A EXPENSES 2 905,27 PREPAID TYPING FEE / UPDATE APPROVED QUOTA 59,91 PREPAID SUBMIT MODIFY OR RENEW - ELECTRONIC WORK PERMI 79,63 PREPAID MODIFY CONTRACT 235,35 PREPAID EMPLOYEE'S FAMILY MEDICAL INSURANCE EXPENSES 20 7 23, 52 Sub Total : PREPAID LABOUR EXPENSES 45 255,25 PREPAID IMMIGRATION EXPENSES PREPAID IMMIGRATION TYPING FEES 3 545,24 PREPAID / VISA APPLICATION CHARGES 6 496,18 PREPAID / CHANGE OF STATUS CHARGES 5 243, PREPAID EMIRATES ID APPLICATION CHARGES 1 703,29BALANCE SHEET As on 10-Oct-2018 Account Details A/CCo Debit Credit PREPAID MEDICAL FITNESS TEST APPLICATION CHARGES 2 559,81 PREPAID VISA STAMPING CHARGES 2 59 PREPAID UPDATE PERSONAL INFORMATION / PROFESSION CHAN 137,86 PREPAID EST ABLISHMENT CARD FEES 3 840,28 Sub Total : PREPAID IMMIGRATION EXPENSES 26 116,97 OTHER RESERVES LABOUR GUARANTEE DEPOSITED FOR EMPLOYEES 24 000,00 Sub Total : OTHER RESERVES 24 000,00 Sub Total : CURRENT ASSETS 11 191 538,65 Sub Total : ASSETS 11 363 092,36 LIABILITIES CURRENT LIABILITIES CREDITORS SUPPLIERS Supplier 1 18 270,00 Supplier 2 2019,3 Supplier 3 318,63 XXXXX INSURANCE COMPANY 861,30 Sub Total : SUPPLIERS 21 469,32 CREDIT CARD PAYABLE Bank CREDIT CARD ****9 13 245,34 Sub Total : CREDIT CARD PAYABLE 13 245,34 Sub Total : CREDITORS 34 714,66 UNEARNED INCOME OUT OF POCKET EXPENSES REVENUE FEES 6 559,69 Sub Total : UNEARNED INCOME 6 559,69 PROVISIONS VAT OUTPUT ACCOUNT (SALES/COLLECTED) 20 426,90 Sub Total : PROVISIONS 20 426,90 Sub Total : CURRENT LIABILITIES 61 701,29 Sub Total : LIABILITIES 61 701,25 CAPITAL & RESERVES PARTNERS' CAPITAL ACCOUNT PARTNER-1 CAPTIAL ACCOUNT 0 000 000,00 Sub Total : PARTNERS' CAPITAL ACCOUNT 10 000 000,00 OWNERS CURRENT ACCOUNT PARTNER-1 CURRENT ACCOUNT 2761 152,23 Sub Total : OWNERS CURRENT ACCOUNT 2 761 152,23 Sub Total : CAPITAL & RESERVES 12 761 152,23 LOSS: 1 459 761,12 Grand Total : 12 875 746,40 12 875 746,40PROFIT & LOSS As on 10-Oct-2018 Account Details A/CCo Debit Credit INCOME GROSS PROFIT SALES SALES REVENUE / 1351 795,24 REVENUE / OUT OF POCKET EXPENSES 18 928,44 Sub Total : SALES 1 370 723,68 Sub Total : GROSS PROFIT 1 370 723,68 OTHER INCOME PURCHASE DISCOUNT 179,60 OTHER INCOME DEDUCTION FROM STAFF 465,73 Sub Total : OTHER INCOME 645,33 CAPITAL INCOME PROFIT FROM INTEREST EARNED 2 184,36 PROFIT FROM COUPON 53 785,94 Sub Total : CAPITAL INCOME 155 970,30 Sub Total : INCOME 1 527 339,31 EXPENSES SELLING EXPENSES ADVERTISEMENT AND PUBLICITY 18 988,5 EXHIBITION, SEMINAR & CONFERENCES 8 700, 19 DISCOUNT ON SALES 216 950,00 Sub Total : SELLING EXPENSES 244 638,70 DEPRECIATION EXPENSES DEPRECIATION EXPENSES - OFFICE EQUIPMENTS 304, 17 DEPRECIATION EXPENSES - FURNITURE & FIXTURES 272,89 DEPRECIATION EXPENSES - COMPUTER SOFTWARE 3 380,58 DEPRECIATION EXPENSES - COMPUTER HARDWARE 36 003,26 DEPRECIATION EXPENSES - ELECTRONIC HARDWARE 2 667,51 DEPRECIATION EXPENSES - ELECTRICAL HARDWARE AND FIXTURES 264,51 Sub Total : DEPRECIATION EXPENSES 52 892,92 ADMINISTRATIVE EXPENSES SALARIES BASIC (60%) 050 537,42 SALARIES ACCOMMODATION (40%) 584 144,09 SALARIES TRANSPORT ATION 80 915,60 SALARIES OTHER ALLOWANCES 64 503,23 RENT EXPENSES 472 078,50 SPONSORSHIP FEES 26 886,68 TRAVELLING & CONVEYANCE 46 130,30 6 687,53 CHILLER 17 894,9% TELEPHONE 41 518,52PROFIT & LOSS As on 10-Oct-2018 Account Details A/CCo Debit Credit POSTAL CHARGES 979,25 LICENSE FEES 36 528,49 INSURANCE CHARGES 117,92 MISCELLANEOUS EXPENSES 16 639,33 OFFICE EXPENSES - OTHER 1 380,82 REFRESHMENT/ENTERTAINMENT EXPENSES 398,08 REPAIRS & MAINTENANCE 4 640,00 VEHICLE PARKING CHARGES 60,00 FINE & PENALTIES 1 128,00 OFFICE CONSUMABLES 7 565,13 COMPUTER CONSUMABLES 3 033,89 TRANSPORTATION CHARGES 13 507,75 DELIVERY CHARGES 289,81 UNIFORM EXPENSE 8 000,00 ROUNDING OFF DIFFERENCE KITCHEN SUPPLIES 5 710,98 IT IMPLEMENTATION CHARGES AND OTHER RELATED COSTS 31 250,00 PO BOX EXPENSE 1 145,75 SERVICE CHARGE 151,00 LEGAL FEES 76 194,0 WEB DESIGN AND DEVELOPMENT 12 800,00 MANAGEMENT EXPENSE 835,22 MAINTENANCE CHARGE FOR THE SOFTWARE/SERVER AND OTHER n1 1 780,86 COMMISSION EXPENSE 63,53 WRITE-OFF 103,00 Sub Total : ADMINISTRATIVE EXPENSES 2 615 603,37 FINANCING EXPENSES BANK CHARGES 6 576, 12 CUSTO ODIAL FEES 1 549,94 CREDIT CARD CHARGES 748,00 Sub Total : FINANCING EXPENSES 8 874,06 LABOUR EXPENSES TYPING JOB OFFER FEE 678,82 TYPING ELECTRONIC PREAPPROVAL FOR WPA FEE 443,38 PRE APPROVAL FOR WORK PERMIT PAYMENT TYPING FEES 354,55 PRE APPROVAL FOR WORK PERMIT PAYMENT FEES 7 211,08 NEW ELECTRONIC WORK PERMIT FEE 387,28 SUBMIT NEW ELECTRONIC WPME-WPA 386,72 EMPLOYEE MEDICAL INSURANCE EXPENSES 35 812,89 E-DIRHAM COMMISSION EXPENSES 281,36 APPLYING NEW QUOTA EXPENSES 1 713,74 TYPING FEE / UPDATE APPROVED QUOTA 43,09 TYPING CANCELLATION OF JOB OFFER 233,55 ELECTRONIC WORK PERMIT CANCELLATION 100,00PROFIT & LOSS As on 10-Oct-2018 Account Details A/CCo Debit Credit LABOUR CARD CANCELLATION 100,00 SUBMIT MODIFY OR RENEW - ELECTRONIC WORK PERMIT APPLICAT 23,37 MODIFY ELECTRONIC WORK PERMIT APPLICATION 67.65 Sub Total : LABOUR EXPENSES 47 837,47 IMMIGRATION EXPENSES IMMIGRATION TYPING FEES 2 297,67 VISION / VISA APPLICATION CHARGES 4 175,32 NOQODI TRANSACTION CHARGES 186,40 SMS / NOQODI CHARGES 15,50 VISION / CHANGE OF STATUS CHARGES 3 953,65 NOQODI CASH DEPOSIT CHARGES/CREDIT CARD CHARGES ON NC 745,00 EMIRATES ID APPLICATION CHARGES 936,71 MEDICAL FITNESS TEST APPLICATION CHARGES 1 320, 19 VISA STAMPING CHARGES 1 799,56 VISA CANCELLATION 100,00 UPDATE PERSONAL INFORMATION /PROFESSION CHANGE - EMPLO 112, 14 ESTABLISHMENT CARD FEES 109,72 ESTABLISHMENT CARD FEES-TYPING 2,08 Sub Total : IMMIGRATION EXPENSES 15 753,94 HUMAN CAPITAL EXPENSES ANNUAL STAFF TRAVEL BENEFIT 1 500,00 Sub Total : HUMAN CAPITAL EXPENSES 1 500,00 Sub Total : EXPENSES 2 987 100,45 LOSS: 1 459 761,14 Grand Total : 2 987 100,45 2 987 100,45
