Premium Essay

Financial Modelling for a Strategic Investment Case

In: Business and Management

Submitted By darshana07
Words 534
Pages 3
STRUCTURE OF THE CASE
• Promoters start business in 2008 in the name of XYZ Ltd. They manufacture product A, B and C and are in the consumer electronics manufacturing industry.
• They pool capital worth Rs 10 crores from personal sources. This is the promoter’s contribution to the business. Equity shares worth 10 crores were issued to promoters, having face value of Rs 10. Shares were issued at par. The founders thus hold 100,00,000 equity shares in the company owning 100% equity in the business.
• In 2012, capital worth 30 crores infused by PE. 20 lakh new shares were issued to PE thus diluting the stake of the promoters from 100% to 83.33%, the PE owning the rest 16.67%.The face value of the Equity Shares of the Company is Rs. 10 each and the Issue Price is 15 times the face value of Equity Shares.The shares were valued as a multiple of 5 times the weighted average EPS for last three years i.e. 2010-2012 considering qualitative factors such as diversified business model and high growth prospects based on valuation of company. The weighted average EPS for 2010-12 is 3 (approx).
• Thus shares are issued to PE @ Rs150 per share (EPS 3* 5 times*face value of share 10)
• PE investment enables company to raise more loans. The capital thus raised, was also used for advertising and brand building thus increasing the net sales of the company by an average of 60%
• Company is raising Debt through Secured Loans hypothecated by company assets as well as Unsecured Loans and a Bank Revolver
• PE exits the business in financial year end of March 2015. It offers its stake for sale in the IPO that the company has planned in May 2015
• In May 2015 the company issues an IPO. The offer is both an offer for sale and fresh issue of shares to public. The IPO will provide liquidity to PE and raise capital for further expansion of business.
• Total 80,25,000 shares are issued to…...

Similar Documents

Premium Essay

Financial Modelling

...Advanced Modelling in Finance using Excel and VBA Mary Jackson and Mike Staunton JOHN WILEY & SONS, LTD Chichester ž New York ž Weinheim ž Brisbane ž Singapore ž Toronto Copyright  2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency, 90 Tottenham Court Road, London W1P 9HE, UK, without the permission in writing of the publisher. Other Wiley Editorial Offices John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, USA Wiley-VCH Verlag GmbH, Pappelallee 3, D-69469 Weinheim, Germany John Wiley & Sons Australia Ltd, 42 McDougall Street, Milton, Queensland 4064, Australia John Wiley & Sons (Asia) Pte Ltd, 2 Clementi Loop #02-01, Jin Xing Distripark, Singapore 129809 John Wiley & Sons Canada Ltd, 6045 Freemont Blvd, Mississauga, ONT, L5R 4J3, Canada British Library Cataloguing in Publication Data A catalogue record for this book is available from the......

Words: 57326 - Pages: 230

Premium Essay

Investment Case

...Cover Letter To the directors of Eagle’s Nest Re: Proposed Investment of USD$ 75 Million in Business Expansion In accordance with our previous discussion, as promised, attached is our proposal to provide business investment plan for Eagle’s Nest Hotels Inc., prepared by the following staffs: Weng Hong Hoh, Kang Yi, Nicklas Ivarsson and Moneeb Aziz. We would like to take this opportunity to thank for all the guidance throughout this project. This proposal contains plenty of information and ideas that we thought are suitable for the company’s strategy. The preferred option for investment, namely Aurora Resorts in Scandinavia Peninsula, has been offered for the consideration of the board and a detailed plan for implementation has attached. We will be looking forward to discuss the plan after you had reviewed our proposal. As always, please do not hesitate to call us or drop us an email if you have any enquiries or if we can be of further assistance. Thank you for your time and attention. Sincerely, Syndicate Group 1, Tutorial 10 – 11, Tuesday. Table of Contents Description | Pages | 1.0 Executive Summary | 4 | 2.0 Introduction 3.1 Background | 55 | 3.0 Investment Ideas 3.1 Eagle Nest Resorts & Spa in South East Asia 3.2 Aurora Resort in Iceland with spa 3.3 Castle by Eagle Nest with wine yard | 6789 | 4.0 Cost and Benefits 4.1 Cost/Income Statements |......

Words: 2961 - Pages: 12

Premium Essay

Portfolio Investment and Financial Planning

...------------------------------------------------- MAF707 Portfolio investments and Financial Planning ------------------------------------------------- Group Assignment Group 77: Weizhe Shi_900443906 Ran Li_210037023 Yichao FU_900387184 Contents Question 1 3 Analysis of securities and the market index 3 Summary 3 Question 2 7 Question 3 8 Question 4. 9 Standard Consumption of CAPM 9 Expectation errors relied on ex-post data 12 Reference List 14 Question 1 Analysis of securities and the market index Summary Firstly we calculated the monthly return of each securities which depend on the data of adjust close price every month. The formula is the latter month’s adjust close price minus the previous monthly adjust close price then divide the latter month’s adjust close price. On the basis of the results, we moved forward the steps that calculate the mean, median, skewnes, kurtosis, variance and correlation coefficients. Those data have been calculated and presented in excels. Definition and Formula 1. Mean The mean value is the average value of monthly return from Jun 2003 to Dec 2010. The formula is: μ=i=1NXiN where N is the number of the month we count of the return and Xi is the total value of the monthly return. 2. Median The median is the value of the middle item of a set of items that has been sorted into ascending or descending order. In an odd-numbered......

Words: 3831 - Pages: 16

Premium Essay

Financial Modelling

...Financial Reporting and Disclosure Corporate governance framework should ensure that timely and accurate disclosure is made on all material matters regarding the corporation, including the financial situation, performance, ownership, and governance of the company Importance of Corporate Governance Disclosures * Stakeholders are paying more attention to what is reported * The global financial crisis has sharpened the lens through which corporate governance structures are held to account and expectations around transparency. * To drive improvements in reputation * Public understanding of structure and activities * Relationships with the communities * Environmental issues Public disclosure is typically required, at a minimum, on an annual basis though some countries require periodic disclosure on a semi-annual or quarterly basis, or even more frequently in the case of material developments affecting the company. Companies often make voluntary disclosure that goes beyond minimum disclosure requirements in response to market demand. A strong disclosure regime that promotes real transparency is a pivotal feature of market-based monitoring of companies and is central to shareholders’ ability to exercise their ownership rights on an informed basis. Experience in countries with large and active equity markets shows that disclosure can also be a powerful tool for influencing the behaviour of companies and for protecting investors. A strong disclosure......

Words: 9232 - Pages: 37

Premium Essay

Investment Case

...Investment Ideas: Expansion of some of the four star hotels in the USA: For this investment idea, an assessment of the four star hotels located in the USA will be carried out. The four star hotels that would have available real estate that can accommodate expansion of the buildings will be considered for this investment. This additional space will be used to build additional facilities such as casinos and hotel-clubs for night life entertainment. Customers will be given membership discount cards for regular use of the hotels. Complementary rooms will be made available to those customers that frequent the use of the casinos, Their casino usage will be monitored by an electronic card, which would be personalised to each customer. Permits, approvals and the necessary licenses for the necessary renovations and modifications to the hotels would have to be sought. The hiring of a reputable architect and contractor that can meet deadlines and work within a specified budget would also be required. To complete this part of the project, an estimated 50 weeks is required. Additionally, all the rooms in the four star hotels will be retrofitted with holographic technology, which will be controlled at a central location. The concept is to offer the customers a customised room that will meet all their desires or fantasises. Examples of this will include converting the room via appropriate software to conform to the environment of any country or to create a scenario that will safely......

Words: 1626 - Pages: 7

Premium Essay

Bus655 Financial Investment

...Week 6 Portfolio Echo Koenig BUS655 Financial Investment Instructor: Keithe Wade June 23rd 2014 The main objective for this portfolio is to invest in companies that have a medium risk. I am part of the middle class society so I don’t want to invest in high risk companies since losing money isn’t an option. I will chose companies that can increase my monetary value in a long period of time, possibly for retirement. The main companies that I am looking to invest in are long term investments with a medium to high risk. I have 3 young children right now that are going to need cars in the future, college funds, and money for their weddings. I do want my savings to be geared towards the future of 20 plus years. The main objective to my portfolio is to save for my children’s’ education in the future. I would like to have about $100,000 per child in the next 18 years. I have three children so I ultimately would need $300,000 in order to have funding for all of their education. You can invest in three different types of investments. The first being a low risk (risk averse), medium risk (risk neutral), and high risk (risk seeker). A risk averse is an investor that will chose the lower risk when they are faced with two investments that have a similar expected return. A risk neutral is an investor that is indifferent to risk. A risk seeker will search for uncertain investments with the highest possibility for return. Two companies that I would invest in for this...

Words: 2971 - Pages: 12

Premium Essay

Strategic and Financial Planning

