Cost vs Benefit Analyses

Cost vs Benefit Calculator - 4 Years.xlsx

Download XLSX • 30KB

Simple Guide: Using the Facility ROI Calculator

How to Use the Calculator:

1. Enter Costs:

   • In the "Costs" section, fill in the "Quantity" and "Price" for each item.

   • The "Total" column will calculate automatically.

2. Enter Benefits:

   • In the "Benefits" section, fill in the "Quantity" and "Price" for each item.

   • The "Total" column will calculate automatically.

3. Review Results:

   • The "Position" section at the bottom will update automatically.

   • It shows Total Costs, Total Benefits, Net Benefit, and Gross Margin.

     
     

How to Add a New Row:

1. Right-click on the row number below where you want to add a new row.

2. Select "Insert" from the menu that appears.

3. A new blank row will be inserted.

4. Fill in the "Category" and "Item/Name" for your new entry.

5. Enter the "Quantity" and "Price".

   
   

How to Extend Formulas to New Rows:

1. This should happen automatically as you create new rows.

   
   

Tips:

• Always double-check your entries to ensure accuracy.

• The "Total Costs" and "Total Benefits" will update automatically when you add new rows.

• If a total doesn't update, try to extend formulas.

Remember: Only edit the white cells. The colored cells calculate automatically!