All of the data you need to compare project costs and revenue is available in the Project Status report. You can export this data to a spreadsheet and carry out calculations there, or you can create a custom formula. Below is mentioned the logic to calculate, and achieve the same using custom columns in reports.

1. Calculating Project Cost:

Total project cost can be calculated using the following formula:
Sum for all project team members of (Hourly Cost x Total Hours)

In custom columns the formula to be used in the Project Status report:

BaseCostRate*TotalHours

This formula will give you the total Project Cost excluding Expenses in the custom column.

* If you are including expenses in the calculation, it would look like this:
Sum for all project team members of (Hourly Cost x Total Hours) + Expense Amount

In custom columns the formula to be used in the Project Status report:
BaseCostRate*TotalHours+BaseExpenseAmount
This formula will give you the total Project Cost including Expenses in the custom column.

2. Calculating Project Revenue:

Revenue can be calculated as follows:
Sum for all project team members of (Billing Rate x Billable Hours)

In custom columns the formula to be used in the 'Project Status' report:

HomeBillingRate*BillableHours

This formula will give you the total Project revenue excluding Billable Expenses in the custom column.

* If you are including expenses in the calculation, it would look like this:
Sum for all project team members of (Billing Rate x Billable Hours) + Billable Expenses

In custom columns the formula to be used in the Project Status report:

HomeBillingRate*BillableHours+BaseExpenseBillableAmount

This formula will give you the total Project revenue including Billable Expenses in the custom column.