![]() |
How to: Add more products / profit centers to financial model
Yes, you can do this...
You will need to go into Excel.
(First, unprotect the page.)
'Insert Rows'
We recommend adding additional lines at the bottom of the section...
The "Total" line at the bottom of that section is what is used throughout the model.
(Make sure the formula in the [sub]total row includes the added lines.)
You will need to look throughout the model for every other page that would include these line items and repeat the procedure.
(Having added the additional lines and adjusting the totaling formula, you can now 'copy right' from the lines above to automatically fill in the formulas referencing numbers and formulas from the source pages.)
And, you do ALL of this at YOUR peril!
(JIAN can not be responsible if you screw this up!)
As an Excel expert, it's as if you are in a 4-wheel drive...
it can get you stuck in a more remote place!
:-)
Get-the-Job-Done Right
and Save a Ton of Time or
we'll
Credit-Your-Account!
Download and use any JIAN Business Planning Solution for up to 60 days and become convinced that it's what we say it is. If it's not, we will credit your account.