Financial Analysis

In: Business and Management

Submitted By spjgreen
Words 6566
Pages 27
Task 5
Bank Request
A1. Key points of the company’s financial picture that could impact the bank officer’s decision.
Historical Income Statement from the past 3 years:
· Decrease in net sales from year 12. Sales decreased by $434,700 from year 12 to year 13 and only rebounded by $80,500 between year 13 and year 14. The lower level of sales results in a lower dollar amount for gross profit, which decreases the amount left to cover selling, general and administrative expenses and leads to lower operating income. The lower operating income leaves a smaller amount to service debt in the form of interest payments.

· Increase in total general and administrative cost when sales are declining – administrative salaries, executive compensation, utilities and other general and administrative expenses increased as net sales were declining.

· Decrease in operating income will impact ability to service debt.

· Decrease in Net Income will impact earnings per share.

Historical Balance Sheet for past 3 years:
· Decrease in short-term investments without increase in cash. Short term investments sold to purchase furniture fixtures and equipment.

· Decrease in net working capital.

· Cash used to increase furniture, fixtures and equipment, not revenue producing items. Increase in furniture, fixtures and equipment corresponds to increase in general and administrative expenses.
· Decrease in Net income results in decrease in earnings per share

Comparative Pro Forma Income Statements:
· Sales are projected to climb by approximately 75% over the 5 year period of the pro forma statements. The historical sales have been in decline from the base period year 12, while sales are expected to increase each year during the period of the pro forma statements.

· Gross profit is projected to be constant over the 5 year period of the pro forma statements.…...

Similar Documents

Financial Analysis

...FINANCIAL STATEMENT ANALYSIS: A TOOL FOR PERFORMANCE EVALUATION A Case Study of Oceanic Bank By IBRAHIM UMAR PGA/09/07766 M.Sc. Assignment Submitted to Dr. M.I. Kida CNA Department of Accountancy University of Maiduguri 2Financial Statement Analysis: A Tool for Performance Evaluation Jan. 2010 3Financial Statement Analysis: A Tool for Performance Evaluation ABSTRACT Financial statements are prepared to meet external reporting obligations and also for decision making purposes. They play a dominant role in setting the framework of managerial decisions. But the information provided in the financial statements is not an end in itself as no meaningful conclusions can be drawn from these statements alone. However, the information provided in the financial statements is of immense use in making decisions through analysis and interpretation of financial statements. There are various methods or techniques that are used in analyzing financial statements, such as comparative statements, schedule of changes in working capital, common size percentages, trend analysis and ratios analysis. This study intends to analyze financial statement of Oceanic bank in Nigeria in order to come up with an in-depth fact finding on its performance and to see if there is any connection between the recent global economic crisis and its overall performance. 4Financial Statement Analysis: A Tool for Performance Evaluation INTRODUCTION 1.1 Background Financial statement......

Words: 5278 - Pages: 22

Financial Analysis

...Corporate Finance a) WACC A company’s weighted average cost of capital (WACC) is usually regarded as the minimum required rate of return. It is defined as the weighted average rate of return a company must pay to its long-term creditors and shareholders for the use of their funds. When WACC is used as the discount rate, it serves as a screening device in net present value analysis. To calculate WACC we must first find the expected return on share i E(Ri), using the securities market line equation, as follows: E(Ri) = RF + βi (E(RM) - RF) = 3% + 1.2 (13% - 3%) = 15% E(Ri) = expected return on share i E(RM) = expected return on the market = (Market risk premium + the risk free rate of return) = 13% RF = risk-free rate of return = 3% βi = beta of share i =1.2 As such, WACC can be calculated using the following equation: WACC = [D/(D+E)*RD](1-T) + [E/(D+E)*RE] = [40%*6%(1-28%)] + [60%*15%] = 10.728% D = value of total debt E = value of shareholders’ equity RD = cost of debt RE = cost of equity T = corporate tax rate b) NPV, IRR, & Payback Period Assumptions: - Generally speaking, because of difficulties related to identifying costs with particular activities and determining the future benefits, all R&D costs are expensed when incurred. They do not become part of the capitalised investment asset. As such, the €20m OMG has spent on R&D will be excluded from the NPV......

