Excel Help
jhaskic
CopyofHaskic_Excel_BU05_A2_HotelConventions.xlsxNewBusinesses
&F
LoanAnalysis
| Painted Paradise Resort & Spa | ||||||||||
| Loan Analysis | ||||||||||
| Loan Amount | $375,000 | Interest Rates | ||||||||
| Term (Years) | 6 | 5.00% | 5.50% | 6.00% | 6.50% | 7.00% | 7.50% | |||
| Interest Rate | 6.50% | Down Payment | $ 20,000.00 | |||||||
| Down Payment | $25,000 | $ 25,000.00 | ||||||||
| Monthly Payment | $5,883.48 | $ 30,000.00 | ||||||||
| $ 35,000.00 | ||||||||||
| $ 40,000.00 | ||||||||||
| $ 45,000.00 |
&F
RoomScheduling
| Painted Paradise Resort & Spa | ||||
| Solver for Room Scheduling | ||||
| Revenue | ||||
| Room | Capacity | Price | Events per Month | |
| The Muisca Room | 500 | $ 7,500.00 | 1 | |
| The Eldorado Room | 100 | $ 1,500.00 | 1 | |
| The Pueblo Room | 25 | $ 375.00 | 1 | |
| New Room 1 | 250 | $ 3,750.00 | 1 | |
| New Room 2 | 125 | $ 1,875.00 | 1 | |
| $ 15,000.00 | ||||
| Expenses | ||||
| Fixed Costs | ||||
| Utilities | $ 280.00 | |||
| Room Maintenance | $ 170.00 | |||
| Total Fixed Costs | $ 450.00 | |||
| Variable Costs | ||||
| Staff Salaries per event | $ 550.00 | |||
| Total Variable Costs | $ 2,750.00 | |||
| Total Expenses | $ 3,200.00 | |||
| Net Income | $ 11,800.00 | |||
| Saved Solver Models |
&F
Documentation
| Create Date | By Whom | Description | Workbook Name |
| mm/dd/yyyy | Firstname Lastname | e05HotelExpansion.xlsx | |
| Mod. Date | By Whom | Mod. Description | Last Version Backup Name |
| Create Date | Sheet Name | Creator | Purpose |
&F
