TEST POST QUESTION FROM ADMIN2/ DO NOT BID
shenge
SHENGE_Excel_7A_Loan_and_Costs1.xlsxHouston New Store Loan
| New Houston Store Loan Options | |
| Amount of Loan | $300,000 |
| Period (years) | 3 |
| Interest rate (per year) | 4% |
| Payment (per month) |
Payment Table
| Loan Options for New Houston Store: Rate versus Months | ||
| Amount of Loan | ||
| Period (months) | ||
| Interest rate (per year) | ||
| Payment Options | ||
| Number of Monthly Payments | ||
| Rates | ||
Quarterly Merchandise Costs
| Jesse Jewelers | ||||
| Merchandise Costs by Quarter, Small Items Category | ||||
| Houston Store | ||||
| Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | |
| Crystal Bracelets | $ 36,470 | $ 28,329 | $ 22,500 | $ 20,596 |
| Beaded Bracelets | 27,319 | 20,510 | 32,194 | 17,531 |
| ID Bracelets | 14,359 | 16,788 | 18,757 | 21,841 |
| Ankle Bracelets | 16,442 | 20,831 | 14,540 | 11,542 |
| Mens Bracelets | 17,127 | 14,542 | 22,657 | 16,471 |
| Charm Necklaces | 10,033 | 11,221 | 14,578 | 13,665 |
| Silver Knot Necklaces | 2,459 | 5,108 | 3,209 | 4,197 |
| Crystal Necklaces | 1,309 | 6,025 | 5,811 | 9,418 |
| Choker Necklaces | 2,464 | 2,805 | 3,891 | 5,475 |
| Initial Key Chains | 1,720 | 1,741 | 2,379 | 3,688 |
| Crystal Key Chains | 1,807 | 1,357 | 1,591 | 1,537 |
| Business Card Cases | 1,293 | 1,317 | 2,360 | 2,659 |
| Total by Quarter | $ 132,802 | $ 130,574 | $ 144,467 | $ 128,620 |
Annual Merchandise Costs
| Jesse Jewelers |
| Small Items Category |
| Annual Costs for Houston Store |
| Bracelets |
| Necklaces |
| Key Chains |
| Business Card Cases |
| Total |