Words: 4150 - Pages: 17

Financial Analysis

...Financial Analysis PepsiCo, Inc. and The Coca Cola have been around for much time exception. Both PepsiCo, Inc. and The Coca Cola Company names have become common house hold around the world today. PepsiCo, Inc. is one of the best in the world of consumer products with many brands of major trading partners and valuable. Division of PepsiCo, Inc. is the second largest soft drinks company in the world, with 21 percent of the beverage market worldwide soft and 29 percent in the United States. The overall mission of adding value to the investment of their shareholders. The company has done this through sales growth, cost control and prudent investment of resources. PepsiCo, Inc. believes that its commercial success depends on the quality of services provided to consumers and customers, products that are safe, wholesome, economically efficient and environmentally friendly, and offer value to investors, while maintaining high standards of integrity (www.fundinguniverse.com). Coca-Cola Company is a leading worldwide consumption of other goods, many countries of the world’s most important and valuable brands. Coca-Cola Company is the largest producer of soft drink sales of 1.3 billion drinks are served every day (www.fundinguniverse.com). Coca-Cola Enterprises red and white logo is the most famous symbol of the world. These companies are mass-produced sparkling and flavored waters for some time and compete in the same market for years. PepsiCo Inc. and Coca-Cola Company is......

Words: 1766 - Pages: 8

Financial Analysis

...Table of Contents Executive Summary Introduction Analysis and evaluation Limitation Conclusion and recommendation References lists Appendices Excusive Summary The aims of this report is to analyze and evaluate the BEACH ENERGY LIMITED, this report will identify the limitation and benefits of the Beach ENERGY LIMITED, In particular, this report will analyze the Ratio of the company, the Horizontal analysis, Vertical analysis and also the trend analysis. Finally, the report will provide conclusions and recommendations. This report was based on the balance sheet, income statement and some professional information from BEACH ENERGY LIMITED. Introduction BEACH ENERGY LIMITED is a long established oil and gas exploration and production organization. The company is based on the Adelaide, South Australia and Beach Energy Limited (ASX: BPT) is a creation of the long-oil and gas exploration and production companies. The company is headquartered in South Australia in Adelaide, through balanced global portfolio of tenements held by the oil and gas reserves and ongoing exploration projects. BEACH ENETGY LIMITED is the major Australian company and was established in 1961. Beach Energy, original beach Petroleum, founded in the early 1960s, registered by the late Dr. Sprigg, a highly regarded Australian oilman, geologist, explorer and environmental experts. With the election of a new board of directors in the 1990s, the company......

Words: 3000 - Pages: 12

Financial Analysis

...  Student Details Surname Azeez Given name Shamina Bhanu Student Number 1232702 Email shamina.azeez@gmail.com   Assignment Details Module name Accounting  & Financial Management Module Code 7AC002     For the attention of Mark Price Due date 14th April 2014   Assignment title Financial Analysis Report   All forms of plagiarism, cheating and unauthorized collusion are regarded seriously by the University and could result in penalties including failure in the unit and possible exclusion from the University. If you are in doubt, please read the following web page.   Student’s Declaration By submitting this assignment I SIGNAL & DECLARE my knowledge and agreement to the following: - Except where I have indicated, the work I am submitting in this assignment is my own work and has not been submitted for assessment in another unit or for any other purpose. This work conforms to the instructions and submission guidelines as contained in the assessment briefing and the module guide respectively.     This submission complies with University of Wolverhampton policies regarding plagiarism, cheating and collusion.   I acknowledge and agree that the assessor of this assignment may, for the purpose of assessing this assignment:   • Reproduce this assignment and provide a copy to another academic staff member; and/or • Communicate a copy of this assignment to a plagiarism-checking service. This web-based service will retain a copy of this work for......

Words: 8199 - Pages: 33

Financial Analysis

