Question

In: Finance

Use Worksheet 7.1. Every 4 months, Sean Ma takes an inventory of the consumer debts that...

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?

Solutions

Expert Solution

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

Related Solutions

You deposit $4.1 thousand at the end of every six months for the next 4 years...
You deposit $4.1 thousand at the end of every six months for the next 4 years into an IRA account that earns 4.3% annually (compounded semiannually). How much will you have on the account after making the last deposit?
4. Emily likes bird watching. Every year she takes a vacation to a park famous for...
4. Emily likes bird watching. Every year she takes a vacation to a park famous for its rare birds. She goes there for 10 days. From her past experience, she knows that on average she can get 6 good sightings a day. A very good day for her is a day with at least 10 good sightings. Assume Poisson distribution of the number of good sightings on any day (independently of other days). a) What is the probability that she...
Someone deposits $200 every 6 months into an account that pays interest at 4% per year...
Someone deposits $200 every 6 months into an account that pays interest at 4% per year compounded quarterly. How much does this person have after 10 years?
An interest rate of 21% per year, compounded every 4 months, is equivalent to what effective...
An interest rate of 21% per year, compounded every 4 months, is equivalent to what effective rate per year? Show spreadsheet solutions
A 9.5% coupon rate bond (that pays interest every six months), with 4 years until maturity...
A 9.5% coupon rate bond (that pays interest every six months), with 4 years until maturity is selling at $950. An investor with a 10 required rate of return ask your advice. What is your advice regarding the purchase of the bond? Select one: A. don't purchase the bond because the bond is overvalued by $34.15 B. purchase the bond because the bond is undervalued by $34.15 C. don't purchase because the bond is overvalued D. purchase the bond because...
A 9.5% coupon rate bond (that pays interest every six months), with 4 years until maturity...
A 9.5% coupon rate bond (that pays interest every six months), with 4 years until maturity is selling at $950. An investor with a 10 required rate of return ask your advice. What is your advice regarding the purchase of the bond? Seleccione una: A.purchase the bond because the bond is undervalued by $33.84 B.not enough data to answer C.don't purchase because the bond is overvalued D.don't purchase the bond because the bond is overvalued by $34.15 E.purchase the bond...
Allstate Batteries advertises and sells a 4 year (48 months) battery. You work at Consumer Digest,...
Allstate Batteries advertises and sells a 4 year (48 months) battery. You work at Consumer Digest, a consumer advocacy organization, and have been receiving complaints from consumers who felt they were not receiving their full 48 months. Test Allstate’s claim that these are 48 month batteries at the 5% level of significance. You have tested a sample of 36 cars and found a mean of 45months and a standard deviation of 1 month. State the appropriate hypotheses from the consumers’...
State H0 and H1. Answer the question. Use megastat and submit software output. See Worksheet 4....
State H0 and H1. Answer the question. Use megastat and submit software output. See Worksheet 4. John Isaac Inc., a designer and installer of industrial signs, employs 60 people. The company recorded the type of the most recent visit to a doctor by each employee. A national assessment conducted in 2014 found that 53% of all physician visits were to primary care physicians, 19% to medical specialists, 17% to surgical specialists, and 11% to emergency departments. Test at the .01...
Step 1. 4% of Capital Balance Approach. Use the managing retirement distributions worksheet to calculate Faye’s...
Step 1. 4% of Capital Balance Approach. Use the managing retirement distributions worksheet to calculate Faye’s annual retirement income possibilities and inheritance, using a beginning-of-the-year withdrawal from ages 65-94 by withdrawing 4% of her capital the first year and with the remainder of her account earning 4% annual after-tax return. Retirement income should increase by 3% annually across retirement to keep pace with inflation. Start with a 4% withdrawal, but if it is not enough, then reduce downward until the...
How mighty a company choose the use of one of the 4 inventory valuation methods to...
How mighty a company choose the use of one of the 4 inventory valuation methods to strategize and or manipulate their earnings?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT