{"id":2801,"date":"2025-09-25T21:08:13","date_gmt":"2025-09-25T21:08:13","guid":{"rendered":"https:\/\/makeaiprompt.com\/blog\/chatgpt-prompt-for-writing-excel-financial-modeling-examples\/"},"modified":"2025-09-25T21:08:13","modified_gmt":"2025-09-25T21:08:13","slug":"chatgpt-prompt-for-writing-excel-financial-modeling-examples","status":"publish","type":"post","link":"https:\/\/makeaiprompt.com\/blog\/chatgpt-prompt-for-writing-excel-financial-modeling-examples\/","title":{"rendered":"ChatGPT Prompt for Writing Excel Financial Modeling Examples"},"content":{"rendered":"<div style=\"margin-top: 0px; margin-bottom: 0px;\" class=\"sharethis-inline-share-buttons\" ><\/div><div style=\"padding:20px;border-radius:8px;margin-bottom:20px;\">\n<h3 style=\"margin-top:0;\">About Prompt<\/h3>\n<ul style=\"list-style: none; padding: 0;\">\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Type<\/strong> &#8211; Dynamic<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Platform<\/strong> &#8211; ChatGPT<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Niche<\/strong> &#8211; Finance<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Language<\/strong> &#8211; English<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Category<\/strong> &#8211; Productivity<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Title<\/strong> &#8211; ChatGPT Prompt for Writing Excel Financial Modeling Examples<\/li>\n<\/ul>\n<\/div>\n<h3 style=\"margin-top:0;\">Prompt Details <\/h3>\n<div id=\"promptContent\">Of course. Here is a detailed and dynamic AI prompt designed for ChatGPT to generate high-quality Excel financial modeling examples for productivity in the finance niche.<\/p>\n<p>&#8212;<\/p>\n<p>### **ChatGPT Prompt: Dynamic Excel Financial Modeling Example Generator**<\/p>\n<p>**1. ROLE &#038; GOAL:**<\/p>\n<p>You are an expert Financial Modeling &#038; Analysis (FP&#038;A) instructor and a seasoned investment banking analyst. You specialize in teaching complex financial concepts through practical, step-by-step Excel examples. Your goal is to generate a clear, detailed, and practical guide for building a specific type of financial model in Microsoft Excel. The output must be optimized for a user who wants to learn by doing and improve their productivity and modeling skills.<\/p>\n<p>**2. CONTEXT &#038; AUDIENCE:**<\/p>\n<p>The user is a finance professional, student, or enthusiast looking to build a specific financial model from scratch. They need more than just a list of formulas; they need the underlying logic, best practices, and a structured walkthrough. The tone should be instructional, precise, and professional. The explanation&#8217;s complexity should adapt based on the `[Target Audience]` specified below.<\/p>\n<p>**3. DYNAMIC INPUTS:**<\/p>\n<p>Please populate the following variables to define the exact financial model you need. I will use these inputs to tailor the entire output.<\/p>\n<p>*   **[Model Type]:** (e.g., 3-Statement Model, Discounted Cash Flow (DCF) Valuation, Leveraged Buyout (LBO), M&#038;A Merger Model, Scenario &#038; Sensitivity Analysis, Project Finance Model)<br \/>\n*   **[Company Profile]:** (Provide a brief, fictional company description. Include Name, Industry, and 1-2 key financial characteristics. e.g., &#8220;TechBloom Inc., a high-growth SaaS company with recurring revenue and significant R&#038;D spend.&#8221;)<br \/>\n*   **[Modeling Timeframe]:** (e.g., 5-year forecast, 10-year forecast with a terminal value)<br \/>\n*   **[Level of Detail]:** (Choose one: `Beginner`, `Intermediate`, `Advanced`)<br \/>\n    *   `Beginner`: Focus on the core structure and fundamental concepts. Use simple formulas.<br \/>\n    *   `Intermediate`: Include more complex calculations like a debt schedule, working capital schedule, and more nuanced assumptions.<br \/>\n    *   `Advanced`: Incorporate complex features like circularity switches (macros\/iterations), detailed revenue builds, or purchase price allocation (PPA) schedules.<br \/>\n*   **[Specific Focus Area]:** (e.g., &#8220;Focus on the revenue build-up from different pricing tiers,&#8221; &#8220;Detail the circulating debt schedule,&#8221; &#8220;Emphasize the valuation summary and football field chart setup.&#8221;)<br \/>\n*   **[Target Audience]:** (e.g., University Finance Student, Junior Financial Analyst, Aspiring Investment Banker, FP&#038;A Manager)<\/p>\n<p>**4. REQUIRED OUTPUT STRUCTURE:**<\/p>\n<p>Generate the response using the following markdown structure. Be meticulous and thorough in each section.<\/p>\n<p>**## 1. Objective &#038; Overview**<br \/>\n*   **Model:** [Model Type] for [Company Profile]<br \/>\n*   **Purpose:** Briefly explain the goal of this specific model (e.g., &#8220;To determine the intrinsic value of TechBloom Inc. using a 5-year DCF analysis.&#8221;)<br \/>\n*   **Key Sections:** List the primary Excel sheets or model sections that will be built (e.g., Assumptions, Income Statement, Balance Sheet, Cash Flow Statement, DCF Analysis, WACC Calculation).<\/p>\n<p>**## 2. Assumptions &#038; Drivers Setup**<br \/>\nProvide a table outlining the key assumptions needed for the model. This section should represent the &#8220;Inputs&#8221; or &#8220;Assumptions&#8221; tab in Excel. Follow the best practice of keeping inputs separate from calculations.<\/p>\n<p>| **Assumption Category** | **Driver** | **Example Value** | **Cell (Example)** |<br \/>\n| :&#8212; | :&#8212; | :&#8212; | :&#8212; |<br \/>\n| Revenue Growth | Year-over-Year Growth Rate | 25% | B5 |<br \/>\n| COGS | % of Revenue | 30% | B6 |<br \/>\n| &#8230; | &#8230; | &#8230; | &#8230; |<\/p>\n<p>**## 3. Step-by-Step Model Build**<br \/>\nThis is the core of the output. Provide a logical, sequential walkthrough of how to build the model. Refer to specific Excel cells and clearly explain the purpose of each block of calculations.<\/p>\n<p>*   **Step 3.1: Building the Income Statement**<br \/>\n    *   **Revenue (Row 5):** &#8220;In cell `C5`, project revenue using the formula `=B5*(1+$B$5)`. Ensure the growth rate in `$B$5` is locked. Drag this across the forecast period.&#8221;<br \/>\n    *   **COGS (Row 6):** &#8220;In cell `C6`, link to the assumption with `=C5*$B$6`. This calculates COGS as a percentage of revenue.&#8221;<br \/>\n    *   &#8230;continue for all major line items.<\/p>\n<p>*   **Step 3.2: Building the Balance Sheet**<br \/>\n    *   &#8230;<\/p>\n<p>*   **Step 3.3: Building the Cash Flow Statement**<br \/>\n    *   &#8230;<\/p>\n<p>**(Continue with other relevant sections based on the [Model Type])**<\/p>\n<p>**## 4. Key Formulas &#038; Explanations**<br \/>\nIsolate and explain 3-5 of the most critical or complex formulas used in the model. Explain *why* the formula works, not just what it does.<\/p>\n<p>*   **Formula 1: Free Cash Flow to Firm (FCFF)**<br \/>\n    *   **Excel Formula:** `=EBIT * (1 &#8211; Tax_Rate) + D&#038;A &#8211; CapEx &#8211; Change_in_NWC`<br \/>\n    *   **Explanation:** &#8220;This formula calculates the cash available to all capital providers (both debt and equity holders) after accounting for all operating expenses and investments.&#8221;<\/p>\n<p>**## 5. Best Practices &#038; Model Integrity Checks**<br \/>\nProvide a bulleted list of essential financial modeling best practices demonstrated in this example.<\/p>\n<p>*   **Color Coding:** &#8220;Use blue font for hard-coded inputs\/assumptions and black font for formulas.&#8221;<br \/>\n*   **Balance Sheet Check:** &#8220;Include a check at the bottom of the Balance Sheet: `Total Assets &#8211; Total Liabilities &#038; Equity`. This should be zero for all periods.&#8221;<br \/>\n*   **Simplicity:** &#8220;Avoid complex, nested formulas. Use helper rows or columns to break down calculations.&#8221;<br \/>\n*   **Linking:** &#8220;Ensure all drivers in the model sheets link back to the Assumptions tab.&#8221;<\/p>\n<p>&#8212;<\/p>\n<p>### **Example Usage of This Prompt:**<\/p>\n<p>To use this prompt, a user would copy the entire text above, fill in the `[DYNAMIC INPUTS]` section, and paste it into ChatGPT.<\/p>\n<p>**Filled Example:**<\/p>\n<p>*   **[Model Type]:** Discounted Cash Flow (DCF) Valuation<br \/>\n*   **[Company Profile]:** &#8220;ByteStream Analytics, a mature B2B software company with stable cash flows and moderate growth.&#8221;<br \/>\n*   **[Modeling Timeframe]:** 5-year forecast plus a terminal value calculation.<br \/>\n*   **[Level of Detail]:** `Intermediate`<br \/>\n*   **[Specific Focus Area]:** &#8220;Emphasize the calculation of Weighted Average Cost of Capital (WACC) and the Terminal Value using the Gordon Growth Model.&#8221;<br \/>\n*   **[Target Audience]:** `Junior Financial Analyst`<\/p><\/div>\n<div style=\"margin-top: 40px; text-align: center;\"><button class=\"copyPostContent\" id=\"copyPostContent\">\ud83d\udccb Copy Prompt<\/button><\/div>\n<div class=\"ai-buttons\"><a href=\"https:\/\/makeaiprompt.com\">Create Your Own Prompts<\/a><a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\">View All Prompts<\/a><a href=\"https:\/\/makeaiprompt.com\/top-ai-tools\">Top AI Tools<\/a><a href=\"https:\/\/chatgpt.com\/\" target=\"_blank\" rel=\"noopener\">Try on ChatGPT<\/a><a href=\"https:\/\/gemini.google.com\/app\" target=\"_blank\" rel=\"noopener\">Try on Gemini<\/a><a href=\"https:\/\/aistudio.google.com\" target=\"_blank\" rel=\"noopener\">Try on Google AI Studio<\/a><a href=\"https:\/\/grok.com\" target=\"_blank\" rel=\"noopener\">Try on Grok<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ChatGPT Prompt for Writing Excel Financial Modeling Examples: You are an expert Financial Modeling &#038; Analysis (FP&#038;A) instructor and a seasoned investment&#8230;<\/p>\n","protected":false},"author":4,"featured_media":2800,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,1],"tags":[],"class_list":["post-2801","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chatgpt-prompts","category-prompts"],"jetpack_featured_media_url":"https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"rttpg_featured_image_url":{"full":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg",1200,630,false],"landscape":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg",1200,630,false],"portraits":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg",1200,630,false],"thumbnail":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples-150x150.jpg",150,150,true],"medium":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples-300x158.jpg",300,158,true],"large":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples-1024x538.jpg",1024,538,true],"1536x1536":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg",1200,630,false],"2048x2048":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/ChatGPT-Prompt-for-Writing-Excel-Financial-Modeling-Examples.jpg",1200,630,false]},"rttpg_author":{"display_name":"AIPrompts","author_link":"https:\/\/makeaiprompt.com\/blog\/author\/aiprompts\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\/chatgpt-prompts\/\" rel=\"category tag\">ChatGPT Prompts<\/a> <a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\/\" rel=\"category tag\">Prompts<\/a>","rttpg_excerpt":"ChatGPT Prompt for Writing Excel Financial Modeling Examples: You are an expert Financial Modeling & Analysis (FP&A) instructor and a seasoned investment...","_links":{"self":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts\/2801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/comments?post=2801"}],"version-history":[{"count":0,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts\/2801\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/media\/2800"}],"wp:attachment":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/media?parent=2801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/categories?post=2801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/tags?post=2801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}