...Running head: Financial Analysis Financial Analysis of eBay Barteet, Jodi Table of Contents Progress in the Last Year 3 Balance Sheet Horizontal Analysis 5 Balance Sheet Vertical Analysis 5 Earnings Horizontal Analysis 7 Liquidity Ratio Analysis 8 Profitability Ratio Analysis 9 Long-Term Solvency Analysis 10 Cash Flow Adequacy Analysis 10 Market Strength Analysis 11 Evaluation 12 References 13 Progress in the Last Year eBay Inc. remains one of the few dot-com success stories long after many of its peers were forced into bankruptcy. eBay has been able to make their name synonymous with internet-based auctions; much like Xerox with copiers and Kleenex with facial tissue, eBay is the undisputed market leader in the world of online auctions. Unlike Xerox and Kleenex, however, eBay has been able to branch out from their initial success into multiple lines of business that are proving to be just as lucrative and allow eBay to continue to expand. As their Annual Report states eBay is now “organized into three businesses: Marketplaces, Payments and Communications. Each is a thriving and successful business in its own right.”(eBay Annual Report 2005, introduction). eBay’s core business remains the online-auction marketplace where $44.3 billion in gross merchandise volume was traded in 2005 (eBay Annual Report 2005, Introduction). eBay’s payment service, PayPal, makes transferring money and accepting payments, both critical to its online auction......

Words: 2403 - Pages: 10

Financial Analysis

...Financial Analysis of Coca-Cola and PepsiCo, Inc. Kyla D. Smith XACC/280 Financial Accounting Axia College Financial Analysis Two of the major competing companies that manufacture drinks are Coca-Cola, and Pepsi. They both produce regular water, flavored water, and soft drinks of many kinds. While this essay will explain what vertical and horizontal analysis is, it will also explain each company’s vertical and horizontal analyses. Also the ratios for each company will be given, and several examples as to how each company can improve in their financial status. The financial analysis of both companies is very important so both businesses can understand how they are being managed. It is very important for a company to keep up to date financial documents, audits, taxes, and other financial statements. This is the information needed to show what a company is doing with their finances and what they have done in the past. This information is also very useful for management to use and know what to do differently in future months or years. Information like this allows a company to grow, and have healthy production going forward. Having this data also helps management, investors, and creditors know if there are any issues that have come up in the past that need to be worked on. While in competition, these two companies have continued to grow in size, market value, and profit sales. Since the beginning of their competition, both companies have ventured into new areas of......

Words: 2009 - Pages: 9

Financial Analysis

...Financial Analysis – Week Five Final Assignment ACC 205 Principles of Accounting I July 4, 2000 Financial Analysis As an introduction, financial analysis provides an opportunity to make informed decisions about the health and viability of the company under review. The analysis can be done in several ways, but most commonly the business activities of a particular entity are compared internally from one year to the next. Similarly, the company is compared to an external but similar company in the same industry. Alternatively, one could also compare the activity of the company under review with that of an industry average of similar companies. The various financial analysis techniques used by accountants and analysts are all designed to provide the best possible estimate of financial viability of a company on a go forward basis. The company selected for this project is a publicly held healthcare corporation based in Boca Raton, Florida and named Cross Country Healthcare. As an overview, the company is comprised of three segments: contingent nurse and allied healthcare provider staffing, physician staffing, and other human capital management services, the latter of which provides education and training programs to the healthcare industry, as well as retained search services for physicians and healthcare executives in the United States. Competitors of Cross Country Healthcare would be companies similar to Staff Care, Maxim, Delta Staffing, Onyx MD, and others...

Words: 1702 - Pages: 7

Financial Analysis

