Description
Select a business operations dataset from the internet or other sources which can be used for forecasting
Develop a minimum of three quantitative forecasts using Microsoft®Excel.
- Compare and contrast each quantitative forecast you develop.
- Choose the one forecast you determine would be the best for the firm and be prepared to explain why you chose this.
- Evaluate the impact this forecast would have on the firm from a financial metrics standpoint.
Develop a 700-word report in which you describe your forecasting project including details on all the assignment steps.
Format your assignment consistent with APA guidelines.
Explanation & Answer
Hi, kindly find attached
Running Head: FORECAST ON COMPANY FINANCIALS
Forecast on Company Financials
Student Name
Institution Affiliation
Date
1
FORECAST ON COMPANY FINANCIALS
2
Forecast on Company Financials
Forecast
Total revenue
400,000,000
352193823
350,000,000
310279649.4
268250642.4
232,887,000
300,000,000
250,000,000
200,000,000
177,866,000
135,987,000
150,000,000
Total revenue
100,000,000
50,000,000 107,006,000
0
1/1/2015 1/1/2016 1/1/2017 1/1/2018 1/1/2019 1/1/2020 1/1/2021
Total revenue
72383000
75055244.23
81781250.7
56576000
88581169.34
9/1/2019
8/1/2019
7/1/2019
6/1/2019
5/1/2019
4/1/2019
3/1/2019
2/1/2019
1/1/2019
12/1/2018
11/1/2018
10/1/2018
9/1/2018
Total
revenue
8/1/2018
7/1/2018
6/1/2018
5/1/2018
4/1/2018
3/1/2018
100000000
90000000
80000000
70000000
60000000
50000000
52886000
40000000
30000000 51042000
20000000
10000000
0
FORECAST ON COMPANY FINANCIALS
3
Net income
17106977.75
18000000
16000000
14200583.45
14000000
11286226.43
12000000
10000000
10073000
8000000
6000000
4000000
23710003033000
2000000 596000
0
Net income
Report
In my analysis, I concentrated on the total revenue and net in...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Prince
by Niccolò Machiavelli
To the Lighthouse
by Virginia Woolf
Freakonomics
by Stephen J. Dubner and Steven D. Levitt
Little Women
by Louisa May Alcott
Mrs Dalloway
by Virginia Woolf
The Red Badge of Courage
by Stephen Crane
Sounds Like Titanic
by Jessica Chiccehito Hindman
Ezperanza Rising
by Pam Muñoz Ryan