Jet2 Task 1

In: Business and Management

Submitted By elaunch
Words 3057
Pages 13
A1.a. Horizontal Analysis Results Competition Bikes, Inc. has seen a rather large decrease in net sales from the current period (years 7 and 8) versus the period before (years 6 and 7). The decrease is attributable to the current economic situation. The company expects unit sales to increase over the next three years but to still stay below the high unit sales figure of the 4,000 units sold in 2007. While sales have decreased, the cost of goods sold as a percentage to net sales has remained a constant 73%. This show raw material prices and labor have remained fairly constant. Advertising has been cut 16.3% from the two periods as a result of lower sales. Marketing budgets are usually the first expense to be cut in a downturn market, but are not necessarily the most prudent as companies must still fight hard for the available sales which are present. For general and admin expenses, Competition Bikes has stayed relatively flat to expenses from the previous period to current. Utilities are up 11.1%, probably due to higher energy costs. One area that bears investigation is the line “other general and admin expenses” which is up $12,000 or 7.6% over the period while sales have fallen 15%. The most troubling line is “operating income” which has fallen 69.1% while sales has fallen only the 15%. The fact of fixed overhead, salaries, and utilities, which are paid out whether any sales are brought in, are draining company cash much more than sales percentage decline. It also appears the company’s labor figures have remained steady while sales are declining. A cutback of hours or attrition on the production workforce would allow this figure to trend down with lower production units coming off the assembly line. The operating income decline carries to the bottom line where net earnings have fallen 81.6% over the two periods from $196,294 in 2007, to only…...

Similar Documents

Jet2 Task 1

...JET2 TASK 1 Introduction Competition Bikes, Inc. is a large company who during recent years has been affected by the changing population and recession. With this have come changes to the financial status of the company. Analyzing the company’s strengths and weaknesses in multiple aspects with regards to financial stats including working capital, internal controls, risks, and compliance with regulations will allow the company to increase revenue and make a plan for future growth and development. A1a: Horizontal Analysis A horizontal analysis allows comparison of multiple years in a linear fashion, compared with the totals to give a percentage of change (Investopedia, 2013a). The company has many strengths and weaknesses within their financial statements based on the horizontal analysis. The net sales amount for the company is the money the company makes after any deductions, returns, discounts, etc. A weakness for the company is the fact that sales have been down in the last year, showing a net sales change of -15% for years 7 and 8. This is mainly due to the current state of the economy, which has caused a decrease in sponsor sales and funding. A strength for the company is the great potential for an increase in net sales in the coming years. The numbers show that from years 6 to 7 there was a 33.3% increase in sales due to the high demand for the CarbonLite bike products that the professional riders want. Since the company has a highly coveted product and the economy......

Words: 8243 - Pages: 33

Jet2 Task 1

...fits into the overall picture. For example, the cash and cash equivalents in year 8 are 9.7% of the total assets. What that means is CBI has a nearly 10% of its assets in either cash or assets that can converted to cash quickly. Year over year analysis of year 6 to year 7 shows that the total current assets increased from 24.5% in year 6 to 31.5% in year 7. In year 8, the total current assets increased again from 31.5% to 36.8%. Total assets also include property and equipment which is recorded at cost. Each line item before depreciation remains static, while the accumulated depreciation continues to increase. The total assets for year 6 were valued at $4,199,303. Year 7 saw a 2% increase at $4,293,044 with year 8 having a slight dip of .1% at $4,285,831. With the significant decrease in net sales between year 7 and year 8, one might expect to see the assets also drop off at a higher rate. This indicates that CBI manages its assets well. The area that is of some concern, however, is the current liabilities. The notes and notes payable line in year 8 has increased by 33% over year 7 and is 6.1% of the total liabilities and equity. This is significantly higher than year 7, which was 4.6% of the total liabilities and equity. This could indicate that CBI has taken on additional, unnecessary debt given its cash and cash equivalents on hand. A review of this debt increase is needed to determine whether some of it should be paid down using the excess cash on hand. The......

Words: 1130 - Pages: 5

Jet2 Task #1

