Enhance Financial Model
Budget: $30 – $250 USD
I am seeking an expert to add a new component to my financial model.
Key Tasks add the following to the model:
-Balance Sheet,
-Cash flow waterfall (start with revenue and showing all cash flows in the order that they rank all the way down to equity distributions & with the capability to run sensitivity analysis and break-even tests)
-Cash flows need to show how the interest is “serviced” (effectively capitalised) during construction from debt and equity. The capitalized interest will feed into the debt: equity ratio
-A detailed source and application summary which can be reconciled to the cash flow
-Functionality to sculpture debt re-payments to optimize the funding structure based on the cover ratios (Debt Service Cover Ratio, Interest Cover Ratio etc)
-Quarterly summary of the cash waterfall during operation to be able to assess the covenants at each payment date, which will typically be quarterly. (The annual summary is useful for overview and aggregation purposes.
Ideal Candidate:
- Comprehensive understanding of financial modelling and forecasting
- Advanced proficiency in Excel
- Exemplary ability to create and integrate an income statement into a financial model
Key Tasks add the following to the model:
-Balance Sheet,
-Cash flow waterfall (start with revenue and showing all cash flows in the order that they rank all the way down to equity distributions & with the capability to run sensitivity analysis and break-even tests)
-Cash flows need to show how the interest is “serviced” (effectively capitalised) during construction from debt and equity. The capitalized interest will feed into the debt: equity ratio
-A detailed source and application summary which can be reconciled to the cash flow
-Functionality to sculpture debt re-payments to optimize the funding structure based on the cover ratios (Debt Service Cover Ratio, Interest Cover Ratio etc)
-Quarterly summary of the cash waterfall during operation to be able to assess the covenants at each payment date, which will typically be quarterly. (The annual summary is useful for overview and aggregation purposes.
Ideal Candidate:
- Comprehensive understanding of financial modelling and forecasting
- Advanced proficiency in Excel
- Exemplary ability to create and integrate an income statement into a financial model