Project Overview
My private investment firm, River Capital, seeks to find an analyst or investment professional that can help us on a financial model. We are considering the recapitalization of a company and have an annual three-statement financial model that we’d like to convert into a three-statement monthly financial model. We are looking to create a model that can use the budgeted financials the company has provided for 2023, and forecasted financials for 2024, to evaluate the financial performance of the company post-acquisition.
We have detailed profit and loss, balance sheet, and cash flow statements for budgeted 2023-Projected 2024 and are looking for someone that knows how to convert the model to forecast its performance through 2024 and 2025 monthly. We need to see on a monthly basis what the impact of the new debt is on the business.
We are looking for someone that has experience using “If:” and “Choose:” statements and data validation to create a flexible model that will allow us to change the acquisition month. We want to be able to change the acquisition month from say, December 2023 to January 2024 and to have that change flow through the three-statement model and debt tab. The months that should be changeable by using this function are November 2023 – May 2024.
This is a very old model, and there appear to be existing circular references. Please fix the model so that there are no circular references.
I’ve attached a copy of the financial model for your review.
Model Notes:
(Model->)
Inputs Tab: this tab drives the three-statement financial model found in tabs “Inc Stmt, BalSht, Cash Flow, and Debt.” The financial information found in this sheet comes from the (Int. Financials->) tabs “Int. Income Statements, Int. Balance Sheets, Int. Cash Flow Statements”.
** We only have Budgeted 2023 and Forecasted 2024 Cash Flow Statements in dollars; all prior years are in thousands. We are working to get the prior year’s financials in dollars. If this is an immediate problem, please let me know.
Assumptions
• Senior Loan: 6-year amortization, interest paid at 9% quarterly.
• Preferred: no principal repayment, 7% interest paid quarterly.
Candidate Qualities
• The ideal person for this job is someone with 10+ years of private equity or investment banking experience.
• Leveraged Finance Experience, Investment Banking experience or CPA, CFA, CAIA
Required
• Must speak crystal clear English.
• Be able to speak during U.S. business hours (8 am to 8 pm Est)
TO APPLY, please email me at with your resume and any relevant work experience. Please put LBO Analyst as the subject; ONLY CANDIDATES that put “LBO Analyst” in the subject will be considered. I will pay according to your experience and speed in completing this project.
Payment is via PayPal!
APPLY FOR THIS JOB:
Company: Figmints Digital Creative Marketing
Name: Tooker Callaway
Email: