Archive for the Financial Statements Category

Month End Close Checklist

Month End Close Checklist

The month-end close is no easy task. Download this free Month-End Close Checklist, modify it to fit your needs, and you’ll find your monthly close goes much more smoothly. At the end of the month, accountants are tasked with ensuring all of the transactions for that month

Read more

Black-Scholes Model (European)

black-scholes

Need a European-style Black-Scholes calculator to compute the value of a Put Option or Call Option?  Just interested in how the calculation works? Want something just to double check a calculation? Either way, this spreadsheet will help. All of the formulas can be read (and modified if you

Read more

Accounts Receivable Aging Template

Accounts receivable aging

Every business should leverage an accounts receivable aging to manage balances outstanding. However, not every business has the need for an expensive accounts receivable ledger or system. This accounts receivable aging is an excel template that makes it easy to age invoices.  It’s also been designed to

Read more

EBITDA

ebitda

A 3 year comparison of EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization) and several financial leverage ratios (EBITDA to P&I Payments, Debt Ratio, Debt to Equity, and Interest Coverage),  are all shown graphically with a few simple inputs. The analysis will print to one page. EBITDA

Read more

Volatility Calculator Template

volatility calculator

This volatility calculator can be used to establish the volatility of a publicly traded stock based on the inputs you provide. Use this spreadsheet to price options. The historical prices are input on one tab (the download contains an example from yahoo.finance).  Then complete the remaining inputs

Read more

Statement of Cash Flows

Statement of Cash Flow

The preparation of the statement of cash flows (indirect method) can be a time-consuming task.  Schedules become messy and cluttered as the schedule grows in length or complex transactions are introduced.  This clutter oftentimes leads to unnecessary time, wasted energy, and the occasional error.  The purpose of this template is to help those

Read more

Proof of Cash Template

Proof of Cash Template

The proof of cash template is also known as the four-column bank reconciliation. It is a powerhouse reconciliation generally used to detect fraud and highlight errors. There are several ways to perform a proof of cash, and we’ve attempted to take as much complexity out of the

Read more

Lease Commitment Template

Lease Commitments Schedule

Looking for a lease commitment template? Commonly accountants are required to report a 5 year schedule of commitments. Such schedules are susceptible to error as these calculations are preformed manually and summarized information is entered or start and end dates are off. This template simplifies this process

Read more

Income Statement Template

Income Statement Template with Data

This income statement and vertical analysis template comes complete with common income statement line items. Just like in our balance sheet template, it’s easier to start with a solid framework than from a blank page. Plus, you’ll find notes containing helpful tips on many line items. To top it

Read more

Accounts Receivable Analysis

Accounts receivable analysis

Analyze and evaluate accounts receivable over a 5 year period with this tool. All information can be reviewed graphically over time to provide additional context. Eight key ratios are calculated off of a few inputs. These ratios include Days Sales in Trade AR, AR Turnover, and Bad

Read more
Page 1 of 212

Disclaimer

The Software Product and any related documentation are provided "As Is." SpreadsheetShoppe makes no warranties, express or implied, and expressly disclaims all representations.
Read the complete End User License Agreement here