...Managing Internal Cost and Controlling Finances JET Task #2 Competition Bikes, Inc. Budget Process Budgets are used for forecasting future business growth and outcomes. Providing a comparison between a forecasted budget with previous year’s actual results allows leadership to strategize and plan for the company’s future on past performance. Producing a master budget roadmap for future operations may be done in two ways--by using fixed budget or flexible budgeting processes. There are advantages and disadvantages of each method of evaluation or projection of growth and it is recommended that the leadership of Competition Bikes, Inc, (CBI) consider all options presented to optimize future corporate growth. The CEO of Competition Bikes, Inc. requested a review of current budgetary information (“Year 8”) projection for the upcoming business year. Areas of analysis and management intervention have been reviewed based on data provided by CBI. Competition Bikes, Inc.’s “Year 9” budget (pro forma) has been based on financial information provided based on a current trend analysis from three previous years and focusing on “Year 8” financials. A master budget was created to plan and control revenues and costs for future growth and corporate development for “Year 9.” The benefit to CBI leadership in reviewing “Year 9” financial plans allows for decision-making on planning, coordination of operations, and benchmarking for an evaluation of actual performance at the end of......

Words: 2859 - Pages: 12

Jet2 Task 1

...graduate demonstrates the use of working capital management and working capital acquisition concepts to balance the related trade-off between profitability and risk. 326.4.4: Risk Evaluation and Mitigation - The graduate evaluates internal and external risks and recommends risk mitigation strategies and techniques to an organization. 329.4.6: Government Regulation - The graduate analyzes applicable legal and regulatory requirements to determine whether organizations meet legal responsibilities and act with social responsibility.Introduction: In this task you will use the “Competition Bikes Inc. Storyline” case study to prepare a summary report based on your evaluation of the company’s operations. Task:   Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 1 work.  The evaluator will need a copy of your data to ensure correct evaluation. A.  Prepare a summary report in which you do the following: 1.  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 2.  Analyze the working capital of Competition Bikes Inc. Consider the following in your analysis: •  Ways to improve the working capital •  Ways to use excess working capital to generate an increase in profits 3.  Evaluate the internal controls for the Competition Bikes Inc. purchasing system. a.  Recommend corrective actions for any......

Words: 351 - Pages: 2

Jet2 Task 1

...JET2-Task1 A.1.a Horizontal analysis Horizontal analysis is essentially an analysis on the trend of the financials of the company. It shows changes in the amounts of the amounts over a period of time. In the financial statement provided, the horizontal analysis is between years six and seven, and years seven and eight; respectively. When analyzing the income statement provided with the task, several strengths and weaknesses are very apparent. They will be broken down individually and analyzed separately. Horizontal analysis is calculated by using the formula below ("Horizontal Analysis," n.d.) Income Statement Revenue: Net sales between years 6 and 7 demonstrate a 33.3% increase or an increase in approximately $1.5 million. This is a strength because there were positive sales during this time frame. Positive sales are always a positive finding in business. However, sales between years 7 and 8 demonstrate a decrease in net sales of -15% or $897,000. This is a weakness due to the overall sales being down. Cost of Goods Sold between years 6 and 7 demonstrates an increase of 31.8% or $1,048,000. The costs associated with manufacturing goods are always going to be a big expense. While the cost associated may appear to be a weakness for the company, it actually demonstrates strength for the company. The reason being is the percent change in sales. It closely represents the increase in sales during the same period. If the sales number did not adequately......

Words: 6498 - Pages: 26

Wgu Jet2 Task 1

