Financial Statement Analysis Applied Corporate Finance: Fill & Download for Free

To build financial models, you will need to develop the following skills:ExcelFinanceModelingApplicationExcelThis skill is fairly easy to master to a sufficient level. You will need to learn:Excel interface and features;Frequently used Excel formulas;Techniques to complete typical modeling tasks;Methods to import and handle data in Excel.There are plenty of good tutorials on the web; if you prefer books, everything from John Walkenbach is solid, i.e:Excel 2010 Bible: John Walkenbach[Note: It's important to understand that financial modeling is not about Excel, it’s about finance and modeling. Knowledge of Excel itself is just a basic prerequisite.]FinanceYou will need to know:Accounting & corporate finance;Financial analysis (understanding financial statements, making adjustments, calculating ratios);Valuation techniques;This book is a quality source for all of the above: Business Analysis and Valuation Using Financial Statements: Krishna PalepuFor valuation analysis specifically, use these:What is the best book to learn about valuation?ModelingModeling is a distinct skill, don't confuse it with "Excel" (which is just an environment for modeling) - the most important talent a modeler needs is the ability to simplify complex things without losing their essence. In addition, to be a good modeler, you need to know how to:Acquire and manage data for your models (from databases and data feeds such as CapitalIQ or Factset);Structure your models so that they are transparent and can be easily maintained (learn to separate inputs, logic and outputs);Model typical financial concepts (discount rates, risks, free cash flows, etc);A good book to start:Building Financial Models: John TjiaApplicationYou will need to apply the above skills to specific problems. For example, if you work for an investment fund, your application will depend on the investment strategy of the fund (private equity, stock investing, venture capital, etc), and your target industry. A good approach is to ask your teammates for model samples (ideally, from the past deals), and study them until you understand every cell.

For investment banking (m&a, etc.) you're going to need a solid understanding of financial accounting and corporate finance fundamentals.Here are some important things:-an solid understanding of financial statements of how changes on one financial statement affects the others. Example: how does a $1000 decrease in depreciation expense on the income statement affect the balance sheet and cash flow statements?-present value, net present value, and future value-understand capital structure and cost of equity and capital-once you can grasp the above look into corporate valuation methods such as discounted cash flow analysis, comparable companies analysis, and precedent transaction analysis-get a book/use an online resource to teach you financial modelling and then practice! You will know financial statements like the back of your hand after this (might be a good idea to start with this--will really help you with the first point)-micro and macro economics at the introductory level is indirectly important. You won't need to explicitly apply the concepts but you should understand supply and demand, market structures and behavior, monetary and fiscal policy, theory of the firm to name a few.-monetary policy: know how the monetary transmission mechanism works. How does a change in the fed funds rate affect the yields/prices of treasuries, bonds and other debt instruments. Know why treasury bills are risk free assets and why their yields are considered "the interest rate."-understand capital markets. Know how debt offerings are different from equity offerings. Know how a bond is priced. Know how stocks are valued.Ill add more if I can think of anything else.

Why Simandhar EducationSimandhar with Becker training is designed with a practical and experiential learning methodology - engaging participants using mock exams, task-based simulations, and sample problems with functionality that mirrors the US CPA exam. The comprehensive content is updated regularly and delivered by experienced faculty. The methodology offers real-life challenges, compelling the learners to apply concepts in the class and prepare for career realities.Certified Management Accountant (CMA) is US certification which is awarded by Institute of Management Accountant (IMA).It is the advanced professional certification specifically designed to measure the accounting and financial management skills that drive business performance.Educational Requirements:Bachelor’s degree from accredited universityCMA Certification is two parts Examination: CMA Part 1 and CMA part 2Part 1: Financial Planning, Performance, and Analytics15% – External Financial Reporting Decisions20% – Planning, Budgeting, and Forecasting20% – Performance Management15% – Cost Management15% – Internal Controls15% – Technology and AnalyticsPart 2: Strategic Financial Management20% – Financial Statement Analysis20% – Corporate Finance25% – Decision Analysis10% – Risk Management10% – Investment Decisions15% – Professional EthicsDurationCMA US 6–9 monthsCPA US 9–12 monthsSimilarly after CMA US one can also do CPA US which is recognised in 100+ countries, conducted by AICPA world's largest accounting body.CPA US consists of 4 papersFinancial reporting frameworkAuditingRegulationBusiness economics and communicationExams are in Mcqs and simulation format.In among all CMA US and CPA US helps us to get a job in less time with lot more opportunities across the globe.For more details contact Simandhar Education and follow Sripal Jain for lot more updates over CMA CPA CA.