Live Online Trainings in January (Finance & Business Analytics) - EXCEL, VBA, SPSS, R

Dear Friends

Welcome to the "Learn a new course every week" series of PACEgurus. Every week we conduct one Live Online training in one of the areas (Finance, Investment, Risk Management, Actuaries, Business Analytics, Statistics) using EXCEL, SPSS, R, VBA and Tableau. All the courses are taken by VAMSIDHAR AMBATIPUDI

Pedagogy: Data sets would be taken and the relevant tools and techniques would be applied, interpreted and the corresponding concepts are explained. So the 20 hours you spend will be completely practical in nature.

Multivariate Analytics using SPSS (20 Hours)

Timings:  4-Jan-2016 to 10-Jan-2016 6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered

Multivariate Distributions	Multiple Regression	Principal Component Analysis
Factor Analysis	Cluster Analysis	Discriminant Analysis
Logistic Regression	Correspondence Analysis	Canonical Correlation Analysis
Multi-Dimensional Scaling	Conjoint Analysis	Multinomial Logistic regression

Financial Statement Analysis using EXCEL (20 Hours)

Timings:  11-Jan-2016 to 17-Jan-2016 6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered

Income Statement	Balance Sheet	Cash Flow Statement
Ratio Analysis	Comparing Financial Statements	Financial Activities – Debt, Leases, Post – retirement
Share-holders Equity	Investment Activities – Inventories, Long Term Assets, Intangibles	Investment Activities – Inter-corporate Investments, Derivatives
Operating Activities – Revenue Recognition, Interest, Taxes	Cash Flow Analysis	Du-Pont Analysis

Basic Statistics using R (20 Hours)

Timings:  18-Jan-2016 to 24-Jan-2016 6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered

Overview of R, Reading data into R	Key constructs in R	Data Frames, Vectors, lists, matrices, factors
Central Tendency, Dispersion, Skewness	Covariance and Correlation	One sample and two sample t-tests
Basic Non parametric Tests	Linear Regression	One way ANOVA
Probability Distributions – Normal, Binomial	Basic Charts – Bar, Line, Scatter, Histogram

Macro Programming using VBA (20 Hours)

Timings:  25-Jan-2016 to 31-Jan-2016 6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered

Macro Recording and code reading	VB Editor, Object oriented programming	Variables, Data Types, Collections, Objects
Working with Ranges	Loops – Do Until, Do While, For Next	Decisions – If then Else, Choose
Using EXCEL Formulas	Working with Arrays	Working with Work Sheets
Working with Workbooks	User forms and Controls	Working with Pivot Tables
Working with Charts	User defined functions	Addins

Summary of Key Ratios to assess the financial Health of a Company

Liquidity Ratios

Measure the firm’s ability to meet short-term financial obligations. These ratios measure the firm’s ability to continue to stay in business and to ensure that the firm has enough cash and short-term assets, such as accounts receivables and inventories, to meet short-term financial obligations, such as accounts payables and notes payables. The short term is either one accounting period or one year, whichever is shorter.

Current Ratio = Current Assets/Current Liabilities - Going concern ratio that indicates how many short-term assets the company has for each dollar of short-term liabilities

Quick Ratio = (Current assets – inventories)/Current Liabilities - Distress ratio that measures the company’s ability to meet short-term financial obligations when inventory is not being converted to accounts receivable and cash

Asset Management Ratios

Measure the efficiency of the firm in the use of assets. If a firm holds excess assets, these excess assets will increase the cost of funds and the increased cost of funds will reduce profitability. If asset levels are too low, sales opportunities may be lost, which reduces profitability.

Days sales outstanding = Receivables/( Annual sales/365) - Average number of days to collect accounts receivable

Inventory turnover = Sales/Inventory - Number of dollars of sales generated each year for each dollar of inventory which measures sales efficiency and measures the number of times a year that inventory is sold

