Jet 2 Task 1

In: Business and Management

Submitted By lisastann
Words 6540
Pages 27
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 years 6 and 7 CBI’s Advertising expenses increased by 37.5% for a change of $8,940. While this was a significant expense increase, the percentage is equal to the gross profit for these same years. Furthermore, the total Selling Expenses between year’s 6 and 7 demonstrates an increase of 33% which is still less than the 37.5% increase in gross profit for those same years. This indicates…...

Similar Documents

Jet 2 Task 2

...1. There are a few areas of concern with the Budget that Competition Bike, Inc. has displayed within their budget for year 9. The most prominent area of concern in is in the Revenue section of the budget. In the budget for year 9, Competition has included units sold to be 3510. This is a lofty prediction given that year 8 had seen such a big decline in that number. In year 8, Competition sold 3400 units, but the previous year had sold around 4000 units, a 15 % decline. The company is hoping for an upswing, but this may be too positive of an estimation. To go with that, Competition is only allowing for $984 more dollars in advertising for year 9. If they had budgeted maybe $2000-$3000 more to this category to get to where their advertising spending was in year 7 when they sold 4000 units, their budget of increased sales in year 9 would not be as suspect. In the Budgeted Income Statement, Competition Bikes has budgeted $1340038 for Selling, General, and Administrative Expenses. This is a little high as in year 7, when the highest number of units was sold, that category totaled $1322075. Sometimes this number is budgeted high to help show how well the company managed the budget, as they have built in extra that they know that they can beat. This is not in the best interest of the company, however, because the goal is not aggressively set, and there is no real push to beat the budgeted amount. The other concern with this area is that a lot of the key components......

Words: 1118 - Pages: 5

Jet Financial Analysis Task 1

...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 an increase in sales. CB experienced greater gross profits in year # 7 than year # 6. The balance sheet also shows a growth in assets. Total assets increased by 2.9%. Liabilities increased to only a slight 1.2% . This is a positive indicator of growth for Competition Bikes, Inc. A comparative review of the CB income statement from year # 7 to year #8, shows a decrease in sales by 15 percent. Product costs went down by 14 percent and sales expense decreased by 15 percent. The general operating expense increased by 1 percent. The decrease in product cost and sales expense was not......

Words: 5051 - Pages: 21

Jet 2 Task 2

...Research for marketing decisions. Englewood Cliffs, N.J: Prentice-Hall. Horngren, C. T., Foster, G., & Datar, S. M. (2006). Cost accounting: A managerial emphasis. Upper Saddle River, NJ: Pearson Prentice-Hall. Lester, A., & Lester, A. (2007). Project management, planning and control: Managing engineering, construction and manufacturing projects to PMI, APM and BSI standards. Amsterdam: Elsevier/Butterworth-Heinemann. Snow, C. C. & Hambrick, D. C. (1980), Measuring Organizational Strategies: Some Theoretical and Methodological Problems, Academy of Management Review, pp. 527-538. William, J. Bruns, Jr. & John, H. Waterhouse (1975), “Budgetary Control and Organization Structure “, Journal of Accounting Research, Vol. 13, issue 2, pp. 177-203....

Words: 1345 - Pages: 6

Jet 2 Task 1

...liabilities. A strength for the company. Retain Earnings: An increase in Retained Earnings was reported this year. The balance sheet shows an increase of 2.7% (or $31,286). An increase in Retained Earnings is expected since we also saw an increase in Cash Equivalents (a strength). This increase also reveals that no dividends have been paid out to stockholders for the year. This is to be expected during years of decline, but it should be an item of concern since no dividends were paid during years 6 and 7 as well. Total Assets: Total Assets declined slightly from $4,293,044 to $4,285,831 (.2% decline). Depreciation was only increased by 50% this year compared to 100% last year (a strength). This shows that us that the double-decline balancing method is used by this company. This 50% reduction along with with the slight increase in capital expenditures is the reason for the .2% decline in Total Assets. Management show put focus on how to reduce Capital Expenditures since this is an item that they can control. Summary Even though this was not a prosperous year for Competition Bike’s, they do show signs of prosperity. The continued decline of Long-Term Liabilities is proof of that. Management should pay special attention in managing Cash Equivalents and Capital Expenditures to show stockholders that Competition Bike’s knows how to manage money and reduce costs. By taking care of the two items mention above, Competition Bikes Income and Balance Sheet so......

Words: 8250 - Pages: 33

Jet Task 1

...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......

Words: 4547 - Pages: 19

Wgu Jet 2 Task 1

...Financial Statements. Retrieved From http://www.readyratios.com/reference/analysis/vertical_analysis_of_financial_statements.html Audit IT (2014). Ready Ratios. Trend Analysis. Retrieved From http://www.readyratios.com/reference/analysis/trend_analysis.html Houghton, Mifflin, & Harcourt (2013). Cliff Notes. Ratio Analysis. Retrieved From http://www.cliffsnotes.com/more-subjects/accounting/accounting-principles-ii/financial-statement-analysis/ratio-analysis Butler, Henry N. (2006). "''The Sarbanes–Oxley Debacle''". Aei.org. Retrieved 2010-08-27. Hilton, Ronald (2009). Managerial Accounting: Creating Value in a Dynamic Business Environment [VitalSouce bookshelf version]. Retrieved from http://online.vitalsource.com/books/0077771540/id/LAppI-1-4 ...

Words: 4532 - Pages: 19

Jet 2 Task 2

...Rachel Johnson Addy JET Task 2 March 29, 2014 JET Task 2 1. A budget is an itemized estimate of expected income as well as estimated expenses over a specified period of time. The reason to design a budget is to regulate spending. There are multiple causes of concern with Competition Bikes budget plan. The main cause for concern is that the sales estimated for year 9 is 3,510 units. This estimate is not supported by past sales data. Due to the current economic status, the amount of units sold from year 7 to 8 decreased 15% according to the horizontal analysis. Rider sponsorships were also reduced and will most likely remain limited in the future (WGU, 2014). There is some misleading and inaccurate information posted within the budget. Under the Selling, General, and Administrative breakdown “utilities” is listed at $150,000 on the vertical analysis for year 8 and year 9. Then there is another listing for “utilities and services” of $54,000. This is misleading because this entry was not listed in the expenses from the previous year. Another cause of concern is that the cash budget is not included in the uncollected receivables. CB makes expensive bikes so there should be room for uncollectable accounts. The uncollectable receivables budget could be used to cover the any uncollected payments. The reduction of sponsorships and the slow economy could possibly cause a rise in uncollectable accounts. There is also some concern because the operating income is......

Words: 1749 - Pages: 7

Jet 2 Task 1

...obligations with current assets. (Horngren, 2008) The current ratio is 5.79 the 7th year, 5.25 the 8th year, compare to Two Wheel Racing 8th year of 4.20. This analysis shows that Competition Bikes is in a great position to pay its obligations, compared to Two Wheel Racing because the greater the ratio the better liquidly the company has. In year 8 Competition Bikes had $5.25 per dollar of debt to make the repayment versus Two Wheel Racing only having $4.20. This was a strength for the company. The Acid- Test Ratio determines the company’s ability to pay present liabilities if they were required to be paid immediately. (Horngren, 2008) Competitive Bikes is strong when utilizing this comparison. The industries acceptable standard is about 1 and the greater the better. Year 7 they were in a better position at 4.41, decreasing to 4.14 in year 8, which was still above the standard and the competitors 3.40. Average Collection Period determines how long it takes for account receivable. Compared to Two Wheel Racing in year 8, this is a weakness for Competitive Bike because it takes them 11.3 days longer to collect clients’ payments. Debt Ratio is the amount owed from liabilities compared to the company’s assets. Bank lines of credit is based upon the debt to assets ratio. Competition Bikes would not be a good candidate to provide credit to, this is a weakness. When analyzing the Total Current Assets in the Vertical Analysis, it reflected that they had the lease amount of cash......

Words: 4327 - Pages: 18

Jet Task 2

...deviation or try and prevent it from happening again. The criteria I am using for my management by exception standard is any variance over $5,000 will be investigated because at that rate each variance would equal about 5% or more of what the operating income was for year 9. The time and motion standard will be used in investigating these variance. This standard determines how long it should take each step to be performed by each laborer and how much machinery and direct labor is needed to complete a product. The first variance that meets this criteria is direct labor cost. These cost were $100,000 more than anticipated so this variance would definitely need to be investigated to see what went wrong and why more labor was needed to perform task than anticipated. Manufacturing overhead costs also meets the MBE criteria with an overage of $26,426 which leaves a big impact on the company’s ending contribution margin. Another variance that meets the criteria are the transportation out costs. All of these variances impacts the company’s bottom line, contribution margin, operating income and in the end its profits. References Management by exception - Wikipedia, the free encyclopedia. (n.d.). Retrieved April 24, 2014, from http://en.wikipedia.org/wiki/Management_by_exception What is a flexible budget variance? - Questions & Answers - AccountingTools. (n.d.). Retrieved from http://www.accountingtools.com/questions-and-answers/what-is-a-flexible-budget-variance.html...

Words: 2148 - Pages: 9

Egt 1 Task 2

