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
| Valuation BMW Group | BUSM31 – Strategic Financial Management | 2010-10-27 | Group 14 | | | Tutor: Authors: Måns Kjellsson Daniel Hedevåg Jonas Karlsson Mathias Ljungberg Jakob Tuvehjelm Background BMW is one of the ten largest automobile manufacturers in the world‚ with an annual production of 1.3 million cars (2009). It is furthermore one of the leading manufacturers in the premium car segment. BMW Group brand portfolio includes in addition
Premium Automotive industry BMW Volkswagen Group
1. What does it mean if a company “trades at a discount”? Is Amtelecom Group Inc. (AGI) really trading at a discount? If the market value of a stock is lower than its intrinsic value‚ this stock is defined as “trades at a discount”. To figure out whether AGI stock is traded at a discount to comparable companies‚ as its management believed‚ we can simply apply multiple which comes from the average multiple of its comparable companies. Considering fluctuation of future after-tax earnings caused
Premium Weighted average cost of capital Discounted cash flow Cash flow
HW Bond Valuation and Bond Yields Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the following bonds: • Bond A has a 7% annual coupon‚ matures in 12 years‚ and has a $1000 face value. • Bond B has a 9% annual coupon‚ matures in 12 years‚ and has a $1000 face value. • Bond C has an 11% annual coupon‚ matures in 12 years‚ and has a $1000 face value. Each bond has a yield to maturity (YTM) of 9%
Premium Bond Bonds
Seminar Questions – Stock Valuation 1. How much should you pay for the preferred stock of the Dakota Doorknob Company if it has $100 par value‚ pays $8.50 a share in annual dividends‚ and your required rate of return is 10 percent? 2. NDV Corp.’s common stock is expected to pay a $2 dividend‚ which will grow at a compound rate of 4 percent indefinitely. a. If the market requires a 14 percent return‚ what should be the current market price of the stock? b. If the
Premium Stock Stock market
Chapter 6 Bond Valuation 6.5 Duration and Convexity Problem Given a 4-yr treasury bond with a face value of $1‚000‚ an annual coupon rate of 3.20%‚ which had a yield to maturity of 2.53%‚ this bond makes 2 semi-annual coupon payments. Thus has 8 periods until maturity and we are required to determine what the duration‚ modified duration‚ and convexity of this bond is‚ based on the Annual Percentage Rate (APR) and the Effective Annual Rate (EAR). Also‚ we are asked to explain an intuitive interpretation
Premium Bond Time Balance sheet
named HFCL Infotel and promoted by Anant Nahata. It started as a provider of landline services under the brand name ‘Connect’ in 2000. It launched CDMA services in 2007 and GSM operations in Punjab in 2010. The HFCL group held 36% in a joint- Valuation Ratios (Consolidated) EPS +/EV / Sales (X) EV / EBITDA (X) 2013E 2013A Negative Negative 1.69 -15.41 Negative Negative - venture with the Videocon group under the name Datacom – this company had licenses in all circles except
Premium Balance sheet Asset GSM
1.0 Executive Summary In part 1 of this document we analyze Wal-Mart financial condition and results of operations based primarily on its audited financial statements information from 2009-2013. Wal-Mart overshadows its competitors‚ with its US retail sales being over three times those of its nearest rival (in FY2013). We attempt to identify what is driving this business model by analyzing the firm’s asset management‚ capital structure and its ability to generate cash. In doing so we include 2
Premium Wal-Mart Revenue Financial ratios
AFIN838 Business Valuation Department of Applied Finance and Actuarial Studies Faculty of Business and Economics Unit Guide S2 Day Session 2‚ North Ryde‚ Day 2013 Table of Content Table of Content General Information 2 3 Convenor and teaching staff Credit Points Prerequisites Corequisites Co-badged status Unit Description 3 3 3 3 3 3 Learning Outcomes Assessment Tasks 4 5 1. Class Test 2. Group Presentations 3. Assignment 4. Final Examination 5 5
Premium Final examination
VALUATION AND MANAGEMENT OF GOODWILL IN A BUSINESS. INTRODUCTION Goodwill is an intangible element connected with the going concern which include personality‚ reputation‚ the company name‚ convenient and favourable location of the business‚ quality of merchandise‚ efficient management‚ supply and demand for a choice product‚ affordable prices‚ efficient labour relations with employees‚ true and fair view and finally courteous methods of treating customers. Goodwill is often shown on the accounting
Premium Balance sheet Financial statements International Financial Reporting Standards