Skip to content

Booksellers & Trade Customers: Sign up for online bulk buying at trade.atlanticbooks.com for wholesale discounts

Booksellers: Create Account on our B2B Portal for wholesale discounts

The Spreadsheet Perpetual Inventory Method: A simple and non-mathematical method to calculate stocks from flows using spreadsheets

by Tim Walshaw
Save 3% Save 3%
Current price ₹1,427.00
Original price ₹1,470.00
Original price ₹1,470.00
Original price ₹1,470.00
(-3%)
₹1,427.00
Current price ₹1,427.00

Imported Edition - Ships in 18-21 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote
+91
Book cover type: Paperback
  • ISBN13: 9780648768951
  • Binding: Paperback
  • Subject: N/A
  • Publisher: Tim Walshaw
  • Publisher Imprint: Tim Walshaw
  • Publication Date:
  • Pages: 102
  • Original Price: USD 15.0
  • Language: English
  • Edition: N/A
  • Item Weight: 264 grams
  • BISAC Subject(s): Insurance / Life

What is the Spreadsheet Perpetual Inventory Method? It is a method to use a Spreadsheet to derive a stock value from a continuous list of flow variables. In the Spreadsheet Perpetual Inventory Method the flow inputs are totaled for the specific period of that cohort of flow data to provide the total stock in that period. The Spreadsheet Perpetual Inventory Method not only provides more accurate and dependable results than the Perpetual Inventory Method using mathematical equations, but it is simpler to use. The results are more understandable to the average person. Also, you do not require years of study as an actuary or a demographer to learn and use complex formulae. All you need to understand is the relationship between flows, including depreciation and appreciation when they are used, and stocks at any point in time. The user just has to understand simple arithmetic. Indeed, after the spreadsheet has been set up, the user just needs to know just how to use the spreadsheet and how it works. Yet this spreadsheet produces more accurate results than using mathematical equations. In this book the Spreadsheet Perpetual Inventory Method (SPIM) is described clearly and precisely, and this methodology can be used estimate the total stock or population at any time from the flows of the inputs and outputs. These flows can be continuously depreciated and appreciated at the same time, yet produce accurate totals. SPIM will greatly simplify accounting inventory estimation, actuarial methods, demography, ecology, and any other study that tries to estimate the value of stocks from flow data.

Walshaw, Tim: - Tim Walshaw is a practicing economist who has written a number of useful books. In the past he worked as a research economics, and then moved successfully to consulting. He is now devoting his time writing books that would be very useful to non-economists.

Trusted for over 49 years

Family Owned Company

Secure Payment

All Major Credit Cards/Debit Cards/UPI & More Accepted

New & Authentic Products

India's Largest Distributor

Need Support?

Whatsapp Us