Explanation “Write the given data in tabular form as follows.” 2018 2017 2016 2015 Sales $298,000 $280,000 $264,000 $249,250 Cost of goods sold 187,085 175,227 164,687 156,785 Accounts receivable 29,820 28,850 27,300 26,250 Consider the year 2018. It is to be noted that the sales for 2018 = $ 298 , 000 and sales for 2015 = $ 249 , 250 . Calculate the trend percentage for sales by using sales for 2015 as base amount. Sales percent = Sales for 2018 Base amount × 100 Substitute the value of $ 298 , 000 as sales for 2018 and $ 249 , 250 for base amount in the above formula. Sales percent = $ 298 , 000 $ 249 , 250 × 100 = 119.56 % Also, it is known that the cost of goods sold for 2018 = $ 187 , 085 and the cost of goods sold for 2015 = $ 156 , 785 . Now, calculate the trend percentage for cost of goods sold by using cost of goods sold for 2015 as base amount: Cost of goods sold percent = Cost of goods sold for 2018 Base amount × 100 Substitute the value of $ 187 , 085 as cost of goods sold for 2018 and $ 156 , 785 for base amount in the above formula. Cost of goods sold percent = $ 187 , 085 $ 156 , 785 × 100 = 119.33 % Also, it is known that the accounts receivable for 2018 = $ 29 , 820 and the accounts receivable for 2015 = $ 26 , 250 . Now, calculate the trend percentage for accounts receivable by using accounts receivable for 2015 as base amount: Accounts receivable = Accounts receivable 2018 Base amount × 100 Substitute the value of $ 29 , 820 as cost of goods sold for 2018 and $ 26 , 250 for base amount in the above formula. Accounts receivable = $ 29 , 820 $26,250 × 100 = 113.6 % Now, consider the year 2017. It is known that the sales for 2017 = $ 280 , 000 and the sales for 2015 = $ 249 , 250 . Therefore, calculate the trend percentage for sales by using sales for 2015 as base amount as shown below. Sales percent = Sales for 2017 Base amount × 100 Substitute the value of $ 280 , 000 as sales for 2017 and $ 249 , 250 for base amount in the above formula. Sales percent = $ 298 , 000 $ 249 , 250 × 100 = 112.34 % Also, it is known that the cost of goods sold for 2017 = $ 175 , 227 and the cost of goods sold for 2015 = $ 156 , 785 . Calculate the trend percentage for cost of goods sold by using cost of goods sold for 2015 as base amount: Cost of goods sold percent = Cost of goods sold for 2017 Base amount × 100 Substitute the value of $ 175 , 227 as cost of goods sold for 2017 and $ 156 , 785 for base amount in the above formula. Cost of goods sold percent = $ 175 , 227 $ 156 , 785 × 100 = 111.76 % Also, it is given that the accounts receivable for 2017 = $ 28 , 850 and the accounts receivable for 2015 = $ 26 , 250 Calculating trend percentage for accounts receivable by using accounts receivable for 2015 as base amount as shown below

Practical Business Math Procedures with Business Math Handbook

12th Edition

ISBN: 9781259725067

Author: Jeffrey Slater, Sharon M. Wittry

Publisher: McGraw-Hill Education

See similar textbooks

Videos

Question

Chapter 16.3, Problem 9AH

To determine

To calculate: Trend analysis for the given items using 2015 as the base year.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 16.3, Problem 8AH

Chapter 16.3, Problem 10AH

Students have asked these similar questions

1. Find the mean of the x-values (x-bar) and the mean of the y-values (y-bar) and write/label each here: 2. Label the second row in the table using proper notation; then, complete the table. In the fifth and sixth columns, show the 'products' of what you're multiplying, as well as the answers. X y x minus x-bar y minus y-bar (x minus x-bar)(y minus y-bar) (x minus x-bar)^2 xy 16 20 34 4-2 5 2 3. Write the sums that represents Sxx and Sxy in the table, at the bottom of their respective columns. 4. Find the slope of the Regression line: bi = (simplify your answer) 5. Find the y-intercept of the Regression line, and then write the equation of the Regression line. Show your work. Then, BOX your final answer. Express your line as "y-hat equals...

