Project Consultant: Financial Model for Income Share Agreements and Loans
About The Position
Labor Mobility Partnerships (LaMP), a Washington, D.C.-based nonprofit working to build sustainable and fair ecosystems for cross-border labor migration, 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 can be financed through income share agreements (ISAs) or loans and how those costs are repaid. The consultant will design and build a portfolio model for 5 to 50 borrowers financed through an ISA or a loan. It should show repayment dynamics for each borrower and calculate IRR at the portfolio level. Deliverables include an Excel model with a clear assumptions tab and dynamic scenario-planning tools, a short methodology note of 2–3 pages, a walkthrough and Q&A session with the LaMP team, and a revised model incorporating the team’s feedback. Ongoing support may be provided at an hourly rate after delivery, as needed. This first project is expected to run from November to December 2026. LaMP is interested in establishing a long-term relationship with a consultant for additional project-based work as needs arise. The work is remote, and compensation will be hourly or daily based on the applicant’s proposal.
Requirements
- Bachelor’s degree in finance, economics, business, or a related field, or equivalent professional experience.
- Proven experience building financial models, including cash flow, scenario analysis, and IRR.
- Experience building models with multiple currencies.
- Ability to clearly explain model and scenario-analysis functionality to non-specialists.
- A firm understanding of how every spreadsheet cell and formula relates to the rest of the model.
Nice To Haves
- Experience with income share agreements and student or microfinance lending.
- Working knowledge of Spanish.
Responsibilities
- Design and build an Excel portfolio model for 5 to 50 borrowers financed through an income share agreement or a loan.
- Model repayment dynamics for each borrower and IRR at the portfolio level.
- Create a clear assumptions tab and dynamic scenario-planning tools.
- Prepare a 2–3-page methodology note.
- Walk the LaMP team through the model and answer questions.
- Revise the model to incorporate LaMP’s feedback.
- Provide ongoing support after delivery at an hourly rate, as needed.
