Working Capital Calculator

The working capital calculator can be used by any business to estimate the cash needed to fund its working capital requirements.

Working capital is the amount of cash needed to fund the normal day to day trading operations of the business.

In a simple business it would be calculated as inventory + accounts receivable – accounts payable, which represents the funding needed to buy inventory and provide credit to customers, reduced by the amount of credit obtained from suppliers.

working capital calculator
Working Capital Calculator

Our tutorials on working capital give full details of how this working capital calculator can be used.

The Excel file available for download below, will help you to carry out your own working capital calculations.

Working Capital Calculator Download

The working capital calculator is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this accounting template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an accounting format that you might use. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the template, please let us know and we will try to fix it.
Working Capital Calculator November 6th, 2016Team

You May Also Like

Related pages

petty cash voucher meaningdepreciation journal entryreconciliation of ledger accountsprepaid expenses journal entryfixed asset turn over ratiostraight bond value calculatorfinancial accounting practice exercisesgeneral ledger samplecash journal templateprepaid expenses accounting definitionexplain double entry bookkeepingshipping fob meanspmt function exampleprepaid expenses entry in tallyaccounts receivables interview questionspetty cash balance sheetsales ledger control account examplecreditor days ratiotransactional analysis for dummiesdouble entry system of bookkeepingpmt function on excelcurrent ratios and quick ratiosdepreciation calculation formulaaccounting cycle exampleinventory adjusting entrybookkeeping cash bookexample of general ledger entriesformula for depreciation straight line methodpetty cash credit or debithow to perform vertical analysisavailable for sale securities exampledefine trade debtorsvalue of an annuity calculatorsoyd depreciationhow to calculate trial balancesimple petty cash book in exceltabel present value anuitaslocom accountingexpense voucher templateaccounting basics tutorialfixed asset registersaccounts receivable turnover ratio calculatorvoucher layout templateannuity factor table excelexamples of cash disbursementswhat is a contra entry give an examplehow to calculate days in accounts receivablefuture value of annuity due tabledouble entry bookkeeping historypercentage complete formula exceldisposal of ppeprintable ledgers bookkeepingfind profit percentage formulapermanent accounts in accountinginventory accounting basicsprovision for expenses journal entrycalculating present value of an annuitystraight line amortization calculatorhow to calculate depreciation of fixed assetspercentage of sales method calculatorproduction overheadamortization schedule excel downloadwip accounting definitioncontra receivablepresent value perpetuity calculatorjournal entry to accrue interestnormal balance for cashimprest checkroce formulacash denomination formatyear end adjustments journal entries