{"id":10439,"date":"2025-12-05T17:05:56","date_gmt":"2025-12-05T11:35:56","guid":{"rendered":"https:\/\/www.thewallstreetschool.com\/blog\/?p=5591"},"modified":"2025-12-05T17:05:56","modified_gmt":"2025-12-05T11:35:56","slug":"ma-modelling-2026-made-simple","status":"publish","type":"post","link":"https:\/\/www.thewallstreetschool.com\/stg-new\/ma-modelling-2026-made-simple\/","title":{"rendered":"M&amp;A Financial Modelling: Steps to Build a Deal Model"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.investopedia.com\/terms\/m\/mergersandacquisitions.asp?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noopener\">M&amp;A<\/a> Modelling 2026 stresses people out more than it should. Most guides online jump straight into formulas and accretion\/dilution calculation without ever explaining what is actually happening. You read a few lines, get a headache, and start doubting whether you will ever understand this stuff.<\/p>\n\n\n\n<p>This article finally fixes that. You are about to learn M&amp;A Modelling 2026 in a way that feels simple and obvious. Each step of the merger model Excel process is broken down so cleanly that you can follow along even if you have never built a big financial model before.<\/p>\n\n\n\n<p>By the time you finish reading, you will know how a company decides whether buying another company will make money or cause losses. You will be able to read a deal and understand the logic behind it.&nbsp;<\/p>\n\n\n\n<p>This guide gives you the clarity you were searching for.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How M&amp;A Modelling 2026 Works in 9 Steps<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Understand the deal<br><\/li>\n\n\n\n<li>Forecast the buyer<br><\/li>\n\n\n\n<li>Forecast the target<br><\/li>\n\n\n\n<li>Build Sources and Uses<br><\/li>\n\n\n\n<li>Do the Purchase Price Allocation<br><\/li>\n\n\n\n<li>Add synergies and integration costs<br><\/li>\n\n\n\n<li>Build pro forma financials<br><\/li>\n\n\n\n<li>Do accretion dilution<br><\/li>\n\n\n\n<li>Run sensitivity tests<\/li>\n<\/ol>\n\n\n\n<p>To keep everything crystal clear, we will use one simple project from start to end.<\/p>\n\n\n\n<p>A company called AlphaTech wants to buy another company called BrightApps <em>(imaginary companies)<\/em>. The deal is worth 120 million. AlphaTech wants BrightApps because it wants a stronger mobile user base. This story will stay with us through every calculation. It keeps everything grounded, so beginners never get lost.<\/p>\n\n\n\n<p>These project numbers we will use throughout:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Purchase price: 120 million<br><\/li>\n\n\n\n<li>Cash paid: 70 million<br><\/li>\n\n\n\n<li>New debt: 50 million<br><\/li>\n\n\n\n<li>BrightApps shares: 6 million<br><\/li>\n\n\n\n<li>Offer per share: 20<br><\/li>\n\n\n\n<li>Buyer forecast revenue: 200, 220, 245 million<br><\/li>\n\n\n\n<li>Target forecast revenue: 60, 72, 86 million<br><\/li>\n\n\n\n<li>Cost synergies: 4, 6, 8 million<br><\/li>\n\n\n\n<li>Integration cost: 2, 1 million<br><\/li>\n\n\n\n<li>Net assets: 50 million<br><\/li>\n\n\n\n<li>FV adjustment: 10 million<br><\/li>\n\n\n\n<li>Goodwill: 60 million<br><\/li>\n\n\n\n<li>Buyer shares: 40 million<\/li>\n<\/ul>\n\n\n\n<p>Now let&#8217;s break each one down.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"What is Mergers and Acquisitions?\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/SNJwrI6vNWw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1. Understand the Deal and Structure the Offer<\/strong><\/h2>\n\n\n\n<p>Before touching any Excel sheet, you need to know what the deal actually is. Who is buying whom? How much is the buyer paying? How are they paying? Cash or debt or stock.<\/p>\n\n\n\n<p>This part sets the base for the whole merger model Excel file.<\/p>\n\n\n\n<p>In our project, AlphaTech wants to buy BrightApps for 120 million. Part of it is paid using cash. The rest comes from new debt. Simple and clean.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image.png\" alt=\"\" class=\"wp-image-5592\"\/><\/figure>\n\n\n\n<p>&nbsp;<em>1.1 Deal Setup<\/em><\/p>\n\n\n\n<p>This table becomes the heart of the M&amp;A Modelling 2026 file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2. Forecast the Buyer Standalone<\/strong><\/h2>\n\n\n\n<p>Before the companies combine, you need to know how the buyer performs alone. These are your finance projections.<\/p>\n\n\n\n<p>This is normal valuation modelling work. You take the buyer\u2019s revenue, costs and profit for the next 3 to 5 years.<\/p>\n\n\n\n<p>Keep it simple. No need to turn into an economist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-2.png\" alt=\"\" class=\"wp-image-5593\"\/><\/figure>\n\n\n\n<p><em>1.2 Buyer Forecast<\/em><\/p>\n\n\n\n<p>Net income builds from there.<\/p>\n\n\n\n<p>This future view is important because investment banking teams compare the before and after impact once the deal closes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3. Forecast the Target Standalone<\/strong><\/h2>\n\n\n\n<p>Now you shift to the company getting bought. Same easy flow. A few basic projections, no drama. These numbers help you understand the target\u2019s strength on its own, which makes the combination later feel like putting two puzzle pieces together that actually fit.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-4.png\" alt=\"\" class=\"wp-image-5599\"\/><\/figure>\n\n\n\n<p><em>1.3 Target Forecast<\/em><\/p>\n\n\n\n<p>This forecast flows into the later combined model in the M&amp;A Modelling 2026 process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4. Build Sources and Uses<\/strong><\/h2>\n\n\n\n<p>This part explains the money movement. Straightforward stuff. Where the money comes from and where it goes. When this section is clean, the rest of the model feels stable. When it\u2019s messy, everything gets confusing fast. So this sheet keeps the whole deal grounded.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Uses<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-1.png\" alt=\"\" class=\"wp-image-5594\"\/><\/figure>\n\n\n\n<p><em>1.4 Uses of Funds<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sources<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-5.png\" alt=\"\" class=\"wp-image-5596\"\/><\/figure>\n\n\n\n<p><em>1.5 Sources of Funds<\/em><\/p>\n\n\n\n<p>Sources match uses. This always stays equal. Otherwise, your sheet is broken.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 5. Purchase Price Allocation<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.investopedia.com\/terms\/p\/purchaseprice.asp\" target=\"_blank\" rel=\"noopener\">PPA<\/a> sounds complicated, but it\u2019s really just breaking the purchase price into simple parts. You\u2019re basically saying here\u2019s what we bought, here\u2019s what it\u2019s worth, and here\u2019s the extra amount we paid because the company has something valuable you can\u2019t touch, like brand or customers. Once you see it laid out, it feels surprisingly normal.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-4.png\" alt=\"\" class=\"wp-image-5600\"\/><\/figure>\n\n\n\n<p><em>1.6 Purchase Price Allocation PPA Schedule<\/em><\/p>\n\n\n\n<p>This goodwill becomes a big line in the combined balance sheet once you finish the M&amp;A Modelling 2026 build.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 6. Synergies and Integration<\/strong><\/h2>\n\n\n\n<p>Companies buy other companies for <a href=\"https:\/\/www.investopedia.com\/terms\/s\/synergy.asp\" target=\"_blank\" rel=\"noopener\">synergies<\/a>. This mostly means cost savings. Sometimes also revenue boosts but those are harder to prove.<\/p>\n\n\n\n<p>In M&amp;A Modelling 2026 you add synergy numbers in a separate block and then feed them into the combined income statement.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-6.png\" alt=\"\" class=\"wp-image-5597\"\/><\/figure>\n\n\n\n<p><em>1.7 Synergies and Integration Costs<\/em><\/p>\n\n\n\n<p>Your synergy benefit minus integration cost shows the real gain from the deal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 7. Build the Pro Forma Financial Statements<\/strong><\/h2>\n\n\n\n<p>Now the fun part. This is where buyer forecast + target forecast + PPA adjustments + synergy savings all merge into one combined view. This is the actual combined future company.<\/p>\n\n\n\n<p>This is the core of a merger model Excel dashboard. This is where M&amp;A Modelling 2026 gets judged by investment banking teams. (<a href=\"https:\/\/www.investopedia.com\/terms\/p\/proforma.asp\" target=\"_blank\" rel=\"noopener\">Pro Forma Financial Statements<\/a>)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-3.png\" alt=\"\" class=\"wp-image-5595\"\/><\/figure>\n\n\n\n<p><em>1.8 Pro Forma combined revenue<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-4.png\" alt=\"\" class=\"wp-image-5598\"\/><\/figure>\n\n\n\n<p><em>1.9 Pro Forma combined EBIT<\/em><\/p>\n\n\n\n<p>This combined statement shows if the company becomes stronger or weaker.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 8. Accretion or Dilution (The Final Step)<\/strong><\/h2>\n\n\n\n<p>Here\u2019s the final check everyone waits for. This number tells you straight up whether the deal works or not. If EPS goes up, the deal is doing its job. If it falls, there\u2019s something off in the logic. It\u2019s honest, simple, and basically the deal\u2019s report card.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-7.png\" alt=\"\" class=\"wp-image-5601\"\/><\/figure>\n\n\n\n<p><em>2.0 EPS Impact Calculation<\/em><\/p>\n\n\n\n<p>This is accretive and usually considered a win.<\/p>\n\n\n\n<p>If it goes down, then your M&amp;A Modelling 2026 tells management to rethink the deal or renegotiate the price.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Bonus Check: Sensitivity and Scenario Analysis (Optional but Smart)<\/strong><\/h2>\n\n\n\n<p>This is not a step. It is just an extra layer to help beginners understand how the deal behaves under different synergy scenarios. Deals are unpredictable. So you check what happens if things go slightly wrong or slightly better.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You test interest rates<\/li>\n\n\n\n<li>You test synergy levels<\/li>\n\n\n\n<li>You test the purchase price<\/li>\n\n\n\n<li>You test revenue growth assumptions<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/image-7.png\" alt=\"\" class=\"wp-image-5602\"\/><\/figure>\n\n\n\n<p><em>2.1 Synergy Sensitivity Analysis on EPS<\/em><\/p>\n\n\n\n<p>This makes your merger model Excel file look professional and ready for decision-making.<\/p>\n\n\n\n<p>Once you reach the EPS result, the model is basically done. You\u2019ve built everything you need. After this point, you\u2019re not calculating anymore, you\u2019re just understanding what the numbers mean. If the combined EPS goes up, the deal looks strong. If it drops, the deal needs to be rechecked. That\u2019s the whole point of M&amp;A Modelling 2026. It shows you, in simple numbers, whether the deal helps the buyer or creates more trouble than it\u2019s worth.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2025\/12\/a-professional-infographic-displaying-th_OHF0K07BTCe1NGTpjYZN5Q_GDC_HYmrQjWMHxlFipEAPg-1024x574.jpeg\" alt=\"M&amp;A Financial Modelling: Steps to Build a Deal Model\n\" class=\"wp-image-5604\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why this Matters for 2026 Skills<\/strong><\/h2>\n\n\n\n<p>Companies are buying companies more aggressively because tech, AI, supply chain and global expansion move fast. Anyone working in <a href=\"https:\/\/thewallstreetschool.com\/stg-new\/investment-banking-jobs-careers-and-growth-in-a-high-stakes-world\/\">investment banking<\/a> or <a href=\"https:\/\/www.thewallstreetschool.com\/financial-modelling-certification-course\/\">valuation modelling<\/a> needs to understand M&amp;A Modelling 2026 because this is where the real strategic decisions happen.<\/p>\n\n\n\n<p>It is not about building fancy spreadsheets. It is about knowing how money moves and what makes a business stronger.<\/p>\n\n\n\n<p>If you can build a clean and easy-to-understand merger model Excel file, you automatically stand out.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Mistakes to Avoid<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Overestimating synergies<br><\/li>\n\n\n\n<li>Ignoring integration costs<br><\/li>\n\n\n\n<li>Not checking if financing changes interest expenses properly<br><\/li>\n\n\n\n<li>Forgetting deferred tax in PPA<br><\/li>\n\n\n\n<li>Not reconciling goodwill correctly<br><\/li>\n\n\n\n<li>Leaving unbalanced balance sheets<br><\/li>\n\n\n\n<li>Hard-coding too much instead of linking formulas<\/li>\n<\/ol>\n\n\n\n<p>Avoid these and your M&amp;A Modelling 2026 skills will look top tier.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>The Verdict<\/strong><\/h3>\n\n\n\n<p>M&amp;A Modelling 2026 is not about being a maths genius. It is about being organised. Think of it like building a Lego set. You add each block slowly. Forecasts, PPA, Synergies, Pro forma statements, EPS impact. When you put it all together, the picture makes sense.<\/p>\n\n\n\n<p>If you\u2019ve reached this point and feel that spark of oh I can actually learn this, then follow it. You\u2019re already closer than you think. <strong>The WallStreet School\u2019s <\/strong><a href=\"https:\/\/www.thewallstreetschool.com\/financial-modelling-certification-course\/\"><strong>Financial Modelling and Valuations course<\/strong><\/a> can take you from understanding the basics to building models with real confidence. It\u2019s practical, structured, and designed to actually move your career forward.<\/p>\n\n\n\n<p>Give yourself that upgrade. This might be the step that actually moves your career forward.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;<strong>People Also Asked<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>How to build an M&amp;A model?<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p><strong>Ans. <\/strong>You predict how both companies will perform, merge the numbers, factor in savings or costs, and see if the deal boosts earnings.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>What are the steps in an M&amp;A deal?<\/strong><\/h3>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p><strong>Ans. <\/strong>You spot a company to buy, figure out what it\u2019s worth, decide how to pay, check the finances, set the terms, and choose to go ahead or drop it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>What is the financial model of M&amp;A?<\/strong><\/h3>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p><strong>Ans. <\/strong>It\u2019s a simple spreadsheet that shows what the two companies look like together and whether joining them actually makes more money.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>Can ChatGPT build financial models?<\/strong><\/h3>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p><strong>Ans. <\/strong>It can help you plan the structure and formulas, but you still fill in the numbers and build the actual Excel file on your system.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M&amp;A Modelling 2026 stresses people out more than it should. Most guides online jump straight into formulas and accretion\/dilution calculation without ever explaining what is actually happening. You read a few lines, get a headache, and start doubting whether you will ever understand this stuff. This article finally fixes that. You are about to learn [&hellip;]<\/p>\n","protected":false},"author":42,"featured_media":8952,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[670],"tags":[844,614,845,846,847],"class_list":["post-10439","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-financial-modeling","tag-finance-projections","tag-investment-banking","tag-ma-modelling-2026","tag-merger-model-excel","tag-valuation-modelling"],"_links":{"self":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/10439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/comments?post=10439"}],"version-history":[{"count":0,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/10439\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media\/8952"}],"wp:attachment":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media?parent=10439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/categories?post=10439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/tags?post=10439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}