The Assignment 
LaMP is seeking a project consultant to build a financial model for a labor mobility project between Colombia and Spain. The model will show how workers’ migration costs are financed through income share agreements (ISAs) or loans, and how those costs are repaid. Our goal is a long-term relationship with a consultant who can pitch in on LaMP projects as needs arise; this project is the first. Scope of Work 
The consultant will design and build a portfolio model for 5 to 50 borrowers financed through an ISA or a loan. The model should show repayment dynamics for each borrower and IRR at the portfolio level. Deliverables A first version of the financial model (Excel) with a clear assumptions tab and dynamic scenario planning tools, plus a short methodology note (2–3 pages) A walkthrough and Q&A session for the LaMP team to review the model  A revised version of the model incorporating LaMP’s feedback Ongoing support at an hourly rate after delivery, as needed