Simply, multiply 1% times your profit(loss) and make your appropriate your path.
Excel spreadsheet is nice but sometimes, it uses a lot of time to enter customer or employee information. Research the auditing process to get ready for what is to come.