posted by .

Lake Michigan Credit Union finances auto loans for its members. Each loan can be classified into one of four categories: paid in full, good standing, poor standing (with one or more missing payments), and delinquent (where the debt is sold to a collection agency).

Past records indicate that each month 10% of the accounts in good standing are paid in full, 70% stay in good standing, and 20% become poor standing.

Also, 50% of the accounts in poor standing move to good standing, 40% remain in poor standing, and 10% are delinquent.

Using excel, construct the transition matrix T for this situation. Be sure to label the states.

Suppose Lake Michigan Credit Union currently has 600 outstanding auto loans, 400 of which are in good standing, and 200 of which are in poor standing. In the long run, approximate how many of these auto loans will be paid in full, and how many will end up as delinquent.

***When I found the solution after putting the transition matrix into my calculator and then selecting rref the last two rows had zeros all the way across and I am stuck as to what it means when the fourth row has zeros all the way across. Please help!

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. math

    You'd also need to know the interest rate, the amount of the monthly payments, and how long you'll have to pay off the loan. The shorter period of time for the loan, the less you'll pay in interest, but the monthly payments will be …
  2. eng

    hows my outline look? Outline: 1)Post secondary education is unaffordable A)Poor students can’t afford tuition (Stat) tuition has increased by Fifty-percent B) The Government has implemented grants, scholarships and student loans
  3. Comm/155

    I need to know if these are correct I have Bolded the adverbs and underlined the adjectives. I have had both good and bad experiences when dealing with credit cards. My credit went from good to better and eventually to what I thought …
  4. math 20 (finance)

    Can someone walk me through how I would enter this into the calculator TMV solver. Can it be done?
  5. Com/155

    Can some one check these for correct advebs and adjectives. I was extremely irresponsible in my younger years. I was not fully educated with credit card debt. The debt added up much faster than expected. The interest rates were extremely …
  6. MAth

    1. John’s loans for his business total $155,000. One of the loans is a SBA loan at 11% interest; the other loan is a Community Business Partner loan whose interest is 6.5% After one year the loans accumulated $12,325 in interest. …
  7. Economics

    The Tax Reform Act of 1986 eliminated the deductibility of interest payments on consumer debt (mostly credit cards and auto loans) but maintained the deductibility of interest payments on mortgages and home equity loans. What do you …
  8. math

    On April 12, Michelle Lizaro borrowed $5,000 from her credit union at 9% for 80 days. The credit union uses the ordinary interest method. a. What is the amount of interest on the loan?
  9. Math

    Suppose you borrowed $25,000 for a car at an APR of 8%, which you are paying off with monthly payments of $510 for 5 years. a) What’s the loan principal?
  10. Finance

    THe dumonts take- home pay ( after deductions for taxes and benefits ) is approximately $6045 monthly. currently nonmortgage debt payments equal $911 (i.e, $405 auto, $100 miscellaneous credit, $196 student loan, and $210 furniture). …

More Similar Questions