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

- Economics - The Tax Reform Act of 1986 eliminated the deductibility of interest ...
- Comm/155 - I need to know if these are correct I have Bolded the adverbs and ...
- 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 20 (finance) - Can someone walk me through how I would enter this into the ...
- math - On April 12, Michelle Lizaro borrowed $5,000 from her credit union at 9...
- eng - hows my outline look? Outline: 1)Post secondary education is unaffordable ...
- Com/155 - Can some one check these for correct advebs and adjectives. I was ...
- 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...

More Related Questions