Stock Valuation Excel Model Tool under weighted average system with timeline.
Originally published: 29/05/2018 09:05
Last version published: 01/10/2019 12:19
Publication number: ELQ-13904-2
View all versions & Certificate

Stock Valuation Excel Model Tool under weighted average system with timeline.

Weighted average stock valuation over the timeline logic for excel beginner.

A stock valuation tool based on weighted average system for beginners to create logic in excel through different function. It provide weighted average value of the inventories. The tool can be modified as per the user specification and in case if you want to create a stock management tool for your company then please contact me through Eloquens chat. Let me know your feedback and inputs to improvise the tool


1) Update the first date of timeline: Should be the first date of any month and year. Refer cell E12 to update.

2) Update the frequency of the timeline. Refer cell E15 to update

3) Update the financial year last month. Refer cell E17 to update.

4) Input the price through out the timeline. Refer row 24 from F column onwards.

5) Input the purchased quantity through out the timeline. Refer row 26 from F column onwards.

6) Input the transfer/sale quantity through out the timeline. Refer row 28 from F column onwards.

In case the cumulative transfer units are more than the cumulative purchased unit then the Error will be shown in row 30 with comments.

For result please refer the output section from row 35 onwards.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $50.00

Add to cart

Add to bookmarks



keyboard_arrow_downShow all

People using this Best Practice also downloaded


Discussion feed for Stock Valuation Excel Model Tool Under Weighted Average System With Timeline.

The user community and author are here to help. Go ahead!

  • Giordano K
    Can i use other currencies? If so, do i have to change anything or just simply input any number in any currency?
    1arrow_drop_uparrow_drop_downReply reply
    • Financial Modeller
      Yes, you can use any currency. The template doesn't consider any forex conversion.
      1arrow_drop_uparrow_drop_downReply reply
    • Financial Modeller
      Hi user, I would like to know your feedback regarding the stock valuation tool.
      arrow_drop_uparrow_drop_downReply reply

      4.2 / 5 (15 votes)

      please wait...