Annual Percentage Yield (APY) and Annual Percentage Rate (APR). This calculator converts from one to the other. Generally people want to convert from APY to APR or APR to APY in order to understand similar investments or loans, or in order to perform their own calculations. APY
Read more →
An incremental purchase or sale of an investment can impact your average basis. The basis is your average cost of the original investment. For tax purposes, the method of computing the gain or loss on investments must be elected and consistently applied. This spreadsheet does not track
Read more →
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 →
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 →
The percentage of completion schedule calculates the amount of revenue to be recognized for long-term construction-type contracts. There are other acceptable methods of revenue recognition, but the cost-to-cost method used in this template is one of the more popular. The cost-to-cost method provides for proportional recognition of revenue
Read more →
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 →
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 →
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 →
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 →
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 →