FP&A Cash Flow Forecast Model
Originally published: 04/08/2020 10:53
Publication number: ELQ-10645-1
View all versions & Certificate

FP&A Cash Flow Forecast Model

An FP&A (financial planing and analysis) Model in Microsoft Excel.

This model will look at how to forecast revenues, operating exp. and changes in the balance sheet items to arrive monthly cash flow to show the financial impact of the forecast on the business to decide if the capital need to raised.

From this model you will learn how to forecast income statement ,balance sheet, and resulting cash flow as will as creating schedule of accounts receivable, accounts payable, inventory, capex, payroll, interest and WACC, in the end feasibility analysis.

The different between this businesses plan and anther that its include planing processing and you can use it for any kind of business.

I use very easy formula that you can understand and explain to your customer.
its include :
-sales schedule
-operating EXP.
-income statement
-balance sheet
-cash flow
-feasibility analysis.

The assumption contain of summary of all activities instead of data wee need for forecasting.
Sales schedule is flexible and you can change it from the roll and any change of sales
will result of change of all other elements that you can easier make decision.

Excel skill will be in this model include conditional formatting, data validation, IF statements and other function required to complete the financial model .

- Rami Abbas

This Best Practice includes
1 Excel Template

Acquire consulting license for $25.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...