Gross Profit Method Calculator

The inventory gross profit method is one way of estimating the cost of inventory at the end of an accounting period. This gross profit method calculator works out the historical gross profit percentage of a business, and then uses this to estimate the cost of the ending inventory for the current accounting period.

If you need further information on the use of gross profit methods and the calculations they involve, our gross profit methods in accounting tutorial discusses these in more detail.

gross profit method calculator v 1.0
Gross Profit Method Calculator Preview

Instructions

The Excel gross profit method calculator, available for download below, is used by entering details of the historical revenue and gross profit, and the current period beginning inventory, purchases and revenue. Using this information, the calculator works out the historical gross profit percentage, the goods available for sale, and estimates the current period cost of goods sold and ending inventory.

To use the calculator enter the details as follows:

Step 1

Enter the historical revenue and gross profit from the latest available financial statements. The calculator works out the historical gross profit percentage for the business.

Step 2

Enter the beginning inventory and the purchases made for the current accounting period. Both figures should be entered at cost. The gross profit method calculator calculates the goods available for sale during the accounting period.

Step 3

Enter the revenue for the current accounting period. Based on the historical gross profit percentage calculated in Step 1, the calculator now estimates the cost of goods sold for the period.

Step 4

Finally, the gross profit method calculator estimates the ending inventory for the accounting period by deducting the cost of goods sold from the goods available for sale.

Gross Profit Method Calculator Download

The GP method calculator spreadsheet is available for download in Excel format by following the link below.

The gross profit method calculator is one of many financial calculators available for bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this gross margin method calculator 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 a GP method calculator that you might use when considering how to calculate ending inventory. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this GP% method calculator, please let us know and we will try to fix it.
Gross Profit Method Calculator November 6th, 2016Team

You May Also Like


Related pages


calculating gross profit ratiowhat is difference between markup and marginsample general ledger chart of accountsthe basic accounting equationcurrent ratio and quick ratio analysisunits of activity depreciation calculatorinventory turnover ratio exampledays accounts receivable rationormal balance for assetsgross margin excel formulaleverage ratios examplessample ledger sheetcallable preferred stockpmt on excelcreditor definition accountingdepreciation declining balancejournal entry for bank reconciliationdepreciation ddbaverage account receivables formulaweighted average cost inventory methodexcel formula for irrcash flow margin formulapetty cash spreadsheetcalculating markup vs marginhow is a common size balance sheet createddouble column cash book examplewhat are accruals on balance sheetfifo spreadsheet templateshort term notes payable definitionpresent value of coupon bondvariable overhead formulavariable cost per unit calculationstandard costing examplecompany projections templatedegree of operating leveragefully depreciateddays cogs in inventorystockholders equity formula balance sheetcredit and debits in accountingreverse allowance for doubtful accountsjournal entry for depreciation of equipmentincome statement percentagesgeneral ledger journal entryannuity due payment calculatorcashiers check definitionperpetual and periodic inventory systemgift card breakagefuture value of annuity formula calculatorwhat is the formula for inventory turnoveraccounting ledger book formathow to figure out markup percentagelease accounting journal entriesbasic accounting knowledge testamortization schedule excel downloadexamples of cash disbursementsexcel payback period formulacash conversion costjournal entry cheat sheetjournal entry for interest expensepayroll tax expense journal entryaccounts receivable test questions answersaccounts payable entriesweighted average method calculatorpetty cash countcos bookkeepingthree column cashbookfactoring account receivablesales discounts on income statementconsignee consignoraccount receivable entriesnpv of annuity formulapayback period formula uneven cash flowsmaterial variances formulasaccurred definitionjournal voucher meaningequity multiplier equationeom mean