...Financial analysis Accountancy Financial analysis (also referred to as financial statement analysis or accounting analysis) refers to an assessment of the viability, stability and profitability of a business, sub-business or project. It is performed by professionals who prepare reports using ratios that make use of information taken from financial statements and other reports. These reports are usually presented to top management as one of their bases in making business decisions. Continue or discontinue its main operation or part of its business; Make or purchase certain materials in the manufacture of its product; Acquire or rent/lease certain machineries and equipment in the production of its goods; Issue stocks or negotiate for a bank loan to increase its working capital; Make decisions regarding investing or lending capital; Other decisions that allow management to make an informed selection on various alternatives in the conduct of its business. Financial analysts often assess the firm's: 1. Profitability -its ability to earn income and sustain growth in both short-term and long-term. A company's degree of profitability is usually based on the income statement, which reports on the company's results of operations; 2. Solvency - its ability to pay its obligation to creditors and other third parties in the long-term; 3. Liquidity - its ability to maintain positive cash flow, while satisfying immediate obligations; Both 2 and 3 are based on the......

Words: 826 - Pages: 4

Financial Analysis

...Financial Analysis The purpose of my paper is to make financial comparisons between PepsiCo, Inc., and Coca Cola. I will be using Vertical and Horizontal analysis, and as Ration Analysis to form my opinion. PepsiCo, Inc. and Coca Cola have been a part of American life for so long that both companies are both taken for granted even though PepsiCo, Inc and Coca Cola are both internationally know the public does not know much about the history of the two corporate giants. Because I am doing a financial comparison of the two, I wanted to know a little history of each company. Pepsi Cola and Coca Cola are two of the world’s best known cola distributers. They have both become strong in the international marketplace. A little knowledge about the history of each company is in order. Pepsi Cola was founded in the late 1890s’ by a pharmacist named Caleb Bradham from North Carolina. In 1961 the Frito Company founded in 1932 merged with the H.W. Lay Company, founded in 1932, to form Frito-Lay, Inc. 1965 Frito-Lay and Pepsi-Cols merged to become PepsiCo, (Our History, 2009). In 1886 in Atlanta Georgia John Pemberton, a pharmacist trying to make a new flavor for a fountain drink invented Coca-Cola. A few doors down at Jacobs Pharmacy he added Carbonated water and started selling his drink for five cents a glass. Pemberton’s book keeper wrote the script still used today. Pemberton passed away just two years later and in 1888 businessman Asa Griggs Candler bought the rights and turned......

Words: 1861 - Pages: 8

Financial Analysis

...Fourth Edition Financial Statement Analysis & Valuation Peter D. Easton University of Notre Dame Mary Lea McAnally Texas A&M University Gregory A. Sommers Southern Methodist University Xiao-Jun Zhang University of California, Berkeley Cambridge Business Publishers To my daughters, Joanne and Stacey —PDE To my husband Brittan, and my children Loic, Maclean, Quinn and Kay —MLM To my wife Susan, and my children Christian, Peter and Philip —GAS To my wife Sharon, my daughter Jasmine, and my parents 滕惠清 and 张祥林 —XZ Financial Statement Analysis & Valuation, Fourth Edition, by Peter D. Easton, Mary Lea McAnally, Gregory A. Sommers, and Xiao-Jun Zhang. COPYRIGHT © 2015 by Cambridge Business Publishers, LLC. Published by Cambridge Business Publishers, LLC. Exclusive rights by Cambridge Business Publishers, LLC for manufacture and export. ALL RIGHTS RESERVED. No part of this publication may be reproduced, distributed, or stored in a database or retrieval system in any form or by any means, without prior written consent of Cambridge Business Publishers, LLC, including, but not limited to, in any network or other electronic storage or transmission, or broadcast for distance learning. Student Edition ISBN 978-1-61853-104-9 Bookstores & Faculty: to order this book, call 800-619-6473 or email customerservice@cambridgepub.com. Students: to order this book, please visit the book’s Website and order directly online. Printed......

Words: 28387 - Pages: 114

Financial Analysis

...Student Number: 10314497 Course Title: MBA (Finance Stream) Lecturer Name: Enda Murphy Module/Subject Code: B9AC106 Module/Subject Title: Financial Analysis Assignment Title: Analysis of Financial Statements No of Words: 3418 (Excluding Citation, Bibliography, Table of Content and Charts) Date of Submission: 12 November, 2015 Table of Content Introduction..............................................................................................................................3 Ratio Analysis of Tata Motors..................................................................................................5 Profitability Ratio.....................................................................................................................5 Gross Profit Margin..................................................................................................................6 Net Profit Margin/Profit for the year (after tax).......................................................................7 Profit before Tax (PBT) Margin................................................................................................8 Return on Equity.......................................................................................................................9 Efficiency Ratio.........................................................................................................................9 Average Receivable Collection Days....................