Net fixed assets = Sales/Fixed Assets - Number of dollars of sales generated each year for each dollar of net fixed assets

Total assets turnover = Sales/Total Assets - Number of dollars of sales generated each year for each dollar of total assets

Financial Leverage Ratios (Debt Management Ratios)

Indicate the extent to which a company uses debt to finance assets. The use of debt will increase a firm’s return on equity (ROE) if the firm earns more on its assets than the interest rate on debt and, at the same time, increased financial leverage will increase the variability of net income.

Total debt ratio = Total Debt/Total Assets - Proportion of assets financed with fixed costs financing debt. Proportion of funds provided by creditors and debt holders. Includes both current liabilities and long-term debt. Creditors and bond holders prefer a lower debt ratio.

Debt to Equity Ratio = Total Debt/Owner’s Equity - A higher ratio indicates more financial leverage and more risk

Equity multiplier = Total Assets/Owner’s Equity - Indicates how many additional dollars of assets the company can buy for each additional dollar of equity

Times interest earned = EBIT/Interest - Indicates the extent that EBIT can drop before the company does not have sufficient earnings to cover interest expense. Failure to make interest payments is an act of bankruptcy

Profitability Ratios

Measure a company’s overall efficiency and analyze the relationship between sales and expenses.

Operating Margin = EBIT/Sales - Ratio of the difference between revenues and operating costs and sales . Operating profit per dollar of sales.

Basic earning power = EBIT/Total Assets - Difference between revenues and operating costs and total assets

Net profit margin = Net Income/Sales - Measures the overall operating efficiency of the company. Proportion of revenue earned by the company

Return on assets = Net Income/Total Assets

Return on equity = Net Income/Owner’s Equity - Proportion of profit generated for each dollar of equity

Market based Ratios

Show the value placed on the company by shareholders. Value of the firm is equal to the market capitalization (number of shares outstanding * price per share) of the firm.

Earnings per share = Net Income/Number of shares outstanding – Net Income earned for each share

Price-to-earnings (P/E) = Market Price per share/Earnings per share - Number of dollars investors are willing to pay for each dollar of earnings

Book value per share = Owner’s Equity/Number of shares outstanding - Stock price based on the accounting value of the firm

Market to book value = Stock price per share/ Book value per share – Number of dollars that investors are willing to pay for each dollar of assets in the company

Dividends per share = Dividends/Number of shares outstanding - Proportion of net income paid in dividends

Dividend yield = Dividend per share/Stock Price

Payout ratio = Dividend per share/ Earnings per share

Retention ratio = (1 – payout ratio)

Different Types of Corporate Restructuring Activities

·         Merger - Any transaction that forms one business enterprise by two or more formerly independent business entities. One company legally absorbs all assets and liabil­ities of the other. Generally negotiated and are friendly

·         Consolidation – Special form of Merger. Combines two business entities and creates a new one

·         Acquisition – Purchase of a controlling interest in a firm and involves transfer of ownership

·         Tender Offer - One firm or person makes an offer directly to the shareholders of the target to buy their shares at specific price. Can be hostile if this offer is made without the approval of board of directors of the target

·         Restructuring - Changes in orga­nization, operations, policies, and strategies to enable the firm to achieve its long term objectives

·         Spin off – Some parent company’s shareholders give up their shares and receive shares in the subsidiary of that value

·         Split up - Division of a company into two or more separate companies. Involves the entire company rather than a subsidiary

·         Equity Carve Out – Parent firm offers some of the subsidiary’s common stock to general public and infuse cash into the parent without losing control

·         Divestiture – Sale of a segment of a company (Asset or Product Line or a Subsidiary) to another party for cash and or securities

·         Industry roll ups - Consolidator acquires a large number of small companies with similar operations. Profit maximization or revenue maximization is achieved by economies of scale in purchasing, marketing, information systems, distribution, and senior management

·         Takeovers or buyouts - Change in controlling ownership of a corporation

