Tim Walshaw

The Spreadsheet Perpetual Inventory Method (eBook, ePUB)

A simple and non-mathematical method to calculate stocks from flows using spreadsheets

• Format: ePub

Produktbeschreibung

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 totalled 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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Lulu.com
• Erscheinungstermin: 20. Juni 2022
• Englisch
• ISBN-13: 9781471661334
• Artikelnr.: 64383702

Autorenporträt

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.