Calculating debt safety ratio. Use Worksheet 7.1(attached below). Every 6 months, Sean Ma takes an inventory of the consumer debts that he has outstanding. His latest tally shows that he still owes $4,000 on a home improvement loan (monthly payments of $125); he is making $85 monthly payments on a personal loan with a remaining balance of $750; he has a $2,000, secured, single-payment loan that's due late next year; he has a $70,000 home mortgage on which he's making $750 monthly payments; he still owes $8,600 on a new car loan (monthly payments of $375); and he has a $960 balance on his MasterCard (minimum payment of $40), a $70 balance on his Exxon credit card (balance due in 30 days), and a $1,200 balance on a personal line of credit ($60 monthly payments). Use Worksheet 7.1 to prepare an inventory of Sean's consumer debt. Find Sean's debt safety ratio given that his take-home pay is $2,500 per month. Would you consider this ratio to be good or bad? Explain. A1 ✓ fx Worksheet 7.1 E D A B C 1 Worksheet 7.1 AN INVENTORY OF CONSUMER DEBT 2 Date 3 Name 6 Creditor Type of Consumer Debt 7 Auto loans 8 9 10 Education loans 11 12 Personal installment loans 13. 14 Home improvement loan 15 Other installment loans 16 17 Single-payment loans 18 19 Credit cards (retail charge 20 cards, bank cards, T&E 21 cards, etc.) 22 23 24 25 26 Overdraft protection line 27 Personal line of credit 28 Home equity credit line 29 Loan on life insurance 30 Margin loan from broker 31 Other loans 32 33 34 35 5672 36 X 37 1. 3. 1. 2. 1. 2. 1. 1. 2. 3. 4. 5. 6. 7. 1. 2. 3. Totals $ Debt safety ratio= Total monthly payments Monthly take-home pay *100= "Leave the space blank if there is no monthly payment required on a loan (e.g., as with a 39 single-payment or education loan). 2. 1. 2. F May 29, 2022 Current Monthly Payment G $ H Latest Balance Due -*100 = 0.0%