A emerging SaaS professional services platform - www.diligentsia.co.uk - requires assistance developing a comprehensive financial model to blueprint the next five years of business growth and operations. The selected freelancer will construct an Excel workbook containing pro forma profit and loss statements, balance sheets, cash flow statements and key operating metrics on a monthly basis through the 60th month of projected operations. Key assumptions justifying revenue and expense forecasts must be visible and dynamically linked throughout the model. We attach our current chart of accounts from Xero and will want to ensure consistency in how numbers are categorized. Once modeling is complete, the projected monthly financial results may be imported back into Xero as a budget to monitor against actual performance going forward. Applicants should demonstrate proficiency with advanced Excel functions to dynamically link assumptions and calculations across multiple worksheets and years. Experience developing models for SaaS software businesses undergoing high growth will be essential. SaaS Metrics calculations should include CAC cost of ARR, LTV to CAC ratio, CAC Payback Period, Margins, ROSE Metric, ACS. Once the model is built, I will expect 3 rounds of adjustments to be included in the fixed price.
