INDIAN INSTITUTE OF QUANTITATIVE FINANCE CERTIFICATE PROGRAM IN FINANCIAL MODELLING IN EXCEL CURRICULUM Advanced Excel (2 Days) (A) Excel Features and Techniques 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. Excel Shortcuts Excel formulae Usage of names to make formulas easier Data Sorting Excel formatting Data Formats Lines and Borders Colours and Patterns Excel functions Excel charts Dynamic Graphs Conditional Formatting Linking worksheets Data Validation Controls
Premium Discounted cash flow Financial statements Spreadsheet
Chapter 9 Stock V l ti St k Valuation McGraw-Hill/Irwin Copyright © 2013 by The McGraw-Hill Companies‚ Inc. All rights reserved. Key Concepts and Skills Understand h stock prices depend on future U d d how k i d d f dividends and dividend growth B able to compute stock prices using the Be bl k i i h dividend growth model U d Understand h growth opportunities affect d how h ii ff stock values U d Understand valuation comparables d l i bl Understand how stock markets work 9-1
Premium Fundamental analysis Stock market P/E ratio
Chapter 9 Stock Valuation at Ragan Engines Input area: Shares owned by each sibling Ragan EPS Dividend to each sibling Ragan ROE Ragan required return $ $ 150‚000 5.08 320‚000 25% 20% EPS 1.09 $ 1.16 (0.32) 0.64 $ 1.97 DPS Stock price 0.16 $ 15.19 0.53 12.49 0.54 23.05 0.41 $ 16.91 ROE 11.00% 14.00% 14.00% 13.00% R 14.00% 19.00% 18.00% 17.00% Blue Ribband Motors Corp. Bon Voyage Marine‚ Inc. Nautilus Marine Engines Industry average Nautilus EPS w/o write-off $ $ $ Prospective
Premium Stock market Stock
Chapter 2 – VALUATION AND CHARACTERISTIC OF BONDS AND STOCKS 1.0 Bonds A bond is a promissory note issued by a business or a governmental unit. Treasury bonds‚ sometimes referred to as government bonds‚ are issued by the Federal government and are not exposed to default risk. Corporate bonds are issued by corporations and are exposed to default risk. Different corporate bonds have different levels of default risk‚ depending on the issuing company ’s characteristics and on the terms of the specific
Premium Bond Bonds
STOCK VALUATION at RAGAN‚ Inc Regan Thermal System Inc was founded 9 years ago by brother and sister Carrington and Genevieve Regan. The company manufactures and installs commercial heating‚ ventilation‚ and cooling (HVAC) units. Ragan has experienced rapid growth because of a propriety technology that increases the energy efficiency of its system. The company is equally owned by Carrington and Genevieve. The original agreement between the siblings gave each 50‚000 shares of stock. In the event
Premium Stock
MARUTI SUZUKI INDIA LTD. Maruti Suzuki India Limited manufactures‚ purchases‚ and sells motor vehicles and spare parts primarily in India and internationally. It offers 15 brands and approximately 150 variants‚ primarily including passenger cars‚ vans‚ utility vehicles‚ sedans‚ SUVs‚ MUVs‚ and life utility vehicles. The company is also involved in the facilitation of pre-owned car sales‚ fleet management‚ and car financing. It operates through a sales network of 1‚100 outlets 801 cities; and 2
Premium Suzuki Maruti Suzuki Dividend yield
increase (decrease) over the past five fiscal years? As per the report of Stock Analysis on Net on Starbucks’ profitability analysis‚ Starbucks’ gross profit margin was 55.75% in 2009‚ and it notably increased to 58.36% in the following year. However‚ the firm’s gross profit margin was decreased by 0.66% in 2011 reaching 57.70%. It was again dropped to 56.29% in 2012. According to the same report‚ in the last fiscal year‚ Starbucks achieved an improved gross profit margin of 57.14%. The recent increase
Premium Bond Stock Finance
discusses the valuation of stocks and bonds. It says that in textbooks‚ the valuation of stocks and bonds is simply stated as the present value of all the future cash flows expected from the security. The concept is logical‚ straightforward‚ and simple. The valuation of bonds is usually presented first‚ since the relatively certain cash flows are broken into an annuity and a payment of the par value at some specific date in the future. Preferred stock valuation follows bond valuation and the value
Premium Stock Bond Preferred stock
Stock Valuation FIN/571 April 13‚ 2015 John Triplett‚ CPA Stock Valuation Intro- Janice A primary “goal for management is to maximize the current value of the firm’s stock” (Parrino‚ Kidwell‚ Bates‚ 2012‚ pg. 12). As a result‚ understanding the true value of stock is beneficial. Stock valuation is important to identify which stocks are more desirable and will maximize wealth. Since stock has an effect on business and one’s own portfolio‚ valuing stock is critical. Several methods to value stock exist
Premium Stock market Stock Fundamental analysis
CHAPTER 10: Stocks and Their Valuation GME – 605 FINANCIAL MANAGEMENT Presented to: Prof. Violeta Josef Presented by: Mildred F. Cacho 1 Learning Objectives: Discuss the types of stocks. Explain the distinction between a stock’s price and its intrinsic value. Identify the two models that can be used to estimate a stock’s intrinsic value List the key characteristics of preferred stock and explain how to estimate the value of preferred stock. 9-2 STOCKS : A type of security that signifies
Premium Stock market Stock exchange Stock