Top Q&A in Financial Planning and Analysis (FP&A)
Financial Planning and Analysis (FP&A) team provides strategic inputs and forecasts to the top management, including that of profit and loss statement, budgeting, and financial modeling of projects. In this article, we talk about the top 10 FP&A Interview Questions and answers that will guide you to prepare well and crack the interview you would face in the near future.
#1 – What’s the difference between budgeting and forecasting?
There are two main differences between budgeting and forecasting.
- Budgeting is setting up a plan for the future that the income and the expenses would be such. Whereas, forecasting is an estimate of what may actually happen. Forecasting is based on real data, historical inputs, and ascertained by using statistical, survey methods.
- Budgeting is often static and not usually updated for a year. Forecasting is not static since it enables a company to understand what may actually happen in the near future. That’s why every once in a quarter, forecasted data is updated.
#2 – Let’s say that you’re a CFO of a company. What would you keep you awake at night?
(To answer this question, first, you need to think of what a CFO does for a company. A CFO ensures that the company has enough liquidity, and the rate of return is more than the cost of capital (think about the weighted average cost of capital, which we can calculate by using the cost of equity and the cost of debt). So, a CFO will work on ensuring the financial well-being of a company.)
The question is subjective. Depending on the financial condition of the company, I may find that I need to reduce the overall cost of capital of the company. That’s why I may increase the debt-equity ratio by lowering the equity and enhancing the debt, or maybe I need to take care of the current liabilities of the company. Depending on what the firm is struggling with, I will strategize and solve the problem.
#3 – How vital three financial statements are? Can you talk briefly about them?
Three financial statements are the backbone of a company’s financial health. If you want to know how a company is doing, just have a glance at its three financial statements.
The income statement talks about the revenues generated and the expenses incurred. The balance sheet talks about the total assets and total liabilities and how total assets equal to total liabilities and shareholders’ equity. The cash flow statement ascertains the net cash inflow/cash outflow from the operating, investing, and finance activities.
Every investor should look at these three financial statements before making an investment decision.
#4 – How to forecast revenues for a company?
There are usually three forecast models a company uses to forecast its revenue.
- The bottom-up approach is the first method where financial modeling starts from the products/service, forecasting the average prices and growth rates.
- The top-down approach is the second method where the forecasting model starts with the market share and market size of the company and how these proportions affect the revenue of the company.
- The third method is a year by year approach where last year’s revenue is taken into account, and then with adding/deducting a certain percentage, the model arrives at the estimation for the next year’s revenue.
#5 – How do you know that an excel model is quite good?
The most crucial ingredient of a good excel model is how user-friendly the excel model is. If you ask a layman to look at it and try to understand, would she know what it’s all about? Quite often, the clients you’ll handle may not know anything about excel modeling. Your job is to create such user-friendly excel models that anyone can understand. If you need to do the error-check regularly, you must do it to ensure that all the figures and calculations in the balance sheet, in the cash flow statement are accurate.
#6 – Can you talk about the three main challenges our company has been facing for a while?
(To answer this question, it’s vital that you thoroughly research the company and look at its annual report for the last year. If you go through all the financial statements of the company, you will get ideas about what’s working well for the company and what’s not working. And try to include both internal and external challenges – challenges that are controllable and challenges that are uncontrollable.)
As I have gone through your annual report, I found that the company could take more debt since the financial leverage of the company is too low. Plus, you have been facing a big challenge in the utilization of your assets. These two challenges can be overcome with the right strategy and execution. The external factor that’s most challenging for you in the last few years is the competitors that are eating away your market share.
#7 – How would you become an excellent Financial Planning Analyst?
There are three skills that financial planning analyst should master.
- The first skill is the skill of analytics. As you can understand, an advanced level of knowledge and application is necessary to master this skill.
- The second skill is the art of presentation. It’s not enough to interpret data. You also need to present it to the key people of the organization so that critical decisions can be made at the right time.
- The third skill is a soft skill. It is the ability to say things clearly and has excellent interpersonal skills.
If you have these three skills, you become a master of financial planning and analysis.
#8 – How would you build a forecast model?
Building a forecast model or a rolling budget is quite easy. All you need to do is to keep the historical data of the previous month (if it’s monthly forecast model) in front and then create a forecast beyond that. If it’s quarterly, you will take the previous quarter’s historical data.
#9 – How would you do modeling for working capital?
The three crucial components of working capital are – inventories, account receivables, and accounts payables. These three things are used to find out about the cost of sales, revenues, payments made, etc. By calculating the days of inventory, the day’s sales outstanding, and the days payable outstanding, you would be able to understand the whole cash conversion cycle. That’s how you would model the working capital of a company.
#10 – How an inventory write-down affects the financial statements?
(This is a common question in Financial Planning and Analysis Interview Questions. You need to talk about how the inventory write-down affects three financial statements.)
In the balance sheet, the asset portion will reduce as the inventory will reduce by the amount of written down. In the income statement, we will see a reduced net income since we need to show forth the written-down effect in COGS or separately. In the cash flow statement, the written-down amount would be added back to cash flow from operating activities since it is a non-cash expense.