THE SPREADSHEET PERPETUAL INVENTORY METHOD: A simple and non-mathematical method to calculate stocks from flows using spreadsheets - Couverture souple

Walshaw, Tim

Couverture souple

ISBN 10 : 0648768953 ISBN 13 : 9780648768951

Editeur : Tim Walshaw, 2022

Synopsis

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.

A propos du livre

À propos de l'auteur

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.

Détails de l'édition

• Éditeur: Tim Walshaw
• Date d'édition: 2022
• Langue: anglais
• ISBN 10: 0648768953
• ISBN 13: 9780648768951
• Reliure: Broché
• Nombre de pages: 100
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible