The following ways can do a typical cost-benefit analysis in excel: • Gather all the essential data. • Calculate cost whether it is fixed, one-time, or variable. • Determine the benefits. • Compare costs with benefits over a specific period of time. • Determine which option is best for the chosen time period.