Calculating Cost of Space Use at Your Church

Jerry Keucher

Directions for using this worksheet:

  1. Save this spreadsheet to your own computer. Then add or delete rows as needed.
  2. Enter your own spaces, square feet and use in Columns A, B, C & D.
  3. Enter your General Maintenance expenses to be allocated into Column I Rows 11-20.
  4. Enter any Direct expenses that apply only to outside groups In Column I, Rows 26-27
  5. Copy the formula in Column F to any row that has square foot hours from outside organizations.
  6. The formulas in the spreadsheet will calculate the amount you can net out against income received.

Read the related article How Much is Your Congregation’s Space Worth? by Jerry Keucher.

Download the Calculating the cost of operating your space worksheet

Save this Tool