Urs Walchli
Nov 6, 2017
Edited: Dec 4, 2017

Deal Valuation (Term Sheets)

Determine the implied valuation of the securities used in alternative deal structure (typically Round A financing).

 

Dividend rights, liquidation preference, participation rights, and conversion rights can have far-reaching value implications when financing deals. This Excel File helps you value the common financing instruments used in deal financing, including Straight Preferred, Convertible Preferred, and Participating Preferred. The ideas and concepts behind these deal structures are discussed in detail in our online course "Deal Structuring."

0 comments0 replies
New Posts
  • Urs Walchli
    Mar 22, 2018

    Finanzcockpit (Deutsch)

    Discussion 
    Mit diesem Excel-File können sie wichtige Finanzkennzahlen rasch berechnen und leicht verständlich darstellen. Einen ausführlichen Guide zum Thema Finanzanalyse finden Sie in Englischer Sprache im Modul " Financial Analysis for Managers "
  • Urs Walchli
    Nov 6, 2017

    Finance Cockpit

    Discussion 
    This Excel file helps you compile common-size balance sheets and income statements. It also computes many different financial ratios (liquidity, activity, financing policy, profitability, value creation) for your firm, shows your cash conversion cycle, tracks the roots of your return on equity (ROE), and provides a comprehensive graphical analysis of all these dimensions of firm performance. For a comprehensive guide to financial analysis, click here .
  • Urs Walchli
    Nov 6, 2017

    Cost of Capital with Preferred Stock

    Discussion 
    This Excel file allows you to estimate the cost of capital of a firm that has Preferred Stock outstanding. It helps you unlever and relever the relevant betas to determine the cost of capital (WACC) under the target capital structure.