Google: Fusion Tables - Exeter Finance

Instructions:

Import the data file into a Fusion Table.

Add two calculated fields:  Installment Price and Carrying Charges 

Installment Price: The Installment Price can be determined by multiplying the monthly payments by the Number of Monthly Payments and adding in the Down Payment

Carrying Charges: The Carrying charges can be determined by subtracting the cash price from the installment price.

Queries:

1. All approved monthly payments between $50 and $100 

2. All loans that have a down payment of less than $100 or $300 and more 

3. All electronics and appliance loans 

4. All loans, except electronics, with an installment price of over $500 

5. any loan that do not make (Carrying Charges) more than $100