Question: Based on your 2012 to 2016 (including pro forma financial statement) data of Sonic Master Supplies Inc., construct the 2017 pro forma financial statements using

Based on your 2012 to 2016 (including pro forma financial statement) data of Sonic Master Supplies Inc., construct the 2017 pro forma financial statements using the following assumptions: Cost of Goods Soldet sales is 86% Operating expenseset sales is 11% Long-term debt is 560 . Current portion of long term-debt is 100 Interest expenseet sales is at 10% Tax rate @ 45% Dividends/eamings is 50% Current Assetset sales is 29% Net fixed assets is 270 Current liabilitieset sales is 14.4% use SPC to forecast 2017 sales. NOTE: The values of a, b, and in the formula Yc= a + bx + cx should be rounded off to TWO DECIMAL PLACES the same applies to the accounts found on the proforma financial statements of Sonic Master for 2017. Question 1 10 pts Worksheet for Sales computation using SPC: Year Sales (in thousands) X x2 x X2Y XY 2012 11,190 2013 13,764 2014 16.104 2015 20,613 2016 25,766 = = NOTE: Answers here should have comma as separators, remove the decimals and use "-" for negative answers. For example: Year Sales (in thousands) X x2 X X2Y XY 1998 10.000 -1 2 4 20.000 - 10,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
