Asset Management Company - Closed End Fund Model (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Provides analysis of a Closed-End Fund hosted by an Asset Management Company.

INTEGRATED FINANCIAL MODEL EXCEL DESCRIPTION

This product (Asset Management Company - Closed End Fund Model) is an Excel template (XLSX), which you can download immediately upon purchase.

Financial Model presenting a scenario of a Closed-End Fund managed by an Asset Management Company.

Closed-End Funds have a fixed maturity and a fixed amount of money to invest. Since Closed-End Funds have a fixed length, investors can invest in the beginning and receive their profits at the end of the fund.

In closed-end funds there is an interaction between the investors and the AMC. Investors will be paid, and a gain or loss will be generated at the end of the fund (typically 10 years with a maximum extension of 3 years.).

The Asset Management Company (AMC) receives two different kinds of remunerations during the life time of the Investment: Management Fees and Carried Interest.

Management fees correspond to the amount of money an AMC receives every year from closed-end funds. The management fees is a fixed percentage of money calculated on the value of the closed-end fund in the beginning of the fund itself.

The second source of remuneration for the AMC is made up of the carried interest and it is computed only at the end of the closed-end fund's life cycle. The carried interest is the spread between the final IRR and a hurdle (a.k.a. threshold) IRR multiplied by a fixed percentage. Usually, the fixed percentage ranges between 25-30%; the hurdle rate ranges between 7-8%. This means that, at the end of the fund, the AMC will receive a carried interest only if the final IRR is larger than 7-8%.

This Financial model analyzes a Closed-End Fund and includes assumptions of Fund Life, Total Fund Size, Investment Period, Capital Drawdown, Dividends and Exit Multiple, Debt, Fund Expenses & Fees, Investors Share (LPs and GPs), Hurdle Rate, Carried Interest and Catchup. It calculates Fund Cash Flows including analysis of Portfolio Investments and Returns per Investment, Investors (LPs) and Managers (GPs) Cash Flows and Returns ad a Fund Summary presenting Fund's key metrics and returns.

Inputs:
•  General Business Info & Reporting Metrics
•  Fund Terms (Fund Size, Debt & Equity, Fund Length, Extension Periods, Investment Periods)
•  Fund Fees & Expenses (Set up Expenses, Management Fee, Administrative Expenses, Transaction Fees)
•  Investments Assumptions (Capital Drawdown per Year, Dividends, Exit Multiple)
•  Investors Assumptions (LPs and GPs Equity Share, Hurdle Rate, Carried Interest, GP Catch Up, After/Before Principal Catch up Calculation)
•  LPs Assumptions (equity contribution for 4 different investors)

Outputs:
•  Fund Cash Flows including analysis per Investment, Debt Schedule, Fund Fees & Expenses, Gross & Net Fund Returns (IRR, MOIC, TVPI, DPI) and Portfolio NAV
•  Partnership Returns Waterfall analyzing the distribution between LPs and GPs including calculation of GP Catch up (Before or After Principal) and Carried Interest.
•  Investors (LPs) Cash Flows analyzing Contributions, Distributions, Profit, Pre and Post Catchup and Carry Returns (IRR, MOIC)
•  Executive Summary presenting overall Closed-End Fund performance

Help & Support

Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user's needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.

This model provides a comprehensive framework for analyzing the financial dynamics of a Closed-End Fund, enabling you to make informed investment decisions. With detailed cash flow projections and performance metrics, it equips executives with the insights needed to optimize fund management and maximize returns for both LPs and GPs.

Source: Best Practices in Integrated Financial Model Excel: Asset Management Company - Closed End Fund Model Excel (XLSX) Spreadsheet, Profit Vision