FINI619 Internship Report Finance On Hashoo Foundation
FINI619 Internship Report Finance On Hashoo Foundation
FINI619 Internship Report Finance On Hashoo Foundation
HASHOO FOUNDATION
Submitted By: Banazir Jahangir MC09020xxxx Session: January 2009 to February 2011 Submission Date; 11/02/2011 Submitted to: Instructor FINI619 Virtual university of Pakistan
www.vuzs.net
Letter of Undertaking;
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 2
Internship Certificate:
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 3
Dedication
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 4
Acknowledgement
In The Name of Allah the Most Gracious and the Most Merciful.
I want to show my gratitude to my loving Parents and teachers who made me able to be at this position.
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 5
Executive Summary
This internship reports discusses an in-depth study of Hashoo Foundation, its operations, scope and position in the development sector. It gives an overview the four thematic areas of the foundation where it works, includes Economic Development, Education and Skill Development, Special needs and Social welfare and Emergency relief. It also gives us a glance over the future plans of the Foundation. The core administration cost of the Foundation is borne by Hashoo Group which promises to support the financial deficit of the Foundation. The Foundation has many donor funded projects which are fully supported by donors, like, Church World Services Afghanistan- Pakistan, HOPE 87, ADA, UNODC, UNHCR, PRM and RMF. An estimated budget including donor funded projects is over Rs. 500 million per year. The Hashoo Group is bearing an average of Rs.70 million a year being the annual financial deficit of the Foundation. I closely worked with Human Development Recourse Center (HDRC) Rawalpindi, as part of the Foundation work in the thematic area of Educational and Skill Development. HDRC offers different secretarial and skill development training. It also has two Youth Development Centers (One Girls Hostel and One Boys Hostel). Since 1999 HDRC has trained over 50,000 people in its different soft skills development programs. HDRC has 13 primary schools in and around Rawalpindi and Islamabad. I worked in Finance Department of HDRC. Where I learnt about the flow of transaction documents and financial information to produce a feedback in form of reports and analyze in view of an organizations goals and objectives.
I recommended to the Foundation for improvements in the Standard Operating Procedures (SOPs) which may be helpful in pacing up the operation of the Foundation.
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 6
Table of Contents
Introduction of Organizations Business Sector ............................ 8 Overview of Organization: ............................................................. 8 Plan of Internship program .......................................................... 16 Training Program .......................................................................... 17 Ratio Analysis ............................................................................... 21 Liquidity Ratios: ........................................................................ 21 Leverage Ratios: ......................................................................... 27 Profitability Ratios: ................................................................... 30 Activity Ratios; .......................................................................... 30 Market Ratios; ........................................................................... 33 Future Prospects of Organization: ............................................... 34 Conclusion: .................................................................................... 36 Recommendations for Improvement: ............................................ 37 References and sources used .......................................................... 38 Annexes ......................................................................................... 39
www.vuzs.net www.vuzs.net http://groups.google.com/group/vuzs Page 7
Abbreviations: ............................................................................... 44
Overview of Organization:
Vision of Foundation
Our vision is of an ethical, equitable, inclusive and progressive society in which people live with dignity and have power over their own lives.
www.vuzs.net www.vuzs.net http://groups.google.com/group/vuzs Page 8
Mission of Foundation
Our mission is to enable and empower communities to be independent by facilitating equitable access to opportunities, through working on programs that lie within its four core programmatic areas: economic development, education and skills development, supporting people with special needs, and providing emergency relief and social welfare.
Values of Foundation
The Hashoo Foundation is influenced by the Hashoo family's philosophy, and draws on the values of equity; inclusivity, transparency, innovation, integrity, respect and fulfillment. Hashoo Foundation (HF) is a progressive and dynamic NGO, leading the way in human development and poverty alleviation by implementing viable economic development, educational and capacity building programs in Pakistan. Hashoo Foundation is also focused on the needs of children with disabilities and provides care and support services to the less privileged and vulnerable members of society. The Foundations all programs promote and support the pursuit of greater financial independence and self reliance of individuals, families and communities. These programs in turn improve social development, education and health facilities which are the primary goals of the Foundation.
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 9
www.vuzs.net
www.vuzs.net http://groups.google.com/group/vuzs
Page 10
1. Economic Development The Hashoo Foundation's programs in this area aim to achieve greater financial independence and self-reliance of individuals, families, and communities. Economic development will in turn lead to improved social development. Partnering with communities at the grass root level and exploring issues of socio-economic development, our economic development programs enhance the basic earning capacity of the community partners while improving access to existing health, education, and nutrition services.
Women Empowerment through Honey Bee Farming The Women Empowerment through Honey Bee Farming Project Plan Bee- was initiated to empower women in the Northern Areas and other areas of Pakistan by expanding employment opportunities and generating a stable source of income through the sale of high-quality honey. The project addresses the discrepancy between the income earned by male and female beekeepers by educating the women in beekeeping and linking them to profitable markets. Furthermore, the project improves the status of women in their communities, as they become more integrated in the decision-making process within male-dominated societies. The project is based on a system of social barter, designed to promote social
Page 11
Expanded Dairy Development Project The Hashoo Foundation is implementing the Expanded Dairy Development Project (EDDP), funded by Church World Services (CWS-P/A) and EED, which is designed to show and tell the local community how to: Improve the breed of local cattle; Increase the yield of milk through better fodder and livestock management; Improve care and treatment of livestock by training veterinary extension workers; Set up a chilling unit for collection of milk from neighbor farmers; Produce quality products like cheese, butter and yogurt for income generation; and Install and use bio-gas for heating and cooking
Marble Shine Associates Marble Shine Associates (MSA) is a unique income generating project of Hashoo Foundation that offers high quality floor polishing services (marble, granite and chips) to commercial, government and private clients. Operating since 1999, MSA works with 5-star hotel chains (Marriott, Pearl Continental), private hospitals and governmental facilities, as well as commercial buildings. The project employs and trains more than 70 staff. Excelling in the art of stone restoration and obtaining the best quality of workmanship, MSA uses the latest technology in its equipment and the finest diamond abrasives to restore the natural beauty of stone. Our highly skilled and experienced staff ensures the efficacy.
Page 12
The Vocational Training Program aims at: Conducting regular market research for identification of vocational training needs;
Page 13
3. Special Needs In the twin cities of Islamabad and Rawalpindi alone, there are about 200,000 children with special needs. To integrate these children back into society with dignity, a center Umeed-e-Noor was established and so far 1,200 children have benefitted from quality therapy and education provided by the center. We provide treatment, vocational training, boarding and therapy to children with multiple disabilities and most of these children are abandoned by their families. We offer support to children with the following disabilities; Polio Down syndrome Muscular Skeletal Disorder Stammer Victim Dyslexia Cerebral Palsy Muscular Dystrophy Neuro-Muscular Disorder Autism Hearing Impairment
Initially operating from a residential set-up, UmeedENoor moved into its new purpose built premises from July 01, 2009. This centre of excellence will cater to the needs of 300 children with special needs, especially the poor and abandoned. The centre will offer state of the art facilities and services such as special education, audio-logical assessment physiotherapy, speech therapy, occupational therapy and vocational training. Fundraising efforts are under way to complete the entire three-storied building by the end of 2011. 4. Social Welfare and Emergency Relief In the absence of state-sponsored social safety nets, vulnerable families and individuals facing temporary hardships and/or unforeseen expenditures can be easily thrown into an endless cycle of poverty. Initiated in 1999, the Social Welfare Program offers medical and economic assistance to families needing limited, and specific help. In the form of small grants and loans, it covers for unforeseen hardships such as medical expenses, loss of job, or loss of a family member, and enables families to overcome crises before they exacerbate.
Page 14
Helping the IDPs The recent turmoil in Pakistan has resulted in one of the largest internal migration of this century, where over 1.5 million Internally Displaced Persons (IDPs) face desperate living conditions in makeshift camps that lack basic living facilities. The Hashoo Foundation and Hashoo Group initially provided 5 truckloads of relief goods for the IDP's and Hashoo Foundation has now established an emergency health unit in Palosa camp, Charsadda, NWFP that is staffed by a medical officer, a nurse and a medical technician, equipped with quality medicines. The Hashoo Foundation is working in collaboration with the local bodies and has the support of the Commissioner of Mardan. It provides: Medical services to 80 patients a day; Educational assistance to 80 children in our Hashoo Foundation school, Nowshera Kalan, NWFP; and Evening classes to another 75 children (books, teachers and stationery) in Hashoo Foundation school, Rashakai, NWFP
HEALTH Hashoo Foundation (HF) Health program is divided into 2 components 1 - Basic Health Centers Real Medicine Foundation-HF Health Project, Talhatta, Balakot, NWFP Hashoo Medical Centre Gwadar Hassan Ali Hashwani Dispensary Karachi
2 - Spinal Cord Injury Project Spinal Cord Injury Project for Pakistan Earthquake Rehabilitation
Page 15
Training Program
It was December 15, 2011, the first day at Hashoo Foundation HRDC Rawalpindi. Mr. Latif took me at every department for formal orientation. On the first day, my supervisor Mr. Sher Ahmed gave me Job Descriptions. He told me to read carefully. On the same day, an assistant guided me following; 1) Vouchers and Filling System 2) Routine Work I have not been given a concrete daily time sheet on my training; instead, I have been given Job Descriptions. The tasks were on daily basis. Besides, I have been given a book written over, Financial Policies and advised to go through carefully. A snapshot of my JDs is below. 1. Receiving of Transaction Documents i. Payment Requisitions from internal / external sources ii. Mails and couriers 2. Maintaining Petty Cash Register
Page 17
As per JDs, I have learnt below. Receiving of Transaction Documents: Performance Measures/ Expectations: o o o o o Checking Accuracy, finding out different errors Entries in Daily Receiving Book Updating Status on Daily basis Prioritize Payments on urgency basis Timely Disbursing Payments
Transaction documents including following, o Payment Requisitions o Travel Requisitions o Advance Adjustment/ Claims All these documents were describing total amount requesting, purpose, Items/ services, unit price/ wage rate etc. I had to be concentrated keep on above mentioned performance measures. Moreover, I have to follow the financial policies of foundation while scrutiny the transaction documents, for instance, in any payment to supplier, any payment above Rs. 10,000/- was to be attached with purchase order. Such payment much has attached along comparative statement fulfilling a minimum three quotations attached therein.
Maintaining Petty Cash Register. Performance Measures/ Expectations: o Completion of Authorized Petty Cash Vouchers o Daily updating MS excel Sheet I recorded daily expenses in the Petty cash statement. Such as; daily tea
Page 18
HASHOO FOUNDATION HRDC RAWALPINDI Petty Cash Statement For the Month of December 2010 No
Date 19-Dec10 19-Dec10 19-Dec10 19-Dec10 19-Dec10 19-Dec10 19-Dec10 19-Dec10 20-Dec10 20-Dec10 20-Dec10 20-Dec10 20-Dec10 20-Dec10
Particulars Daily tea and Refreshment for Staff Hired taxi I-12 to F8/3 Daily tea and Refreshment for Staff Hired taxi I-12 to Rawalpindi Hired taxi I-12 to Rawalpindi Daily tea and Refreshment for Staff Daily tea and Refreshment for Staff Daily tea and Refreshment for Staff Hired taxi I-12 to Chak Shahzad Hired taxi Chak Shahzad to I-8 Daily tea and Refreshment for Staff Hired taxi I-12 to F8/3 Hired taxi F8/3 to I-8 Hired taxi I-12 to NIRM office TOTAL
PCV # 52 53 54 55 56 57 58 59 60 61 62 63 64 14
Project Skills Skills Skills Skills Skills HRDC HRDC HRDC Skills HRDC HRDC HRDC HMTP Skills 5,219
Refreshment 950
Taxi Rent
Stationary
Training material
Utilities
200 282 600 400 332 293 306 400 300 306 250 300 300 2,469 2,750 -
Page 19
I prepared all types of cheques such as crossed and open cheques. I did remember, when I wrote in figures Rs. 25,500/- and in words (Twenty Five Thousand). Later, an authorized signatory pointed out this error in signing the cheque. As per Financial Polices, all cheques amounting Rs. 5000/- and above must be crossed except, in case of minor or authorized by Country Director/ Deputy Country Director.
Page 20
Ratio Analysis
Liquidity Ratios:
Current Ratio (Working Capital Ratio); Formula; Current Assets / Current liabilities
2007 = 17,700,641/ 5,745,087 = 3.08 2008 = 21,591,464 / 12,479,563 = 1.73 2009 = 87,968,165 / 9,116,062 = 9.65
Working;
Current Assets Years 2008 (PKR) 1,228,914 4,891,366
Page 21
Current Liabilities
Trade and other payables Current portion of liabilities against assets subject to finance lease Due to related parties Bank over draft Total
5,745,087
Graphical Presentation;
Page 22
Interpretation; The Foundations current ratio increased in 2009 because there is excess amount of cash and bank balances.
Acid test Ratio: Formula; Acid Test Ratio = (Current Assets - Inventory) / Current Liabilities
2007 = 16,476,371 / 5,745,087 = 2.87 2008 = 20,362,550 / 12,479,563 = 1.63 2009 = 87,682,558 / 9,116,062 = 9.62
Working;
Current Assets - Inventory Years
Page 23
Current Liabilities
Trade and other payables Current portion of liabilities against assets subject to finance lease Due to related parties Bank over draft Total
5,745,087
Graphical presentation;
Page 24
Interpretation; The Foundations Acid test ratio increased in 2009 because there is excess amount of cash and bank balances.
Net Working Capital; Formula; Working Capital = Current Assets Current Liabilities
2007 = 17,700,641 - 5,745,087 = 11,955,554 2008 = 21,591,464 12,479,563 = 9,111,901 2009 = 87,968,165 - 9,116,062 = 78,852,103
Page 25
2009 (PKR) 285,607 7,408,880 1,000,000 10,403,766 5,067,963 691,655 63,110,294 87,968,165
Inventory Accounts receivable Short term investments Advances, prepayments and other receivables Advance income tax Accrued interest Cash and bank balances Total
17,700,641
Current Liabilities
Trade and other payables Current portion of liabilities against assets subject to finance lease Due to related parties Bank over draft Total
5,745,087
Graphical presentation;
Page 26
Interpretation; The Foundations Net working capital increased in 2009 due to increase in amount of cash and bank balances.
Leverage Ratios:
Time interest earned ratio;
Formula; EBIT / Total interest Interpretation; Since the Foundation is not for profit organization (NPO/NGO), therefore Time interest earned ratio is not applicable Debt ratio; Formula; Total debt / Total assets Interpretation:
Page 27
Working;
Total Liabilities Years 2008 (PKR) 11,091,998 339,616 1,047,949 4,390,616 7,299,720 10,199,500 7,256,535 6,894,180 10,199,500
2007 (PKR) 1,759,267 560,215 1,996,450 1,429,155 1,215,706 85,333 7,705,260 599,500
Trade and other payables Current portion of liabilities against assets subject to finance lease Due to related parties Bank over draft Deferred liabilities Deferred income Deferred capital grant Capital grant
Page 28
Total Assets
2007 (PKR) 1,224,270 2,684,411 1,715,000 5,712,997 46,206 6,317,757 16,827,914 21,150,000 279,499
Years 2008 (PKR) 1,228,914 4,891,366 1,542,618 6,469,054 4,722,401 438,877 2,298,234 33,529,890 21,150,000 438,250 76,709,604
2009 (PKR) 285,607 7,408,880 1,000,000 10,403,766 5,067,963 691,655 63,110,294 34,130,982 696,166 34,525,000 1,163,750 158,484,063
Inventory Accounts receivable Short term investments Advances, prepayments and other receivables Advance income tax Accrued interest Cash and bank balances Property, plant and equipment Biological assets Long term investments Long term security deposits Total
55,958,054
Years Net Worth 2007 (PKR) 35,332,529 2008 (PKR) 41,675,348 2009 (PKR) 91,906,728
There are no net tangible assets for year 2007, 2008 and 2009. Graphical Presentation;
Page 29
Total Capitalization Ratio: Formula; Long term debt / (long term debt + shareholders) Interpretation; There are no debts therefore Total Capitalization ratio cannot be calculated.
Profitability Ratios:
Since the Foundation is not for profit organization (NPO/NGO), therefore Profitability Ratios are not applicable.
Activity Ratios;
Total Assests turnover; Formula; Turnover / Total assets
2007 = 24,020,273 / 55,958,054 = 0.43 2008 28,697,273 / 76,709,604 = 0.37 2009 30,137,984 / 158,484,063 =0.19
Page 30
Total Assets
2007 (PKR) 1,224,270 2,684,411 1,715,000 5,712,997 46,206 6,317,757 16,827,914 21,150,000 279,499
Years 2008 (PKR) 1,228,914 4,891,366 1,542,618 6,469,054 4,722,401 438,877 2,298,234 33,529,890 21,150,000 438,250 76,709,604
2009 (PKR) 285,607 7,408,880 1,000,000 10,403,766 5,067,963 691,655 63,110,294 34,130,982 696,166 34,525,000 1,163,750 158,484,063
Inventory Accounts receivable Short term investments Advances, prepayments and other receivables Advance income tax Accrued interest Cash and bank balances Property, plant and equipment Biological assets Long term investments Long term security deposits Total
55,958,054
Page 31
Interpretation; Above graph shows that assets turnover ratio decreases year by year. It shows assets contribution towards sale is low. Fixed Assets Turnover; Formula; Turnover / Net Fixed Assets
2007 = 24,020,273/16,827,914 = 1.43 2008 =28,697,273/33,529,890 = 0.86 2009 =30,137,984/34,130,982 = 0.88
Working;
Years Turnover 2007 (PKR) 24,020,273 Total 24,020,273 2008 (PKR) 27,438,053 1,259,220 28,697,273 2009 (PKR) 28,433,095 1,704,889 30,137,984
Page 32
Graphical presentation;
Interpretation; Fixed assets turnover in year 2008 is less as compare to in year 2007 and 2009. This ratio is low in all three years and less effectively the fixed assets are utilized.
Market Ratios;
Since the Foundation is not for profit organization (NPO/NGO), therefore Market Ratios are not applicable.
Page 33
Moreover the Foundation globally continued projects in the United States, working on policy issues with other philanthropic partners. Building on the success of the BBC World Challenge 2008 award winning the Honey Bee Farming social enterprise project, the Foundation is partnering with several US microcredit University programs to explore growing the project through the extension of micro-loans. The Foundation is also diligently working to export the produce of its social enterprise projects into the international market and is expanding the project across Pakistan and into Afghanistan and Tajikistan.
Page 35
Conclusion:
Based on ratio analysis of the Foundation for the financial year 2007 to 2009 I have found the following, Liquidity Ratios shows that these have been shouted up dramatically, due to considerable increase in Cash in hand. It shows that in the year of 2009, the Foundation has either received huge donations or has limited its operations. 1) The Foundation has two income generation Unit, Marble Polishing Project and Honey Bee project. Assets Turn Over ratio is decreasing due to wear and tear of Assets. Also, new machinery has not been purchased in more recent years. 2) Since, the Foundation is not for profit organization; its true sense is to deliver the excellent services to serve the humanity. Therefore profitability ratios are not applicable in case of the Foundation. Beside; the Foundations all programs promote and support the pursuit of greater financial independence and self reliance of individuals, families and communities. These programs in turn improve social development, education and health facilities which are the primary goals of the Foundation. The Foundations vision is an ethical, equitable, inclusive and progressive society in which people live with dignity and have power over their own lives. We are committed to serve humanity by undertaking the challenges that our world is facing; suffering keeps increasing day by day, poverty is on the rise, global turmoil, and natural and man-made disasters taking precedent. Under such huge disturbances, there is an increased need for civil society organizations to take additional responsibilities and strive to improve governance to ensure transparency and benefit from the funds available globally both privately and publicly. Hashoo Foundation has designed innovative and empowering programs to further the cause of improving the quality of peoples life, so they can live in peace. The Foundation achieves this by creating opportunities for communities to become economically independent. Yet, these improvements rely on developing synergies between partners and stakeholders with a key focus on
Page 36
Page 37
Page 38
Annexes
Financial Statements for 2007- 2008
Page 39
Page 40
Page 41
Page 42
Page 43
Abbreviations:
UEN- Umeed-e-Noor SWP- Social Welfare Program SWO- Social Welfare Officer AMF Assistant Manager Finance SO-HR Senior Officer Human Resource MIS Management Information System SFO Senior Finance Officer FO- Finance Officer SO-HR- Senior Officer Human Resource PO- Procurement Officer
Page 44