Forecast on Company Financials Report Paper

User Generated

ZbbaTnmre

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags