DUE AFTER 12 HOURS
magic-1
excel_chapter_7.xlsxSales Data By Agent
| Bonus | Region | ||||||
| 3% | Domestic | ||||||
| 5% | International | ||||||
| 2015 Sales Total By Quarter | |||||||
| Sales Rep | Q1 | Q2 | Q3 | Q4 | Total | Location | Bonus |
| Ron | $ 29,911.00 | $ 92,249.00 | $ 46,475.00 | $ 33,947.00 | $ 202,582.00 | International | |
| Nick | $ 32,752.00 | $ 30,222.00 | $ 43,997.00 | $ 93,277.00 | $ 200,248.00 | International | |
| Sally | $ 36,991.00 | $ 54,102.00 | $ 63,914.00 | $ 42,642.00 | $ 197,649.00 | Domestic | |
| Susan | $ 50,087.00 | $ 25,179.00 | $ 64,912.00 | $ 68,875.00 | $ 209,053.00 | Domestic | |
| Bob | $ 52,923.00 | $ 62,673.00 | $ 63,635.00 | $ 57,410.00 | $ 236,641.00 | Domestic | |
| Mark | $ 59,678.00 | $ 70,934.00 | $ 78,410.00 | $ 32,994.00 | $ 242,016.00 | Domestic | |
| Swathi | $ 66,385.00 | $ 74,270.00 | $ 36,165.00 | $ 76,548.00 | $ 253,368.00 | Domestic | |
| Mike | $ 66,936.00 | $ 72,838.00 | $ 60,479.00 | $ 63,324.00 | $ 263,577.00 | Domestic | |
| Rick | $ 74,507.00 | $ 94,178.00 | $ 41,391.00 | $ 27,235.00 | $ 237,311.00 | Domestic | |
| Rich | $ 76,889.00 | $ 49,266.00 | $ 64,225.00 | $ 55,410.00 | $ 245,790.00 | Domestic | |
| Jill | $ 90,515.00 | $ 29,238.00 | $ 30,973.00 | $ 32,145.00 | $ 182,871.00 | Domestic | |
| John | $ 97,426.00 | $ 43,061.00 | $ 26,122.00 | $ 83,391.00 | $ 250,000.00 | Domestic | |
| Greg | $ 98,094.00 | $ 47,398.00 | $ 80,755.00 | $ 40,446.00 | $ 266,693.00 | International | |
| Look up | |||||||
| Sales rep name | |||||||
| Quarter | |||||||
| Amount sold |
Individual Awards
| Criteria | ||||||||
| Sales Rep | Q1 | Q2 | Q3 | Q4 | Total | Location | ||
| Sales Rep | Q1 | Q2 | Q3 | Q4 | Total | Location | Totals | |
| Ron | $ 29,911.00 | $ 92,249.00 | $ 46,475.00 | $ 33,947.00 | $ 202,582.00 | International | Total Number of Domestic reps | |
| Nick | $ 32,752.00 | $ 30,222.00 | $ 43,997.00 | $ 93,277.00 | $ 200,248.00 | International | Total Number of International reps | |
| Sally | $ 36,991.00 | $ 54,102.00 | $ 63,914.00 | $ 42,642.00 | $ 197,649.00 | Domestic | Max International Sales | |
| Susan | $ 50,087.00 | $ 25,179.00 | $ 64,912.00 | $ 68,875.00 | $ 209,053.00 | Domestic | Max Domestic Sales | |
| Bob | $ 52,923.00 | $ 62,673.00 | $ 63,635.00 | $ 57,410.00 | $ 236,641.00 | Domestic | ||
| Mark | $ 59,678.00 | $ 70,934.00 | $ 78,410.00 | $ 32,994.00 | $ 242,016.00 | Domestic | ||
| Swathi | $ 66,385.00 | $ 74,270.00 | $ 36,165.00 | $ 76,548.00 | $ 253,368.00 | Domestic | ||
| Mike | $ 66,936.00 | $ 72,838.00 | $ 60,479.00 | $ 63,324.00 | $ 263,577.00 | Domestic | ||
| Rick | $ 74,507.00 | $ 94,178.00 | $ 41,391.00 | $ 27,235.00 | $ 237,311.00 | Domestic | ||
| Rich | $ 76,889.00 | $ 49,266.00 | $ 64,225.00 | $ 55,410.00 | $ 245,790.00 | Domestic | ||
| Jill | $ 90,515.00 | $ 29,238.00 | $ 30,973.00 | $ 32,145.00 | $ 182,871.00 | Domestic | ||
| John | $ 97,426.00 | $ 43,061.00 | $ 26,122.00 | $ 83,391.00 | $ 250,000.00 | Domestic | ||
| Greg | $ 98,094.00 | $ 47,398.00 | $ 80,755.00 | $ 40,446.00 | $ 266,693.00 | International | ||
| Sales Rep | Q1 | Q2 | Q3 | Q4 | Total | Location |
Acquisition
| Input Area | Summary Calculations | ||||
| Facility costs | $ 720,000.00 | Loan Amount | |||
| Down Payment | $ 250,000.00 | No. Periods | |||
| # of Pmts per Year | 12 | Monthly Rate | |||
| Years | 30 | Monthly Payment | |||
| APR | 5.25% | Total Interest Paid | |||
| 1st Payment Date | 3/20/15 | ||||
| Payment # | Payment Date | Beginning Balance | Interest Paid | Principal Payment | Ending Balance |
