Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Determine the Working Capital of the company? Show the formula and the calculation method, and explain briefly. Please find attached balance sheets for your reference

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Determine the Working Capital of the company? Show the formula and the calculation method, and explain briefly. Please find attached balance sheets for your reference

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

7th Edition

0273658492, 978-0273658498

More Books

Students also viewed these Finance questions

Question

What are the pros and cons of using credit? (p. 321)

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago