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,…
DCF Model Template This DCF model template provides you with a foundation to build your own discounted cash flow model with different assumptions. Below is a preview of the DCF model template: Download the Free DCF Model Template Enter your name and email in the form below and download the free template now! DCF Step…
Cash Flow Statement Template This cash flow statement template provides you with a foundation to record operating, investing, and financing cash flows annually. This is what the cash flow statement template looks like: Download the Free Template Enter your name and email in the form below and download the free template now! The Statement of…
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…
Balance Sheet Template This 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: Download the Free Balance Sheet Template Enter your name and email in the form below and download the free…
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 Enter your name and email in the form below and download the free template now! Working capital…
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…