Words: 4725 - Pages: 19

Financial Analysis

...Financial Statement Analysis – DIRECTV (DTV) On July 24, 2015 AT&T have acquired/merged with DIRECTV, which will enable more customer services. According to form 10K – Annual Report Pursuant to Section 13 or 15(d) of the Securities Exchange Act of 1934: 2015 annual reports were not reported due to AT&T acquisition of DIRECTV. AT&T is now the parent company of DIRECTV. DIRECTV is the leading provider of digital television entertainment service. Its subsidiaries and affiliates companies in the United States, Brazil, Mexico and countries in Latin America, DIRECTV provides digital television services to 19.4 million customers in the U.S. and 9.55 million in Latin America. Perspective The financial analysis will begin with DIRCTV’s 2014 annual report and prior year’s annual report. This analysis is being prepared to gain knowledge on how prosperous paid digital television services has become and realize the financial position and financial ratios of DIRECTV to make decisions as a potential investor. Statement of Cash Flows DIRECTV have input large amount of capital in the operation, investment and financial activities of the company. I took notice on the activities of depreciation and amortizations expense, share-based compensation expenses, equity in earnings, dividends received and excess tax benefits for share-based compensation expense. The company receive tax breaks to giving share-based compensation insurance, such as health, lost wages for employees work related...

Words: 1067 - Pages: 5

Financial Analysis

...three years and also shows the forecast of the company for financial year 2012. This would help investors and researchers to decide on investing to SWM or not. SWM has been analyzed step by step in order to find out its true value in the industry. The analysts have first looked into SWM business and strategy where it has been noted that SWM was a result of merger of seven group holdings and Australian West Newspaper in order to expand and use their resources efficiently. Secondly, SWM accounting policies and procedures have been analyzed where they showed that the company is following the accounting standards and using their flexibility that was given by the standard in order to measure some accounts in the financial statement. This flexibility was compared to the industry where it has noted that the company is valuing these accounts in a proper way. Thirdly, a financial analysis was also undertaken. It has been understood that the company, though there was a merger, is managing their resources well that resulted to positive book and cash returns. Lastly, the forecasts of the said company, where the analyst has determined the company’s value and the full set of financial statement for 2012, were estimated and calculated intelligently. With the help of the four steps of business analysis, the group has recommended that it is safe to invest to seven west media even if merger has occurred twice in the last three financial year. I. INTRODUCTION In order for a......

Words: 1963 - Pages: 8

Financial Analysis

...Financial Data Analysis Jesse Patacsil HCS 577 June 29, 2012 Financial Data Analysis Financial data analysis is the procedure for assessing budgets and other finance-related things to determine the sustainability of a business venture. A financial analysis is used to analyze whether a unit is constant, solvent, liquid, or profitable enough to be invested in by shareholders. When looking at a specific company, the financial analyst will often focus on the income statement, balance sheet, and statement of revenue and expenses statements. In addition, one key area of financial analysis involves comparing the company's past year performance into an estimate of the company's future performance.(Stock Analysis, 2912) On the Balance sheet the patient accounts receivable had a larger allowance for bad debts on the audited version. There was $1,000,000 more in the allowance for bad debts (or doubtful accounts) in the audited version of the financial statements (Patton-Fuller Community Hospital, 2009). This means that the hospital most likely will not collect on this patient accounts receivable and has classified it as a bad debt so it is estimated to result in a loss. The management uses historical data to estimate bad debt but new agreements with managed care payers required an adjustment to the expense and allowance during the audit (Patton-Fuller Community Hospital, 2009). This also decreases the total assets by $1,000,000 in the audited version of the balance......

Words: 778 - Pages: 4