Posted by **Jackie** on Tuesday, June 24, 2014 at 5:30pm.

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!

## Answer This Question

## Related Questions

- Math - Suppose you borrowed $25,000 for a car at an APR of 8%, which you are ...
- math - You'd also need to know the interest rate, the amount of the monthly ...
- math - On April 12, Michelle Lizaro borrowed $5,000 from her credit union at 9...
- math 20 (finance) - Can someone walk me through how I would enter this into the ...
- MAth - 1. John’s loans for his business total $155,000. One of the loans is a ...
- real estate finance - I need to find the mortgage loan amount and can't remember...
- math - There are thirty-five (35) members in the Kalamazoo Travel Club. Four (4...
- Math - Suppose you have student loans totaling $10,500 when you graduate from ...
- College math - Can someone please assist me The problem reads "use the rule of ...
- Statistics - At 100 college campuses, 1200 full-time undergraduate students were...

More Related Questions