Excel Practice Test
Blacksmith G
DSSCapstoneInputv4.xlsxAuto Loan
| Auto Loan Calculation | One-Variable Data Table | Two-Variable Data Table | |||||||||
| Effect of Loan Amount Change on Payment, Percent Capital, and Insurance Cost | Effect of Purchase Price and Rate Change on Payment | ||||||||||
| Income | Auto Loan Information | ||||||||||
| Annual Income | $ 50,000.00 | Purchase price | $ 21,544.38 | ||||||||
| Monthly Income | $ 4,166.67 | Down payment | $ 5,000.00 | ||||||||
| Income tax rate | Amount of loan | $ 16,544.38 | |||||||||
| Monthly take home | $ 4,166.67 | Interest rate | 4.25% | ||||||||
| Total number of payments | 60 | ||||||||||
| Expenses | |||||||||||
| Rent | $ 1,200.00 | Loan Summary | |||||||||
| Utilities | $ 125.00 | Monthly payment | |||||||||
| Dining out | $ 250.00 | Total value repaid | $0.00 | ||||||||
| Entertainment | $ 150.00 | Total interest paid | ($16,544.38) | ||||||||
| Misc | Percentage of available capital | ERROR:#DIV/0! | |||||||||
| Total | $ 1,725.00 | Insurance rate based on total car price | 6% | ||||||||
| Annual insurance premium | $992.66 | ||||||||||
| Available capital | |||||||||||
| . | |||||||||||
| Monthly Income | Tax Rate | ||||||||||
| $0 | 5.75% | ||||||||||
| $2,500 | 6.00% | ||||||||||
| $3,500 | 6.25% | ||||||||||
| $4,500 | 6.50% | ||||||||||
| $5,500 | 6.75% | ||||||||||
Subtotals
| George's Groceries | ||||||||||
| 2012 Sales Results | ||||||||||
| Quarter 3 | ||||||||||
| Department | ||||||||||
| Month | Location | Produce | Meat/Seafood | Dairy | Bakery | Frozen Foods | Beverages | Home | Misc. | Total |
| July | Brooklyn Drive | $ 12,578.65 | $ 13,349.16 | $ 10,264.31 | $ 7,568.49 | $ 9,205.76 | $ 7,413.96 | $ 8,500.26 | $ 8,044.03 | $ 76,924.62 |
| July | Main Street | $ 9,974.21 | $ 12,403.85 | $ 9,018.49 | $ 6,902.58 | $ 8,193.25 | $ 6,729.54 | $ 7,198.05 | $ 7,930.55 | $ 68,350.52 |
| July | Park Avenue | $ 10,467.68 | $ 12,946.37 | $ 9,583.44 | $ 7,164.83 | $ 8,759.68 | $ 7,006.24 | $ 7,761.59 | $ 8,167.94 | $ 71,857.77 |
| August | Brooklyn Drive | $ 9,975.26 | $ 12,267.34 | $ 9,943.02 | $ 8,017.38 | $ 9,992.76 | $ 7,048.97 | $ 8,047.31 | $ 8,847.72 | $ 74,139.76 |
| August | Main Street | $ 8,762.14 | $ 13,086.31 | $ 8,647.16 | $ 7,342.95 | $ 8,594.62 | $ 6,549.22 | $ 7,214.32 | $ 8,604.51 | $ 68,801.23 |
| August | Park Avenue | $ 9,035.48 | $ 10,296.18 | $ 9,728.49 | $ 7,005.24 | $ 9,027.39 | $ 6,978.35 | $ 8,002.54 | $ 7,568.38 | $ 67,642.05 |
| September | Brooklyn Drive | $ 12,763.01 | $ 13,005.57 | $ 10,883.77 | $ 7,961.58 | $ 9,564.17 | $ 7,961.46 | $ 8,849.67 | $ 7,946.15 | $ 78,935.38 |
| September | Main Street | $ 10,025.19 | $ 11,367.28 | $ 8,884.22 | $ 7,104.39 | $ 8,468.79 | $ 6,597.36 | $ 7,364.55 | $ 8,241.34 | $ 68,053.12 |
| September | Park Avenue | $ 11,597.36 | $ 12,381.49 | $ 9,761.47 | $ 8,029.64 | $ 8,579.47 | $ 7,154.28 | $ 8,210.19 | $ 8,269.49 | $ 73,983.39 |