...JET2 Task 1 I. Evaluation of company’s strengths and weaknesses: a. Horizontal Analysis Results evaluation Net sales increased 33.3% from year 6 to 7 which signifies strength in the company. Increasing sales increases stockholder value and the overall value of the company. Net sales decreased 15% from year 7 to 8 which is a weakness for the company and affects the overall value. Advertising expenses decreased 16.3% from year 7 to 8 as well. This is a weakness for the company because the decrease in advertising can have a direct impact on the sales. In addition research and development was 37.55 from year 6 to 7 and -16.3% from year 7 to 8. Research and development will also have a direct impact on sales and year 7 to 8 shows a weakness in the company for research and development. Net earnings increased 313.4% for year 6 to 7 which is strength. Net earnings increase the value of the company. The net earnings from year 7 to 8 were -81.6% which is a weakness and decreases the overall earnings for the company. Utilities increased from 3.8% from year 6 to 7 and 11.1% from year 7 to 8. This is a weakness because it is an added expense for the company and affects overall earnings. Total operating expenses increased 23.9% from year 6 to 7 which demonstrates a weakness in the company. This decreases earnings and the value of the company. Totals operating expenses from years 7 to 8 decreased 3.6% which shows strength in the company and increases the value...

Words: 1607 - Pages: 7

Jet2 Task 1

...success of the company relies on accountability and transparency and therefore, a financial analysis is completed on a yearly basis. This process is vital to the success of the company as it gives management the foundation with which to base future long and short term goals. Each financial analysis evaluates horizontal, vertical, trend, and ratio results. A1a. Horizontal Analysis is “A procedure in fundamental analysis in which an analyst compares ratios or line items in a company's financial statements over a certain period of time. The analyst will use his or her discretion when choosing a particular timeline; however, the decision is often based on the investing time horizon under consideration” (Investopedia, Horizontal Analysis, para. 1). According to the Income Statements Competition Bikes, Inc. was strong in many areas from year 6 to year 7. Net sales increased by $1,495,000 from Y6 to Y7 which is a 33.3% increase. When looked at with the cost of goods sold which increased only 31.8% or $1,048,000 during the same time period you can see that the company was successful in increasing its gross profit. Gross profit increased $447,000 from Y6 to Y7 or 37.5%. Increased profit is a big strength for the company. Operating expenses were controlled successfully. This is a strength for the company as expenses take away from profits. Selling expenses increased $98,740 or 33.0%. General and Administration Expenses increased $156,440 or 20.4%. Therefore, Total......

Words: 4303 - Pages: 18

Jet2 Task 1

...that the drastic increase in Total Current Assets was the main reason for the increase of Working Capital. The company has the assets on hand to quickly dispose of its Current Liabilities, which is a good thing. The company should take steps to use the Working Capital to pay down some of the increasing Current Liabilities. Additionally, with the next three years of forecast consistent and a competitor who is working to compete for the same market share, Competition Bikes, Inc. should use some of the working capital in Research and Development to maintain their niche and competitive advantage. Additionally, they should invest in more advertising to help maintain and increase market share. These two steps will have a two-fold effect. 1. It will use the excess capital and it should have the effect of increasing profits over time, which is a much better use of the capital than sitting in a bank account earning almost no interest. A3. The purpose of internal control’s according to Horngren are to safeguard assets, encourage employees to follow company policy, promote operational efficiency, and ensure accurate, reliable accounting records (2008). The scenario describes Competition Bikes, Inc.’s purchasing system. The internal controls described are weak as they are vague and lack specific detail. While purchasing does check with three different suppliers to allow for competition between suppliers and ensure they are purchasing equipment at the lowest cost available,......

Words: 4902 - Pages: 20

Jet2 Task#1

...Running head: Financial Analysis Report 1 Competition Bikes, Inc. Financial Analysis Report Western Governors University Financial Analysis Report 2 Competition Bikes, Inc. Financial Analysis Report Analysis must be completed to determine a company’s performance and future viability. The review of income statements, balance sheets, past and present performance will be utilized to predict future company performance. Management of Competition Bikes, Inc. will then use this information to help influence decisions that will meet with company goals. The financial analysis report for Competition Bikes, Inc. (CBI) will include a total of four sections. The financial strengths and weaknesses for years 6, 7, and 8 will be analyzed through utilization of horizontal analysis, vertical analysis, trend analysis and ratio analysis. Secondly, the company’s working capital will be reviewed. Suggestions will be made on how to improve working capital and improve profits. Thirdly, the internal controls within CBI will be reviewed and weaknesses will be identified at this time. Finally, the Sarbanes-Oxley requirements will be detailed and requirements that CBI needs to adhere to for risk reduction and maintain compliance. A1a. Horizontal Analysis CBI years 6 and 7 will be compared first and then years 7 and 8. This will provide a three year time period to analyze. This information will provide insight into CBI business and if business is growing, steady, or falling. CBI net......

