Write a 3 page executive summary
Igotyou
DMBA630-WK10RevenueForecast_1.xlsxREVENUE
| Disney+ | ||
| REVENUE Forecast and assumptions | ||
| Year 1 | ||
| Hulu | ||
| # of subscribers | 9,000,000 | |
| Price persubscribers | 4.99 | |
| Total | 44,910,000 | |
| Disney+ | ||
| # of subscribers | 20,000,000 | |
| Price persubscribers | 4.99 | |
| Total | $99,800,000 | |
| Bundle | ||
| # of subscribers | 9,000,000 | |
| Price persubscribers | 7.99 | |
| Total | 71,910,000 | |
| Net Revenue | 216,620,000 | |
| Months | Year 1 | |
| Month 1 | 0 | |
| Month 2 | 0 | |
| Month 3 | 0 | |
| Total 1st Quarter | 0 | |
| Month 4 | 10,831,000 | |
| Month 5 | 17,329,600 | |
| Month 6 | 21,662,000 | |
| Total 2nd Quarter | 49,822,600 | |
| Month 7 | 21,662,000 | |
| Month 8 | 25,994,400 | |
| Month 9 | 32,493,000 | |
| Total 3rd Quarter | 80,149,400 | |
| Month 10 | 25,994,400 | |
| Month 11 | 28,160,600 | |
| Month 12 | 32,493,000 | |
| Total 4th Quarter | 86,648,000 | |
| Total for year | 216,620,000 | |
| Average Revenue | ||
| by Month | 18,051,667 | |
| by Quarter | 54,155,000 | |
&D &T
Month 1 Month 2 Month 3 Total 1st Quarter Month 4 Month 5 Month 6 Total 2nd Quarter Month 7 Month 8 Month 9 Total 3rd Quarter Month 10 Month 11 Month 12 Total 4th Quarter Month 1 Month 2 Month 3 Total 1st Quarter Month 4 Month 5 Month 6 Total 2nd Quarter Month 7 Month 8 Month 9 Total 3rd Quarter Month 10 Month 11 Month 12 Total 4th Quarter 0 0 0 0 10831000 17329600 21662000 49822600 21662000 25994400 32493000 80149400 25994400 28160600 32493000 86648000
