Financial Model & Valuation Analysis
Budget: $10 – $30 USD
I already have several years of historical figures—revenue & expenses, assets & liabilities, and cash-flow data—plus forward assumptions supplied by my university supervisor. I now need everything pulled together in one clear, Excel-based model that extends the story into the future.
Here is what I’m looking for:
• Complete, linked Income Statement, Balance Sheet, and Cash Flow Statement projections.
• Calculation of free cash flow to the firm (FCFF) and a discounted cash-flow valuation that rolls through to an implied equity value per share.
• Return on invested capital (ROIC) derived directly from the model.
• Sensitivity tables showing how value shifts when WACC and the terminal growth rate (g) move within reasonable ranges.
I will provide the raw historical data and the supervisor’s forecast assumptions; you turn that into a clean, auditable workbook with clearly labelled sheets and formulas (no hard-coded numbers hidden in the cells). Please let me know your typical timeline and any clarifying questions you have once you review the files.
Here is what I’m looking for:
• Complete, linked Income Statement, Balance Sheet, and Cash Flow Statement projections.
• Calculation of free cash flow to the firm (FCFF) and a discounted cash-flow valuation that rolls through to an implied equity value per share.
• Return on invested capital (ROIC) derived directly from the model.
• Sensitivity tables showing how value shifts when WACC and the terminal growth rate (g) move within reasonable ranges.
I will provide the raw historical data and the supervisor’s forecast assumptions; you turn that into a clean, auditable workbook with clearly labelled sheets and formulas (no hard-coded numbers hidden in the cells). Please let me know your typical timeline and any clarifying questions you have once you review the files.