Each time a template is opened, it produces a new spreadsheet together with all of the formulas, formatting etc in place. If you can't locate the template that you require, you can choose the Template Gallery add-on. The Excel accounting templates are free and they are sometimes adjusted dependent on how many times you want to calculate accounts. Fortunately, there are several Excel accounting templates which you can get for free for your business enterprise.
Excel Spreadsheet Templates