...Strategic and Financial Planning University of Phoenix FIN / 370 September 9, 2009 Strategic and Financial Planning Every organization should have both a strategic plan and a financial plan. Although these two seem have two different purposes, they are both needed in order for the company to survive. Strategic planning is the process of determining a company’s long-term goals and then identifying the best approach for achieving those goals (Investor Words, 2009). Financial planning is the long-term process of wisely managing finances so you can achieve the goals while at the same time negotiating the financial barriers that inevitably arise in every stage of the company’s goals (FPA, 2009). Upon examining the relationship between strategic and financial planning, we will see how Quizno’s, Family Focus Lawndale and the LaSalle Network each utilize strategic and financial planning. Quizno’s Strategic Planning Initiative Quizno’s is a gourmet sub shop that sells different kinds of oven-toasted sandwiches. At Quizno’s, the store managers are always coming u with new plans and ideas to bring in new customers. Each store has a different type of promotion that is specifically targeted for the store location to drive in new business. The store managers have weekly meeting with the storeowner to talk about ways to increase productivity and reduce waste. The store managers also have monthly meeting with the store employees to see that everyone stays......

Words: 1641 - Pages: 7

Premium Essay

Investment and Financial Analysis

...largest economy within the region just behind Indonesia and Thailand which is more populated than Malaysia and also 29th largest economy in the world[1]. It is also the largest Islamic banking and financial centre in the world. Malaysia was once a country well known with a big variety of natural resources available, from timber, tin, natural gas, petroleum and many more. However, timber may only contribute only a small part to Malaysia’s economy today as a result of government’s intervention in order to protect the environment after serious erosion problem due to massive expansion of the timber industry during the 1960s. Petroleum and natural gas however, are still currently the backbone for the economy of Malaysia, managed by PETRONAS along with a few foreign O&G companies such as ExxonMobil to explore oil fields in Malaysia. The importance of the industry in Malaysia is so significant that 45% of the government’s federal budget relies on PETRONAS dividend. As at 3rd September 2013, Malaysia has 4 billion barrels of oil barrels which is 24th of the world while having 83 trillion cubic feet of natural gas reserves is 15th largest natural gas reserve of the world[2]. Malaysia has an unemployment rate averaging to 3% within 2005-2013. Highest during 2009 which is post financial crisis at the unemployment rate of 3.7% and since then the rate has been lowered. For year 2013, the unemployment rate of Malaysia is 3.2% which is the 6th position among the 10 South East Asia......

Words: 5082 - Pages: 21

Premium Essay

Strategic Financial Management

...Strategic financial management for LULULEMON Introduction Strategic Financial management is the managing and controlling financial resources of the organization to achieve organization common goal. It is a full range of financial information of an organization. It involves with some steps, establish financial objectives, and identify financial resources, collecting analyzing use financial data to make financial decision. Strategic financial management refers to short time objectives as well as long term objectives. It is concerned with handling the element of financial statement such assets, liability, resources, capital , profit etc. it is always find out how we can ensure best use of financial resources of a firm to make maximum profitability. Lululemon athletica is a famous yoga-inspired athletic instrument producer and distributor company, which produces essential clothes and sells international clothing stores from its company base in Vancouver, British Columbia, Canada. Dennis "Chip" Wilson established Lululemon Athletica (usually referred to simply as "lululemon" or "lulu") in 1998 in order to enhancing female participation in athletic and his belief in yoga as the important way to maintain athletic excellence into an advanced age. They make technical athletic instrument for yoga, jumping, dancing, and most other sweaty pursuits. All lululemon locations are very much reachable to our local communities. Lululemon athletica inc., registered on November 21,......

Words: 7830 - Pages: 32

Premium Essay

Strategic and Financial Planning

...Relationship between Strategic Planning and Financial Planning Abstract: A major part of a company's success is planning. It is a process that at best helps the firms avoid uncertainty into the future backward. The companies use two types of planning-- strategic and financial planning. Strategic planning is important for strategic management of companies. Top-level managers plan not just in the context of the current competitive environment but also in the future competitive environment. What future will look like? To try to anticipate this, managers can use scenario planning techniques to plan for different possible futures (Hill, C.W.L. and Jones, G.R. 2009). Lack of effective financial planning demonstrates financial distress and failure for the firm. Financial planning establishes course of action for change and growth in firm (Ross, A.S. et al. 2011). Introduction: Strategic planning is the process of determining the path a company takes, the goals for the business and how to achieve successfully what the company wants. It also encompasses a broader concept of a business plan where projections to be made go beyond financial planning and current market forecasts (Cantoria, s.c, 2011). Whereas financial planning manages the finances over time in such a way that one can meet his/her business needs. The purpose of strategic planning is to give a road-map for the progression of the business. With a good business road map, it is possible to eliminate areas of inefficiency.......

Words: 1152 - Pages: 5

Premium Essay

Financial Investment

