...Financial Analysis (COURSE CODE: JET Task 1) A1 a. Horizontal Analysis Results Income Statement Based on the review of Competition’s Bike’s Horizontal Analysis, revenue shows a decline of $897,000 or 15% in Year 8 compared to Year 7. The decline was mainly due to the current economic conditions. This also resulted in the decline in gross profits by $266,600 or 16.3%. The selling expenses of the company fell by 14.9%, compared to a 16.3% decline in the gross profits from year 8 to Year 7. Most of their customers are expert riders, who are supported. Several of the supporters have reduced on the financial support to the cyclists. The cost of goods sold for Competition Bikes, Inc. declined 14.5% in Year 8, a 31.8% drop contrast to Year 7. Even though it does draw a parallel to earnings the decrease was not significant. Selling costs such as advertising, website creation and sales commissions, distribution network support, maintenance, and transportation showed declined by 14.9 %, a slump from 33% in Year 7. This decrease in the cost between goods sold and the selling expenses are full force for the company. The General and Admin expenses such as administrative supplies, executive compensation, employment taxes, utilities, payroll services, research and development, depreciation expense and more showed a slight increase of 1.2% in Year 8. The increase in general administrative expenses is due to a 11.1 % increase in utilities, a 7.6% a raise in other general and...
Words: 4547 - Pages: 19
...amounts as the percentage of the total amount taken as 100 (businessdictionary.com, 2014) will also be shown. In a balance sheet, for example, cash and other assets are shown as a percentage of the total assets and, in an income statement, each expense is shown as a percentage of the sales revenue. Financial statements using this technique are called common size financial statements. (businessdictionary.com, 2014) In order to assist the company in determining the possibilities over the next few years, included in this report will be a trend analysis which is a method of time series data (information in sequence over time) analysis involving comparison of the same item (such as monthly sales revenue figures) over a significantly long period to (1) detect general pattern of a relationship between associated factors or variables, and (2) project the future direction of this pattern (businessdictionary.com, 2014). The final form of financial analysis to be covered is ratio analysis, which, is...
Words: 5976 - Pages: 24
...Financial Statement Analysis and Controls Prepared for Competitive Bikes, Inc. Horizontal Analysis Using a horizontal analysis of the income statement for Competitive Bikes, several things stand out. Years 6 and 7 Comparing Years 6 and 7, the company did very well. They saw a 33% increase in net sales during Year 7, which gave them a 31.8% increase in cost of goods sold. Subtracting the dollar amounts of cost of goods sold from net sales yields an increase of 37.5% in gross profit for Year 7. Increasing profit is, of course, the main goal of a company, which made Competitive Bikes quite successful in Year 7. Perhaps part of the reason for the increase in profits was that Competitive Bikes increased the amount spent on advertising by 37.5%, and had an increase in research and development of 37.5%. As learned in the Supply Chain Management class given by Western Governor’s University, both an increase in advertising and in research and development will lead to an increase in profits. With extra sales come extra expenses. Total selling expenses increased by 33% and general and admin expenses increased by 31.1%. This is not a problem, because the company was still quite profitable. These numbers would only be a concern if the company had not had such an impressive increase in net sales. In Year 7, Competitive Bikes saw their net earnings jump from $47,479 to $196,294, which figures out to a 313.4% increase. This means that Competitive Bikes...
Words: 5430 - Pages: 22
...The first option is to reproduce the whistle and package it for the cost of $100,000. We could discuss what the comfort level is with the school district in shipping the product a little later and reassure them that the lead problem has been addressed and corrected. They should be informed that a minimum of two weeks will be necessary to correct the error. Although key members of the school system may be disappointed, I believe that they will appreciate our honesty and the fact that we are trying to produce a safe and quality product. This honest approach to the problem should serve to preserve our integrity with the customer and that is why I offer this scenario as a possible repair to our situation. There is of course the possibility that the school will opt not to use us again for future business and begin trading with a competitor. This is a risk that we must take as this risk is much less than the risk involved in a child’s health, our reputation, or being presented with a class action lawsuit. The next option would also cause our company to incur loss, but it would mitigate the amount needed to finance another production run. One positive factor on our side is that at least we didn’t see a loss from shipping. Being that these items are still resident within our warehousing, we can simply dispose of them by means supported by the EPA. The option is to simply let the customer know about the mishap and offer to refund their money on the whistle only. That of course could only...
Words: 310 - Pages: 2
...A.1 Throughout this paper, the “Competition Bikes Inc. Storyline” case study will be used to prepare a summary report based on the evaluation of the company’s operations. The objective will be to evaluate the company’s operational strengths and weaknesses based on the following: a. Horizontal analysis results b. Vertical analysis results c. Trend analysis results d. Ratio analysis results As defined by Business Dictionary (2014) Horizontal Analysis is ” Comparative study of a balance sheet or income statement for two or more accounting periods, to compute both total and relative variances for each line item.” Competition Bikes Inc. will be analyzed in each area in regards to years 6, 7, & 8. Analyzing the strengths and weakness of the operations throughout the discussed years will take place throughout the assignment. The Strengths of Competition Bikes Inc. will first be analyzed and discussed. Firstly, Revenue will be analyzed for years 6 & 7, in which there are strengths concerning Net Sales. From year 6 to 7, Net Sales increased by $1,495,000, a 33.3% increase for Competition Bikes Inc. Year 7 was a much stronger year concerning Net Sales for Competition Bikes Inc., compared to year 6. A second strength within the Horizontal Analysis is the Cost of Goods Sold for year 7, compared to the previous year. The COGS increased to $1,048,000, which is a 31.8% increase. This is significant due to the fact that the Net Sales enjoyed a much larger increase compared to the Cost...
Words: 3522 - Pages: 15
...Horizontal analysis results Horizontal analysis compares the company’s finances over several years, with a base years for comparison. Competition Bikes uses year 6 as the base year, and a comparison of changes from year 6 to 7 and then with years 7 and 8. The strengths are mostly for year 6 to year 7. Net sales were $4,485,000 for year 6 and increased by $1,495,000 to $5,980,000 in year 7. Then from year 7 to 8 there is a decline in sales by $897,000 this decrease was the major weakness. The cost of goods in year 6 equaled $3,294,000 then increased in year 7 by 32.8% to $4,342,000. The Gross profits were up 37.5% in year 7 compared to year 6 for a growth of $447,000. The operating expenses increased due to the increase in sales from year 6 to 7. This is always a strength when you a company spend more because they are making more money. Advertising could have played a role in the increased sales. They spent the greatest amount of money on year 7, which was $32,760. There was a decreased in advertising expenses in year 8, by 16.3%. The company had fixed percent that they spent in sales commissions, distributions, network support, and transportation out, which all increased 33% from the 6th to 7th year and decreased 15% from the 7th to the 8th. The overall selling expenses were $299,220 in year 6 and increased to $397,960 (+33%) year 7 and then decreased to $338,748 (14.9%) year 8. Competition Bikes selling expenses were high for the 6th to the 7th year, but they managed to regain...
Words: 4327 - Pages: 18
...Financial Analysis Summary Report Task 1 Competition Bikes Incorporated Lisa A Castro, MSW Western Governors University Horizontal Analysis (A. 1. a) A horizontal analysis can be defined as “the study of percentage changes in comparative statements” (Charles T. Horngren, 2008, p. 746). It is useful in determining a company’s financial stability. This section will analyze Competition Bikes Incorporated’s (CBI) percentage changes from years 6 to 7 and then 7 to 8. The report will include an analysis of CBI’s comparative income statement and balance sheet. Between years 6 and 7 CBI’s Net Sales increased by 33.3% for a change of $1,495,000. The increase of 33% indicates strength for the company because it means that the company has become more profitable. This also indicates that demand for CBI’s product has increased and that their marketing strategies have been more successful. It is good news for the shareholders because more profits means more revenue. Between years 6 and 7 CBI’s Cost of Goods Sold increased by 31.8% for a change of $1,048,000. Even though the Cost of Good Sold increased significantly it is still less than the Net Sales increase of 33.3%. This resulted in a Gross Profit of 37.5% or $447,000. This indicates strength for CBI, as the management was able to control their costs to turn a profit on the increased sales. This is also a positive for the shareholders because increased profits mean more revenue for the shareholders. Between...
Words: 6540 - Pages: 27
...Competition Bikes Inc. Summary Report 2014 Here is the Horizontal Analysis for years 6 and 7 for Competition Bikes Inc. Income Statement Sales Revenue: Net sales for Competition Bikes Inc. increase from $4,485,000 to $5,980,000, which was an increase of 33.3% for the year. This is a strength for the company since it shows that the demand for Competitions Bike’s product has increase over the year. This figure should also make stockholders very happy since the money the company makes helps determine the stock price. In this case it was a positive increase so it’s stock price should reflect a positive increase as well. Cost of Goods Sold: Cost of Goods Sold (COGS) increased from $3,294,000 to $4,342,000, which was an increase of 31.8% for the year. The increase in COGS is not necessarily a bad thing (strength) for Competition bikes. The COGS should be in tandem with sales revenue since more products sold mean more goods to be produced. In this case the increase of COGS was slightly below the 33.3% increase in sales revenue which shows that some efficiency’s were made in the company. Gross Profits: Gross Profits showed an increase of $447,000 ($1,638,000 - $1,191,000) which is to be expected since net sales increased for the year. With an increase in efficiency (as mentioned in COGS) this figure should be increase as well. Having a increase in Gross Profit also states that Competitions Bike's product is selling very well and/or they have limited availability...
Words: 8250 - Pages: 33
...Competition Bikes, inc, Executive Summary Report * Skip to Navigation * Skip to Content ------------------------------------------------- Top of Form Bottom of Form Horizontal, Vertical, Trend and Ratio Analysis The assessments of the financial health of Competition Bikes, Inc. (CB) are derived using the attached income statements and balance sheets. Focusing on calendar years # 6, 7 and 8 to gauge the growth and stability of this company. Between the years # 6 and 7, Competition Bikes, Inc. had a significant growth in new earnings that was not extended on into year # 8. The net earnings moved from a positive 313.4 % to a dramatic loss of 81.6% . A.1.a) Horizontal Analysis Results Horizontal Analysis is a direct comparative analysis of each line item across the same time frames of a particular company. It is calculated in dollars and percentages. An analysis will look at how the accounts have fluctuated from one year to the next. The formula used is: Dollar change = This Year’s Balance – Last Year’s Balance. Percent change = Dollar Change . The income statement from year # 6 to year # 7, exhibited a sales increase of 33%. There was only a 31 percent increase in product costs. This decrease in cost of materials was offset by sales expense of 33 percent and an increase in general operating espense – totaling 20 percent.. These line expenses both increased from year # 6 through year # 8. These increases offset the profit from...
Words: 5051 - Pages: 21
...Competition Bikes Summary Report Sherri Silva Western Governor's University Abstract Competition Bikes, Inc. is a successful business that makes bikes for professional cyclists helping them to live their dreams and compete in major cycling events to include triathlons and other competitive cycling sports. After three years in business, Larry Ferguson, the business owner decided to take the company public in efforts to gain the capitol needed to build the current two manufacturing facilities. Both facilities are staffed to manage an increase in bike sales if necessary. Competition Bikes, Inc. is unique in that it really honors the quality and design of the bike being sold. Money is spent on research in efforts to ensure the lightest most custom bike is offered to its customers. The company also invented the CarbonLite which was the first designed bike to offer drive shaft technology. Although Competition Bikes, Inc. has experienced tremendous success over the past eight years in business, they have also experience a 15% sales decline over the most recent years. It is imperative that a financial analysis take place in efforts to trend where the financial issues are arising from allowing Competition Bikes, Inc. to explore other means of increasing profit margins. In completing a financial analysis for Competition Bikes, Inc. one must analyze financial data to include performing a horizontal analysis. This type of analysis is designed to show trends or changes between years...
Words: 4532 - Pages: 19
...company. There are quite a few difference analyses that could be used. One such analysis is Horizontal analysis. In Horizontal analysis the changes and difference are an indication for further analysis. Horizontal analysis on its own will help identify potential issues, but even better would be to compare this company’s Horizontal analysis with similar companies in the same industry. Using dollars for the analysis can be deceiving, even within the same industry. A solution to the skewed numbers is to use percentages when comparing multiple companies allows the comparison to be reviewed on an even ground. An example would be company A and companies B both have an increase in earnings of $100,000. Company A has total earnings of $1 million, a ten percent increase, and company B $10 million, only a one percent increase. The smaller company will be happier with the increase then the larger. Within the industry, trends can be identified and corrected before they are out of control. A downfall to Horizontal analysis is that the numbers change from day to day. It is helpful to conduct this analysis as soon as the financials are available to prevent further loses. Another downfall to Horizontal analysis is the data can be manipulated, to an extent. The management can portray the scope of data to reflect what the management would like to reviewer to interpret from the analysis presented. An example would be the year chosen for the base year. Carefully choosing...
Words: 3872 - Pages: 16
...Course Project – Part I Task 1: Assessing loan options for Air Jet Best Parts, Inc. The company needs to finance $8,000,000 for a new factory in Mexico. The funds will be obtained through a commercial loan and by issuing corporate bonds. Here is some of the information regarding the APRs offered by two well-known commercial banks. Bank APR Number of Times Compounded National First Prime Rate + 6.75% Semiannually Regions Best 13.17 Monthly 1. Assuming that Air Jet Parts, Inc. is considering loans from National First and Regions Best, what are the EARs for these two banks? Hint for National Bank: Go to the St. Louis Federal Reserve Board’s website (http://research.stlouisfed.org/fred2/). Select “Interest Rates” and then “Prime Bank Loan Rate”. Use the latest MPRIME. Show your calculations. (25 pts.) Bank Prime Loan Rate as of Jan 26, 2013 – 3.25% according to the Federal Reserve Bank of St. Louis. National First - EAR EAR = (1+(Prime Rate +6.75%)/2)^2-1 EAR = (1+(3.25% + 6.75%)/2)^2–1 EAR = (1+.10/2)^2–1 EAR = (1.05)^2-1 EAR = 1.1025-1 EAR = .1025 EAR = 10.25% Regions Best - EAR EAR = (1+13.17%/12)^12-1 EAR = (1+0.010975)^12-1 EAR = (1.010975)^12-1 EAR = 1.13995-1 EAR = 0.13995 EAR = 13.995% EAR = 14% 2. Based on your calculations above, which of the two banks would you recommend and why? Explain your rationale. (25 pts.) I would suggest that Jet Air go with National First to get their loan. I say this because of the lower...
Words: 901 - Pages: 4
... | |Qualification |Unit number and title | |BTEC Level 3 Extended Diploma/ Subsidiary Diploma in Business |Unit 2: Business Resources | |Assignment no and title | Assignment 1 : Know how human resources are managed | |Criteria reference|To achieve the criteria the evidence must show that | | |Task No | | |the student is able to: | | | | |P1 | | | |Task 1 | | |Describe the recruitment...
Words: 596 - Pages: 3
...[Company name] [Company address] Marrketing principles Contents Introduction 2 Learning Outcome 01 2 Task 1 2 Task 2 4 Learning Outcome 02 5 Task 3 5 Task 4 10 Task 5 12 Learning Outcome 03 12 Task 6 12 Task 7 13 References: 13 Introduction British Airways (BA) is the banner bearer aerial shuttle of the United Kingdom and its biggest carrier focused around armada size, universal flights and global ends. At the point when measured by travelers conveyed it is second-biggest, behind Buisness jet. The aerial shuttle is situated in Waterside close to its primary center point at London Heathrow Airport. A British Airways Board was built by the United Kingdom government in 1972 to deal with the two nationalized aerial shuttle companies, British Overseas Airways Corporation and British European Airways, and two littler, provincial carriers, Cambrian Airways, from Cardiff, and Northeast Airlines, from Newcastle upon Tyne. On 31 March 1974, every one of the four organizations was consolidated to structure British Airways. After very nearly 13 years as a state organization, British Airways was privatized in February 1987 as a feature of a more extensive privatization arrange by the Conservative government. The transporter soon stretched with the securing of British Caledonian in 1987, took after by Dan-Air in 1992 and British Midland International in 2012. British Airways is an establishing part of the one world aerial shuttle union, alongside American...
Words: 6241 - Pages: 25
...in Alberta, Canada. Kelly's father was a successful larvyer in Calgary, and her mother was a high school English teacher. Kelly had an older sister, Laurel, 27 , who had just passed the bar exam and was working fbr a corporate law firm in Edmonton. Kelly had studied Japanese in high school and in university and spoke and wrote the language quite well. When she was 15 years oid, Kelly spent tbur months in Japan on a school exchange. She had enjoyed the time she spent there and ahvays planned to return one day. Upon graduating tiom high school. Kelly lvent to the University of Alberta, in Ednonton, to stucly nlarragement. During her final year at the universitv, Kelly heard some of her friends talking about the Japan Exchange and Teaching (JET) Program. She rvas told ihat it rvas quite easy to get accepte(l-all an applicant needed was a university deglee and an interest in Japanand that it rvould be a...
Words: 2608 - Pages: 11
