In: Economics
A friend of yours just bought a new sports car with a $4,500 down payment, and her $32,000 car loan is financed at an interest rate of 0.50% per month for 36
months. After 2 years, the "Blue Book" value of her vehicle in the used-car marketplace is $10,000.
a. How much does your friend still owe on the car loan immediately after she makes her 24th payment?
b. Compare your answer to Part (a) to $10,000.
This situation is called being "upside down." What can she do about it?
| LOAN AMOUNT | 32000 | |
| RATE OF INTEREST PER ANNUM | 6% | |
| RATE OF INTEREST PER MONTH | 1% | |
| NO OF INSTALLMENT | 36 | 
| MONTHS | EMI | INTEREST | PRINCIPAL REPAYMENT | OST PRINCIPAL | 
| 0 | 32000 | |||
| 1 | 974 | 160 | 814 | 31186 | 
| 2 | 974 | 156 | 818 | 30369 | 
| 3 | 974 | 152 | 822 | 29547 | 
| 4 | 974 | 148 | 826 | 28722 | 
| 5 | 974 | 144 | 830 | 27892 | 
| 6 | 974 | 139 | 834 | 27058 | 
| 7 | 974 | 135 | 838 | 26219 | 
| 8 | 974 | 131 | 842 | 25377 | 
| 9 | 974 | 127 | 847 | 24530 | 
| 10 | 974 | 123 | 851 | 23679 | 
| 11 | 974 | 118 | 855 | 22824 | 
| 12 | 974 | 114 | 859 | 21965 | 
| 13 | 974 | 110 | 864 | 21101 | 
| 14 | 974 | 106 | 868 | 20233 | 
| 15 | 974 | 101 | 872 | 19361 | 
| 16 | 974 | 97 | 877 | 18484 | 
| 17 | 974 | 92 | 881 | 17603 | 
| 18 | 974 | 88 | 885 | 16718 | 
| 19 | 974 | 84 | 890 | 15828 | 
| 20 | 974 | 79 | 894 | 14933 | 
| 21 | 974 | 75 | 899 | 14035 | 
| 22 | 974 | 70 | 903 | 13131 | 
| 23 | 974 | 66 | 908 | 12223 | 
| 24 | 974 | 61 | 912 | 11311 | 
| 25 | 974 | 57 | 917 | 10394 | 
| 26 | 974 | 52 | 922 | 9473 | 
| 27 | 974 | 47 | 926 | 8546 | 
| 28 | 974 | 43 | 931 | 7616 | 
| 29 | 974 | 38 | 935 | 6680 | 
| 30 | 974 | 33 | 940 | 5740 | 
| 31 | 974 | 29 | 945 | 4795 | 
| 32 | 974 | 24 | 950 | 3846 | 
| 33 | 974 | 19 | 954 | 2892 | 
| 34 | 974 | 14 | 959 | 1932 | 
| 35 | 974 | 10 | 964 | 969 | 
| 36 | 974 | 5 | 969 | 0 | 
a. After 24th payment, she owes $11311=32000-20689
b. When compared to blue book of 10000, she owes more by $1311
With the loan amount more than book value, she can ask the trader to include the difference amount before trading and get a better deal or needs to cover the difference amount before making the sale.