...Confidential Financial Investment Opportunities Prepared for: Ms. Joey Lai (Lecturer) Financial Investment Opportunities Banking Academy, Hanoi BTEC HND in Business (Finance) Prepared by: BBQ CLASS: F06B 1 Confidential Table of Contents INTRODUCTION .......................................................................................................................... 3 1.1 Assess the risk tolerance/attitudes of individual investors to risk when evaluating the suitability of investments. ............................................................................................................... 4 1.1.1: Low risk ............................................................................................................................ 4 1.1.2: Mid risk ............................................................................................................................. 5 1.1.3: High risk ........................................................................................................................... 5 1.2 Evaluate a range of investments available from banks, building societies, insurance companies and national savings. ..................................................................................................... 7 1.2.1: Bank .................................................................................................................................. 7 1.2.1: Building society .......................................................

Words: 7109 - Pages: 29

Free Essay

Financial Modelling

...Advanced Financial Modeling Macros © EduPristine – www.edupristine.com/ca Agenda  Introduction to Macros & Advanced Application Building in Excel • Introduction and context  Key Concepts in Macros  Macros as recorded Robots!  Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel  Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro  Debugging VBA code • Errors in VBA • Step into VBA  Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box  Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 2 Agenda  Introduction to Macros & Advanced Application Building in Excel • Introduction and context  Key Concepts in Macros  Macros as recorded Robots!  Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel  Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro  Debugging VBA code • Errors in VBA • Step into VBA  Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box  Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 3 Building user applications in excel requires......

Words: 4063 - Pages: 17

Premium Essay

Strategic Financial Management

...Advantage of franchising – Subway In engaging a franchise business, one will face the pros and cons from the business they operate. There are a lot of benefits prospective franchisees can get from Subway the company provides their franchisees with assistances before and after they open a Subway restaurant. Services provided before opening include an intensive 2-week training, site selection, restaurant design, equipment ordering, and access to product formulas & operational systems. And services provided after opening include, in-depth operations manual, field support, franchise services, research and development, and continuing education (Subway Franchise Training & Investment, Subway Help & Support, n.d.). Apart from the many benefits derived from the cooperation between Subway and the franchisee, there are some more advantages for potential franchisees in buying a franchise business (Franchising 101, 2005), for examples, franchisees can enjoy the advantage of well-established trademark and name recognition of the franchise business. Fred DeLuca, the founder of Subway created the principles which all the ‘Subway’ restaurants needed to follow. High quality, fresh food and customer satisfaction were main things which the franchises needed to keep up. And in 1978, Subway’s success was followed by the opening of its 100th store. The company’s rule in which the bread that was used should be baked in the restaurant itself. This helped increase Subway’s reputation......

Words: 2026 - Pages: 9

Premium Essay

Financial Futures Investments

...FIN-567: Options and Financial Futures Markets Final Project By Jacob C. Harris 19 Dec 2015 The objective of this project is to develop an investing strategy for a portfolio that consists of $500,000 of stock from ten different companies, $500,000 worth of US Treasury notes ranging from two to five years in maturity, and another $500,000 in money markets. The money market investment is considered safe and will provide a return at the risk-free rate. The market outlook for the next 18 months indicates a flat to slight downturn prediction. Given this predication, I developed a strategy of using various call and put options on a few of the stock assets in the portfolio in order to provide some income in a flat to down market. I will write covered calls to generate income and protective puts in order to limit the amount of losses in case of a dramatic drop in the market. The US Treasury notes portion of the portfolio is a ladder strategy consisting of various maturity dates to generate a steady stream of income from coupon payments over the next five years. The money market assets will also provide a steady stream of income at the risk-free rate equal to the rate on three-month US Treasury bills. My hedging strategy is to be conservative in a flat to down market that is predicted for the next 18 months. The portfolio of stocks consists of companies in various sectors of industry in order to diversify the unsystematic risk. I have two......

Words: 1061 - Pages: 5

Premium Essay

Saving, Investment, and the Financial System

...Chapter twenty-six examines how the financial system in America works and analyzes its macroeconomic role. I plan to structure my summary similar to the way chapter twenty-six does. First by talking about different financial institutions and how they work in the U.S. economy. Then by breaking down saving and investment in the national income accounts. Lastly I will explain how government policies affect society’s allocation of resources by manipulating the interest rate. The first thing chapter twenty-six does is explain what a financial system is and why they are needed. A financial system is defined in the book as a group of institutions in the economy that help to match one person’s saving with another person’s investment. Without a financial system, long-term economic growth is not going to happen. Saving and investment allows for higher capital which in return raises productivity and the living standard. Financial institutions allow for the economy's scarce resources to move from savers to borrowers. Savers only provide their money to financial institutions for one reason and that is to gain interest. Interest allows savers to ultimately make money by storing their money in financial markets. Financial markets allow savers to be able to directly supply funds to borrowers. The two main financial markets are the stock market and the bond market. Financial markets are what particularly interest me. Increasing my savings is very important to me and figuring out......

Words: 1223 - Pages: 5