·         Leveraged Buyouts - A small group of inves­tors purchases a target company by financing the acquisition largely by borrowed funds

·         Leveraged Recapitalization - Defen­sive reorganization of the company’s capital structure. Outside shareholders (non­-management) receive a large, one-time cash dividend and inside shareholders receive new shares of stock.

·         Greenfield Investment - Investment in a new project involving the con­struction of a new building, purchasing of new machinery and equipment, hiring of managers, administrative staff, and production workers. Investors create a new business entity.

·         Cross-border M&A - FDI through which an existing business in part or in its entirety is acquired in a host country

·         Foreign direct investment (FDI) - Investment in a for­eign country and can assume greenfield or cross-border M&A form

Understanding Investments - Workshop for the Corporate

www.pacegurus.com announces a workshop on "Understanding Investments" for the corporate covering the following attached topics. If your organization has requirement, please do get in touch with us at +91-98480 12123. Any customizations also can be accommodated.

Theme	Topics Covered
Investment Choices	·         Ownership Investments (Stock Markets, Real Estate, Business), Lending Investments, Options and Futures, Precious Metals, Collectibles
Risk vs. Return	·         Understanding Risks – Market value, Individual Investment risk, Purchasing power risk ·         Analyzing Return – Components, Money market returns, Bond, Stock, Real Estate, Small Business Returns ·         Goal Setting
Planning	·         Emergency Reserve, Debt Evaluation, Financial Goals, Savings rate and Investments rate, Retirement Plan, Tax Plan, Right Investment Mix (Age, Investment Options), SIP
Stocks and Bonds	·         Modes of raising capital, IPO, Understanding Financial Markets and Economics, Market Efficiency, Drivers of Movement, Brokerage firms
Stocks in Depth	·         Market, Stock Market Indices, Stock buying methods, Mutual Funds, Right time to buy and sell, P/E, Speculative excess, Problematic stock buying practices ·         External Research (Independent brokerage, Financial Publications, websites, Fund manager picks) ·         Annual reports and other useful corporate reports
Bonds in Depth	·         Types of Bonds – Maturity, Probability of Default, Credit Rating ·         Buying bonds – Pricing, Other lending instruments
Mutual Funds and Exchange Traded Funds	·         Benefits of Best Funds, Successful fund investing drivers ·         Fund portfolio with asset allocation, Best Stock funds and Bond funds, Balanced Funds, Money Market Funds
Real Estate	·         Invest in Home – Ownership, Amount to spend, Property type, Location etc. ·         Attractions for real estate investment, Direct vs. Indirect property investments, ·         Financing – Types of mortgages, Closing the deal, Selling real estate

Why Do People Use Python?

Python is a general-purpose programming language that is often applied in scripting roles. It is commonly defined as an object-oriented scripting language

Because there are many programming languages available today, this is the usual first question of newcomers.The choice of development tools is sometimes based on unique constraints or personal preference

Software quality - Python’s focus on readability, coherence, and software quality and hence reusable and maintainable and makes it easy to understand, even if you did not write it. Python has deep support for more advanced software reuse mechanisms, such as object-oriented programming (OOP)

Developer productivity - Python boosts developer productivity many times beyond compiled or statically typed languages such as C, C++, and Java. Python code is typically one-third to one-fifth the size of equivalent C++ or Java code - Less to Type and Debug and less to maintain. Python programs also run immediately without the lengthy compile and link steps required by some other tools

Program portability - Most Python programs run unchanged on all major computer platforms. Porting Python code between Linux and Windows, for example, is usually just a matter of copying a script’s code between machines

Support libraries - Python comes with a large collection of prebuilt and portable functionality. This library supports an array of application-level programming tasks, from text pattern matching to network scripting. Python’s third-party domain offers tools for website construction, numeric programming, serial port access, game development etc.

Enjoyment - Because of Python’s ease of use and built-in toolset, it can make the act of programming more pleasure than chore