For this final assignment Id like you to call upon your knowledge of forecasting to help project your firms 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. Id 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 B C D E F G Time Year 1 2 3 4 - W NPD N 5 NNNPP 6 7 8 Quarter Individual Donations Donations from Local Businesses Total Revenue 1 1 17600 40000 57600 1 2 18800 24000 42800 1 3 20800 48000 68800 1 4 22000 80000 102000 2 1 19200 44000 63200 2. 2 19200 30000 49200 2 3 21200 44000 65200 2 4 22400 88000 110400 3 1 20400 48000 68400 3 2 20800 32000 52800 3 3 22000 52000 74000 3 4 23200 72000 95200 4 1 21600 48000 69600 4 2 22000 40000 62000 4 3 23600 56000 79600 4 4 24400 84000 108400 9 10 nm 11 mmm + 12 13 14 15 16 17 5 1 18 5 2 19 3 5 5 20 4