andrew@agcapitalcfo.com
+1 214 7363614

What’s in Common between Financial Modeling and Boxing?!

Financial Modeling is Like Boxing! It seems that financial modeling has something in common with boxing! Since 2013 I’ve been taking part in ModelOff Financial Modeling World Championships, qualifying to the finals twice and taking the 5th place in the 2017 New York Finals. I have recently discovered that there is another financial modeling competition...
Read More →

Dynamic Chart in Excel the Simple Way

The Background I live in a EU country that is rich in 2 things – forest and educated people. The proportion of people with higher education is one of the best in the world. We are a relatively small nation, just below 2 million people. Population density is quite low, so there is plenty of...
Read More →

OFFSET Formula – an Easy Example to Understand

The background One of my friends has recently asked me which Excel formula do I consider to be the most powerful. There are many aspects to define what is powerful. If I define it like “Which formula has saved me the most of time after I mastered it?” – then the answer obviously is the...
Read More →

The Best Non-Financial Modeling Book for Financial Modelers

The White Swan About a year ago I’ve been modeling a potential M&A project. A retail company was about to buy its closest rival. The target company was in a brilliant situation – high sales, high margins, very good EBITDA, no debt. We have modeled the potential development of the target company’s business with seemingly...
Read More →

Financial Modeling Self Study Plan

A New Guy Joins our Team Next Monday we at CFOTemplates.com will welcome a new analyst to join our team. The person has a solid 15-year track record in the field of corporate finance. However, we will still need to teach him some specifics and advanced tricks of financial modeling. We will also have to...
Read More →

CAPEX and Depreciation Projections: a Universal Approach

CAPEX and Depreciation Projections I’ve been doing financial modeling since 2001. Initially – for my employers, then for my clients on the local market. In 2011 we have launched CFOTemplates.com website and now my financial models are being used around the world. CAPEX and depreciation projections have always been an integral part of these financial...
Read More →

Financial Modeling Explained to a 7-y.o. Kid

My daughter sometimes asks me “Dad, what do you do?” OMG, how shall I make financial modeling explained to her? My usual answer is kind of simple: “I do financial modeling for companies to help them maximize their ROI thanks to well-calculated decision-making” – but not for a 7-year old kid.   So, I decided...
Read More →

My CFM Exam Preparation

It seems that sharing my experience about the AFM exam was very useful for the readers. So, here are my thoughts about my CFM exam preparation (I took the exam last Saturday). The Chartered Financial Modeler is the 2nd level qualification of the new world-wide certification that has been launched and is administered by the...
Read More →