Apply STATA commands & submit the output for each question only when indicated below i. Generate the log of birthweight and family income of children. Name these new variables Ibwght & Ifaminc. Include the output of this code. ii. Apply the command sum with the detail option to the variable faminc. Note: you should find the 25th percentile value, the 50th percentile and the 75th percentile value of faminc from the output - you will need it to answer the next question Include the output of this code. iii. iv. Use the output from part ii of this question to Generate a variable called "high_faminc" that takes a value 1 if faminc is less than or equal to the 25th percentile, it takes the value 2 if faminc is greater than 25th percentile but less than or equal to the 50th percentile, it takes the value 3 if faminc is greater than 50th percentile but less than or equal to the 75th percentile, it takes the value 4 if faminc is greater than the 75th percentile. Include the outcome of this code…

solve this on paper

Chapter 16 Solutions

Practical Business Math Procedures with Business Math Handbook

Ch. 16.1 - Complete this partial comparative balance sheet by...Ch. 16.1 - What is the amount of change in merchandise...Ch. 16.1 - Prob. 1EPQ Ch. 16.1 - Prob. 2EPQ Ch. 16.1 - Prob. 1AH Ch. 16.1 - Prob. 2AH Ch. 16.1 - Prob. 3AH Ch. 16.1 - Prob. 4AH Ch. 16.2 - From the following information, calculate: Net...Ch. 16.2 - Prob. 1EPQ

Ch. 16.2 - Prob. 1AH Ch. 16.2 - Prob. 2AH Ch. 16.2 - Prob. 3AH Ch. 16.2 - Prob. 4AH Ch. 16.3 - Prob. 1PQ Ch. 16.3 - Prob. 2PQ Ch. 16.3 - Prob. 1EPQ Ch. 16.3 - Prob. 2EPQ Ch. 16.3 - Prob. 1AH Ch. 16.3 - Prob. 2AH Ch. 16.3 - Prob. 3AH Ch. 16.3 - Prob. 4AH Ch. 16.3 - Prob. 5AH Ch. 16.3 - Prob. 6AH Ch. 16.3 - Prob. 7AH Ch. 16.3 - Prob. 8AH Ch. 16.3 - Prob. 9AH Ch. 16.3 - Prob. 10AH Ch. 16.3 - Prob. 11AH Ch. 16.3 - Prob. 12AH Ch. 16.3 - Prob. 13AH Ch. 16.3 - Prob. 14AH Ch. 16.3 - Prob. 15AH Ch. 16 - Prob. 1ECP Ch. 16 - From the following, prepare a classified balance...Ch. 16 - Complete a horizontal analysis for Brown Company,...Ch. 16 - Prepare an income statement for Hansen Realty for...Ch. 16 - Prob. 5ECP Ch. 16 - Prob. 6ECP Ch. 16 - Complete the comparative income statement and...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - From Problem 16–7, your supervisor has requested...Ch. 16 - William Burris invested $100,000 in an...Ch. 16 - General Motors announced a quarterly profit of...Ch. 16 - Find the following ratios for Motorola Credit...Ch. 16 - Assume figures were presented for the past 5 years...Ch. 16 - Don Williams received a memo requesting that he...Ch. 16 - The French bank Société Générale reported its 2014...Ch. 16 - At age 32, you have assets of $275,658 and...Ch. 16 - On January 1, Fete Rowe bought a ski chalet for...Ch. 16 - As the accountant for Tootsie Roll, you are asked...Ch. 16 - Given: Gross sales, $170,000; sales returns and...Ch. 16 - Complete the following partial comparative balance...Ch. 16 - Calculate the amount of increase or decrease and...Ch. 16 - Complete a trend analysis for sales, rounding to...Ch. 16 - From the following, prepare a balance sheet for...Ch. 16 - Solve from the following facts, rounding to the...

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.