🀫 The investment funds cheat sheet


Hey Reader,
​
I once was tasked with creating a forecast for a VC fund...and to be honest, I had no idea where to begin.

Funds have always been really complicated until I really understood the way they operate.

Today, I want to share with you my learnings so that anytime you come across work for a fund, you have that much more experience and can do a good job.

Let's begin!


What we’re going to talk about

What is Custom Formatting?

Why Should You Care About Custom Formatting?

How to Access Custom Formatting

The Secret Formula: Understanding the Syntax

Powerful Formatting Elements

Real-World Applications

​

This newsletter is sponsored by Mighty Digits.

​

A fund is an investment vehicle that collects capital from investors and then deploys that capital into various investments.
​
The hope is that the return on investments that the fund makes will exceed the capital invested (plus a minimum return)…
​
returning capital to both the investors.
​
as well as the fund managers / investment advisors.


Management Fee β†’ Often times there’s a fee associated with managing the fund based on a % of Assets Under Management (AUM).

Carried Interest β†’ Some funds have a performance kicker, where the General Partner gets a % of the funds return once a β€œhurdle” is reached.

The GP takes their performance kicker, then returns the profits to the investors


Funds can either be Private funds, or Registered funds.
​
​Private funds generally:
​
β€’ are exempt from registering with the SEC
​
β€’ can only collect capital from accredited investors (called Limited Partners or β€œLPs”)
​
β€’ have less flexible liquidity options

Registered funds generally:
​
β€’ must register with the SEC
​
β€’ can collect capital from a wider range of individuals
​
β€’ offer same day liquidity


The most common funds are:
​
​Hedge Funds​
​
πŸ’Έ capital is oftentimes invested in public equities
​
⏱️ no specific exit strategy or timeline
​
​Venture Capital Funds (VC)​
​
πŸ’Έ capital is invested in high-growth startups
​
⏱️ funds are typically 10 years (though can be extended)
​
​Private Equity Funds (PE)​
​
πŸ’Έ capital is invested in later-stage, private companies (generally those that are profitable)
​
⏱️ funds are typically 10 years (though can be extended)
​
​Credit Funds​
​
πŸ’Έ capital is invested in debt instruments
​
⏱️ funds life cycle is usually 7-10 years


Mutual Funds​
​
πŸ’Έ capital is oftentimes invested in stocks / bonds
​
ex: Vanguard 500index funds (VFIAX), which aims to replicate the performance of the S&P 500 index
​
​Index Funds​
​
πŸ’Έ capital is invested in assets matching index components
​
ex: S&P 500, which is an index of the 500 largest publicly traded companies
​
​Exchange Traded Funds (ETFs)​
​
πŸ’Έ similar to an index fund, only it’s traded on stock exchanges
​
ex: SPDRY S&P 500 ETF Trust (SPY)
​
​Real Estate Investment Trusts (REITs)​
​
πŸ’Έ capital is invested in real estate properties or assets
​
ex: Vanguard Real Estate ETF (VNQ)

That’s my take on funds…I learned a TON while preparing this.
​
and I have a lot more to learn.
​
What would you add?
​
Let me know by replying to this email.

Till next time!


Did you enjoy this email?


​

When you’re ready, here are a few ways in which I can help you:

Download my bundle of 10 FP&A Templates​

These templates include a variety of accounting topics from helping you grasp the basics to more advanced ones designed to help you run your accounting function.

Learn how to build a simple 3 Statement Model​

Learn the foundations of creating a 3 Statement Model in less than 2 hours.

Create 15 CFO Dashboards & Reports in Excel

Get access to 15 stunning CFO Dashboards & Reports, and learn how to build them all from scratch.

Work with me 1:1

Got a special project, or perhaps you’d like to learn more about how you can accelerate your career as an accountant? Simply hit the button below, tell me a little about what you're trying to accomplish and I'll get you all the details.


Josh (Your CFO Guy)
​
Fractional CFO for Startups | Founder & CEO at Mighty Digits

​

This email is part of my weekly newsletter, FP&A Secrets.
If you no longer want to receive emails on this topic, or if you want to subscribe to other Finance & Accounting topics, you can do so over
here.


Looking to change the frequency of emails, or unsubscribe?

​​Click here to manage your preferences​

​​Unsubscribe me from everything​

Your CFO Guy

NEW YORK, United States of America

​

Daily Finance & Accounting Tips

Sign up now to join a community of 80,000+ people who receive my curated selection of the most exciting and thought-provoking content straight to your inbox every week!

Read more from Daily Finance & Accounting Tips

Hey Reader, You know what drives me crazy? When people talk about departmental budgeting like it's all about the spreadsheets. I mean seriously... most finance pros obsess over formulas and formatting while ignoring the actual hard part: Working with people. After building financial processes for dozens of companies, I can tell you this: departmental budgeting fails because of relationship breakdowns, not calculation errors. Your fancy Excel model means nothing if your Marketing Director...

Hey Reader, I’m super excited to share some big news with you today - we’re growing the team here at Your CFO Guy! πŸŽ‰ Over the past few years, it’s been incredible watching our community grow to over 400,000 LinkedIn followers and 100,000+ newsletter readers like yourself. All this growth means we need more awesome people to help us continue creating valuable content and supporting our community. We’re Looking for Talented Team Members We have three positions open, and honestly, they have a...

Hey Reader, After my last few emails, I’ve received a lot of great questions about how exactly our community works. I love these questions because they show you’re doing your due diligence - exactly what a great CFO should do. I thought it would be helpful to share everything in one comprehensive breakdown. This way, you’ll have all the information you need to make the right decision before our founding member deadline on Thursday. Let me walk you through everything, question by question. Who...