excel question
hrutikkshroff
Shah_go16_xl_ch04_grader_4g_hw.xlsxWarehouse Purchase
| Warehouse Purchase in Chicago | |
| Amount of Loan | $975,000 |
| Period (years) | 10 |
| Interest rate (per year) | 5.25% |
| Payment (per month) | $10,460.94 |
| Option #1 Reduce the Loan | |
| Amount of Loan | $728,802 |
| Period (years) | 10 |
| Interest rate (per year) | 5.50% |
| Payment (per month) | $8,000.00 |
| Option #2 Increase the Years | |
| Amount of Loan | $975,000 |
| Period (years) | 15 |
| Interest rate (per year) | 5.50% |
| Payment (per month) | $8,000.00 |
Warehouse Payment Table
| Loan Options for Warehouse Purchase: Rates versus Months | |||||||
| Amount of Loan | $975,000 | ||||||
| Period (months) | 120 | ||||||
| Interest rate (per year) | 5.25% | ||||||
| Payment Options | |||||||
| Number of Monthly Payments | |||||||
| 60 | 120 | 180 | 240 | 300 | 360 | ||
| Rates | 7.50% | ||||||
| 7.00% | |||||||
| 6.50% | |||||||
| 6.00% | |||||||
| 5.50% | |||||||
| 5.00% | |||||||
| 4.50% | |||||||
| 4.00% |
Staffing Plan
| Jesse Jewelers | |||||
| Store Staff Planning Form | |||||
| Name | Richmond | ||||
| Store # | N211 | ||||
| Date | 9-Jan | ||||
| Job Code | Description | # of Positions | Type | Salary | Budget Amount |
| $ - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| - | |||||
| Total: |
Job Information
| Jesse Jewelers | ||
| Job Classification List | ||
| Job Code | Description | Salary |
| M-MG | Manager | $ 75,000 |
| M-AMG | Assistant Manager | $ 52,500 |
| C-CASH | Cashier | $ 39,750 |
| C-CSA | Customer Service | $ 36,000 |
| S-STR | Stockroom Assistant | $ 33,000 |
| B-BYR | Buyer | $ 45,750 |
| CC-J | Maintenance Attendant | $ 30,000 |
Bracelet Revenue
| Jesse Jewelers | ||||||||||||
| Last Year: Online Bracelet Sales | Projected: Online Bracelet Sales | |||||||||||
| Product | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % |
| Crystal Bracelets | 1,898 | 2,008 | 1,876 | 2,151 | 7,933 | 22% | 2,164 | 2,289 | 2,139 | 2,452 | 9,044 | 20% |
| Beaded Bracelets | 1,337 | 1,254 | 1,656 | 2,002 | 6,249 | 17% | 1,671 | 1,430 | 2,070 | 2,503 | 7,673 | 17% |
| ID Bracelets | 2,145 | 1,766 | 2,074 | 2,255 | 8,240 | 22% | 2,252 | 1,854 | 2,178 | 2,368 | 8,652 | ERROR:#DIV/0! |
| Ankle Bracelets | 2,371 | 2,151 | 2,206 | 2,085 | 6,728 | 18% | 2,798 | 2,538 | 2,603 | 2,460 | 10,399 | 23% |
| Mens Bracelets | 1,656 | 1,436 | 2,052 | 2,475 | 7,619 | 21% | 2,020 | 1,752 | 2,339 | 3,020 | 9,131 | 20% |
| Total | 9,407 | 8,615 | 9,864 | 10,968 | 36,769 | 10,905 | 9,863 | 11,329 | 12,802 | 44,899 | ||
| Assumptions | ||||||||||||
| Item | Growth | |||||||||||
| Crystal Bracelets | 14.0% | |||||||||||
| Beaded Bracelets | 25.0% | |||||||||||
| ID Bracelets | 5.0% | |||||||||||
| Ankle Bracelets | 18.0% | |||||||||||
| Mens Bracelets | 22.0% | |||||||||||
