In: Finance
Use Worksheet 7.1. Every 4 months, Sean Ma takes an inventory of the consumer debts that he has outstanding. His latest tally shows that he still owes $3,750 on a home improvement loan (monthly payments of $175); he is making $105 monthly payments on a personal loan with a remaining balance of $625; he has a $2,250, secured, single-payment loan that's due late next year; he has a $90,000 home mortgage on which he's making $900 monthly payments; he still owes $7,100 on a new car loan (monthly payments of $400); and he has a $760 balance on his MasterCard (minimum payment of $40), a $30 balance on his Exxon credit card (balance due in 30 days), and a $900 balance on a personal line of credit ($50 monthly payments). Use Worksheet 7.1 to prepare an inventory of Sean's consumer debt. Round the answers to the nearest cent.
Type of Consumer Debt  | 
Creditor  | 
Currently Monthly Payment  | 
Latest Balance Due  | 
| Auto loans | $ | $ | |
| Personal installment loans | $ | $ | |
| Home improvement loan | $ | $ | |
| Single-payment loans | $ | ||
| Credit cards | MasterCard | $ | $ | 
| (retail charge cards, bank cards, T&E cards, etc.) | Exxon | $ | |
| Personal line of credit | $ | $ | |
| Totals | $ | $ | 
Find Sean's debt safety ratio given that his take-home pay is $2,500 per month. Round the answer to 1 decimal place.
%
Would you consider this ratio to be good or bad?
| Type of consumer debt | current monthly payment | latest balance due | |
| Auto loans | 400 | 7100 | |
| Personal installment loans | 105 | 625 | |
| Home improvement loan | 175 | 3750 | |
| Single-payment loans | 2250 | ||
| Credit cards | MasterCard | 30 | 760 | 
| (retail charge cards, bank cards, T&E cards, etc.) | Exxon | $ | 30 | 
| Personal line of credit | 50 | 900 | |
| Totals | 760 | 15415 | |
| Debt safety ratio = total of current monthly payment towards consumer debt payment/total take homepay | 760/2500 | 30.40% | |
| This ratio does not seems good as it is 30.4% while it should be with the limit of 15% to 20% of the take home pay |