...Financial Analysis – JET2 Task 1 Report for Competition Bikes, Inc. Competition Bikes, Inc was formed in 2001 and manufactures professional and performance bicycles used in a variety of racing events for expert riders. Bicycles produced by this company are ridden by 60% of all race winners and word of mouth has been their main marketing strategy. Competition Bikes is also the first company to use drive shaft technology in their bikes, which sets them apart from their competitors. A horizontal, vertical, trend and ratio analysis of Competition Bikes has been completed and is summarized in the review below. HORIZONTAL, VERTICAL, & TREND ANALYSIS Beginning with a comparison between year 6 and 7, sales in units rose from 3000 to 4000 which was a 33.3% increase in the number of units sold and is reflected in total Net Sales which rose from $4,485,000 to $5,980,000. Consistent with this same increase of 33.3% were sales commissions, distribution network support, transportation out costs, and total selling expenses. The total cost of goods sold increased 31.8%; this helped the company produce their product at a lower cost adding to their overall profit margin. The gross profit margin from year 6 to year 7 increased 37.5%. The company increased both their advertising and research and development 37.5% between year 6 and 7, this can strengthen their market base and aide in the development of new or improved products. Administrative salaries increased 21.4% and Executive...
Words: 5457 - Pages: 22
...This paper is to be used as a reference only. Do NOT submit as is because it will not pass turnitin. Financial Analysis – JET2 Task 1 A.1.a. Horizontal Analysis Results Comparative Income Statements Revenue - Years 6 and 7: Net sales increased 33.3% showing significant boost of sales compared to prior year. Cost of goods sold also increased by 31.8% related to increased sales volume. Gross profit rose 37.5% commensurate with the substantial increase in net sales. Overall, this data represents a strong increase in revenue. This significant increase in sales/revenue suggests market approval and preference for the product. Revenue - Years 7 and 8: Net sales declined by 15% or close to $900,000. This is a staggering decline compared to prior performance. Cost of goods went down as expected since less volume was manufactured or sold and gross profit declined 16.3%. This decline in revenue is related to the poor economy and subsequent reduction of funding from professional rider’s sponsors. Other considerations should also be investigated such as management decisions or price increases that may have negatively impacted sales/revenue. Selling Expenses – Years 6 and 7: Advertising expenses increased 37.5% which may have contributed to the substantial increase in revenue for this period. Sales commissions, distribution network support, and transportation expenses were up 33.3% likely due to the increase in sales. Selling Expenses – Years 7 and 8: Advertising expenses...
Words: 7025 - Pages: 29
...Following is a comprehensive analysis of the financials of the profitability, competitiveness and overall stability of the Competition Bikes, Inc. based on their finance statements. This analysis provides information based on working capital, horizontal analysis, vertical analysis, ratio analysis and trend analysis. This analysis provides essential information on forecasting budget limits and overhead expenses based on overall sales potential. The analysis is based on the last three fiscal years of data provided by Competition Bicycles, Inc. A.1.A. : Horizontal Analysis A horizontal analysis is used to see variations in account line items from year to year. Strictly speaking, according to Accounting for Management (2014), a horizontal analysis “shows changes in the amounts of corresponding financial statement items over a period of time.” The formula utilized to calculate this change is Dollar change = Comparison Year Balance – Base Year’s Balance. The percent change is, therefore, calculated as the dollar change / Base Year’s Balance and multiplied by 100 for a strict percentage. At Competition Bikes, the numbers tell an interesting story. Sales dramatically increased 33.3% between years 6 and 7 before taking a loss of 15% in years 7 to 8. This still puts Competition Bikes at a solid increase of 13.3% in sales from years 6 to 8. Gross profits show a similar trend, increasing by 37.5% between years 6 and 7, while dropping by 16.3% between years 7 and 8 – the net profit increase...
Words: 4486 - Pages: 18
...Financial Analysis Task 1 In the following summary report I will provide a closer look at Competition Bikes Inc., by examining the companies’ operational strengths and weaknesses, analyzing the working capital of the company, evaluating the internal controls present in the companies purchasing system and finally I will analyze the companies’ level of compliance with Sarbanes-Oxley requirements. This will be accomplished by taking a very close look at the income statement and balance sheet of the company. A.) Prepare a Summary Report 1.) Evaluate the company’s operational strengths and weaknesses 1a.) Horizontal Analysis: Accountingformanagement.org defines a Horizontal Analysis as, “a technique that shows changes in the amounts of corresponding financial statement items over a period of time.”("Horizontal analysis," 2013) In this section I we will take a look at both the income statement and balance sheet for the company Competition Bikes, Inc. Using the information provided I will perform a horizontal analysis based on years: 8 (current year), 7 (previous year) and year 6 (a past year). From this information I will point of some of the strengths of the company as well as some of the weaknesses. After properly identifying these areas, I will make recommendations on how to either maintain the good progress, or I will make suggestions about what needs to be adjusted in order to correct any weaknesses. Let’s begin by taking a look at the...
Words: 10162 - Pages: 41
...Costing Method: The excel document title, “JET2 Task 1-4 Workbook” and tabs ‘Task 4 Cost-Volume-Profit’, and “Task 4 Activity Based Costing” is where the information is derived from and recommendations will be made based off of the information in these tabs. The excel document title, “JET2 Task 1-4 Workbook” and tab ‘Task 4 Cost-Volume-Profit’ highlights two unit costs methods: traditional and activity based. Each unit cost method will be analyzed and a recommendation will be made regarding which costing method should be used by Competition Bikes. Traditional method to figure out costs- this method computes the overhead cost of titanium bikes at $239,020 and the overhead costs of carbonlite bikes at $232,380 for a total overhead cost of $471,400 ($239,020 + $232,380= $471,400). Again this information was derived from the excel document titled, “JET2 Task 1-4 Workbook” and by clicking on tab ‘Task 4 Cost-Volume-Profit’ and by viewing the second half of the page, looking at the summary of traditional and carbonlite overhead costs. Once the overhead costs are known the direct costs for each bike will be added to that number. So for titanium bikes the direct cost is $402,300 plus the overhead cost $239,020= $ 641,320 for titanium bikes. For carbonlite bikes the direct cost is $447,000 + $232,380= $679,380. The $641,320 for the titanium bikes is considered the total cost and the $679,380 is considered the total cost for the carbonlite bikes. Take the total cost for each bike...
Words: 1954 - Pages: 8
...JET2 TASK 2 1 JET 2 TASK 2: Financial Analysis Theo Adams Western Governors University MBA Program JET2 TASK 2 2 (A1) Budget Concerns Investopedia defines Budget as an "estimation of the expenses and revenues over a specific future period of time. Budgets can be made for a group of people, family, person, country, business, government, organization or anything else that makes or spend money. The budget is a micro economic concept that shows the trade-offs made when one good is exchange for another." When looking at the year 9 budget for CB first thing that jumped out at me was the sales goal of 3510 is a 5247450. This is my first immediate concern considering that the storyline has clearly stated it is a down market due to the reductions in monies for sponsored professional riders from their sponsors. This is the main sources sales for the Carbonlite model from CB. The professional riders not having the same resources they had in year 7 when sales went to 4000 from the 3000 sold in year 6. which meant CB's revenue went from 4485000 in year 6 to 5980000 in year 7. This 33.3% jump was followed by 15% drop from 4000 units sold in year 7 to 3400 units sold in year 8. Again this drop was due to the cut in sponsorship money for the professional riders which ended up reflecting at the drop in revenue as well from year 7 to 8 of 5980000 to 4485000. These facts do not seem to warrant an increase in sales from 3400 units to 3510 units and an Increased Revenue to 5247450. Even...
Words: 2595 - Pages: 11
...[pic]RJET Task 1 | | | | | | | |Help on this Page | |Directions | | | |SUBDOMAINS: 326.1 - MANAGING INTERNAL COST & CONTROLLING FINANCES | |326.2 - MANAGING CAPITAL AND FINANCIAL ASSETS | |326.4 - MANAGING ENTERPRISE RISK & CONTINUITY | |329.4 - MANAGING OPERATIONS | | | |Competencies: 326.1.1: Financial Analysis - The graduate analyzes and benchmarks financial statements, evaluates company | |performance, identifies...
Words: 549 - Pages: 3
...Introduction: In this task you will prepare a presentation for the chief financial officer (CFO) to present to a bank vice president. The bank vice president will decide if the bank will approve a $1,000,000 funding request for the European expansion of Custom Snowboards Inc. currently under consideration. The bank has not confirmed it is willing to consider a $1,000,000 loan. The bank will make its assessment of the risk associated with the loan after your presentation. You will prepare another presentation to present directly to the chief executive officer (CEO) of Custom Snowboards Inc. The presentation will include a recommendation on how to proceed with the expansion plans. The presentations can assume the form of a presentation or a report. You may combine the two or submit them separately. Be sure to enter your first initial and last name on the first worksheet in Custom Snowboards, Inc. Financial Data excel document. Task: Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 5 work. When you enter your first initial and last name at the top of the Income Statement you are given a dataset that is based on your name. The evaluator will need a copy of your data to ensure correct evaluation. Note: Your presentations may be in a variety of formats (e.g., report, multimedia presentation). A. Create a presentation or report for the chief financial officer in which you do the following: 1. Summarize the key points of...
Words: 667 - Pages: 3
...Introduction: In this task you will prepare a presentation for the chief financial officer (CFO) to present to a bank vice president. The bank vice president will decide if the bank will approve a $1,000,000 funding request for the European expansion of Custom Snowboards Inc. currently under consideration. The bank has not confirmed it is willing to consider a $1,000,000 loan. The bank will make its assessment of the risk associated with the loan after your presentation. You will prepare another presentation to present directly to the chief executive officer (CEO) of Custom Snowboards Inc. The presentation will include a recommendation on how to proceed with the expansion plans. The presentations can assume the form of a presentation or a report. You may combine the two or submit them separately. Be sure to enter your first initial and last name on the first worksheet in Custom Snowboards, Inc. Financial Data excel document. Task: Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 5 work. When you enter your first initial and last name at the top of the Income Statement you are given a dataset that is based on your name. The evaluator will need a copy of your data to ensure correct evaluation. Note: Your presentations may be in a variety of formats (e.g., report, multimedia presentation). A. Create a presentation or report for the chief financial officer in which you do the following: 1. Summarize the key points...
Words: 497 - Pages: 2
...Introduction: JET2 Task 2 Summary Report for Budgetary Planning Competition Bikes, Inc. will be reviewed for its various budgets and for its budgetary planning. Budgets are the main planning tool in all businesses that are used by managers to executive management to make decisions for the company. Cash flow is the bloodline of any organization’s operation including operating activities that determine how much cash stays in the organization called revenues and how much is paid out as an expense or liability. Competition Bikes Inc. makes bicycles for professional riders who compete in road races such as triathlons and biathlons. The bikes have an extraordinary success rate and the product consistently finishes in the winners bracket approximately sixty percent of the time. However, due to the recent economic situation Competition Bikes, Inc. has experience a recent decline of approximately 15 percent in its bicycle sales which the trend expecting to continue for the next thirty six months. This review will provide an analysis and provide recommendation for improving budget planning for the company in a summary report Task: Note: submit a copy of your Excel workbook when submitting your JET2 Task 2 work. . A. Prepare a summary report in which you do the following: 1. Discussion of budgetary areas that raise concern in the budget planning. One of the biggest issues when creating budgets is that there is no absolute way of knowing what next year...
Words: 2261 - Pages: 10
...JET2 - Financial Analysis - Task 4 JET2 – Task 4 A1. Costing Method Costing is used in business accounting strategies as a way of determining cost of manufacturing a product in relation to the revenue generated by that product. Costing systems determine the overhead of production and then allocate those overhead costs to a business’s product. There are two common methods for allocating these indirect costs to products, traditional costing and activity based costing. Both of these methods assess overhead costs and then attach these costs to products based on certain cost drivers, “a factor that causes cost to incur, such as machine hours, direct labor hours and direct material hours (Johnson 2014).” The first of these methods is Traditional Costing. This costing method drops all overhead costs into one bucket and then disperses them across three drivers, units produced, labor, and machine hours. Although this method works well for lines that are similar and consistent, one of its drawbacks is that this method does not account for customization requirements and overall complexity of the lines. So the company ends up allocating the same cost drivers across all production lines. The second method is Activity Based Costing. Activity based costing on the other hand, utilizes multiple cost pools as it relates to overhead costs based on resources used. Overall, this is a better cost system methodology for the company as it allows for the customization and specialty line...
Words: 2113 - Pages: 9
...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
...| 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 was...
Words: 5232 - Pages: 21
...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 profit...
Words: 5846 - Pages: 24
...JET2 Task 1- Financial Analysis A) Competition Bikes Incorporated has been a highly successful company in the past and is an extremely popular brand in the racing community. Over the past year there has been some changes in their financial success due to the economy. 1a) In reviewing the horizontal analysis there were areas of huge strengths and gains in years 6 and 7. Net sales “is the amount of sales generated by a company after the deduction of returns, allowances for damages or missing goods and discounts allowed.” (Investopedia, 1012) The net increase in sales was $1,495,000 at least 33.3%, which was a tremendous strength. This is potentially due to the durability and reliability of the bikes along with the light weight frames made of CarbonLite which the company can customize. There was a weakness from years 7-8 with a 15% decrease which was attributed to a decrease in sponsors due to the poor economy and some sponsor cutting back on funding to their professional riders. The cost of goods sold is the “direct costs attributed to the production of the goods sold by a company. This amount includes the cost of materials used in creating the goods along with the direct labor costs used to produce the goods.” (investopedia, 2012) The costs of goods is relatively high due to a high skill level and manufacturing costs of the product. In the years 6-7 the % increase was 31.8 % at 1,048,000 in the years 7-8 it was at $630,400 a -14.5% decrease. It was thought...
Words: 2990 - Pages: 12
