The accompanying table presents the company's cash budget from 2013 to 2020 in million pesos. Expenditures 710,755 779,976 Year Revenues 2013 563,732 567,293 626,630 699,768 795,707 882,435 1,136,560 1,202,905 2014 826,493 886,825 942,235 940,755 1,149,001 1,271,022 2015 2016 2017 2018 2019 2020 Using Time-series Forecast Technique(Linear Regression), develop a forecast model to predict/estimate the revenues for a given expenditure.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter7: Exponents And Exponential Functions
Section: Chapter Questions
Problem 68SGR
icon
Related questions
Question

PLEASE SHOW YOUR SOLUTION CLEARLY AD NEATLY

3. The accompanying table presents the company's cash budget from 2013 to 2020 in million
pesos.
Year
Expenditures
710,755
Revenues
2013
563,732
567,293
626,630
699,768
2014
779,976
826,493
886,825
942,235
940,755
1,149,001
2015
2016
2017
795,707
882,435
1,136,560
1,202,905
2018
2019
2020
1,271,022
Using Time-series Forecast Technique(Linear Regression), develop a forecast model to
predict/estimate the revenues for a given expenditure.
Transcribed Image Text:3. The accompanying table presents the company's cash budget from 2013 to 2020 in million pesos. Year Expenditures 710,755 Revenues 2013 563,732 567,293 626,630 699,768 2014 779,976 826,493 886,825 942,235 940,755 1,149,001 2015 2016 2017 795,707 882,435 1,136,560 1,202,905 2018 2019 2020 1,271,022 Using Time-series Forecast Technique(Linear Regression), develop a forecast model to predict/estimate the revenues for a given expenditure.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill