{"id":2026103626,"date":"2026-11-20T18:58:11","date_gmt":"2026-11-20T11:58:11","guid":{"rendered":"https:\/\/danieel.id\/?page_id=2026103626"},"modified":"2026-11-21T11:11:51","modified_gmt":"2026-11-21T04:11:51","slug":"financial-statements-and-stock-valuation-excel-template","status":"publish","type":"page","link":"https:\/\/danieel.id\/en\/templates\/financial-statements-and-stock-valuation-excel-template\/","title":{"rendered":"Financial Statements and Stock Valuation Excel Template"},"content":{"rendered":"<div style=\"display:flex;flex-wrap:wrap;gap:28px;align-items:flex-start;margin:0 0 32px;\">\n<div style=\"flex:1 1 240px;max-width:340px;\">\n    <img decoding=\"async\" loading=\"eager\" fetchpriority=\"high\" data-no-lazy=\"1\" src=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/template-excel-en.png\" alt=\"Financial Statements and Stock Valuation Excel Template by danieel.id\" style=\"width:100%;height:auto;border-radius:6px;box-shadow:0 8px 24px rgba(0,0,0,.18);\" \/>\n  <\/div>\n<div style=\"flex:2 1 320px;\">\n<p style=\"margin:0 0 6px;font-size:13px;letter-spacing:2px;font-weight:700;color:#2e8b57;\">READY-TO-USE EXCEL TEMPLATE<\/p>\n<h2 style=\"margin:0 0 8px;\">Financial Statements and Stock Valuation Excel Template<\/h2>\n<p style=\"margin:0 0 16px;font-size:17px;color:#444;\">From financial statements to a stock&#8217;s fair value. The formulas are already built in, so you just enter the numbers and focus on what they mean.<\/p>\n<p style=\"margin:0 0 18px;\">\n      <a href=\"https:\/\/danieel.id\/en\/checkout\/?add-to-cart=2026103394\" style=\"display:inline-block;padding:12px 22px;background:#1f3a5f;color:#fff;border-radius:6px;text-decoration:none;font-weight:700;\">Buy the Template \u2013 US$3.99<\/a>\n    <\/p>\n<table style=\"width:100%;border-collapse:collapse;font-size:15px;\">\n<tbody>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Format<\/td>\n<td style=\"padding:6px 0;\">Excel file (.xlsx)<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">What you get<\/td>\n<td style=\"padding:6px 0;\">2 files: an Example version (filled with danieel.id Company data) and a Blank version<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Coverage<\/td>\n<td style=\"padding:6px 0;\">4 linked financial statements, 18 ratios with automatic evaluation, DuPont analysis, free cash flow, WACC, and stock valuation (DCF, DDM, market multiples)<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Software<\/td>\n<td style=\"padding:6px 0;\">Microsoft Excel 2016 or later (recommended); usually also opens in Google Sheets<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Language<\/td>\n<td style=\"padding:6px 0;\">English (an Indonesian version is sold separately)<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Price<\/td>\n<td style=\"padding:6px 0;\"><strong>US$3.99<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Delivery<\/td>\n<td style=\"padding:6px 0;\">Instant download once payment is confirmed<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:6px 10px 6px 0;color:#666;\">Status<\/td>\n<td style=\"padding:6px 0;\">Available<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n<h2>What Is This Template For?<\/h2>\n<p>Reading financial statements is not really about memorizing formulas. The hard part is making everything connect: net income has to flow into the balance sheet, the cash flow statement has to reconcile with the change in cash, and the ratios, cost of capital, and valuation all have to use the same numbers. Build it from scratch and one wrong cell can throw your fair value way off (and you usually only find it after a whole evening of hunting \ud83d\ude04).<\/p>\n<p>This template takes care of that technical part. Every formula and every link between the statements is already in place, so you simply enter a company&#8217;s numbers and the analysis appears. Your time goes to what matters more: understanding the story behind the numbers.<\/p>\n<h2>What&#8217;s Inside<\/h2>\n<h3>1. One input sheet, four financial statements<\/h3>\n<p>All raw data goes into a single Input sheet, in yellow cells for the current and prior year. From there the template builds the income statement (including EBITDA, EPS, and dividends per share), a two-year balance sheet, the statement of changes in equity, and an indirect-method cash flow statement. Built-in checks tell you whether the balance sheet is \u201c\u2713 Balanced\u201d and the cash flow \u201c\u2713 Reconciled\u201d, so typos get caught quickly.<\/p>\n<figure style=\"margin:12px auto 28px;max-width:560px;\"><a href=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-balance-sheet.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-balance-sheet.png\" alt=\"Balance Sheet sheet of the danieel.id financial statements Excel template with an automatic Balanced check\" width=\"974\" height=\"1306\" loading=\"lazy\" style=\"width:100%;height:auto;border:1px solid #e1e6ee;border-radius:6px;box-shadow:0 4px 14px rgba(0,0,0,.08);\" \/><\/a><figcaption style=\"font-size:14px;color:#666;text-align:center;margin-top:8px;\">Balance Sheet sheet in the Example version: two years, a change column, and the \u201c\u2713 Balanced\u201d check on the last row.<\/figcaption><\/figure>\n<h3>2. Eighteen financial ratios<\/h3>\n<p>Liquidity, activity, debt, profitability, and market ratios are calculated automatically, each with its formula. Every ratio is evaluated two ways: against the prior year (improved or deteriorated) and against the industry average (better or worse). You can replace the industry averages with data for the industry you are analyzing.<\/p>\n<figure style=\"margin:12px auto 28px;max-width:1100px;\"><a href=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-financial-ratios.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-financial-ratios.png\" alt=\"Ratios sheet of the financial statements Excel template with 18 financial ratios and time-series and cross-sectional evaluation\" width=\"2268\" height=\"1278\" loading=\"lazy\" style=\"width:100%;height:auto;border:1px solid #e1e6ee;border-radius:6px;box-shadow:0 4px 14px rgba(0,0,0,.08);\" \/><\/a><figcaption style=\"font-size:14px;color:#666;text-align:center;margin-top:8px;\">Ratios sheet: 18 ratios with formulas, a year-over-year evaluation, and a comparison with the industry average.<\/figcaption><\/figure>\n<h3>3. DuPont analysis and free cash flow<\/h3>\n<p>ROE is broken down into profit margin, asset turnover, and financial leverage, so you can see where shareholder returns actually come from. Free cash flow is calculated with three methods to show how much cash is truly free after operating and investment needs are met.<\/p>\n<figure style=\"margin:12px auto 28px;max-width:1100px;\"><a href=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-dupont.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-dupont.png\" alt=\"DuPont sheet of the financial statements Excel template breaking down ROA and ROE\" width=\"1812\" height=\"960\" loading=\"lazy\" style=\"width:100%;height:auto;border:1px solid #e1e6ee;border-radius:6px;box-shadow:0 4px 14px rgba(0,0,0,.08);\" \/><\/a><figcaption style=\"font-size:14px;color:#666;text-align:center;margin-top:8px;\">DuPont sheet: ROE broken down into margin, asset turnover, and the financial leverage multiplier.<\/figcaption><\/figure>\n<h3>4. Cost of capital (WACC) and stock valuation<\/h3>\n<p>Cost of equity (CAPM), cost of debt (yield to maturity), cost of preferred stock, and WACC are calculated step by step. The result feeds a DCF\/FCFF valuation with a sensitivity table, which is then compared with the dividend discount model (DDM), market multiples, and the current share price.<\/p>\n<figure style=\"margin:12px auto 28px;max-width:1100px;\"><a href=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-dcf-valuation.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/danieel.id\/wp-content\/uploads\/2026\/11\/excel-template-dcf-valuation.png\" alt=\"Valuation sheet of the financial statements Excel template: DCF value per share and sensitivity table\" width=\"1640\" height=\"786\" loading=\"lazy\" style=\"width:100%;height:auto;border:1px solid #e1e6ee;border-radius:6px;box-shadow:0 4px 14px rgba(0,0,0,.08);\" \/><\/a><figcaption style=\"font-size:14px;color:#666;text-align:center;margin-top:8px;\">Valuation sheet: from enterprise value to value per share, with a WACC and growth sensitivity table.<\/figcaption><\/figure>\n<h2>How to Use It<\/h2>\n<ol>\n<li><strong>Study the Example version.<\/strong> Open the file filled with danieel.id Company data to follow the calculation from the financial statements all the way to fair value.<\/li>\n<li><strong>Fill in the Blank version.<\/strong> Copy the numbers from your chosen company&#8217;s financial statements into the yellow cells on the Input sheet, then add market assumptions such as beta and the growth rate.<\/li>\n<li><strong>Check, then read the results.<\/strong> Make sure the balance sheet shows \u201c\u2713 Balanced\u201d and the cash flow \u201c\u2713 Reconciled\u201d. The ratios, DuPont analysis, free cash flow, WACC, and fair value are then ready, and your job is to interpret them.<\/li>\n<\/ol>\n<h2>Learn with Articles, Videos, and the E-book<\/h2>\n<p>This template is the hands-on companion to the financial statements series on danieel.id. Each part of the template pairs with material that explains the concept, so you can learn the idea first and then try it straight away in Excel.<\/p>\n<table style=\"width:100%;border-collapse:collapse;font-size:15px;\">\n<thead>\n<tr style=\"background:#f2f5f9;\">\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">Template section<\/th>\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">Articles on danieel.id<\/th>\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">E-book<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Four financial statements<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/types-of-financial-statements\/\">Types of Financial Statements<\/a>, <a href=\"https:\/\/danieel.id\/en\/how-to-read-an-income-statement\/\">Income Statement<\/a>, <a href=\"https:\/\/danieel.id\/en\/ebitda-vs-net-profit-the-differences\/\">EBITDA vs Net Profit<\/a>, <a href=\"https:\/\/danieel.id\/en\/how-to-read-a-balance-sheet\/\">Balance Sheet<\/a>, <a href=\"https:\/\/danieel.id\/en\/how-to-read-a-statement-of-changes-in-equity\/\">Changes in Equity<\/a>, <a href=\"https:\/\/danieel.id\/en\/how-to-read-a-companys-cash-flow-statement\/\">Cash Flow Statement<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapters 1\u20136<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">18 financial ratios<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/company-financial-ratios\/\">Company Financial Ratios<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapter 7<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">DuPont analysis<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/dupont-analysis\/\">DuPont Analysis<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapter 8<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Free cash flow<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/financial-statement-analysis-guide\/\">Financial Statement Analysis Guide<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapter 9<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Cost of capital (WACC)<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/how-to-calculate-cost-of-equity-capm\/\">Cost of Equity<\/a>, <a href=\"https:\/\/danieel.id\/en\/how-to-calculate-cost-of-debt\/\">Cost of Debt<\/a>, <a href=\"https:\/\/danieel.id\/en\/wacc-calculation-formula-examples\/\">WACC<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapters 10\u201312<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Stock valuation<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/stock-valuation-methods-formulas-examples\/\">Stock Valuation<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Chapter 13<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Video versions are being released gradually on the <a href=\"https:\/\/www.youtube.com\/@danieelid\" target=\"_blank\" rel=\"noopener\">@danieelid<\/a> YouTube channel. Want to learn in order from the beginning? Start with <a href=\"https:\/\/danieel.id\/en\/financial-statement-analysis-guide\/\">the learning roadmap<\/a>.<\/p>\n<h2>Who Is It For?<\/h2>\n<ul>\n<li>Beginner investors who want to value stocks with numbers rather than just follow recommendations.<\/li>\n<li>Students learning financial statement analysis or valuation.<\/li>\n<li>Business owners and employees who want to understand a company&#8217;s financial performance.<\/li>\n<\/ul>\n<p>This template is <strong>not<\/strong> a buy or sell signal tool. The results depend on the data and assumptions you enter, so they still need to be read with judgment.<\/p>\n<h2>Buying Options<\/h2>\n<table style=\"width:100%;border-collapse:collapse;font-size:15px;\">\n<thead>\n<tr style=\"background:#f2f5f9;\">\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">Product<\/th>\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">What you get<\/th>\n<th style=\"color:#1a1a1a;text-align:left;padding:10px;border:1px solid #e1e6ee;\">Price<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><strong>Excel Template<\/strong><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">Example and Blank versions (.xlsx). <a href=\"https:\/\/danieel.id\/en\/checkout\/?add-to-cart=2026103394\">Buy now<\/a><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">US$3.99<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><strong>E-book + Template Bundle<\/strong><\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\"><a href=\"https:\/\/danieel.id\/en\/e-books\/reading-financial-statements-and-stock-valuation\/\">Reading Financial Statements and Stock Valuation<\/a> e-book plus the Excel template. Coming soon, when the e-book is released.<\/td>\n<td style=\"padding:10px;border:1px solid #e1e6ee;vertical-align:top;\">US$8.99<br \/><small>Launch price: US$7.49<\/small><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Specifications and Access<\/h2>\n<ul>\n<li>Two .xlsx files: an Example version and a Blank version.<\/li>\n<li>Best opened in Microsoft Excel 2016 or later. It usually also opens in Google Sheets, although the layout and some formatting may differ slightly.<\/li>\n<li>Download links appear on the order confirmation page once payment is confirmed, are sent to your email, and are available under My Account \u2192 Downloads if you create an account at checkout.<\/li>\n<li>Each file can be downloaded up to 5 times.<\/li>\n<li>Formula sheets are protected without a password so they are not deleted by accident; you can unlock them via Review \u203a Unprotect Sheet if you want to modify them.<\/li>\n<li>Single-user license.<\/li>\n<\/ul>\n<h2>Frequently Asked Questions<\/h2>\n<h3>Can I use this template for any listed company?<\/h3>\n<p>Yes. Fill the Blank version with the numbers from any company&#8217;s financial statements, whether it is listed in the US, Indonesia, or elsewhere.<\/p>\n<h3>Do I need the e-book to use the template?<\/h3>\n<p>No. The Example version already shows how the calculations flow, and the concepts behind each section are explained in free articles on danieel.id. The e-book helps you understand them more deeply and in sequence.<\/p>\n<h3>Can I use it for coursework or at work?<\/h3>\n<p>Yes, for learning, coursework, personal analysis, and your own work. If you publish the results, please credit danieel.id as the source. One purchase covers one user, and the files may not be resold, shared, or uploaded elsewhere without written permission.<\/p>\n<h3>Can I get a refund?<\/h3>\n<p>Because this is a digital product, downloaded purchases are non-refundable unless a file is corrupted, does not match its description, or the download link does not work. See our <a href=\"https:\/\/danieel.id\/en\/refund-policy\/\">Refund Policy<\/a> for details.<\/p>\n<p style=\"font-size:14px;color:#666;margin-top:32px;\"><em>Disclaimer: this template is an analysis and education tool, not investment advice, and not a recommendation to buy or sell any security. danieel.id Company is a fictional company used for practice.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>READY-TO-USE EXCEL TEMPLATE Financial Statements and Stock Valuation Excel Template From financial statements to a stock&#8217;s fair value. The formulas are already built in, so you just enter the numbers and focus on what they mean. Buy the Template \u2013 US$3.99 Format Excel file (.xlsx) What you get 2 files: an Example version (filled with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2026103624,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"footnotes":""},"class_list":["post-2026103626","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/pages\/2026103626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/comments?post=2026103626"}],"version-history":[{"count":5,"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/pages\/2026103626\/revisions"}],"predecessor-version":[{"id":2026103707,"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/pages\/2026103626\/revisions\/2026103707"}],"up":[{"embeddable":true,"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/pages\/2026103624"}],"wp:attachment":[{"href":"https:\/\/danieel.id\/en\/wp-json\/wp\/v2\/media?parent=2026103626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}