Project Consultant, Financial Model for Income Share Agreements and Loans

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Develop a financial model for a labor mobility initiative connecting Colombia and Spain.

• Structure the financing of workers' migration costs through income share agreements or loans.

• Analyze repayment dynamics for individual borrowers and the internal rate of return (IRR) at the portfolio level.

• Create and design a portfolio model accommodating 5 to 50 borrowers.

• Incorporate a comprehensive assumptions tab and dynamic scenario planning tools within the Excel model.

• Draft a methodology note spanning 2–3 pages.

• Facilitate a walkthrough and Q&A session for the LaMP team.

• Update the model based on feedback received from LaMP.

• Offer continued support at an hourly rate post-delivery, as required.

⛳️ Requirements

• Bachelor's degree in finance, economics, business, or a relevant field, or equivalent professional experience.

• Demonstrated experience in constructing financial models (cash flow, scenario analysis, IRR).

• Background in income share agreements and student or microfinance lending.

• Proficiency in building models that operate with multiple currencies.

• Capability to clearly articulate model and scenario analysis functions to non-specialists.

• Strong understanding of every spreadsheet cell and formula used.

• Working knowledge of Spanish is advantageous.

• Submit a CV along with a concise cover letter.

• Provide daily and hourly rates, estimated project hours, and client references.

🏝️ Benefits

• Continued support at an hourly rate after delivery, as required.

• Opportunity for ongoing project-based assignments.

• Flexible remote work arrangement.