Words: 5856 - Pages: 24

Jet2 Task 1

...JET2 Task 1 Horizontal Analysis Results Horizontal Analysis is defined as “a procedure in fundamental analysis in which an analyst compares ratios or line items in a company’s financial statements over a certain period of time. The analyst will use his or her discretion when choosing a particular timeline; however, the decision is often based on the investing time horizon under consideration.” (investopedia.com). This data is calculated in both dollars and percentages using data from the balance sheet and income statement. It is an extremely useful tool to evaluate trend situations. The Horizontal Analysis is used to determine Competition Bikes actual financial operating performance from years 6 through 8, with year 6 as the base year. When I looked at the analysis between years 6 and 7, I looked at the financial changes to see what the actual performance was by percentage. The net sales for years 6 and 7 showed a change of $1,495,000 which is a positive increase of 33%. This shows that sales have increased and leads the company to believe that the operating performance was also good and tha customers/dealers really like the product. There was a change of $1,048,000, an increase of 31%, for cost of goods sold. This shows that there is financial strength for the company and also shows that customers/dealers like the products. When looking at cost of goods sold, they should remain lower that the sales increase so that the company can control the cost...

Words: 5924 - Pages: 24

Jet2 Task 1

...income to get net income available to the common stockholders. Then you will divide that amount by average common stockholders’ equity (Horngren, Harrison, & Oliver, 2008). Competition Bikes had a return on common equity of 8.6% for year 7. Two Wheel Racing had an amount of 8.1%. Competition Bikes had a higher rate of common equity than Two Wheel Racing. This was very positive for Competition Bikes. In year 8 Competition Bikes return on common equity decreased dramatically. This amount decreased to 1.4% in year 8. This was not a positive change for the company. Price/Earnings Ratio Price/Earnings ratio is the ratio of the market price of a share of common stock to the company’s earnings per share. This amount will show the market price of $1 of earnings. This ratio is calculated by taking the market price per share of common stock divided by earnings per share. This ratio also appears in the Wall Street Journal stock listings (Horngren, Harrison, & Oliver, 2008). The price/earnings ratio for Competition Bikes in year 7 was 49.67. When comparing this number to Two Wheel Racings price/earnings ratio of 29.00 is not very good. When basing these two numbers by themselves then Two Wheel Racing is by far the most successful company. This is very true when compared to year 8 Competition Bikes. This amount increased to 96.61. This ultimately means the stock investors for Competition Bikes is paying $96.61 for every dollar that is earned. An average company should have a......

Words: 8569 - Pages: 35

Jet2 Task 1

...Financial Statement Analysis JET2 Task 1 Evaluate the company’s operational strengths and weaknesses: A-1a Horizontal Analysis is defined as the following: A procedure in fundamental analysis in which an analyst compares ratios or line items in a company's financial statements over a certain period of time (Investopedia). Vertical Analysis is defined as the following: “is a popular method of financial statement analysis that shows each item on a statement as a percentage of a base figure within the statement” (Accounting, formanagerment.org). Trend Analysis is defined as the following: An aspect of technical analysis that tries to predict the future movement of a stock based on past data. Trend analysis is based on the idea that what has happened in the past gives traders an idea of what will happen in the future (Investopedia). Ratio Analysis is defined as the following: Ratio Analysis is a form of Financial Statement Analysis that is used to obtain a quick indication of a firm's financial performance in several key areas (Mathis). Competition Bikes, Inc. Comparative Income Statements Revenue Net Sales- The company’s net sales increased from year 6 to 7 by $1,495,000.00 or as the spreadsheet shows 33.3%. This is a very strong in increase. However, year 7 to 8 showed a net sales decreased of -$897,000.00 or -15%. This decrease shows a weakness, it is vital that net sales grow or at least stay even. Gross Profit- Gross profit shows an increase......

