Cash Flow Ratios Calculator

This cash ratios calculator uses operating cash flow instead of net income to calculate three financial ratios. Unlike net income, cash flow is an objective measure of performance which cannot be manipulated or distorted using accounting assumptions and opinions.

Cash Flow Ratios Calculator September 26th, 2017

Lump Sum Purchase Calculator

This Excel basket purchase allocation calculator can allocate the total cost of a lump sum purchase over a maximum of 12 assets based on their relative fair market value.

Lump Sum Purchase Calculator August 11th, 2017

Accrual to Cash Conversion Excel Worksheet

Financial statements prepared using the accruals basis of accounting can be used to provide cash receipts and payments information using this Excel accruals to cash conversion tool.

Accrual to Cash Conversion Excel Worksheet May 22nd, 2017

Cash to Accrual Conversion Calculator

Financial statements prepared using the cash basis of accounting can be converted to an accruals basis using this Excel cash to accruals conversion tool.

Cash to Accrual Conversion Calculator May 9th, 2017

Straight Line Depreciation Schedule Calculator

The straight line method is one method of calculating the depreciation expense for an asset. This Excel calculator produces a straight line depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a straight line depreciation rate.

Straight Line Depreciation Schedule Calculator May 9th, 2017

Declining Balance Depreciation Schedule Calculator

The declining balance method is one method of calculating the depreciation expense for an asset. This calculator produces as asset depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a declining balance depreciation rate.

Declining Balance Depreciation Schedule Calculator March 14th, 2017

This overhead recovery rate calculator can be used to calculate the amount of manufacturing overhead to be absorbed by a unit of production.

Overhead Recovery Rate Calculator November 22nd, 2016

The overhead apportionment calculator, sometimes referred to as a cost apportioning calculator, can be used to apportion up to eight overhead types between six departments or cost centers.

Overhead Apportionment Calculator November 6th, 2016

Sales Tax Calculator

The sales tax calculator works out the sales tax rate percentage, sales tax amount, net amount, or gross amount by entering any two of these values.

Sales Tax Calculator November 6th, 2016

Gross Profit Method Calculator

The gross profit method calculator works out a products net price after applying multiple trade discounts to its list price. This free Excel calculator also provides a summary showing the original price, total discount, and net price, together with a calculation of the single equivalent rate (SED).

Gross Profit Method Calculator November 6th, 2016

Chain Discount Calculator

The chain discount calculator works out a products net price after applying multiple trade discounts to its list price. This free Excel calculator also provides a summary showing the original price, total discount, and net price, together with a calculation of the single equivalent rate (SED).

Chain Discount Calculator November 6th, 2016

Vertical Analysis Calculator

A vertical analysis shows each line of financial statements as a percentage of a base line item so that comparisons can be made. This free Excel calculator produces a vertical analysis of an income statement in relation to total revenue, and of a balance sheet in relation to total assets.

Vertical Analysis Calculator November 6th, 2016

Related pages

debtors collection period ratio analysisefficiency ratio receivables turnoverbookkeeping ledgeradjusting entries for depreciationcalculate ending work in process inventorytransposition errorsinventory sheets templateimprest accountperiodic inventory system average cost methodcoupon bond calculator present valuediscount annuity formulaformula for annuity future valuetemplate for a voucherformula leverage ratioinvoice reconciliation processdiscount on note receivablehow to calculate unit variable costfree petty cash voucher templatepayback period calculation excelexcel chart of accounts templatewhat are accruals and prepaymentsunpaid salary journal entrywhat is a contra assetpetty cash in tallynet purchases equationunearned revenue on a balance sheetaccrual accounting basicsdefine cushioningfixed asset turnover ratestraight lining of leasesaccounting templates excel worksheetsbad debt expense allowance methodopposite of deferred revenuewhat are outstanding chequeshow to calculate allowance for doubtful accountsmodified irr calculatorexamples of long term liabilities on balance sheethow to calculate markup and marginjournal entry to record net incomeformula for growing perpetuitybalancing quizaccrued and prepaid expensesgeneral journal adjusting entriespayback period calculator excelgearing financecalculating wipcreditor definition in accountingchanges in accounts receivableshow to prepare an amortization scheduleissuing preferred stockperpetuity factordouble decline depreciation examplejournal general entries accountingfob calculationpremium bonds effective interest ratenormal absorption costingpremium bonds repaymentdouble entry bookkeeping excel templatecontribution margin format income statementexamples of ledgerstypes of bank reconciliation statementdifference between notes payable and accounts payablecalculate irr in excelwhat are accrued salarieswhat is percentage markupaccounts receivable turnover definitionageing accounts receivablelease amortization schedule excelis depreciation a period costsample cash receipts journalprintable ledgercommon sized income statement