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


variable overhead rateaccrued expense accountinghow to calculate fifo and lifocompound depreciationadjusting entries depreciationdepreciation salvage value formulahow to calculate cost of goods available for saleasset turnover ratio equationjournal entries for depreciation of fixed assettable of present value annuity factorsadvantages and disadvantages of accounting rate of returnbookkeeping meaning and definitionwhat is the fixed cost formulaunearned revenue examplepercentage of completion accounting journal entriesdepreciation straight line formulacogs income statementperpetual cash flow formulacreditors days formulasafety stock calculation excelwhat is factoring receivablesdividend ratio formulaincome statement format xlsunrealized gain accountingfixed asset turnover ratio industry averagesales ledger control accounttabel discount ratehow to calculate depreciation straight linecheque wikiimprest system accountingfob plant definitionbalance sheet deferred revenuestock option journal entriesexcel formula for irrblank bank reconciliation templateincome statement bad debt expensetransposition error in trial balanceaccounting excel templatechart of accounts template canadabalancing of ledger accountsformat of general ledgerpresent value of annuity table pdfthe monetary unitincome tax provision accounting entriesmarkup v margin calculatorgearing definition financevoucher book formataccumulated depreciation fixed assetinventory perpetual methodhow to calculate the acid test ratioequity method of accounting for joint venturesdefine interest coverage ratioaccounts receivable aging report samplecalculating margin vs markupwhat is accounting cycle and stepsdefinition of return on capital employedprepaid asset journal entrydso calcpresent value annuity due tableaccrual journal entry examplepresent value formula for annuitybank reconsdebtors ledger formataccounting for uncollectible accountsformula for owners equityaccrual adjusting entries examplesjournal ledger entriespayback method calculatorcalculate effective annual ratepayroll quizaccounting ledgers templatesdebt to owners equitystatement of changes in equity templatewhat is the definition of bookkeeping