BALANCE SHEETAs on 10 -Oct -2018 Account DetailsA/CCodeDebitCredit ASSETS FIXED ASSETS FIXED ASSETS FIXED ASSET- OFFICE EQUIPMENTS
Question:
BALANCE SHEETAs on 10-Oct-2018Account DetailsA/CCodeDebitCredit 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 ASSETS224,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 FIXTURES 264.51 Sub Total : ACCUMULATED DEPRECIATION52,892.92 Sub Total : FIXED ASSETS171,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.55 TCARD 7,803.35 Sub Total : CASH IN HAND204,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,515,248.53 Bank 3 PORTFOLIO ACCOUNT (AED) 263.88 Bank 3 PORTFOLIO ACCOUNT (USD) 6.50 Sub Total : BANK BALANCES CURRENT A/C5,359,754.54 Sub Total : CASH & BANK BALANCES5,563,932.39 INVENTORY STOCK OF OFFICE SUPPLIES 7,650.56 Sub Total : INVENTORY7,650.56 ADVANCES,INVESTMENTS, DEPOSITS & PREPAIDS ADVANCES ADVANCE TO STAFF Staff 1 5,564.39 Staff 24,953.25 Staff 34,318.73 Sub Total : ADVANCE TO STAFF14,836.37 Sub Total : ADVANCES14,836.37 INVESTMENTS XXX GOVT INT'L BONDS 1,786,985.00 YYY GOVT INT'L BONDS1,504,813.33 XXX SECURITIES 1,863,102.22 Sub Total : INVESTMENTS5,154,900.55 DEPOSITS ELECTRICITY DEPOSIT 6,000.00 CHILLER DEPOSIT 6,000.00 FACILITY MANAGEMENT DEPOSIT 33,000.00 Sub Total : DEPOSITS45,000.00 PREPAID EXPENSES PREPAID LICENSE 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 AND OTHER IT RELATED COSTS 23,959.61 PREPAID PROFESSIONAL&LEGAL FEES 16,188.24 Sub Total : PREPAID EXPENSES306,100.94 INPUT TAX VAT INPUT ACCOUNT (PURCHASE/PAID) 3,745.63 Sub Total : INPUT TAX3,745.63 Sub Total : ADVANCES,INVESTMENTS, DEPOSITS & PREPAIDS5,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 FEES 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 QUOTA EXPENSES 2,905.27 PREPAID TYPING FEE / UPDATE APPROVED QUOTA 59.91 PREPAID SUBMIT MODIFY OR RENEW - ELECTRONIC WORK PERMIT APPLICATION 79.63 PREPAID MODIFY CONTRACT 235.35 PREPAID EMPLOYEE'S FAMILY MEDICAL INSURANCE EXPENSES 20,723.52 Sub Total : PREPAID LABOUR EXPENSES45,255.25 PREPAID IMMIGRATION EXPENSES PREPAID IMMIGRATION TYPING FEES 3,545.25 PREPAID / VISA APPLICATION CHARGES 6,496.18 PREPAID / CHANGE OF STATUS CHARGES 5,243.85 PREPAID EMIRATES ID APPLICATION CHARGES 1,703.29 PREPAID MEDICAL FITNESS TEST APPLICATION CHARGES 2,559.81 PREPAID VISA STAMPING CHARGES 2,590.44 PREPAID UPDATE PERSONAL INFORMATION / PROFESSION CHANGE - EMPLOYMENT 137.86 PREPAID ESTABLISHMENT CARD FEES 3,840.28 Sub Total : PREPAID IMMIGRATION EXPENSES26,116.97 OTHER RESERVES LABOUR GUARANTEE DEPOSITED FOR EMPLOYEES24,000.00 Sub Total : OTHER RESERVES24,000.00 Sub Total : CURRENT ASSETS11,191,538.65 Sub Total : ASSETS11,363,092.36 LIABILITIES CURRENT LIABILITIES CREDITORS SUPPLIERS Supplier 118,270.00 Supplier 22,019.39 Supplier 3318.63 XXXXX INSURANCE COMPANY 861.30 Sub Total : SUPPLIERS21,469.32 CREDIT CARD PAYABLE Bank CREDIT CARD ****913,245.34 Sub Total : CREDIT CARD PAYABLE13,245.34 Sub Total : CREDITORS34,714.66 UNEARNED INCOME OUT OF POCKET EXPENSES REVENUE FEES 6,559.69 Sub Total : UNEARNED INCOME6,559.69 PROVISIONS VAT OUTPUT ACCOUNT (SALES/COLLECTED) 20,426.90 Sub Total : PROVISIONS20,426.90 Sub Total : CURRENT LIABILITIES61,701.25 Sub Total : LIABILITIES61,701.25 CAPITAL & RESERVES PARTNERS' CAPITAL ACCOUNT PARTNER-1 CAPTIAL ACCOUNT 10,000,000.00 Sub Total : PARTNERS' CAPITAL ACCOUNT10,000,000.00 OWNERS CURRENT ACCOUNT PARTNER-1 CURRENT ACCOUNT 2,761,152.23 Sub Total : OWNERS CURRENT ACCOUNT2,761,152.23 Sub Total : CAPITAL & RESERVES12,761,152.23 LOSS:1,459,761.12 Grand Total :12,875,746.4012,875,746.40
Question 1- (2 marks)
Based on the Balance sheet attached, please calculate the owners' equity value.
Show the formula and the calculation method, and explain briefly.
Question 2- (2 marks)
Can you please calculate the Working Capital of the company?
Show the formula and the calculation method, and explain briefly.
Question 3- (2 marks)
What is the Net Income of the company?
Show the formula and the calculation method, and explain briefly.
Question 4- (2 marks)
Can you please calculate the Operating Expenses of the company?
Show the formula and the calculation method, and explain briefy
Question 5- (30 marks, "4 marks for each ratio - formula (1), calculation (2), explanation (1), and 2 marks for classification)
Please calculate the following Ratios, show the formula and explain briefly each ratio based on your understanding. Classify the ratio by type, Solvency, profitability, performance and investment.
1. Current Ratio =?
2. Quick Ratio =?
3. Gross Profit Margin =?
4. Net Profit Margin =?
5. Return on Assets =?
6. Gearing Ratio =?
7. Overheads as Percentage of Turnover =?
Question 6- (2 marks)
Based on all the above results obtained, please give your own interpretation and recommendation for the company