Engineering Consultant Nove
Resume:
CV of Arif Ahmed Mob: +971**-*******, +971**-******* ****.*********@*****.*** 1 Page
ARIF AHMED
Dubai, UAE, ****.*********@*****.***
Visa Status: Visit Visa, Availability: Immediate
LinkedIn https://www.linkedin.com/in/arif-ahmed-a0585426/ MANAGEMENT PROFESSIONAL – FINANCE / COMMERCIAL / HR ADMIN / OPERATIONS PROFESSIONAL PROFILE
Ø Capable of handling multiple responsibilities and working in dynamic environments with more than 21 years of UAE experience
Ø Working closely with the Chairman & CEO on the strategic direction of the business. Ø Commercial, business awareness and Problem-solving skills and initiative. Ø Organizing all statutory returns to UAE VAT returns filling and payments Ø Preparation and analysis of dashboard reports (KPI) Ø Manage accounts worth QAR 160 million in annual sales & Effective Treasury Management Ø Worked in Wholesale - Retails, Construction, Manufacturing, Training & Educational companies Ø High level of interpersonal skills to work effectively with local government authorities Ø Well versed UAE Labor Laws and I am conversant in Arabic SKILLS
Financial Management Personal
Cash Flow control Dash Board Report Attention to detail Management accounts Supervisory skills Communication skills Budget preparation Business Analysis Good IT knowledge Financial forecasting Decision making Data processing skills Costing Key Performance Indicator (KPI) Problem solving Banking & Credit Facilitation Effective delegation Analytical mind Inventory Management
Payroll Management
Conflict Management
HR Database
Negotiating
Interpersonal Skills
ACADEMICAL QUALIFICATION
Master of Business Administration (MBA Finance) (IMRS) Indian Management School & Research Bachelor’s Degree in Arts (BA Economics) CSJM Kanpur University in India Diploma in Human Resources Management, Strategic Planning, Academic Collage of London, UAE Diploma in Certified Finance & Accounting – (DCFA), from Netscape Educations, India Certified Management of Accounting (CMA USA) – IMA Pursuing COMPUTER SKILLS
Fully proficient with Windows and MS Office Tools, MS Word / Excel / Access / PowerPoint Expertise in various ERP’s, Tally, QuickBooks, SAP, Peachtree, Oracle, Bright I developed HR Employee DATABASE & Payroll Reports in MS Access Microsoft Dynamic 365 ERP & CRM Business Central & Microsoft BI Power Data Analytic ACHIEVEMENTS AWARDS
v Certificate Awarded “BEST EMPLOYEE OF THE YEAR 2010 by Inter Taym FZCO v Received Award Certificate of Excellence from Lahmeyer International GmbH PROFESSIONAL EXPERIENCE
AL SHAHEEN EST February 2018 - March 2021, Doha, Qatar Finance Manager, Reporting to: Chairman, Business Activity: Wholesale & Retails,
§ Managing accounts worth QAR 160 million in annual turnover
§ Responsible for timely reporting of monthly financial analysis and management reports.
§ Prepare full accounting reports, summaries & reconciliation with relevant reports submit before the deadline.
§ Investigate, resolve accounting discrepancies and irregularities
§ Review monthly accounts, variance analysis and highlight key weaknesses & recommend for improvement
§ Provide monthly expense and cost analysis for management review.
§ Prepare, monitor and control the budget analysis and forecasting as well as comparison to ensure a realistic budget
§ Handle monthly payroll and office administrative tasks.
§ Processing of payments to vendors and petty cash payments perform timely
§ Ensuring an accurate monthly, quarterly and year end closure of the books of account, preparation of financial
§ Designing appropriate internal controls, policies and procedures which suits the company
§ Managing & Supervising, directing, and reviewing the day to day operations of the finance department (including, Cash Management, Bank Reconciliations, Accounts Receivable, Accounts Payable, Fixed Asset Register(FAR), Payroll, Credit Facility Management, review of various Advances, recording of Revenue, Expenses, Costing and Inventories
§ Responsible for attending monthly financial review meetings with Group Chairman and Executive management to present the financials.
§ Preparation of the yearly budget/forecast both Operational and Capital budget CV of Arif Ahmed Mob: +971**-*******, +971**-******* ****.*********@*****.*** 2 Page
§ Liaison with Banks for Loans and Treasury related work of Letter of Credits (LC) & (LG)
§ Coordinates with various auditors, both internal and external
§ Follow up with clients to manage debt settlements
§ Monitoring and reviewing budgets, sales forecasts on a monthly basis and reporting to the management on variances and recommendations
§ Process and review Tax matters are tracked and submitted on time.
§ Provide support for financial matters in subsidiary companies and branches.
§ Substantiates business transactions with relevant supporting documents and maintain proper filing system and records to document transactions
§ Maintain financial policies and procedures for the company
§ Provide advice and information to the Chairman on the latest change in companies' law and regulation and practices
§ Develop and maintain thorough financial procedures for the organization and all finance records kept and secure in legislative requirements
§ Analyzing market trends and competitors
MANIPAL ACADEMY OF HIGHER EDUCATION January 2015 - February 2017, Dubai UAE Head of Administration - Accounting Reporting to: Academic President, Business Activity: Training & Education.
§ Keeping a Track of the Company’s assets handed over to Employees (Car, Laptop, etc.)
§ Facilitating Health insurance for all employees and students
§ Work with the MOH, DHA and Civil Defense to obtain Restricted Chemical Licenses permits
§ Liaise with KHDA to obtain Operational NOC, Permit Renewals, Course Addition, Certificate Attestation
§ Online portal access and processes in GDRFA, MOL, DPS, TRA, DM, DUBAI TRADE, EID, DOHMS, TECOM
§ Liaise with TECOM and RERA commercial & property team to be obtained lease agreement Finance & Accounting
§ Analyzed and reconciled bank accounts and all general ledger accounts.
§ Reconciled all balance sheet accounts and calculated all Journal Entry for month-end close.
§ Reconcile vendor statements, research and correct discrepancies.
§ Tracked all expense reports and verified amounts are reasonable.
§ Processed payroll for staff of 120 employees.
§ Prepared and reviewed financial statement for the Controller.
§ Oversaw accounts payable/account receivable in relation to invoicing and aging. GEO LOGIC GIS SOLUTIONS LLC December 2011 - December 2014, Dubai, UAE Finance Admin Manager, Reporting to: General Manager + CEO, Business Activity: IT & Retails, Finance & Accounting
§ Providing a true and fair picture of the company's financial position and reports (Balance Sheet, Profit & Loss and Cashflow)
§ Analyzing of Cash flow, Inventory, and Receivables analyses with details of sales, overdue debts, collection forecasts, and update on bad debtors
§ Oversee execution of bank reconciliation, loan term reconciliation, and bank interest
§ Generating monthly close of financial statements, cash flow, working capital management, cost control
§ Supervising General Ledger, Financial Reporting process, Receipt, Petty Cash, Bank A/c
§ Review all the invoices appropriate documentation and approval before the payment
§ Credit recovery based on an ageing report, negotiating with client’s unrecoverable credit.
§ Managing sales & purchases invoices & the upkeep of an accurate accounts filing system
§ Processing & finalizing all the company online payments & transfers
§ Resolving contractual and commercial issues and disputes & Conducting meetings with commercial contractors HR – Administration
§ Monitoring daily attendance and Investigate and understand causes for staff absences
§ Setting up, monitoring and tracking employee probationary periods.
§ Issuance of NOC, salary certificates, employment certificates, Appointment & Termination, Warning Letters
§ Preparing Annual leave calculator & Scheduling & Shuffling Annual leave of Employees.
§ Maintaining and recording the data of the new joiners into the system
§ Provide orientation to new employees about the function of HR and Admin Department
§ Conducting joining formalities for the new entrants
§ Processing payroll on monthly basis by considering date of joining, leave taken, salary advance and deductions
§ Preparation of payroll as per Wages Protection System. INTER TAYM FZCO April 2008 - November 2011, Jebel Ali Free Zone, Dubai Finance Operations Manager, Reporting to: Group President, Business Activity: Steel Manufacture,
§ Analyze revenue and expenses to ensure they are recorded appropriately on a monthly
§ Producing financial reports related to budgets, account payables & receivables, expenses
§ Primary responsibility is to prepare financial statements (Profit Loss, Balance Sheet)
§ Monthly depreciation management of fixed assets and posting
§ Analyze costs, pricing, variable contributions, sales results and the company’s actual performance compared to the business plans
§ Preparing monthly business review meeting slides for top management budgeting
§ Supervising General Ledger, Cash Receipt, Bank account and Petty cash
§ Responsible for budgeting, Account Payable, Account Receivable, Fixed Asset, Costing and Inventories
§ Monitoring and reporting on Production and Operation activities.
§ Managing the procurement and logistics activities & team that includes drivers and warehouse operatives. CV of Arif Ahmed Mob: +971**-*******, +971**-******* ****.*********@*****.*** 3 Page
§ Follow-up with Shipping Line to collect Freight Invoice & DO for Import Consignment.
§ Vehicle fleet management and Monitoring & Handling vehicle GPS tracking system
§ Responsible for managing the loading of vehicles, finished stocks and load bay areas.
§ Planning and scheduling the delivery of goods
§ Receiving Quotations, Raising LPO and Placing Order.
§ Coordinate with Rental Company for leasing and variations of invoices
§ Conducting account meetings with commercial contacts
§ Analysis of current manpower requirements across a number of departments
§ Identifying training needs of the organization and undertake various training like Induction training, EHS, Fire Marshall, Fork Lift, Overhead Cranes, DPS Training & Occupational
§ Work with an insurance company to process and renew all of the group's insurance policies, including workmen's compensation, property, plant & equipment
§ Onboarding process of the newcomers to the company
§ Employee counselling and conflict management.
§ Finalizing job offers & appointment letters for selected candidates
§ Involved in final appraisal/rating after receiving the feedback NUROL LLC CONSTRUCTION February 2003 - March 2008, Dubai, Abu Dhabi UAE Sr. Accountant Reporting to: HR Finance Manager, Business Activity: Construction, 6800 employees
§ Interim Payment Certificate (Construction) preparation and submission
§ Monitor the day-to-day financial operations within the company, such as payroll, invoicing, and other transactions
§ Prepared and conducted reviews of variance, cash flow, and KPI reports
§ Review financial data and prepare monthly and annual reports
§ Prepare journal entries, reconciliations, and trend analyses during month end
§ Manage revenue, accounts payable, accounts receivable and expense accrual accounts
§ Responsible for cash salary distributions
§ Maintains confidence by keeping financial information confidential.
§ Analyze financial information in response to queries from Management, suppliers, Payroll HR Administrator
§ Screening & shortlisting resumes from job portals, posting advertisements in the headhunting
§ Participate in recruitment activities including preliminary interviews & preparing reports
§ Conducting the joining formalities for the new employee.
§ Payroll administration process for salary calculation, overtime, deduction, commission, leave pay, gratuity
§ Finalization & Processing Payroll and file upload to the bank
§ Collecting information of attendance and overtime from all departments and Resolving payroll discrepancies
§ Calculating annual leave, HRA Advances, bonus, medical reimbursement, telephone bills and other deductions for all employees in the company.
§ Establish reconciliation report (adding new employees, recording resignations, terminating employees, transferring employees, figuring long leaves, and determining return to duty)
§ Resolve employee’s personal and official issues by ensuring that their problems are resolved on time -such as loans, salary advances and camp issues etc.
LAHMEYER INTERNATIONAL GmbH February 1999 - January 2003, Abu Dhabi, UAE Accountant \ Admin Assistant, Reporting to: Project Manager, Business Activity: Engineering Consultant,
§ Post and process journal entries to ensure all business transactions are recorded
§ Update accounts payable and perform reconciliations
§ Assist in the processing of balance sheets, income statements
§ Assist with reviewing of expenses, payroll records etc.
§ Prepare and submit weekly/monthly reports
§ Assist senior accountants in the preparation of monthly/yearly closings
§ Daily cash management & Petty Cash
§ Oversee front office administration
§ Preparation and submission of tender documents, specifications, and prequalification’s
§ Maintaining minutes of meetings and assist with schedule management TRAINING
v Conducted CPR & Basic First Aid (Adult Mode) American Safety & Health Institute. v Training on the Security System Process was conducted from DXB Protective System (Dubai Pollice) PERSONAL SUMMARY
Profile Indian, Male, 43 Age, Married, Islam
Driving License UAE / QATAR LMV Driving License
LANGUAGE
English Arabic Hindi Malayalam (Speak/Read/Write)
Jan 1, 2020 - Feb 28, 2021
Prepared by Arif Ahmed
Balance Sheet Report
Fixed Asset
16.4M
71.4% from previous year
Branch
Current Liabilities
5.9M
72.2% from previous year
Long Term Liabilities
2.7M
25.7% from previous year
Current Asset
10.4M
66.1% from previous year
Equity
4.2M
71.3% from previous year
Inventory
5.5M
70.8% from previous year
Total Asset Total Asset (previous year)
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 2021
1.7M
1.8M
1.9M
2M
2.1M
Total Liability Total Liability (previous…
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 2021
400K
600K
800K
1M
Total Assets Total Liabilities
Equity Equity (previous year)
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 2021
200K
250K
300K
350K
400K
Equity
Networking Capital Networking Capit…
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 2021
200K
300K
400K
500K
Net Working Capital
November
December
May
September
October
April
March
August
July
others
6.1%
6.4%
6.8%
7.1%
7.2%
7.2%
8.1%
34.6%
8.4%
8.2%
Jan 1, 2020 - Feb 28, 2021
Prepared by Arif Ahmed
Cash Flow Report
Operating Cash Flow
1.6M
-25.4% from previous year
Branch
Investing Cash Flow
-132.2K
51.9% from previous year
Financing Cash Flow
289.0K
448.2% from previous year
Net Cash Flow
1.8M
-2.1% from previous year
Net Cash Flow Net Cash Flow (previous year)
January
February
March
April
May
June
July
August
September
October
November
December
200K
400K
600K
360K
434K 413K
235K
82K
1K
-69K
127K
-70K
76K
174K
15K
353K 371K
0 0 0 0
171K
95K 112K 100K
353K
260K
Abu Dhabi Dubai
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 20…
-200K
0
200K
400K
600K
224K 207K 232.5K
31.5K 30.5K 8.8K -22K
110K 95K 65K 81K
-73K -65K -34K
129K 164K
180K
203K
51K
-7.5K
-47K
17K
-165K
11K
93K
88K 72K
97K
Net Cash Flow by Month Net Cash Flow by Branch
Abu Dhabi Dubai
January
Februa…
March
April
May
June
July
August
Septe…
October
Nove…
Decem…
50K
100K
150K
200K
180K173K
110K105K
90K
70K 65K
50K 45K 35K
17K 9K
Operating Cash Flow by Branch
Dubai Abu Dhabi
January
Februa…
March
April
May
June
July
August
Septe…
October
Nove…
Decem…
50K
100K
150K
200K
104K
183K
120K125K
-30K -95K -135K-140K-155K
15K
80K 90K
Financing Cash Flow by Branch
Dubai Abu Dhabi
January
Februa…
March
April
May
June
July
August
Septe…
October
Nove…
Decem…
20K
40K
60K
80K
80K
32K
5K 3K 1K 500 -49K
8K
-35K -19K
8K
18K
Investing Cash Flow by Branch
Overview Pro t & Loss Revenue Analysis Expense Analysis Jan 1, 2020 - Jun 30, 2020 Prepared by Arif Ahmed
Pro t & Loss Analysis
Financial Report of Arif Ahmed Co Pro t & Loss Analysis Revenue
Amount
1.8M
118.9% from previous 182 days
Amount
1.8M
84.8% from previous year
CGS
Amount
1.3M
111.0% from previous 182 days
Amount
1.3M
92.0% from previous year
Operating Expense
Amount
283.1K
76.6% from previous 182 days
Amount
283.1K
77.0% from previous year
Gross Pro t
Amount
542.9K
139.9% from previous 182 days
Amount
542.9K
70.1% from previous year
Net Pro t
Amount
259.9K
293.8% from previous 182 days
Amount
259.9K
63.2% from previous year
Selling Expense
Amount
123.7K
127.6% from previous 182 days
Amount
123.7K
73.8% from previous year
Financial Expense
Amount
588.0
74.4% from previous 182 days
Amount
588.0
217.9% from previous year
Total Expense
Amount
1.6M
103.8% from previous 182 days
Amount
1.6M
89.1% from previous year
Table Reporting Amount % Δ
1. Revenue 1.8M 118.9%
2. Total Expenses 1.6M 103.8%
3. CGS 1.3M 111.0%
4. Gross Pro t 542.9K 139.9%
5. Net Pro t 259.9K 293.8%
0 500K 1M 1.5M
Overview Pro t & Loss Revenue Analysis Expense Analysis Jan 1, 2020 - Jun 30, 2020 Prepared by Arif Ahmed
Pro t & Loss Analysis
Financial Report of Arif Ahmed Co Pro t & Loss Analysis Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
250K
500K
750K
1M
Revenue
Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
200K
400K
600K
800K
Expenses
Revenue Total Expenses
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 20… 0
250K
500K
750K
1M
Revenue vs Expenses
Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 20…
-100K
0
100K
200K
Net Pro t
Revenue
Total Expenses
CGS
Gross Pro t
Net Pro t
33.3%
10%
23.3%
28.6%
Overview Pro t & Loss Revenue Analysis Expense Analysis Jan 1, 2020 - Jun 30, 2020 Prepared by Arif Ahmed
Pro t & Loss Analysis
Financial Report of Arif Ahmed Co Pro t & Loss Analysis Revenue Revenue (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
250K
500K
750K
1M
Revenue Revenue (previous year)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
200K
400K
600K
800K
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
8.3%
6%
25.8%
8.1%
46.8%
Revenue
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 20… 0
250K
500K
750K
1M
149.8K 109.3K
468.2K
147.4K
89.4K
847.5K
Revenue
Jun 2020 May 2020 Apr 2020 Mar 2020 Feb 2020 Jan 2020 847,470.82 89,386.98 147,422.64 468,161.26 109,332 149,775.46 Monthly Revenue / Amount
Account Code
1,811,549.16
847,470.82 89,386.98 147,422.64 468,161.26 109,332 149,775.46 Grand total
Grand total 1,811,549.16
Revenue Analysis
Overview Pro t & Loss Revenue Analysis Expense Analysis Jan 1, 2020 - Jun 30, 2020 Prepared by Arif Ahmed
Pro t & Loss Analysis
Financial Report of Arif Ahmed Co Pro t & Loss Analysis Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
200K
400K
600K
Cost of Goods Sold
Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
25K
50K
75K
100K
Operating Expense
Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
20K
40K
60K
Selling Expense
Amount Amount (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 0
100
200
300
Financial Expense
Purchases Carriage/Freight Custom Charges
0 100K 200K 300K 400K 500K 600K
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
553.7K
47.8K
103.3K
333.8K
61.3K
125.2K
21.1K
2K
4.2K
4K
1.3K
1.4K
7K
1.4K
150
0
984
Direct Expenses
Salaries Govt. Fee Other EOSB Professional Fee
0 5K 10K 15K 20K 25K 30K 35K
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
15.8K
15.8K
15.8K
15.8K
7.6K
7.6K
11.8K
1.7K
1.7K
3K
8K
1.3K
2.6K
1.1K
684
2.9K
1.6K
1.9K
568.8
568.8
568.8
568.8
316.7
316.7
0
0
0
0
0
0
Indirect Expenses
CGS
Operating
Expenses
18.2%
81.8%
Jan 1, 2020 - Jun 30, 2020
Prepared by Arif Ahmed
Expenses Analysis Report
Branch
Cost of Goods Sold
301.5K
6.1% from previous 182 days
Expenses
Expenses Expenses (previous 182 days)
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 50K
100K
150K
Expenses Expenses by Branches
578.7K
9.3% from previous 182 days
Operating Expenses
277.3K
12.9% from previous 182 days
Branch Expenses % Δ
1. Abu Dhabi 305.2K -
2. Dubai 273.5K -
Grand total 578.7K -
1 - 2 < >
Abu Dhabi Dubai
Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 20… 0
50K
100K
150K
Dubai
Abu Dhabi
Jun 2020 Jan 2020 May 2020 Mar 2020 Apr 2020 Feb 2020 33.5K 42.6K 48.1K 43.1K 53.5K 52.6K
51.3K 48K 46.7K 56.7K 48.4K 54.2K
Copy of Date / Expenses
Branch
273.5K
305.2K
84.8K 90.6K 94.8K 99.9K 101.8K 106.8K
Grand total
Grand total 578.7K
Feb 2020
Apr 2020
Mar 2020
May 2020
Jan 2020
Jun 2020
18.5%
17.6%
14.7%
15.6%
16.4%
17.3%
Ageing Analysis by Outstanding Days Receivable Maturity by Time Delayed Receivables by Time Net Receivable
ARIF CO Account Receivable Ageing Report
690.9K
Not Yet Due
407.4K
Past Due Balances
0 - 30 Days
109.0K
31 - 60 Days
130.2K
61 - 90 Days
39.9K
> 90 Days
4.4K
Net Dues
283.5K
Days Outstanding Amount
AL Shaheen EST
GEO Logic
Inter Taym FZCO
Lahmeyer Int'l
Nurol LLC
Talal S/M
Total Tech
Union COOP
WellTch
0
25K
50K
75K
100K
**-**-**-**-**-** 74 25 115
Not Yet Due Days Outstanding
2020 2021
0
100K
200K
300K
400K
374K
33.4K
Amount
0 100K 200K 300K 400K 500K
0-30
Days
31-60
Days
61-90
Days
>90
Days
Not Yet
Due
109K
130.2K
39.9K
4.4K
407.4K
Client Amount
Days
Outsta
nding
Not Yet
Due
0-30
days
31-60
Days 61-90 Days > 90 Days Net Due
1. Day To Day 172.9K 0 172.9K 0 0 0 0 0
2. Parco 126.5K 0 126.5K 0 0 0 0 0
3. Lahmeyer Int'l 96.9K 37 0 0 96.9K 0 0 96.9K
4. Talal S/M 81.6K 11 0 81.6K 0 0 0 81.6K
5. Madeen Al Shour 74.5K 0 74.5K 0 0 0 0 0
6. AL Shaheen EST 32.1K 66 0 0 0 32.1K 0 32.1K
7. Union COOP 27.4K 25 0 27.4K 0 0 0 27.4K
Grand total 690.9K 497 407.4K 109K 130.2K 39.9K 4.4K 283.5K
Not Yet Due
31-60 Days
0-30 Days
61-90 Days
>90 Days
5.8%
15.8%
18.8%
59%
Over Dues
Prepared by Arif Ahmed
Jul 1, 2020 - Feb 28, 2021
Ratio Analysis Report
Branch
Cash Ratio
1,202%
15.0% from previous year
Quick Ratio
1,485%
5.0% from previous year
Current Ratio
3,353%
10.0% from previous year
Capitalization Ratio
698%
-15.6% from previous year
D - E Ratio
4,661%
-17.6% from previous year
Networking Ratio
3,353%
10.0% from previous year
Receivables Ratio
3.2K
-42.7% from previous year
Payables Ratio
2.8K
113.8% from previous year
Cash Ratio Cash Ratio (previous year)
Jul 2020
Aug 2020
Sep 2020
Oct 2020
Nov 2020
Dec 2020
Jan 2021
Feb 2021
0%
100%
200%
300%
Current Ratio Cash Ratio Quick Ratio
Jan 2021
Feb 2021
Nov 2020
Dec 2020
Sep 2020
Aug 2020
Oct 2020
Jul 2020
0%
200%
400%
600%
800%
Capitalization Ratio
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
Jul 2020
0%
50%
100%
150%
79% 83% 82% 73% 69%
84%
115% 113%
Debt to Equity Ratio
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
Jul 2020
0%
250%
500%
750%
1,000%
526%
437%
515% 496% 491% 453%
826%
917%
Abu Dhabi Dubai
Sep 2020
Jul 2020
Aug 2020
Oct 2020
Feb 2021
Nov 2020
Dec 2020
Jan 2021
0
200
400
600
420.9
200.3 217.5
300.4
193.1 195.6 181.8 162.5
113
298.9 281.6
92.1
146.7 140.5 133.1
89.9
Receivables Outstanding
Abu Dhabi Dubai
Jul 2020
Jan 2021
Dec 2020
Feb 2021
Nov 2020
Oct 2020
Sep 2020
Aug 2020
0
200
400
600
384.7
335.6
252
291
244.1
201.9 222.3
157.4
57.8
44.2
94.4
49
87 123.4 99.9
115.9
Payables Outstanding
Branch Cash Ratio % Δ Quick Ratio % Δ Current Ratio % Δ Capitalization R… % Δ Debt to Equity … % Δ Networking Capi… % Δ Receivable … % Δ Payable Outsta… % Δ 1. Abu Dhabi 694% 31.9% 883% 30.8% 2,094% 22.3% 469% -9.5% 3,514% -19.3% 2,094% 22.3% 1.9K -9.9% 2.1K 95.7% 2. Dubai 508% -2.1% 602% -18.5% 1,260% -5.7% 228% -25.9% 1,147% -11.8% 1,260% -5.7% 1.3K -62.… 671.7 199.4% Grand total 1,202% 15.0% 1,485% 5.0% 3,353% 10.0% 698% -15.6% 4,661% -17.6% 3,353% 10.0% 3.2K -42.… 2.8K 113.8%
1 - 2 / 2 < >
Prepared by Arif Ahmed
ARIF AHMED CO SALES FORECAST Jan 1, 2021 - Dec 31, 2021 WT 101
Total Revenue
2.4M
985.3K
23.3% from previous year
TOTAL REVENUE 2021 REVENUE
799.0K
25.5% from previous year
2020 REVENUE
636.4K
No data from previous year
2019 REVENUE
Sold WT 101 Sold WT 203 Sold WT 304
December
November
October
September
January
August
July
June
February
May
0
1K
2K
3K
4K
SALES 2021
Sold WT 101 Sold WT 203 Sold WT 304
December
November
October
September
August
January
July
June
February
May
0
1K
2K
3K
4K
SALES 2020
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Jan 2021
Aug 2021
Jul 2021
Jun 2021
Feb 2021
May 2021
Apr 2021
Mar 2021
10.2%
9.6%
9%
8.5%
8.5%
7.3%
7.3%
7.6%
7.9%
7.9%
7.9%
8.2%
Sold WT 101 Sold WT 203 Sold WT 304
December
November
October
September
April
March
May
August
July
June
0
1K
2K
3K
SALES 2019
SALES AVERAGE GROWTH RATE %
1.78
2019
2.83
2020
3.17
2021
WT 203
7.33
2019
2.83
2020
2.25
2021
WT 304
6.83
2019
1.5
2020
3.17
2021
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Jan 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
11.9%
11.9%
10.4%
8.9%
5.9%
5.9%
6.7%
6.7%
7.4%
7.4%
8.1% 8.9%
Jul 2021
Jun 2021
May 2021
Sep 2021
Aug 2021
Nov 2021
Oct 2021
Apr 2021
Dec 2021
Mar 2021
Feb 2021
Jan 2021
10.9%
10%
9.1%
9.1%
9.1%
5.9%
6.4%
7.3%
7.7%
8.2%
8.2%
8.2%
WT 101 UNIT SOLD WT 203 UNIT SOLD WT 304 UNIT SOLD ARIF AHMED CO SALES FORECAST Jan 1, 2021 - Dec 31, 2021 8.9K
18.0% from previous year
SALES WT 101 - 2021
33.8K
23.9% from previous year
SALES WT 203 - 2021
5.5K
25.7% from previous year
SALES WT 304 - 2021 Date (Y… Total Revenue
1. 2021 985.3K
2. 2020 799K
3. 2019 636.4K
3.75 4 3.5
January
February
March
April
May
June
July
August
Septem…
October
Novem…
Decem…
0
2
4
3.75 3.75
0 0 0
3.75 3.75 3.75 3.75
0 0 0 0 0
4 4 4
0 0 0 0 0 0 0 0 0 0 0 0
3.5 3.5 3.5
COST WT 101 - 2021
3.1 2.9 2.85
January
February
March
April
May
June
July
August
Septem…
October
Novem…
Decem…
0
2
4
0
3.1 3.1 3.1 3.1 3.1 3.1 3.1
0 0 0 0
2.9
0 0 0 0 0 0 0
2.9 2.9
0 0 0 0 0 0 0 0 0 0 0 0
2.85 2.85
COST WT 203 - 2021
1.55 1.1
January
February
March
April
May
June
July
August
September
October
November
D…
0
1
2 1.55 1.55 1.55 1.55
0 0 0 0 0
1.55 1.55 1.55
0 0 0 0
1.1 1.1 1.1 1.1 1.1
0 0 0
COST WT 304 - 2021
Date (Y… TOTAL SOLD
1. 2021 48.1K
2. 2020 39.1K
3. 2019 31.7K
Margin Per Unit WT 101
16.24
2.1% from previous year
AVG MARGIN WT 101
Margin Per Unit WT 203
11.98
0.3% from previous year
AVG MARGIN 203
Margin Per Unit WT 304
58.63
9.6% from previous year
AVG MARGIN 304
Gross Profit WT 101
143.9K
20.5% from previous year
PROFIT WT 101 - 21
Gross Profit WT 203
405.2K
24.3% from previous year
PROFIT WT 203 - 21
Gross Profit WT 304
322.6K
37.9% from previous year
PROFIT WT 304 - 21
TOTAL GRO PROFIT
871.7K
28.3% from previous year
GROSS PROFIT 2021
TOTAL GRO PROFIT
679.5K
26.9% from previous year
GROSS PROFIT 2020
TOTAL GRO PROFIT
535.4K
No data from previous year
GROSS PROFIT 2019 Date (Ye… TOTAL GRO PROFIT
1. 2021 871.7K
2. 2020 679.5K
3. 2019 535.4K
Grand t… 2.1M
Contact this candidate