Question

In: Finance

Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020...

Suppose a firm has had the following historic sales figures.

Year: 2016 2017 2018 2019 2020
Sales $1,450,000 $1,710,000 $1,600,000 $2,000,000 $1,850,000


What would be the forecast for next year’s sales using regression to estimate a trend?

Solutions

Expert Solution

Please find attached the output image for the forecast with formula and regression summary.

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013   Sales $ 2,500,000 $ 3,780,000 $ 4,340,000 $ 4,940,000 $ 5,510,000    What would be the forecast for next year’s sales using regression to estimate a trend?
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013   Sales: $ 2,430,000. $ 3,850,000 $ 4,440,000 $ 4,920,000 $ 5,540,000 What would be the forecast for next year’s sales using regression to estimate a trend? Next years sales?
The following relates to a firm: Statement of Financial Position Figures in Sh. 2018 2017 2016...
The following relates to a firm: Statement of Financial Position Figures in Sh. 2018 2017 2016 Cash 308,000 356,250 368,000 Accounts receivables 885,000 625,000 492,000 Inventory 1,115,000 825,000 530,000 Prepaid expenses 97,000 93,750 40,000 PPE 2,775,000 2,550,000 2,295,000 Total assets 5,180,000 4,450,000 3,725,000 Accounts payable 1,289,000 752,500 492,500 Loan 975,000 1,025,000 825,000 Share capital (Sh. 10 par) 1,625,000 1,625,000 1,625,000 Retained earnings 1,291,000 1,047,500 782,500 Total liability and equity 5,180,000 4,450,000 3,725,000 Income Statement 2018 2017 Sales 6,725,000 5,300,000 Cost...
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017...
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017 Year 2016 $ $ $ $ Sales revenue 1,095,910 1,060,900 1,030,000 1,000,000 Less: Cost of goods sold (895,358) (866,755) (842,540) (820,000) Gross profit 200,552 194,145 187,460 180,000 Other operating expenses (162,877) (161,827) (160,900) (160,000) Income before tax 37,675 32,318 26,560 20,000 Less: Income tax expense (3,768) (3,232) (2,656) (2,000) Net income 33,907 29,086 23,904 18,000 Required: Compute the index-number trend percentages for the accounts...
2019 2018 2017 2016 2015 Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400...
2019 2018 2017 2016 2015 Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400 Cost of goods sold 244,756 158,059 130,106 89,117 63,954 Accounts receivable 23,095 17,966 16,955 9,999 8,577 Compute trend percents for the above accounts, using 2015 as the base year.
Break Even Corp has the following info: 2016 2017 2018 2019 Beginning Inventory (in units)        ...
Break Even Corp has the following info: 2016 2017 2018 2019 Beginning Inventory (in units)         20         30         10       140 Actual Sales (in units)       400       410       390       350 Budgeted production (in units)       500       400       424 484 Budgeted fixed manufacturing costs (in $) 8,000 8,000 8,190 8,470 Operating Income using Variable Costing (in $)        $   0 $ 0 $ 0 $ 0 In 2015, budgeted manufacturing costs were $50 per...
Suppose a firm has the following values represented in it's 2018 and 2019 Balance Sheets and...
Suppose a firm has the following values represented in it's 2018 and 2019 Balance Sheets and Income Statements: Item 2018 2019 Cash $9,396 $8,579 Inventory $8,160 $8,953 Accounts Receivable $7,654 $7,751 Sales Revenue $178,423 $175,589 Depreciation Expense $7,849 $5,692 Accounts Payable $6,574 $7,076 Wages Payable $6,381 $7,397 Interest Paid $7,443 $5,017 Taxes Paid $7,443 $5,017 Paid in capital: Common $100,000 $100,000 Bank Loans $88,755 $84,523 Equipment $81,085 $87,120 Buildings $169,801 $173,420 Paid in capital: Preferred $30,000 $30,000 Dividends Paid $4,002...
Net income figures for Flounder Ltd. are as follows: 2016 - $77,800 2017 - $56,500 2018...
Net income figures for Flounder Ltd. are as follows: 2016 - $77,800 2017 - $56,500 2018 - $86,400 2019 - $90,600 2020 - $71,600 Future income is expected to continue at the average amount of the past five years. The company’s identifiable net assets are appraised at $468,200 on December 31, 2020. The business is to be acquired by Novak Corp. in early 2021. The normal rate of return on net assets for the industry is 9%. Click here to...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 BVPS, start of year 7 7.61 8.51 9.51 10.73 11.77 13.17 14.4 15.91 17.58 19.43 21.47 23.72 25.38 27.16 29.06 EPS 0.81 1.1 1.3 1.52 1.64 2 2.03 2.16 2.39 2.64 2.91 3.22 2.37 2.54 2.72 2.91 ROE 0.116 0.145 0.153 0.16 0.153 0.17 0.154 0.15 0.15 0.15 0.15 0.15 0.1 0.1 0.1 0.1 Payout Ratio 0.247 0.182 0.231 0.197 0.366 0.3 0.394 0.3...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT