In place of the worksheet I have given, place yours in formula mode.
Please use a formula to calculate all values that are derived from the following chart.
| Item | Bob 01 | Bob 00 | Bob 99 |
| Price | 10,000 | 9,500 | 7,500 |
| Trade In | 1,000 | 1,000 | 850 |
| Rebate | 875.98 | 700 | 0 |
| Interest Rate | 0.0% | 7.5% | 9.5% |
Assume all loans are for 5 years.
You should calculate the monthly payment for each sled.
You should also calculate how much extra the Bob 00, and Bob 99 would cost given these loans. (Difference between monthly payments * number of payments)
Please use the following numbers for a comparison
| item | Bob 01 | Bob 00 | Bob 99 |
| Capacity (Sacks) | 15 | 13 | 12 |
| Speed (MPH) | 17 | 12 | 19 |
| Team Size | 5 | 6 | 6 |
| Elf Seats | 3 | 2 | 1 |
Please create a graph comparing the features of the three sleds.
Please create a graph comparing the List price and the actual cost of the three sleds.
The red marks on the example graphs are to prevent cheating.
Make sure that your name is on the page, and print out a copy of your final work.
Please remember to save your work, as you are responsible for crashes, and operator error that may cause you to delete your work.
Text: The Bob Sled Company is pleased to announce the winter sled sale. Come in now for unbeatable deals on the new BOB 01 and take advantage of a HUGE manufacturers rebate and 0% interest form the Bob Sled Financing Company.