must use Excel. please show work/equations

B C D E F 2 Ryan Day Rodeos is the premier rodeo destination on this side of the Mississippi. Unfortunately, 3 RDR has lost a majority of its income in 2020 after being shut down due to COVID-19 and Ryan is 1 unsure of whether it is worth it to open for the 2021 season with all of the restrictions and 5 uncertainty. If RDR opens, Ryan must pay Ohio State $15,000,000 on December 19, 2020 to reserve 5 space at the 'Shoe to host his 2021 rodeos. Additionally, RDR must follow the state guildelines that restrict the number of fans in attendance. Gov. DeWine has offered the following capacity 3 estimates for each month of 2021: 10% capacity for January - March, 35% capacity for April - 2 September, and 25% capacity for October - December. The % revenue that RDR will make (earned 0 on the last day of every month) is equal to the % capacity, and RDR brings in $5,000,000 per month 1 at full capacity. What are all of the expenses and revenues associated with opening for the 2021 2 season worth on December 19, 2020 if RDR has a 10% MARR? 3 Stadium Capacity 4 Guidelines 5 Month Capacity 6 January 10% 7 February 10% 8 March 10% 9 April 35% 0 May 35% 1 June 35% 2 July 35% 3 August 35% -4 September 35% 5 October 25% C6 November 25% 7 December 25% 012 Q13 Q14 Q15 5 6. 08 09 010 011