Excel
raulhm3
Hernandez_go16_xl_ch04_grader_4e_hw.xlsxCondo Purchase
| Jesse Jewelers Condo Purchase | |
| Amount of Loan | $615,000 |
| Period (years) | 10 |
| Interest Rate (per year) | 5.25% |
| Payment (per month) |
Payment Table
| Loan Options for Condo Purchase: Rates versus Months | |
| Payment Options | |
| Number of Monthly Payments | |
| Rates | |
Advertising Costs by Quarter
| Jesse Jewelers | ||||
| Advertising Costs by Quarter | ||||
| All U.S. Stores | ||||
| 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | |
| Local Newspapers | 14471 | 13809 | 13809 | 2006 |
| Regional Newspapers | 13735 | 13031 | 15365 | 1692 |
| National Newspapers | 12489 | 12674 | 12927 | 13042 |
| Specialty Newspapers | 1648 | 3188 | 3628 | 1202 |
| Online Newspapers | 13827 | 12452 | 12451 | 14821 |
| Internet | 13342 | 13443 | 13555 | 14545 |
| 14549 | 15525 | 16740 | 12448 | |
| TV | 18821 | 20403 | 21211 | 21958 |
| Travel Podcasts | 12342 | 13475 | 15794 | 15948 |
| Women's Magazines | 12308 | 21101 | 20034 | 19105 |
| Men's Magazines | 18637 | 188357 | 16662 | 21118 |
| Billboard Costs | 12294 | 13418 | 14461 | 13473 |
| Total by Quarter | 158462 | 340877 | 176637 | 151358 |
Annual Advertising Costs
| Jesse Jewelers |
| Advertising Costs |
| Annual Costs for All U.S. Stores |
| Newspaper_Costs |
| Digital_Costs |
| Magazine_Costs |
| Outdoor_Costs |
| Total |
