...from Michael Kor's. I will explain my thought process by taking into consideration my own personal risk preferences, interest rates, inflation and what the probability of being paid back might be. Next, a discussion about what the discount rate for $100,000.00 Kor's bond will be explained by using the present value formula from the background readings . In addition to that two other companies (Ralph Lauren and Coach) which are in the same industry will be compared by putting their key stats in a side by side excel chart that will be color coded below. The chart will begin with Ralph Lauren to the left as the company that I would pay less for and Kors will be in put in the center as the one I will pay par for and Coach will be on the right end as the company I would be willing to pay a more for. A conclusion will be made by including which company will be the safest investment. Kors: Beginning with the all the key stats about my chosen company (Kor's ) listed in the center of the excel spreadsheet and the fact that I am a speculative investor I would personally be willing to pay par value for their $100,000.00 bond and will explain my reasons following the included spreadsheet below. The bond price is essentially derived by adding the PV of interest payments plus the PV of the bond principal payment at the end of the year and the PV is computed using the ivestor's required interest rate. The calculation for the present value is calculated as: PV = FV/(1+r)^n...
Words: 1127 - Pages: 5
...How to use Microsoft Excel for financial calculations? Microsoft Office Excel is a great computer program that is widely used throughout the financial industry. Excel is an invaluable tool in Finance and Accounting. Of course professionals also use special financial calculators. But a financial calculator can be expensive for students. It is not intuitive to use and unless they become investment bankers or realtors, most students will never use it after finishing the financial course. Fortunately, it is very easy to create a financial calculator for free if you have Excel on your computer. In fact, an Excel calculator can do much more than a dedicated financial calculator. Another advantage is the fact that if you learned how to use financial functions of Excel you will be able also to use a special financial calculator should the need arise. Below is a short introduction of how to start using MS Excel for financial calculations. Inserting Functions Excel comes with a wide array of functions that can easily be inserted into a spreadsheet. Adding a function is as easy as clicking on the "Insert Function" button on the top tool bar. Insert Function Button If you don't see the "Insert Function" button on your tool bar, you can easily add it by clicking: Tools > Customize > Commands > Find and click on Insert in the left-hand scroll-down menu. Then, find "Insert Function" in the right-hand scroll-down menu and click and drag it to your tool bar. Clicking on the "Insert...
Words: 488 - Pages: 2
...COMM 491 Summer 2015 Team Presentation 1 Industry Analysis Presentation Due: Wednesday, July 29, 8:30am; submitted via email to bernie.maroney@sauder.ubc.ca , and presented in class Format: Presentation: 10 minute in-class presentation of your industry analysis; I would recommend no more than 15 slides (aside from the opening slide and a “thank you/ questions” slide). Each member of your team must be present and must contribute to the presentation, unless other circumstances prevent. Worth 10% of your final grade. Please, no “Presi,” we’re all sick of it, and it isn’t “cool” anymore. Filename protocol: In order to distinguish your file from every other groups, you must name your submitted file as such: COMM491-VSP_Summer2015_IndustryAnalysis_Cohort#_Team# , where Cohort# is either Cohort4 or Cohort 5; and Team# is your team number, such as Team2. Topic: Each team must perform an industry analysis on one of the following industries: * Craft or micro-breweries in B.C. * Food trucks in Vancouver * The cleantech industry in Canada * Private tourism agencies in Canada catering to Chinese tourists. Thus you have different geographic areas to also consider; you must choose your topic and post it on the discussion forum on Connect no later than 1700hrs on Sunday, July 26. No more than three teams in each cohort may choose the same topic. Assignment: Suppose that your team is thinking of starting a new business in the industry chosen. Using Porter’s Five...
Words: 1010 - Pages: 5
...INTRODUCTION TO LEVER BROTHERS PAKISTAN LIMITED LBPL are the largest Consumer Products Company in Pakistan; LBPL belong to Unilever Group of companies, which makes up one of the largest global companies in the world. LBPL was incorporated in Pakistan in 1948 and work started on the present factory at Rahim Yar Khan. In 1951 the Governor General of Pakistan formally inaugurated the factory. Dalda Banaspati was the first product to come out of factory followed by Lux toilet soap in 1954. LBPL pioneered the business of processed animal and poultry feeds in Pakistan when they began their production and marketing in 1960. However due to immense difficulties it was not possible to keep this part of business viable therefore it was closed in 1980. A soap and glycerin factory was established in Chitagong in the then East Pakistan in 1961. However this factory is no longer a part of LBPL as a result of succession in 1971. Surf, first of their non-soap detergent (nsd) powders was launched in 1963. It is produced by arrangement with Futehally Chemicals (Pvt) limited. The present Karachi Edible factory was acquired in 1965 from A&B Oil Industries Ltd. Reconstruction and expansion of the factory was completed in 1994 making it one of the most modern plant in Pakistan. LBPL moved into Personal Products Business in 1981. Further diversification on the food side of business has taken place with the introduction of margarine and cooking oils. In 1994 a state of the art...
Words: 2735 - Pages: 11
...Michael Smith October 30, 2011 IT/206 Final Project Instructor: Nick Cabrera Microsoft® Word® is a program used to create many documents from letters, resumes, flyers, and even legal documents. The use of Word is easy for beginners to learn with little to no skill and become advanced users in a short time. The application is used throughout many businesses, schools’, and home usage. Five common errors and support to solving them: * Editing and placing header and footers can be done through; double clicking the top or bottom of the page and clicking on ‘Insert’ tab. Clicking on either Header or Footer will give you preset templates to give you a quick setup to fill in with the information you would like to insert. If you are creating a document for a business letter, you can be saved as a template for future use and quicker access. This can be done through ‘Quick Parts’, choosing ‘Field’ and adding exactly what you desire your document to look like and highlight you header by clicking to the left of the margin. Click on ‘Header’ again in the group box and ‘Save Selection to Quick Parts Gallery…’ to save this format for easy retrieval later. * Templates can be a timesaver when sending or printing many reports at different times. This can be done with opening a new Word document. Much like setting up your headers and footers, you can create a whole document predesigned and ready to go with only a few areas needing to be filled in. * Inserting pictures...
Words: 1843 - Pages: 8
...FNCE 6330 – Fall 2012 Class portfolio project, part I Due: August 27 Blackboard folder: Project, Parts I&II\Portfolio Project, part I This project has three goals. The first is to compare (contrast?) the investment practices of eight legendary investors to the theoretical methods considered in this class. The second is to give you an opportunity to work with real data, albeit over an unrealistically short time horizon. The third and most important goal is that the investor and stock selection process be interesting and fun. Please do not let it turn into a huge time commitment. The assignment is as follows. Part I 1. Go to the Project folder on our website. There you will find links to the biographies of 8 legendary investors. The chapters describing the investors come from John Train's books, The Money Masters and The New Money Masters. Browse the investor profiles and select an investor that interests you. 2. Read the chapter that describes your chosen investor. 3. Choose one stock that reflects your investor's stock selection style. Links to helpful stock-screening websites can be found in the Webliography on eCollege or External Links on Blackboard. Your stock's price must be reported on the Yahoo! Finance web site (link in Webliography or External Links) and have weekly price data going back to July 5, 2011. 4. Go to finance.yahoo.com and download the weekly price series for your stock. To do this, enter your stock's ticker symbol in...
Words: 679 - Pages: 3
...Digit Scan “Identify You” [pic] CONFIDENTIAL December 12, 2011 For More Information Contact: Michelle Ryerson Justise Villamor Amanda Michielsen Alex Herrick Kayla Mc Kenzie 800-4digits www.digitscan.com Table of Contents Introduction and Overview 3 Products and Services 5 The Market and Competition 6 Sales and Marketing Plan 9 Management Team 12 Go-to-Market Strategy 13 Operating Plan 14 Key Financial Information 16 Capitalization and Use of Funds 18 Exit Strategy or Payback Analysis 18 Notices and Disclaimers 18 Introduction and Overview Digit Scan will provide the Digit scanner for hospitals, doctors, EMT’s as well as any other business and or organization which needs to use data base of information to provide their clients and or patients with the utmost accurate and secure services. Digit Scan will be especially helpful to customers who deal with clients with medial issues or for people who need to identify their customers records in a discreet and accurate manner. The company has a promising future due to the growth rates currently being seen in the biometric field. As the founder of this new business, we are familiar with bring important experience to the business, including [insert a sentence or two describing your experience, include industry experience, startup or small business experience, and even community involvement that shows your character]. I am...
Words: 4937 - Pages: 20
...performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003; emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access. Please be aware that Microsoft Access is only available for Windows users; Mac users may want to seek out a FileMaker Pro Tutorial. Objectives By using this tutorial, you will learn to perform the following operations in Access 2003: • • • • • • Launch Access and identify the parts of the screen. Define fields and field properties constructing table structures. Enter and edit records in a table. Find, sort data. Design custom queries to display data. Import and export data between Excel and Access. Definitions These words are used often in Access so you will want to become familiar with them before using the program and this tutorial. Relational Database: in relational databases such as Access, data is stored in tables made up of one or more fields (Access calls a column a field). The data stored in each 1 column must be of a single data type such as Character, Number or Date. A collection of values from each column of a table is called a record or a row in the table. Different tables can have the same column in common. This feature is used to explicitly specify a relationship between two tables. Values appearing in column A in one table are shared with another table Table: tables are the main...
Words: 3238 - Pages: 13
...have been asked by the MD to prepare a report on the good HRM practices in order to increase employee’s morale and commitment. Your report should address the following issues. a. Different approaches to HRM and the need of Guest’s model of HRM to Excel Accounting There are a variety of ways to approach the management of HR in a business. The business textbooks like to describe two broad approaches to HRM which are explained further below: * “Hard” HR * “Soft” HR * The key features of the hard and soft approach to HR can be summarised as follows: Hard HR Management | Soft HR Management | Treats employees simply as a resource of the business (like machinery & buildings) Strong link with corporate business planning – what resources do we need, how do we get them and how much will they cost | Treats employees as the most important resource in the business and a source of competitive advantage Employees are treated as individuals and their needs are planned accordingly | Focus of HRM: identify workforce needs of the business and recruit & manage accordingly (hiring, moving and firing) | Focus of HRM: concentrate on the needs of employees – their roles, rewards, motivation etc | Key features | Key features | Short-term changes in employee numbers (recruitment, redundancy) | Strategic focus on longer-term workforce planning | Minimal communication, from the top down | Strong and regular two-way communication | Pay – enough to recruit and retain enough staff...
Words: 833 - Pages: 4
...calculating the discount rate, we require the proportion of Equity and Debt in the capital structure using our ABC example. For the capital structure calculations, annual reports of ABC have provided us with the following information on Debt and the Equity related items from the footnotes. The capitalization table of ABC company is as per below. ($ in MM) Short term Borrowings Revolver Bonds Of which Convertible Bonds Convertible Preferred Stock Due Date 15-Aug-09 31-May-10 31-Dec-12 31-May-10 1-Aug-12 31-Mar-14 31-Dec-10 5.2 14.2 80.0 12.0 7.0 Notes 3.2% coupon Due 5/31/2010 7.5% coupon, amortizing Bond Amortizing portion 4.5% coupon, conversion price $25, 1 bond of Fair value $100 converts into 4 shares 9.0 3% coupon, conversion price $20, 1 preferred stock of Fair value $18 converts into 1 share UNDERSTANDING THE CAPITAL STRUCTURE OF THE FIRM Short Term Borrowings: Short term borrowings is an account shown in the current liabilities portion of a company's balance sheet. This account is comprised of any debt incurred by a company that is due within one year. The debt in this account is usually made up of short-term bank loans taken out by a company. ABC needs to pay $5.2 million within one year along with the interest (coupon) of 3.2%. www.educorporatebridge.com Revolver Revolving...
Words: 2396 - Pages: 10
...A - Assigned tasks My position required me to focus on various tasks to support the team. However, on a daily basis, my assignments were not repetitive at all. A few tasks I did had to be done every months or quarters. Below is a list of the main requests I had to fulfil, from the most frequent to the least frequent. - The cornerstone of my internship was to manage an Excel database with more than 5000 lines and 700 columns. This database included all the historical and current information the team could ever need about all of our clients in the UK, Africa, Middle East, central Europe and eastern Europe. For instance, it included data such as the contract terms, the subscriber numbers, the revenue in the contract currency and US dollars for each client. I had to keep it updated to reflect the correct contract terms, the latest subscriber numbers and revenue figures, and add the new clients and remove the ones terminating their contracts. As well, it had to be restated to different monthly FX rates and clearly show our forecasts per month, quarter, and year. This database was frequently...
Words: 2169 - Pages: 9
...Statement 6 Profit and Loss (also called the Income Statement) 6 Balance Sheet 6 8. Appendix 7 1. Executive Summary Write this section last. It should be a page (no longer than 2) and include everything that you would cover in a five-minute pitch. Introduce your company. What product or service do you provide? Who will you be selling to (who are your customers)? What short term goals (1-2 years) and long term goals (3-5 years) do you have for your company? What makes you unique and special? 2. Company Summary This section describes your company. If you are writing a business plan for yourself, you may not need to complete this section. If you are writing the plan to get a loan or to attract investors or partners, then they will want to know about your company. If you decide not to do this section, you SHOULD do the Startup Plan and Funding table. This section includes: Legal entity and ownership - the structure of your company (Sole Proprietorship, Partnership, LLC, Corporation- S or C corporation). If there is more than one owner, detail what percentage each owner owns. Key employees of your business, such as Partners or the CEO, President and Vice President, etc., depending on the structure of your company. Location and facilities – Depending on the type of business you have, the location and type of facilities may be more or less important. For a retail business, the...
Words: 989 - Pages: 4
...Walkthrough Major Study and Learning Features The following section highlights the key features developed to provide you with the best overall text available. We hope these features give you maximum support to learn, understand, and apply operations concepts. C STRAEPYTANDR 2 H AT G E SUSTA Chapter Opener INABILITY Learning Obj LO1 LO2 LO3 LO4 LO5 LO6 ectives Understand the parameters of a sustainable opera Understand the tions and supply competitive dim chain strategy. ensions of opera Identify order tions and supply winners and or chain strategy. der qualifiers. See how strategy is implemented through operatio Introduce the co ns and supply ch ncepts of risk as ain activities. sessment and mi Show how prod tigation. uctivity is me asured and ho supply chain pr w it relates to ocesses. operations and Chapter Outlin e 25 Mi ssi on St at em en ts wi th As pir at ion s be yo nd Ma 26 A Su sta ina kin g a Pr of it ble Op er at ion s an d Su pp ly Ch ain St rat eg y 28 W ha t Is Op er at ion s an d Su pp ly Ch ain Competitive Dim St rat eg y? ensions The Notion of Trade-Offs Order Winners and Order Qualifi ers: The Marketing–O perations Link Operations and Sustainability defi ned Triple bottom line defined supply chain str ategy defined Operations eff ectiveness defi ned Straddling defi ned Order winner defi ned Order qualifier defined e Ris k As so cia system maps defi ned te d wi th Op er at ion s an d Framework Su pp ly Ch ain St rat eg ies 37 Pr od uc tiv ity Supply chain risk...
Words: 3267 - Pages: 14
...Computer Science Chapter 1: Introduction to Computer Hardware Different Categories of Computer and Computing Devices Tablets The lightest and most portable Touch interface, good for “light” work Laptops/Notebooks Larger display area; adds CD or DVD as well as physical keyboard They are portable; price for performance is not as good as desktop, choice of hardware is limited Specialized Variant Laptops Ultrabooks Thinner, and lighter than laptops Cost is higher than laptop (all hardware being equal) Netbooks Cheaper more portable laptop that is smaller and has a lower quality display and overall less powerful hardware Much less common than tablets today Desktop Computers Everything is separate (monitor, computer, keyboard, etc); this allows you to mix and match and customize your desktop computer, at the cost of increased complexity (some compatibility issues may arise – not everything works together) and decreased portability. Larger ‘footprint’ (More space is required, but this allows for increase expandability) ------------------------------------------------- Reduced costs/more options (compared to laptops) ------------------------------------------------- The purpose of an operating system is to run the computer. The operating system determines the interface of a computer, its configurability, and its security. In general, due to popularity and tweak-ability, the MS-WINDOWS (PC) OS has more viruses than the MAC OS. In general, the MAC OS...
Words: 3669 - Pages: 15
...registered in our Hong Kong office. There were key assumption my team and I made in our analysis and they are as follows: 1. We assumed a discount rate of 9% throughout the life of the new capsize. 2. Secondly, we assumed a tax rate of 35% in the United States and a 0% tax rate in Hong Kong. 3. The company policy of only 15 years of service would be upheld with the new capsize. 4. The given spot rates are reasonably accurate throughout the life of the capesize. 5. The charterer offered rate and annual escalation for years 1 through 3 are set in stone. After considering our assumptions we analyzed the data to calculate the free cash flows of the project and were able to come up with the Net Present Value, Profitability Index, and the Internal Rate of Return for the new project. Our calculations are in the attached Excel Workbook under the Investment tab. As you will see in the Excel tab the NWC gained from building the capesize in Hong Kong was $7,149,883, while the NWC from building the capesize in United States created a loss of $1,207,088 for the company. Exhibit 2 it shows the new number of capesizes being built by delivery date. Because of these new capesizes, the demand for them will go down which will bring average daily rates down during this time. But the production of iron ore in Australia is expected to be strong and Indian iron ore will grow within the next few years. So in the short term we can infer that the market will be saturated...
Words: 628 - Pages: 3
