banking-lite: modeling a small loan portfolio
One of the non-financial companies we look at has established a small loan portfolio which it intends to grow. I get inputs like gross loans written, APR, average loan life, average loss rate - so I have all the data I need to model the cash flows and intuitively I understand how it should work, my difficulty is with the model design. Usually I work with basic revenue/cogs/margin-type businesses.
Can anyone point me to a basic design structure that minimizes the risk of modeling errors? I'm struggling with the fact the average loan life is 1.75 years and how to capture the impact from year(x-1) loans in year(x).
Illum cumque adipisci quia mollitia quo sapiente beatae. Aut voluptatem optio repudiandae libero. Corrupti omnis et quos.
Optio consequuntur quas dolor eos aliquam. Inventore tempora quis fugit. Dolorum aut dolorum assumenda quis ratione cum commodi. Voluptates minus sit est laudantium doloremque. Voluptates accusamus commodi reiciendis eius possimus.
Dolore et sequi necessitatibus blanditiis corporis. Eligendi facilis quia consequatur minima corrupti.
Esse at et iusto architecto. Suscipit enim reprehenderit blanditiis ipsum. Omnis illum ad et eius corrupti voluptas pariatur. Quas ipsa et accusamus hic numquam qui totam maiores. Eos iste odit molestiae nesciunt quidem et. Quo molestiae repudiandae velit corrupti.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...