![]() Note: You don't need to enter all of your current expenses. This screen shot shows the entries in the sample file, and you can edit the list, to include your own current expenses.įor example, what are your current home maintenance costs every month? From that amount, the workbook can calculate your annual maintenance cost. On the CostPerYear worksheet, enter your current spending,īy filling in the green cells for Scenario A. So, when you select a time unit on the CostPerYear sheet, this lookup table returns the number of periods for the selected time unit.įor example, select Weekly, and the cost is multiplied by 52 - the number of weeks in a year. These named ranges are used as a lookup for the cost per year calculations. Number of work weeks per year, to match your schedule. ![]() You can adjust the number of work days per week, and the In this template, there is a Lists sheet, where the time units areĮntered. open a full-sized version of the workbook, in Excel for the Web.download a copy of the workbook, to use in Excel for the Desktop.Click icons at the bottom of the embedded workbook to:.you can change the values in those cells, to adust the results in Scenario A and Scenario B.How much can you save each year, if you make small changes to your current spending? If your web browser supports it, try the Annual Cost Calculator in this embedded Excel workbook. The written instructions are below the video, and there is an embedded workbook in the next section, so you can try out the calculator. To see how the annual cost calculator works, you can watch this short In the sample workbook that you can download on this page, there are formulas that calculate the difference in annual cost for each item, Or, what expenses will be increasing over the coming months? Some cost increases are out of your control Where can you cut back in your daily, weekly or monthly spending? Even a small reduction in a daily expense can add up to big savings, in the annual total cost for that item. Get the Sample File Using the Cost Calculator
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |