Financial Statement Analysis
FOR
Competition Bikes
Western Governors University
Financial Analysis
(NAME)
(DATE)
A1. This financial analysis is for Competition Bikes that was taken from balance sheets and income statements from years 6, 7 & 8.
A1a. Horizontal Analysis
Strengths
Net Sales – totaled $4,485,000.00 for year 6, and grew +33.3% or $1,495,000.00 between years 6 to 7.
Cost of Goods Sold – totaled $3,294,000.00 for year 6, and from years 6 to 7 grew +32.8% or $1,048,000.00.
Sales Commissions – totaled $134,550.00 for year 6, and from years 6 to 7 grew +33% or $44,850.00.
Gross Profit – totaled $1,191,000.00 for year 6, and from years 6 to 7
…show more content…
Because Competition Bikes was able to save money on Gasoline and maintenance costs for vehicles, yet they were unsuccessful at using their vehicles making this a weakness.
Utilities – totaled $120,000.00 in year 7, and in years 7 to 8 increased +11.1% or $135,000.00. You would think this is strength if looking merely at the numbers, but in actuality it’s a negative because utilities used cost the company money. They shouldn’t have been used nearly as much because the overall usage of the manufacturing plant went down, and that makes this a firm weakness.
Research and development – totaled $98,280.00 in year 7, and in years 7 to 8 decreased -16.3% or $15,996.00. This is weakness in sales and performance, but a smart decision because of the cut in R&D saved -16.3% or $15,996.00 that would have been looked at as profit. They were able to use the previous year’s investment on R&D.
Balance Sheet
The Balance sheet is a display of both strengths and growth in significant areas.
Cash and Cash Equivalent – totaled $118,549.00 in year 7; gained $326,475.00 or +275.4%.
Short Term Investments – totaled $220,000.00 in year 6, a gain of $21,500.00 or +10.8%.
Total Current Assets – All 3 years analyzed display growth shown below:
Year 6 to 7 totaled $1,029,600.00 and grew $349,914.00 or +34% to $1,379,217.00.
Year 7 to 8 totaled $1,379,217.00 and grew $227.600.00 or +16.5% to $1,606,817.00.
Assets –
• In 1993 cost of goods sold being 90% of sales and 9.6% gross profit of sales. Company’s lack of ability to manage inventory and lack of cash forced them to order from more expensive (12-15%more) warehouse than steel mills.
years decisions for Bikes Bikes Bikes, which have resulted in both negative and positive impacts.
The company recorded revenues of $25,003 million during the financial year ended January 2011, an increase of 6.4% over Fiscal Year 2010. The operating
The financial performance of the company over the years six t thirteen is shown in table no 7. The data includes Revenue generated over the years, Earning per share, Return on Investment and Stock Prices. Chart 5 shows that there has been a decline in the revenues generated. Charts 6 to 8 all show a decline in Earnings per Share, Return on Equity and Stock Prices suggesting a poor financial performance by the company.
* Our company’s sales forecast has been based on performance from previous years along with market circumstances. We are looking at the future of the business objectively which we then can evaluate past to
Based on Talbots filing of the 10-K, net sales in FY 2005 were $1,808,606 compared to $1,697,843 in FY 2004, an increase of 6.5%. Operating income was $152,148 in FY 2005, compared to $142,115 in FY 2004, an increase of 7.1%. Cash flow from operations was 12% of sales, or $211,438 for FY 2005, compared to $155,223 for FY 2004. Total revenues for the year rose 7% to approximately $1.8 billion. Comparable store sales also grew at a modest 2.6%. Comparable store sales were positive in each of the first seven months of FY 2005, driven by a healthy sales performance across the U.S..
Calculate cost of goods sold for the year. (Omit the "$" sign in your response.)
From 1976 to 1982 the compound annual growth in net sales was 18.5% and the compound annual growth of after tax profit was 25.9%. Therefore, a 10% net sales growth shown in the proforma financial data seems reasonable.
One of the primary financial results is the increase in net income from fiscal year 2014 to fiscal year 2015. The percentage increased 2% from $337.6 million to $344.2 million, which may be accounted for by a liquidation of assets, due to the sale of the plane as well as an increase in sales. This change is verified and observed by seeing that, according to the Executive Summary, net sales also increased 10% from $6,213.2 million to $6,814 million. This was primarily due to store expansion and same store sales.
years, sales had increased at a 7% compound rate, while earnings, benefiting from substantial cost
From above, we see that sales grew at an average of 11.15% and EBIT at 9.03%. Coinciding this, is an average capital expenditure of 9.90%. Let us now look at the second period.
Year 12 finished with Net Sales of $6,601,000. In year 13, Net Sales increased slightly by 0.5% to $6,633,200 from year 12. In year 14, Net Sales declined by -3.4% to 6,407,800 from year 13. Year 14 also reflects a decline in Net Sales from year 12 by -2.93%.
net sales: $1,000,000 cost of goods sold: $700,000 rent: $20,000 wages: $100,000 other operating expenses: $50,000 net sales – all operating expenses = 530,000
• Current 2Q17 reported revenue consensus is $2,976 (Previous mean $2,975; range $2,886 - $3,079)
We knew we had an excess supply of 286 and production set at 6,927 units in quarter 2 but our adjustment was very simple by decreasing the number of production units to 6,350 in quarter 3 which brought our excess supply down from 286 to 249. We knew we were taking small steps forward and it showed in the end but let’s see what else we made adjustments in. Our demand might have decreased in quarter 3 going from 6,641 to 6,101 but in comparison to where our production was set and the amount we saved with the excess supply, it actually worked in our favor. We decreased advertising by $500 bringing it to a total of $4,500, product development decreased $150 to a total of $4,250 and we dropped process improvement by $550 to a total of $1,200. All these decreased except in price actually helped up and sky rocketed us from last to first in almost every category. We also shot our plant size up from 9 to 12 from quarter 2 to quarter 3 and we think that had a significant impact on the results at the end of quarter 3.