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:
- All approved monthly payments between $50 and $100
- All loans that have a down payment of less than $100 or $300 and more
- All electronics and appliance loans
- All loans, except electronics, with an installment price of over $500
- any loan that do not make (Carrying Charges) more than $100
|