Question

In: Accounting

Develop a percentage change trend analysis for each of the three years.  Results must be entered in...

  1. Develop a percentage change trend analysis for each of the three years.  Results must be entered in schedule below.
  2. Make at least one observation that is revealed by information provided in the analysis.

2011

2012

2013

Historical Data

Inventory

16,500

16,300

16,200

Property Plant & Equipment

82,500

84,000

80,100

Current Liabilities

35,000

32,500

31,800

Sales

150,000

135,000

128,000

Cost of Goods Sold

86,000

75,000

70,000

Operating Expenses

52,000

57,000

50,000

Net Income (loss)

12,000

3,000

8000

Trend Percentages

Inventory

Property Plant & Equipment

Current Liabilities

Sales

Cost of Goods Sold

Operating Expenses

Net Income (loss)

Solutions

Expert Solution

a)A percentage change trend analysis for each of the three year is as follows:

2011 2012 2013
Inventory 16,500 16,300 16,200
Property,Plant and Equipment 82,500 84,000 80,100
Current Liability 35,000 32,500 31,800
Sale 150,000 135,000 128,000
Cost of Goods Sold 86,000 75,000 70,000
Operating Expenses 52,000 57,000 50,000
Net Income(Loss) 12,000 3,000 8,000
Trend Percentage % % %
Inventory 100% 98.79% 98.18%
Property,Plant and Equipment 100% 101.82% 97.09%
Current Liability 100% 92.86% 90.86%
Sale 100% 90% 85.33%
Cost of Goods Sold 100% 87.21% 81.40%
Operating Expenses 100% 109.62% 96.15%
Net Income(Loss) 100% 25% 66.67%

b)1)Net sale of the company is reducing over the years but net income decreased sharply then recovered.

2)Inventory and current liability is decreasing but on the same time the value of Property,Plant and Equipment is fluctuating.


Related Solutions

Further analyze the financial ratios and trend analysis to evaluate and make management decisions. Develop a...
Further analyze the financial ratios and trend analysis to evaluate and make management decisions. Develop a business decision that evaluates a growth or improvement opportunity for the company. Using analysis, determine whether it should be accepted or rejected by the organization. Prepare a strategic plan to the board of directors of the company that includes analysis of financial information and recommendations for increased profitability. As part of your analysis, be sure to evaluate risks and opportunities as well as alternatives...
Perform a horizontal analysis providing both the amount and percentage change. (Round Percentage answers to 1...
Perform a horizontal analysis providing both the amount and percentage change. (Round Percentage answers to 1 decimal place. Decreases should be indicated by a minus sign.) Year 2018 2017   Cash $ 278,860    $ 730,000      Accounts receivable 324,090    130,000      Inventory 715,680    630,000      Long-term assets 3,280,330    2,230,000         Total assets $ 4,598,960    $ 3,720,000   
Question: Perform a common size analysis and percentage change analysis for 2016 and 2017. What do...
Question: Perform a common size analysis and percentage change analysis for 2016 and 2017. What do these analyses tell you about Brinker? BRINKER INTERNATIONAL INC 6/2 8/2017 10-K CONSOLIDATED STATEMENTS OF INCOME Fiscal Years 2017 2016 2015 Revenues: Company sales    3,062,579 3,166,659 $2,904,746 Franchise and other revenues (a)       88,258                    90,830 97,532 Total revenues    3,150,837 3,257,489 3,002,278 Operating Costs and Expenses: Company restaurants (excluding depreciation and amortization) Cost of sales      791,321                  840,204 775,063 Restaurant labor...
Develop a plan for data conversion and system changeover that specifies which data items must be entered, the order in which the data should be entered
Develop a plan for data conversion and system changeover that specifies which data items must be entered, the order in which the data should be entered, and which data items are the most time critical. Discuss what method should be used for system changeover.
a. What is trend in the liquidity of CVS over the last three years, explain with...
a. What is trend in the liquidity of CVS over the last three years, explain with ratios? b. What is trend in the liquidity of Walgreens over the last three years, explain with ratios? c. Which company has had better liquidity over the last 3 years? Explain with ratios. Income Statement for CVS Balance Sheet All numbers in thousands Period Ending 8/31/2017 8/31/2016 8/31/2015 Current Assets Cash And Cash Equivalents 3,301,000 9,807,000 3,000,000 Short Term Investments - - - Net...
5) Draw the trend analysis based on following sales data for four years and analyse the...
5) Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5
Prepare an analysis of the revenue change, separating the productivity effect (billing percentage) from the volume...
Prepare an analysis of the revenue change, separating the productivity effect (billing percentage) from the volume effect (increase in number of consultants). Exhibit 4: Budget and Actual Income Statement: Quarter 2 2000 Actual Budget Revenues $               3,264,000 $               3,231,900 Less: Consultants' Salaries and Fringes $               2,029,050 $               1,748,250 Operating Expenses $                  938,560 $                  877,300 Total Expenses $               2,967,610 $               2,625,550 Operating Profit $                  296,390 $                  606,350 Profit % 9.1% 18.8% Operating Statistics Number of Consultants(FTE) 113 105 Hours Supplied 50,850...
Differentiate among the three phases of change that individuals must work through in process change.
Differentiate among the three phases of change that individuals must work through in process change.
Draw the trend analysis based on following sales data for four years and analyse the fifth-year...
Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5
a. What is trend in long-term debt paying ability of over the last three years for...
a. What is trend in long-term debt paying ability of over the last three years for CVS - using ratios? b. What is trend in long-term debt paying ability of over the last three years Walgreens - using ratios? c. Which company has had better long-term debt paying ability over the last 3 years? Explain with ratios. Income Statement for CVS Revenue 12/31/2017 12/31/2016 12/31/2015 Total Revenue 184,765,000 177,526,000 153,290,000 Cost of Revenue 156,220,000 148,669,000 126,762,000 Gross Profit 28,545,000 28,857,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT