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, 2017Team
Read more

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, 2017Team
Read more

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, 2017Team
Read more

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, 2017Team
Read more

Overhead Apportionment Calculator

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, 2016Team
Read more

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, 2016Team
Read more

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, 2016Team
Read more

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, 2016Team
Read more

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, 2016Team
Read more

You May Also Like


Related pages


journal entry of bad debtsstandard costing and variancesbalance sheet with accumulated depreciationaccrued revenues areaccounting entries for prepaid expensesmargin vs markup tablepros and cons of reversing entriesadjusting entries accounting practice problemsinterest expense adjusting entryfreight terms prepaidsample interview questions and answers for bookkeeperpetty cash expenses examplehow to calculate receivable turnoverfixed asset turnover ratio formulacash payment voucher formatfixed cost formula accountingdisposal of fixed assets double entryaccounts payable excel templateamortisation calculationprofit margin calculator excelgross margin per unit formulaprintable accounting ledgerwhat are the principles of book keepingaccounting equation chartaccounting internal controls checklistwhat is the formula for straight line depreciationhow to calculate variable costs per unitnet profit on sales ratioflat rate to apr formuladouble entry for accounts receivablefuture value annuity formulaaccruals and prepayments definitionexcel ledger templatesdirect materials efficiency variancefifo calculationcredit turnover ratio formulapractice bookkeeping testledger book templateperpetuity valuationformula for annuityformula for present value of an annuitydecline in value calculatorexplain debit noteeffective monthly rate calculatorissuance price of bond calculatorcontribution margin ratio equationpayroll expense journal entryirr formula exceldefine sundry debtorsreceivables turnover ratio calculationmanagerial accounting variance formulasdeferred taxation meaningaccounts payable and accrued expensesgross margin markup calculatorcalculate wip inventorypayback ratiooverhead calculation spreadsheetsample chart of accounts for construction companyspecial journals accountingformula of present value of annuityincome tax expense journal entrydouble entry bookkeeping pdfamortization expense formulafinancial leverage ratio debt equity ratiofuture value growing annuityperpetuity annuity formuladouble entry bookkeeping booksmeaning of prepaid expenses in accountingtrade receivables debtorsvariable expenses examplesstraight line depreciation examplesledger entries in accountingvariable contribution marginaccounts receivable is a debit or creditfob merchandisestockholders equity accountingrule of 78 sales calculatorbookkeeping cheat sheetwhat is a profitability index