Words: 6793 - Pages: 28

Jet2 Task 1

...JET2 Financial Analysis Task 1 Western Governors University Kim Laudig, RN, BSN, MSN 11/01/2014 JET2 Financial Analysis Task 1 A1a Horizontal Analysis Results The Horizontal Analysis Results are taken from Competition Bikes’ Income Statements and their Balance Sheets. A Horizontal Analysis looks at data from one year to the next, usually over a three year span. This company’s Horizontal Analysis is comparing year six to year seven and year seven to year eight. While evaluating the company’s operational strengths and weaknesses, and analyzing the results of the Income Statement for years six, seven, and eight, there were several areas of concern. Years seven and eight shows the most areas of concern for the company. However, while analyzing years six and seven, there were some positive results for the company. During years six and seven, there was an increase in revenue. Net sales increased by 33.3% increase. The cost of goods sold also increased. This was an increase of 31.8%. The fact of increase with both of these analysis showed positive results. The increase of net sales should always be more than the increase in cost of goods. If this does not happen, than the company is spending more on parts and supplies than they are making on goods sold. This also showed the company was able to sell more bikes at a lower cost than they had to spend on the supplies needed to make the bikes. This was proven by the company showing a 37.5% increase in gross......

Words: 5846 - Pages: 24

Jet2 Task 1

...Running head: JET2 TASK 2 1 JET2 Task 2 Budgeting Bonnie Wilson Western Governors University JET2 TASK 2 A.1. Operational Strengths and Weaknesses A.1. Budget Concerns 2 Revenue from sales is budgeted too high. In year 8 Competition Bikes experienced a 15% decline in sales revenue, and yet for year 9, they have budgeted for a 3.2% increase. This is likely to be an overly optimistic projection and relies heavily on economic factors outside of the company’s control. Inaccuracy in this projection will have a negative impact on the rest of the budget. Advertising is budgeted too low. The year 9 budgeted amount of $28,412 represents a 3.5% increase over year 8, but it is still almost 20% shy of the amount spent on advertising in year 7 when sales were at an all time high. If the company is to have any hope of realizing its revenue projection, then the amount budgeted for advertising is too low. Executive compensation is budgeted too high. In year 7 executive compensation increased by $50,000 dollars. This made sense then because sales had increased by 33%. However, holding that number steady in year 8 when there was a 15% decrease, and again in year 9 when even a 3.2% increase is optimistic, is not a financially sound budgeting decision. Research and development is budgeted too low. The budgeted amount for year 9 is $85,237. While this represents the same 1.6% of sales revenue that Competition Bikes consistently allots, research and development is an investment in......

Words: 1470 - Pages: 6

Jet2 Task 1

...| Competition Bikes: Task 1 | | Jamila Mitchell | | Competition Bikes: Task 1 | | Jamila Mitchell | Western Governors University JET2 Financial Analysis Western Governors University JET2 Financial Analysis Competition Bikes: Task 1 Jamila Mitchell Operational Strengths and Weaknesses Horizontal Analysis To evaluate changes in financial statements, a horizontal analysis is necessary so the company can determine whether there is positive or negative growth over time. The changes in percentages is calculated and decisions are made according to the increases or declines. Competition Bikes: Year 7 Overall, year seven was a successful year for the company based on the horizontal analysis of the following financial aspects. Revenue Net sales went from $4,485,000 in year six to $5,980,000 in year seven, an increase of $1,495,000 or a 33.3% increase. The cost of goods sold in year six was $3,294,000, which increased to $4,342,000. This increase of $1,048,000, or 31.8%, was expected considering the increase in net sales. The cost of goods sold remained less than net sales, so this is a strength for the company. While both net sales and cost of goods sold increased, there was still a balance between the two. This shows that the company sold more products at a lower cost, which also attributed to the 37.5% increase in growth profits. Total Selling Expenses Total selling expenses increased from $299,220 in year six to $397,960 in year seven. This......

Words: 5232 - Pages: 21