What is a Bank Reconciliation Statement Template? This bank reconciliation statement template shows you how to calculate the adjusted cash balance using the bank statement and a company’s accounting record. This is what the bank reconciliation statement template looks like: Download the Free Bank Reconciliation Statement Template Why Use a Bank Reconciliation Statement? A bank…
Property, Plant, and Equipment Schedule Template This property, plant, and equipment schedule template will help you keep track of PP&E balances and depreciation costs. This is what a property, plant, and equipment schedule looks like: Download the Free Template Download CFI’s free property plant and equipment schedule template now to advance your finance knowledge. Property, Plant,…
Download the Free DCF Model Template Click the button below to download our free DCF Model template! This DCF Excel template includes a fully linked three-statement model, a 5‑year unlevered free cash flow (FCFF) forecast, a separate assumptions tab, and an automatically calculated valuation summary table. It’s pre‑built with key drivers like revenue growth, margins,…
Cash Flow Statement Template Download the Free Template Click the button below to download CFI’s free Cash Flow Statement template! This cash flow statement template provides a foundation for recording operating, investing, and financing cash flows on an annual basis. Below, see how the cash flow statement template looks: The Statement of Cash Flows (also…
Profit and Loss (P&L) Statement Template This profit and loss (P&L) statement template summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period. Below is a screenshot of the P&L statement template: #1 Monthly Profit and Loss template The monthly P&L template is perfect for…
Download the Free Balance Sheet Template The following balance sheet template provides you with a foundation to build your own company’s financial statement showing the total assets, liabilities, and shareholders’ equity. Here is a screenshot of the balance sheet template: The balance sheet is based on the fundamental equation: Assets = Liabilities + Equity. Using this…
What is Owner’s Equity? Owner’s Equity is defined as the proportion of the total value of a company’s assets that can be claimed by its owners (sole proprietorship or partnership) and by its shareholders (if it is a corporation). It is calculated by deducting all liabilities from the total value of an asset (Equity =…
Working Capital Template This working capital template allows you to calculate working capital using the following formula: Working Capital = Current Assets – Current Liabilities Here is what the template looks like: Download the Free Working Capital Template Click the button below to download our free Working Capital template! Working capital is the difference between…
How to Create an Excel Waterfall Chart In Excel 2016, Microsoft finally added a Waterfall chart option. It’s a great way to visually show the effect of positive and negative cash flows on a cumulative basis. If you’re working in Excel 2013 or earlier version, please follow the instructions below as a workaround to build…
What is the Diluted EPS Formula? The Diluted EPS formula is equal to net income less preferred dividends, divided by the total number of diluted shares outstanding (basic shares outstanding plus the exercise of in-the-money options, warrants, and other dilutive securities). Diluted EPS Formula: Diluted EPS = (net income – preferred dividends) / (weighted average…
