...RJET Task 1 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 Horizontal analysis is to determine dollar and percentage changes by comparing financial statements. (Investopedia.com, 2011) Between years 6 and 7, Competition Bike Inc.’s net sales increased 33.3% at $1,495,000. Between years 7 and 8, net sales of the product decreased 15.0% with a loss of $897,000. Gross profits increased 37.5% at $447,000 between years 6 and 7, but decreased 16.3% with a loss of $266,600 between years 7 and 8. This clearly demonstrated the weakness of Competition Bikes that it has not met its goal of sales. The total general and administrative expenses increased 20.4% with $156,440 in years 6 and 7. It also increased 1.2% with $11,004 in years 7 and 8. Regarding the utilities cost, there is 11.1% increase in years 7 and 8 comparing the 3.8% increase in years 6 and 7. It also has a continuous growth at other general and admin expenses at 31.1% and 7.6%. This demonstrates the weakness in expenses control. The company cut advertising expense to response to the declining sales in year 7 and 8. It is a weakness that company is unable to respond properly to the market changes. In addition, there is 16.3% decrease of research and development in years 7 and 8 comparing the 37.5% increase in years 6 and 7. Lack of research and development fund is...
Words: 4615 - Pages: 19
...Horizontal Analysis A Horizontal Analysis is done by comparing the company’s financial data, over several years, side by side so that you can see any differences from year to year. When using the Comparative Income Statements of years 6, 7, and 8 for the Competition Bikes, Inc. When looking at the Revenue and comparing year seven to year six we are able to see that the Net Sales had a positive increase of 33.3% in year seven. Along with the increase in sales it stands to reason that the Cost of Goods also had an increase which was 31.8%. Year seven showed a gross profit increased a whooping $447000 or 37.5%. A comparison of year eight to year seven shows that Competition Bikes, Inc was not immune to the economic woes of the world. Year eight shows a 15.0% drop in sales for the year. While the company was able to bring down their Cost of Goods Sold in year eight by 14.5% from year seven there was still a Gross Profit loss of 16.3% Operational Expenses Between year six and seven showed an increase in all areas except two. Year eight did have increases in expenses however there were some expenses that decreased or remained static. Year seven showed an increase over year six when it came to the Selling Expenses with the exception of the Website Creation and Maintenance which remained static. Year seven Advertising costs increased 37.5 %. With the increase in the sale of bikes the Sales Commissions increased 33.3% as one would expect. The cost of the Distribution...
Words: 3484 - Pages: 14
...A1a: Horizontal Analysis: To adequately understand what we are looking at it is helpful to understand the true meaning of horizontal analysis. In Webster’s new world dictionary horizontal is defined as “1. Parallel to the plane of the horizon; not vertical. 2. Flat and even; level.” (Simon and Schuster Inc., 1990) Analysis is then defined as “1. A breaking up of a whole into its parts to find their nature, etc. 2. A statement of the results of this…” (Simon and Schuster Inc., 1990) Therefore in regards to the horizontal analysis we are basically looking across the balance sheet or statement. For this task we are given a comparative income sheet. This document lists years 6 through 8. The information on the sheet gives us a look at how the company is doing financially, and what the company is doing in regard to sales. Looking at the horizontal analysis for Competition Bikes, Inc. you can tell see that Competition Bikes, Inc. has experienced a decline of their net sales. It is fairly certain that this decline is a direct correlation to the downturn in the economy. Competition Bikes, Inc. remains upbeat believing that sales will increase during the three year future projections, but they are expecting the new high to fall below the sales figures they saw in 2007. Even though Competition Bikes, Inc. saw their sales decrease, when the cost of goods sold is formulated as a percentage of net sales we see that it remained steady at 73%. This is a good indicator that the labor budget...
Words: 4378 - Pages: 18
...A1a: Horizontal Analysis: To adequately understand what we are looking at it is helpful to understand the true meaning of horizontal analysis. In Webster’s new world dictionary horizontal is defined as “1. Parallel to the plane of the horizon; not vertical. 2. Flat and even; level.” (Simon and Schuster Inc., 1990) Analysis is then defined as “1. A breaking up of a whole into its parts to find their nature, etc. 2. A statement of the results of this…” (Simon and Schuster Inc., 1990) Therefore in regards to the horizontal analysis we are basically looking across the balance sheet or statement. For this task we are given a comparative income sheet. This document lists years 6 through 8. The information on the sheet gives us a look at how the company is doing financially, and what the company is doing in regard to sales. Looking at the horizontal analysis for Competition Bikes, Inc. you can tell see that Competition Bikes, Inc. has experienced a decline of their net sales. It is fairly certain that this decline is a direct correlation to the downturn in the economy. Competition Bikes, Inc. remains upbeat believing that sales will increase during the three year future projections, but they are expecting the new high to fall below the sales figures they saw in 2007. Even though Competition Bikes, Inc. saw their sales decrease, when the cost of goods sold is formulated as a percentage of net sales we see that it remained steady at 73%. This is a good indicator that the labor budget...
Words: 4378 - Pages: 18
...A.1 Horizontal, Vertical, Trend and Ratio Analysis Executive Summary The financial assessments of Competition Bikes, Inc. (CB) are based upon the income statements and balance sheets from Calendar Years 6, 7 and 8 to gauge the operation efficiencies of the company. In general, the analysis shows that, between Year 6 and 7, Competition Bikes, Inc. had a large growth in new earnings that was not capitalized in Year 8. The Net Earnings has moved from a positive 313.4% down to a -81.6% loss. This will be evaluated in detail below. A.1.a. Horizontal Analysis Results Horizontal Analysis is the comparative analysis of each line item across the timeframes of the company and is calculated in dollars and percentages. The analysis will look at how the accounts have changed from one year to the next. The formulas used are: Dollar change = This Year’s Balance – Last Year’s Balance Percent change = Dollar Change . Last year’s Balance The horizontal analysis will provide an analysis of the financial performance of Competition Bikes, Inc. and provides an overview of potential trends of the company (Ashfaq, n.d.). The horizontal analysis between Years 7 and 8 further shows that total revenues decreased by 15.0% and total expenses decreased by 69.1%. As result of this, Earnings Before Income Taxes (EBIT) also decreased 313.4% and net earnings reduced by 81.6%. INCOME STATEMENT The horizontal analysis is based on the income statement for Years...
Words: 6791 - Pages: 28
...Horizontal Analysis Horizontal analysis is one of the two main ways to analysis the financial statements of a business. This analysis provides a year to year look at the financial performance of the business being evaluated. The spreadsheet that is attached provides a horizontal analysis of years 6, 7,and 8 for the balance sheet and income statement for Competitive Bikes and Two Wheel Racing.The horizontal analysis can take into account either the dollar amount of the changes over theyears or the percentage of change for the years. This analysis will consider both items, and willalso be comparing years 6 and 7 and 7 and 8. Year 7 The analysis of years 6 and 7 shows a positive result for Competitive Bikes. RevenueThere was a positive increase in revenue for years 6 and 7. Net sales increased by $1,495,000 between years 6 and 7. This was a 33.3% increase for Competition Bikes. The cost of goodssold increased $1,048,000. This was a 31.8% increase. The fact that net sales increased by33.3%, and cost of goods sold increased by only 31.8% was a significant factor in these twoyears. This was a positive result, because net sales increased more than what the cost of goodssold increased. Competition Bikes found a way to sell more bikes at a lower cost for thecompany. This is why the company had an increase of 37.5% in gross profit.Selling ExpensesTotal selling expenses increased by 33% between years 6 and 7. This was expected, becausemost of the selling expenses are considered variable...
Words: 1844 - Pages: 8
...RJET TASK 4 A1. COSTING METHOD Activity based costing or ABC accounting as it is called distributes manufacturing overhead costs to products in a smarter way than in the traditional way. This way of simply assigning costs on the basis of machine hours. Activity based costing assigns costs first to the activities that make up the real overhead. Then it assigns a cost to the activities that affect only the products produce. ABC vs Traditional Costing This is one main difference between ABC (Activity Based Costing) and TCA (Traditional Cost Accounting) it is Activity Based Costing is complex and takes more time and effort to figure out and Traditional Cost Accounting is simple and to the point. Activity Based Costing began some time in 1981 so it is still a relatively new costing bases. But Traditional Cost Accounting has been around since the late 1800’s. In TCA you figure the cost of the items used to produce the product and the resources that were alos used. But in the ABC method you only figure the cost for the actual materials that were used to finish the product. Activity Based Costing is a more accurate way of costing produts and is preferred over the Traditional Cost Accounting method. The ABC method is normally implemented when overheads are high and there is a large amount of misc. products. If the product costing method in incorrect then you may be under cutting your competitors, but you might also be losing your profits at the same time. So it is better for the...
Words: 1246 - Pages: 5
...| Budgeting| RJET Task 2| C.Smith-Barber4/16/2013| A1. Budget Concerns A fiscal document used to plan future revenue and expenditures is a called a budget (Murray, n.d.). The overall process of whether or not the company can continue to run with the projected revenue and expenditures is called budgeting (Murray, n.d.). It is valuable because it helps an organization consume the inadequate financials and human capital for which is best to achieve current business opportunities. A company is also capable of formulating both long-term and short-term strategies for help in implementation and constant assessment of its performance. Competition Bikes (CB) has made a master budget for Year 9 after being on a roller coaster for Year 6-Year 8. Due to the economic downturn, the company experienced a 15% decline in sales during Year 8. It has been budgeted that CB will sale 3510 units at a selling price of $1495 in Year 9 which brings some concern. The number of units has increased compared to the previous year and of Year 6 especially when there has been an economic situation. With the change of the amount of units sold that will also alter the budgeted dollar amount for its raw materials- components’ total cost is $965,250 and the total cost for frame materials is approximately $1.3 million. The accounts payable at $229,203 is too high. CB has always done a better job in paying debts in the past; in Year 6, Competition Bikes had net sales of about $4.5 million...
Words: 1324 - Pages: 6
...RJET 2 Task 3 When a company is looking to expand and grow, there are many aspects of finance that must be considered. The company needs to ensure that there is a demand for the products they offer, that they are financially stable and able to expand without putting themselves into bankruptcy, and if acquiring another company that an acquisition is in both companies favors. Looking at capital structure, capital budget, and working capital are a great place for Competition Bikes, Inc. (CB) to start to evaluate the possibility and profitability of expanding, merging or acquiring Canadian Biking, Inc (CB2). A1: Capital Structure Capital structure is essentially “how a company can finance its operations and growth through the use of a mixture of debt and equity (Investopedia US, 2013).” A company’s debt is its long-term loans and bonds, while its equity is considered to be common and/or preferred stocks. A company looking to expand must ensure that it has the right capital structure to maximize return on investment, increase cash flow, and pay off debts. For CB, there are five options of capital structure for them to analyze to ensure that they have the highest earnings per share (EPS) to keep shareholders happy, and a strong net income to support the business. The reason that EPS will be used to gauge which capital structure is because it shows the company how their financial decisions will impact their shareholders and stockholders. EPS is a strong indicator of how financially...
Words: 3370 - Pages: 14
...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
...RJET Task 5 A. Create a report for the chief financial officer in which you do the following: 1. Summarize the key points of the company’s financial picture that could impact the bank officer’s position. In order to analyze the key points of the company’s financial picture, we will need to focus on the following three areas: profitability, liquidity, and solvency. The banker will examine these three areas very closely when considering the loan for the European expansion. Profitability is another term for how much money the company actually makes. Sales and expenses drive profitability. During year 13, sales suffered a decline of 6.44%, but in year 14 have increased by 1.28% over the previous year. This will be a salient point for the banker to consider because it shows that sales are rebounding a bit over the decline in year 12. Another decline was shown in gross profit and selling expenses in year 13 of 6.44% and then increased in year 14 by 1.28%. This is directly related to the sales figures. This demonstrates to the banker that the company managed to maintain its cost of goods sold and its selling expenses during those years. One area that does not show as favorably is the area of general and administrative expenses. These increased by 7.24% in year 13 and by 6.5% in year 14. From these figures, the banker will be able to see that the company did not manage those expenses well during that period of time. These factors all played a role in the decline of 67.66% in...
Words: 5525 - Pages: 23
