Use Excel's AI to Narrate Financial Spreads

What This Does

Copilot in Excel can analyze your financial spread data and write a plain-English narrative explaining what the numbers mean for creditworthiness — turning rows of ratios into a paragraph ready for your credit memo.

Before You Start

• You have Excel open with a completed financial spread (income statement, balance sheet, or ratio summary)
• You're signed into Microsoft 365 Business Standard or higher
• Your data is in a named Table (Excel tables work best with Copilot)

Steps

1. Format your data as a Table

Select your spread data. Go to Insert → Table (or press Ctrl+T). Make sure "My table has headers" is checked. This helps Copilot understand your data structure.

2. Open Copilot

Click the Copilot button in the Home ribbon (sparkle icon, right side). The Copilot panel opens on the right side of your screen.

3. Ask for the narrative

In the Copilot chat box, type your analysis request. Be specific about what you need:

"Analyze the DSCR, current ratio, and debt-to-equity trends in this table from 2022 to 2024. Write a 3-sentence financial analysis narrative summarizing what these trends indicate about the borrower's creditworthiness. Assume a commercial bank credit memo audience."

4. Review and export the result

Copilot returns the narrative in the chat panel. Copy it and paste into your Word credit memo. If the narrative misses something, ask a follow-up: "Also note that revenue growth has been consistent at 8% per year."

Real Example

Scenario: You've completed the financial spread for a manufacturing company applying for a $2M equipment loan. Key ratios: DSCR improved from 1.09x (2022) to 1.31x (2024), current ratio 1.6, debt/equity declining from 3.1 to 2.4.

What you type: "Analyze this financial data and write a credit narrative: DSCR 2022: 1.09x, 2023: 1.18x, 2024: 1.31x. Current ratio 2024: 1.6. Debt/equity: declining from 3.1 to 2.4 over 3 years. Revenue growth: 11% per year. Write 3 sentences for a commercial loan credit memo."

What you get: "Borrower demonstrates consistent improvement in debt service coverage, with DSCR strengthening from 1.09x in 2022 to 1.31x in 2024, reflecting healthy cash flow generation relative to debt obligations. Liquidity position is adequate with a current ratio of 1.6x, and the declining debt-to-equity ratio from 3.1x to 2.4x indicates successful balance sheet deleveraging. Combined with 11% annual revenue growth, the trend profile supports the creditworthiness of the proposed borrowing."

Tips

• If your spread is in a format Copilot doesn't understand well, paste the key ratios as a simple two-column table (Metric | Value) and ask for the narrative from that.
• Ask Copilot to "flag any ratios that would typically concern a commercial lender" — it often catches things you might overlook.
• You can also use Excel Copilot to build DSCR calculation formulas: "Write a formula that calculates DSCR from annual net income, depreciation, and total debt service."

Tool interfaces change — if a button has moved, look for similar AI/magic/smart options in the same menu area.