Hi, I have been working on one of the practical exercises in the training section of the website (Modano_Generic Financial Model that incorporates the historic and forecast financial model).
Just wondering if anyone has encountered the situation where Modano inserts an 'extra' Creditors Category in Creditors Assumptions in the Working Capital sheet. I have included a screen shot below.
I am not sure how to fix it, or if it is impacting on the integrity of the model.
I noticed that there was a similar issue in the Rev_Exp sheet when I was uploading assumptions.
thanks James
Hi James,
The spare categories you're seeing will have been created or overlooked during the Import Assumptions mapping process you undertook earlier in the exercise to import the historical income statement and balance sheet data.
You needn't worry about them impacting the integrity of the model, and feel free to delete them by selecting a cell in their rows and using the Delete Categories command. I'd recommend always deleting them from the source so you're sure you're deleting redundant categories - i.e. in your above image delete row 63 to remove the unwanted creditors category.
Funnily enough, I had this same issue last week after using the Import Assumptions tool and chopping and changing the mapping. It's nothing to be concerned about, as long as your reconciliation is correct. Just delete them and move on.
M.
Thanks Michael - I just hit the delete category for row 63 - seems to have done the trick!