...Western Governors University Economics and Global Business Task 2 Egt1: Task 2 A) Elasticity of demand is describes as the degree of percentage change in demand for a good or service due to variation in price. Elasticity measurements can be expressed by three types of demand; inelastic demand, unit elastic demand, or relatively elastic demand. To determine the percentage of change in demand for a product or service the price elasticity equation and coefficient are used. The coefficient Ed is defined as “the percentage change in quantity demanded of product divided by the percentage change in price of product X” (McConnell, Brue, Flynn, 2012, pg. 76) The three expressions of Ed are Elastic, Inelastic, and Unit Elasticity. Elastic demand occurs “if a specific percentage change in price results in a larger percentage change in quantity demanded” (McConnell, Brue, Flynn, 2012, pg. 77). For a product with inelastic demand Ed < 1. An example of elastic demand is when there is a 2% decrease in the price of chocolate that results in a 6% increase in quantity. Ed= .06/.02 = 3 Inelastic demand occurs “if a specific percentage change in price produces a smaller percentage change in quantity demanded.”(McConnell, Brue, Flynn, 2012, pg. 77) For products with inelastic demand Ed <1. An example of inelastic demand is when there’s a 2% decrease in the price of milk that results in a 1% increase of demand. Ed= .01/.02 = .5 Unit elasticity of demand occurs “where a......

Words: 1252 - Pages: 6

Jet Task 1

...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 the single most important technique of financial analysis in which quantities are converted into ratios for meaningful comparisons, with past ratios and ratios of other firms in the same or different industries. Ratio analysis determines trends and exposes strengths or weaknesses of a firm (businessdictionary.com, 2014). Horizontal Analysis Results Based on the information provided in the Comparative Income Statement for year six, seven, and eight the horizontal analysis shows a substantial gross profit increase of 37.5% or $447,000 in...

Words: 5976 - Pages: 24

Financial Analysis Jet Task 2

...Requirements for 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) Review the horizontal analysis, analyze the results, and discuss operational areas of concern. “Horizontal analysis of financial statements involves comparison of a financial ratio, a benchmark, or a line item over a number of accounting periods. This method of analysis is also known as trend analysis. Horizontal analysis allows the assessment of relative changes in different items over time. It also indicates the behavior of revenues, expenses, and other line items of financial statements over the course of time.” (Ready Ratios, 2014a) The sections below summarize the results of my horizontal analysis of Competition Bikes, Inc. (CB): Year 7 to Year 8 CB suffered a decrease in Net Sales Revenue of 15% from Year 7 to Year 8, but the course materials explained this as a result of a decline in the overall economy. This is a reasonable explanation and may very well indicate that CB management’s actions or inactions are not to blame for decline. It is encouraging that percentage decreases in Cost of Goods Sold and Selling Expenses, 14.5% and 14.9%, respectively, approximated the 15% decrease in Net Sales indicating no significant change in marginal cost of production and sales. That total General and Administrative Expenses increased by 1.2% is not any cause......

Words: 10434 - Pages: 42

Jet Task 1

...important number for a company to keep an eye on. An increase in this number means that the company has had an increase in profits, while a decrease could signal problems within the company (Horngren et al., 2009). For Year 7, Competitive Bikes had a gross profit percentage of 27.4%. In Year 8, they saw a decrease to 27%. The decrease in this number is because Year 7 saw really high sales and profits in the company, and Year 8 didn’t fare as well. The competitor, Two Wheel Racing, had a gross profit percentage of 32.10% in Year 8. This number is higher than Competitive Bikes, which puts the competition in a better position. Operating Profit Margin The operating profit margin shows how much a company earns in operating income per $1 of sales. A higher number means that the company is making more money per sale, so a higher number is preferable (Horngren et al., 2009). Competitive Bikes had an operating profit margin of 5.3% in Year 7 and 1.9% in Year 8. This means that Year 7 saw operating income of $0.053 per dollar in sales and Year 8 saw $0.019 of operating income per dollar of sales. This is a significant drop in Year 8, and can be explained by the drop in sales for Year 8. Two Wheels Racing has a operating profit margin of 5.20%. Competitive Bikes came nowhere near this number in Year 8, which is a concern. Based on the trend analysis and future forecasts, Year 7 had an abnormally large amount of sales. This number of large sales lead to......

Words: 5430 - Pages: 22

Task 1 & 2

...Crime & It’s Effects Assignment 1 Task 1: The primary objective of the Crime and Disorder Act 1998 was to give more responsibility to local authorities with regards to implementing strategies to help with the reduction of crime and public disorder within the local community. Although the Act also put an end to the death penalty for piracy and treason and abolished the presumption that a child under 10 years old could be incapable of committing a criminal offence, the key areas are concerned primarily with Anti-Social Behaviour orders, commonly referred to as an “ASBO”, sex offender orders, parenting orders and racially aggravated offences. Anti-Social Behaviour Orders These orders are issued against people who have carried out anti-social behaviour which has caused distress, Harassment or alarm to a person(s) who does not reside in the same household as the alleged offender him or herself. In other words, the ASBO is deemed necessary to protect people from potential further anti-social acts being carried out by the alleged offender. This would be linked to the Anti-Social Behaviour Act 2003. Police Reform Act 2002 The Police Reform Act 2002 is an Act of Parliament in the United Kingdom. Amongst the provisions of the Act are the creation of the role of police community support officer, who have some police powers whilst not being constables, and the ability for chief constables to confer a more limited range of police powers on other individuals as part of Community......

Words: 738 - Pages: 3

Jet Task 1

...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......

Words: 3522 - Pages: 15