Question: how to calculate efn in excel?
Answer: Instead of preparing a set of forecasted financial statements, you can also calculate your external financing needs (EFN) by using a formula that looks at three changes: 1. Required increases to assets given a change in sales. Formula = (A/S) x (Δ Sales).