top of page

Forecast Inventory

Forecast your inventory balance. Enter in your projected Cost of Goods Sold, and control when the cash expenditures will hit your bank account via a waterfall calculation to get your ending inventory balance.

Compatible with Excel

Color coding

Items in blue - inputs (editable)

Items in black - calculations (do not edit)

Items in purple - referencing another cell (do not edit)

Items in Red - error check rows (do not edit)

Set your starting date by editing this blue cell as such:




Enter in your projected Cost of Goods Sold amounts as such:




Enter in the assumptions for when the purchases will be paid for the amounts entered in your COGS line. The values should equal a total of 100% between all periods. Under the example below, the amount forecasted in COGS will be purchased 3 months beforehand at 50%, and 50% beforehand at 1 month prior.




Expand the waterfall to showcase the waterfall which will outline the payment period:


Update your beginning inventory balance over here:


Collapse the waterfall to showcase your projected inventory Balance, which is the sum of your beginning balance, + new purchases from the waterfall, less the COGS amounts you forecasted.

Instructions

  • How does it work?
    Download the template from the Microsoft App store, and get access to 80+ excel templates, infographics, power point files.
  • What type of templates are included?
    Accounting templates, FP&A templates, Dashboards, and Templates to learn excel
  • How long will I have access for?
    You will have access for an entire year
  • What is the price?
    $50 / month, paid annually.
  • What technical requirements do I need?
    You will need a license to Microsoft Excel
  • Will I be notified of new templates added
    Yes! We will continue adding new templates, which will sync directly to the plugin that you will have access to.
  • Do you have a google sheets integration?
    Not yet, but it's on the roadmap!
  • Can I connect my data to these templates?
    Not yet, but we will be releasing a premium version of our plugin soon where you will be able to!
bottom of page