Build Your Own Financial Planning Spreadsheet
- A basic knowledge on spreadsheet is strong recommended.
Starting with blank excel spreadsheet, together we build a financial model that include multiple savings levels, return / return expectations, time horizons, and scenarios. Almost certainly there is some for everyone interested in planning finances! The model is created such that it is easy to amend to tailor your own needs. Model builds on some Kroijer Youtube videos on investing.
Who this course is for:
- Anyone who is interested in financial planning.
- 11:43Adding Minimal Risk Asset
- 11:14Adding Volatility of Returns
- 18:56Adding Multiple Scenarios
- 10:54Adding Retirement Spending
- 11:57Compoung Annual Growth Rate (CAGR) vs. Average Return
- 11:07Adding Range of Allocations
- 14:35Estimating Fees
- 25:44Adding variable Cash In/Out Flows
- 17:30Model Walk-through and Taking Stock
Mr. Kroijer (born 1972) is the founder and managing director of Alliedcrowds – the leading directory and aggregator of alternative capital into the world’s 132 lower and middle income countries. He is the author of "Money Mavericks - Confessions of a Hedge Fund Manager" (Financial Times Press – 2010 & 2012 - 2nd edition) and “Investing Demystified – How to Invest without Speculation and Sleepless Nights” (Financial Times Press - 2013).
Mr. Kroijer currently serves on the advisory board of alternative investment funds in London, New York, and Hong Kong. He has frequently appeared as a finance expert on a broad range of media, including BBC, CNN, CNBC, FT, Bloomberg, Reuters, NY Times, Forbes, etc.
Previously Mr. Kroijer was the CIO of Holte Capital Ltd, a London-based market neutral special situations hedge fund which he founded in 2002 before returning external capital in the spring of 2008. Prior to establishing Holte Capital, Mr. Kroijer served in the London office of HBK Investments focusing on special situations investing. In addition, he previously worked at SC Fundamental, a value-focused hedge fund, and the investment banking division of Lazard Frères, both in New York. While in graduate school Mr. Kroijer held internships with the private equity firm Permira Advisors (then Schroder Ventures) and management consulting firm McKinsey & Co.
Mr. Kroijer graduated Magna cum Laude from Harvard University with a degree in economics and received a MBA from Harvard Business School.
A Danish national, Mr. Kroijer lives in London and is married with twin daughters.