Excel assignment
Keer49
Sharma_e02ch03_grader_hw_Renovations.xlsxRenovations
| Painted Paradise Golf Resort & Spa | ||||||||
| Banquet Room Renovations | ||||||||
| Created by Lesa Martin | ||||||||
| Renovations Started | Renovations Completed | Length of Renovations in Days | Original Capacity | New Capacity | Quarterly Revenue Prior to Renovations | Projected Quarterly Revenue after Renovations | Renovation Projection Schedule | Projected Room Classification |
| The Muisca Room | 1/6/18 | 5/10/18 | 500 | 290,000 | ||||
| The Eldorado Room | 3/15/18 | 7/15/18 | 100 | 575,000 | ||||
| The Pueblo Room | 9/10/18 | 11/30/18 | 25 | 225,000 | ||||
| Technology room 1 | 8/1/18 | 10/1/18 | 45 | 150,000 | ||||
| Technology room 2 | 2/15/18 | 4/15/18 | 25 | 75,000 | ||||
| Increase in Capacity | 30% | |||||||
| Increase in Revenue | 40% | |||||||
| Median Renovation Length in Days | ||||||||
| Loan Information | ||||||||
| Amount of Loan | 125,000 | |||||||
| Annualized Rate | 6% | |||||||
| Term (in Years) | 5 | |||||||
| Monthly Payment | ||||||||
| Room Classification | ||||||||
| 0 | Bronze | |||||||
| 250,000 | Silver | |||||||
| 500,000 | Gold | |||||||
| 750,000 | Platinum |
