For this final assignment I’d like you to call upon your knowledge of forecasting to help project your firm’s revenue stream for the upcoming year. In the Microsoft Excel that is attached to this assignment, you will find the past four years of quarterly revenue data for your nonprofit. Your revenue comes from two major sources: individual donations and donations from corporations. I’d like you to use the past four years’ worth of data to forecast the individual donations and donations for corporations for the next fiscal year (year 5 quarters 1-4).   Once you have forecasted both individual revenue streams you can simply add them together to get your overall revenue forecast for the next fiscal year. Please discuss what forecasting method you chose and how you made your decision. You can do this in your excel document or write up a separate paragraph or two in a Microsoft Word document.

Principles of Management
OER 2019th Edition
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax
Chapter8: Strategic Analysis: Understanding A Firm’s Competitive Environment
Section: Chapter Questions
Problem 4CRQ: What is a firms micro environment, and why is it important?
icon
Related questions
Question

For this final assignment I’d like you to call upon your knowledge of forecasting to help project your firm’s revenue stream for the upcoming year. In the Microsoft Excel that is attached to this assignment, you will find the past four years of quarterly revenue data for your nonprofit. Your revenue comes from two major sources: individual donations and donations from corporations. I’d like you to use the past four years’ worth of data to forecast the individual donations and donations for corporations for the next fiscal year (year 5 quarters 1-4).

 

Once you have forecasted both individual revenue streams you can simply add them together to get your overall revenue forecast for the next fiscal year. Please discuss what forecasting method you chose and how you made your decision. You can do this in your excel document or write up a separate paragraph or two in a Microsoft Word document. 

A
C
D
E
F
Time
Year
Quarter
Individual Donations
Donations from Local Businesses
Total Revenue
1
1
1
17600
40000
57600
2
1
18800
24000
42800
1
3
20800
48000
68800
4
1
4
22000
80000
102000
5
2
19200
44000
63200
2
2
19200
30000
49200
7
2
21200
44000
65200
8.
2
4
22400
88000
110400
9
3
1
20400
48000
68400
10
20800
32000
52800
11
3
22000
52000
74000
12
4
23200
72000
95200
13
4
1
21600
48000
69600
14
4
22000
40000
62000
15
4
23600
56000
79600
16
4
4
24400
84000
108400
17
5
1
18
19
5
3
20
4
Transcribed Image Text:A C D E F Time Year Quarter Individual Donations Donations from Local Businesses Total Revenue 1 1 1 17600 40000 57600 2 1 18800 24000 42800 1 3 20800 48000 68800 4 1 4 22000 80000 102000 5 2 19200 44000 63200 2 2 19200 30000 49200 7 2 21200 44000 65200 8. 2 4 22400 88000 110400 9 3 1 20400 48000 68400 10 20800 32000 52800 11 3 22000 52000 74000 12 4 23200 72000 95200 13 4 1 21600 48000 69600 14 4 22000 40000 62000 15 4 23600 56000 79600 16 4 4 24400 84000 108400 17 5 1 18 19 5 3 20 4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer