Financial modelling of investment instrument

The first specific job requires financial modeling expertise in Excel to calculate the IRRs and return multiples for a floating rate mezzanine note. I have all the economic terms of the note (e.g. maturity, accrual rates, cash pay vs PIK, base rate and margins, OID). The successful candidate will be able to quickly use the economic terms provided to calculate the returns using the XIRR function in Excel.

The timeframe for this specific project is relatively fast, with a target deadline of end of day on Tuesday April 9th.

In addition to the above discrete project, the second job includes additional business analysis and financial projection modeling for a new investing business. We will need to work together to develop the key assumptions and develop a financial presentation based on the work.