About the Institution
|Module 1: Overview of Financial Modeling|
|Providing an overview of Financial Modeling||00:00:00|
|Identifying the new features available in Excel 2007||00:00:00|
|Explaining the procedure to get started with Excel Basics||00:00:00|
|Explaining the procedure to get started with Advanced Excel||00:00:00|
|Stating the technique, design, business and industry knowledge required in financial modeling||00:00:00|
|Describing the purpose of using Financial Model and stating its application by different users||00:00:00|
|Module 2: Getting Familiar with Excel Basics|
|Getting familiar with the Excel||00:00:00|
|Moving Around the Cells and Entering Information||00:00:00|
|Working with Formulae and Functions||00:00:00|
|Understanding the File Operations||00:00:00|
|Moving and Copying the Data||00:00:00|
|Working with Names||00:00:00|
|Working with Multiple Sheets||00:00:00|
|Manipulating Large Worksheets||00:00:00|
|Sorting & Subtotaling Data||00:00:00|
|Module 3: Working with Advanced Excel|
|Working with Advanced Worksheet Functions||00:00:00|
|Creating Views and Using Goal Seek and Solver||00:00:00|
|Using Excel to manage Lists||00:00:00|
|Managing Pivot Tables||00:00:00|
|Working with Charts||00:00:00|
|Working with Templates||00:00:00|
|Getting familiar with Auditing Features||00:00:00|
|Formatting the cells||00:00:00|
|Learning about other Excel Features||00:00:00|
|Inserting Formatting and Deleting objects; Reviewing; Proofing Tools|
|Module 4: Preparing a Financial Model|
|Overview of Financial Modeling||00:00:00|
|Excel Best Practices||00:00:00|
|Modeling Warm Up||00:00:00|
|Understanding the Key Financial Statements||00:00:00|
|Building Financial Statements||00:00:00|
|Building Depreciation Schedule||00:00:00|
|Building Amortization Schedule||00:00:00|
|Module 5: Discounted Cash Flow (DCF) Analysis|
|Explain the Discounted Cash Flow||00:00:00|
|Perform the calculations for Discount Rate (Cost of Debt, Cost of Equity, CAPM)||00:00:00|
|Gather information for Historical Financials||00:00:00|
|Prepare Forecasts and Unlevered Free Cash Flow Calculation||00:00:00|
|Perform the calculations for Terminal Value (Exit Value, Perpetuity Growth Method)||00:00:00|
|Perform the calculations for discounting the Cash flows to Valuation date||00:00:00|
|Perform the calculations to derive the Enterprise Value||00:00:00|
|Perform the calculations and adjustments for Enterprise Value and Equity Value (Equity Value Multiples: P/E, P/CF, P/BV, PEG, Dividend Yield)||00:00:00|
|Perform Sensitivity Analysis (TABLE Function)||00:00:00|
|Build a Full DCF model||00:00:00|
|Full DCF Model||00:00:00|
|Module 6: Overview of Valuation Modeling|
|Why do we value companies?||00:00:00|
|Differentiating between Book Value and Market Value||00:00:00|
|Understanding Equity Value vs. Total Enterprise Value (TEV)||00:00:00|
|Understanding the three Generally Accepted Valuation Methodologies||00:00:00|
|Qualitative factors in valuation – management quality||00:00:00|
|Module 7: Comparable Company Analysis|
|Choosing appropriate Peer Group||00:00:00|
|Calculating Equity Value and Enterprise Value (EV)||00:00:00|
|Calculating Last Twelve Months (LTM)||00:00:00|
|Adjusting the Enterprise Value (EV)||00:00:00|
|Calculating Fully Diluted Shares Outstanding (Options & Convertibles)||00:00:00|
|Equity Value Multiples: P/E, P/CF, P/BV, PEG, Dividend Yield||00:00:00|
|Calculating various multiples||00:00:00|
|Module 8: Comparable Transaction Analysis|
|Choosing appropriate deals||00:00:00|
|Discussing the strategic rationale||00:00:00|
|Control premiums, synergies||00:00:00|
|Calculating Equity Value and Enterprise Value (EV)||00:00:00|
|Calculating Last Twelve Months (LTM)||00:00:00|
|Checking and interpreting results||00:00:00|
Any candidate who is a graduate, or is in the final year of graduation, is eligible for the courses.
No, Copal Institute does not guarantee any job for self study courses, each course will provide students the desired skill set to be able to explore themselves in various verticals: financial research, investment banking, investment research (credit and equity), and private equity. These courses will give you potential help in securing jobs across financial services industry.
If someone is unable to clear the final assessment, he/she has to register for the exam again by paying the requisite fee and then re-appear for the test.
Students can register online by filling up the online form and paying through credit cards / debit cards / net banking. Students can also register offline by submitting a demand draft and the duly filled form at our regional centers.
The coursework provided by us includes the following: Reading Material Video Tutorials Reusable, modifiable Excel model templates Live Chat Support to resolve queries and clear the doubts on a real time basis Interactive Check Your Understanding (CYU) questions Home Work (comprising of assignments and submission of projects which will be evaluated by experts through an e-mail correspondence) Final Assessment Test and Certification (are optional depending on individual need of the learner)
Candidate’s details will be maintained in a database at Copal Institute and will be shared with recruitment agencies / potential employers at regular intervals.
1. You can register yourself on our site with any of your existing e-mail id (Gmail/Yahoo/Hotmail etc.) 2. You can then select the online course of your choice and make the payment either through an NEFT transaction OR through our secured HDFC payment gateway A. If the payment is made through our secured HDFC payment gateway i. You will get the access automatically B. If the payment is made through an NEFT transaction i. You will need to update us with the transaction details and your e-mail address with which you have registered on our site as mentioned in Point No.1 ii. We will align the course to the registered E-mail ID provided by you
A. If the payment is made through our secured HDFC payment gateway i. You will get the access automatically, and you start learning right away B. If the payment is made through an NEFT transaction i. You will need to update us with the transaction details and your e-mail address with which you have registered on our site as mentioned in Point No.1 ii We will align the course to the registered E-mail ID provided by you-It will take few hours – Please note that we work from Monday to Friday from 10:00 A.M. to 7:00 P.M. You will then receive an acknowledgement mail from us with your Login Credentials and course completion guidelines. You can access this online course anytime (24/7) from anywhere, and can pursue it at your own pace within the registration validity period mentioned in your User Profile.
Final Course Assessment is conducted online only. You can give it anytime (24/7) from any location. However, you need to ensure that you have good internet connectivity so that you can complete it in one instance. You can appear for the Final Assessment after completing all the modules/ lessons, and submitting the Project work within course registration window.
Your assignments will be evaluated by our expert faculties and the feedback would be shared accordingly. We can hold 1 hour doubt clearing session for you each month. This session can be pre-scheduled at a mutually agreed feasible time.
The course content is not downloadable, but we do provide reusable, modifiable Excel model templates and PDF guides to help you with the assignment work. Since, this is an online course therefore you can access the course material anytime (24/7) from anywhere across the globe. However, you need to have good internet connectivity so that you can pursue the course without any hindrance.
You can access the course material during the registration validity ranging from 3 to 6 months. Once the registration validity is over, you will not be able to access the course materials.
We offer Instructor-Led (Classroom) as well as Web-Based (Online) trainings For the Classroom trainings – Hard copy of the course materials are available For the Online trainings – Online study materials are available which can be accessed anytime (24/7) from any location during the course registration window.
Final Course Assessment is conducted online only. It can be given anytime (24/7) from anywhere across the globe. We recommend good internet connectivity so that you are able to complete the test without any hindrance.
You will be given a single attempt to pass the Final Course Assessment. However, in case if you are not able to clear the Final Assessment in the first attempt, you can re-appear for the test by paying the requisite fee.
Yes, you can earn a Certificate of Completion; after doing the following activities: A. Studying all the modules/ lessons B. Submitting the Projects/ Assignments (It takes around 7 business days to evaluate your project work) C. Scoring 60% or more in the online Final Course Assessment
Payment can be made through either of the following mode: A. Online – Credit card/ Debit card / Net banking B. Offline – Cash/ Demand draft deposited at our Gurgaon centre.
It was a great learning experience at Copal Institute. I got the practical exposure of valuation specially DCF and Relative Valuation technique. All the faculty members have relevant industry experience and are quite helpful.
Training method is excellent. I personally recommend everyone to join the “Certificate in Financial Research” course.
I take immense pleasure in attesting my association with Copal Institute. It's only due to the strong association and relation that has helped me in achieving the position of a Sr. Analyst in Copal Amba.
Being a part of the Copal Institute, I have learnt almost all the relevant concepts of Investment Banking and feel confident to use my skills in Financial Modeling. I have always received the complete support and cooperation in understanding the course curriculum. It has not only provided me with the theory, but has also helped with the practice sessions on the complete projects.
The course has also covered the soft skills training which has helped me present my projects in a better way. I shall always be thankful to all the trainers and members of the institute who have helped me learn the core dynamics of the industry.
I am very thankful to Copal Institute and my faculties. Thank you for always being there and guiding me, and even taking extra efforts to clear my basics first before making me understand anything at a higher level.
From the day I joined Copal Institute till the last day, I can proudly say, “that with every session, my knowledge and skills have improved very much, more than what I acquired from my graduation and post graduation courses”.
The main strength of this course is its curriculum and even more important is the teaching faculty, the best I would say. When you have to be the best, you have to learn from the best, and that is what I got from this Institute.
Whether it is my Excel skills or financial knowledge, now I have got a better understanding and a new perspective. Every faculty is quite knowledgeable, as most of them are working in Copal Amba so they share their work experiences and practical knowledge, which has made the course all the more fruitful for me.
Experience - Good
Learning - Good (I didn’t know most of it before)
Overall - Good
I have successfully been placed with Cians Analytics as an Analyst MIS - Operations.
The trainings provided here covers all that is required to enter the KPO industry
Well experienced faculty, who are both interactive and approachable
One can expect to get placed with Copal Amba and the likes but only when required efforts are in place
Active placement cell, that provides a number of job opportunities
Those 12 weeks are still remembered, as if coming back to college, in a class of 16. Being a fresh commerce graduate (2012) always had the idea (suggested by others) that commerce = finance but never knew what finance is. So I took the plunge and enrolled myself.
My expectation out of the Certificate in Financial Research course:
One can expect to master Excel (never knew these big businesses use Excel so extensively)
Learn how to value a business (the EV which one can find on the Bloomberg's website)
Trading and Transaction Comparables (valuation of business)(Here, you will get to make your own model)
Discounted Cash Flow analysis
An insight into as to what Credit Research and Private Equity is
Sector Analysis, Economic Analysis
Relation between finance and economy
Time value of money
Extensive Ratio Analysis
40% of CFA level 1 - covered
I will rate joining Copal Institute as one of the best decisions of my life. I have grown at Copal Institute not only in terms of knowledge but also in terms of personality.
Having being well trained at Copal Institute, I feel at par with my team members at Copal Amba in terms of overall knowledge.
This training has helped me realize my dream of working in the field of financial research. The well-structured course content and the style of teaching are a few things that I admire the most about Copal Institute.
I firmly believe that the training and the knowledge imparted by Copal Institute is the best that one could get. The faculty at Copal Institute not only provided me with a platform to learn and understand practical aspects of financial research, but, also prepared me for the future interviews.
We were encouraged to be updated with current economic scenarios and events on a weekly basis, which further enhanced my understanding and knowledge of finance and economy as a whole.
I take this opportunity to thank the faculties and the management of Copal Institute for honing my skills, and helping me achieve my goal. 'Copal Institute' has emerged as a landmark Institute.
The courses are very comprehensive, covering a wide range of aspects of finance industry. It gave me a good exposure to Financial Modeling. Engaging and prominent lecturers not only match the reputation of the brand 'Copal Institute', but the knowledge being passed on is consistently allowing students to meet their career ambitions as a successful finance professional.
Faculties gave me very good guidance and a lot of moral support. It was all worth being in the Copal Institute.
I always suggest that “Copal Institute is the right place for anyone who wants to explore the finance industry.”
It was a “dream come true” for me to get placed in Copal Amba.
When I took admission in Copal Institute, I was a graduate only. I was quite fearful whether I had done the right thing in taking admissions without doing an MBA. When my classes started, I found out that my batchmates were either having 6 years of work experience OR were having an MBA degree. I thought I won’t be able to stand anywhere in comparison to them.
Certificate in Financial Research is a 3 months course, and almost each day a thought crossed my mind “Whether I will be successful or not” and “Will I have to move back without anything”.
The trainers (Prakash Sir, Deepak Sir, Shivani Mam’, Vibha, and Priyanka Mam) have helped me a lot in solving my problems. They have trained me on each and every aspect of the finance industry. The hard work of Copal Institute truly reflects.
The work based knowledge and skills imparted at Copal Institute were wonderful. It gave me a complete understanding of the Financial Statements, Trading Comparables and Transaction Comparables.
The trainings on Advanced Excel and Financial Modeling have helped me increase my skill level.
It has made me ready for a career in the financial industry, with clarity of fundamental concepts of Finance and Accounting.
I would recommend this course to all those who want to excel their knowledge in Investment banking, Equity Research and Credit Research. Copal Institute offers "Excellent Practical Knowledge in Finance".
I am Milan Luthra…and I joined Copal Institute (Weekend batch) in December 2012… I did my graduation (B.com) from Delhi University (and only I know how I did that...)
Anyways, I did Certificate in Financial Research course from the Copal Institute.
Talking about the faculty, Mr. Prakash Sumani is one of the best trainers Copal Institute has today as far as dedication, honesty, knowledge and guidance are concerned. Being a graduate, I wanted to have more exposure in finance. Earlier, I hardly had any Excel knowledge, and now I am able to create the financial models on my own.
After the completion of my course, Copal Institute helped me get placed at Copal Amba, one of the best Financial Research companies in India. It also assisted in the placements outside Copal Amba. Few of my classmates got placed in Deloitte, WNS, Ernst & Young and many other financial firms.
Guys who want to make their career in the field of investment banking research; this is a golden opportunity for you...all you need is to make some sincere efforts to learn things.....
Copal Institute has an excellent faculty and teaching methodology with emphasis on practical training. Here, I met and interacted with some of the industry’s bright brains.
Everything worked well for me and I am pleased with how things turned out for me. I got placed in Copal Amba, one of the leading Financial Research firms in India. I attended the full time Financial Research program at Copal Institute last year.
I was working as derivative analyst for about 4 years after an MBA in International Business and CFA.
I wanted to move into investment banking research, and was looking for a short term course which would help me build my Financial Research and analysis skills and also give me an insight into day-to-day life of a financial analyst.
Hello Everyone, Copal Institute is one of the best things that happened in my life. The kind of knowledge and training imparted here is unbeatable. I got a chance to be associated with a reputed company like Copal Amba.
I had joined the course “Certificate in Financial Research” in June and the course ended by mid September. I got placed by 25th Sep 2012 in Copal Amba, one of the fastest growing companies in the KPO sector. I will recommend this course to all those who are looking for a bright career in financial analysis and are willing to devote 100% of their time and attention to this training.
Mr. Prakash Sumani is one of the best trainers one can ever come across in his/her life. He is so dedicated for his work. He is always happy to help and guide even after the class is over. The only thing he expects from his students is hard work which is fair enough.
I got what I expected from the course. I believe, I earned much more than what I actually paid. It was a onetime cost but then the benefits that I enjoy are for a lifetime. Before this training, I barely knew anything about Excel, but now I can prepare complex Excel models, all this was possible because of the correct training and guidance. All I can say is any training institute can only guide you; at the end what matters most is your own hard work and dedication.
If you are not giving your 100% then you cannot expect the results to be in your favor.
No Refund will be provided after enrollment in the course
No Reviews found for this course.