: Calculation of the upper limit of funding a bank can provide. Form VI: Fund Flow Statement
It answers the question: "Did the company buy that new factory using their profits, or by taking a short-term loan?" (Using short-term loans for long-term assets is a red flag). cma data report in excel format
Think of it as a financial health card. It tells the bank: : Calculation of the upper limit of funding
– Tracks the movement of funds to capture how the business generates and utilizes cash over a given period. It tells the bank: – Tracks the movement
: Captures the movement of funds for the given period to see where money is being sourced and how it is applied (e.g., asset purchases vs. debt repayment). Ratio Analysis : The final analytical layer providing key metrics such as Gross Profit (GP) Net Profit Debt-Equity Current Ratios , allowing bankers to gauge risk in minutes. Why Excel is the Preferred Format
A PDF is frozen. An Excel spreadsheet is alive. When a banker asks, “What if your raw material costs increase by 10%?” a static PDF forces the analyst to recalculate everything manually. With a , you simply change one cell (e.g., cost of goods sold), and all linked ratios—current ratio, debt-equity ratio, DSCR—update instantly.
– Presents the business plan, including current and projected sales (domestic vs. export), expenses, and profits (PBIT, PBT, PAT) for 3–5 years.