Higher AIT - Syntax for Calculated Queries on a DB

What would the formula be to create a calculated query for the following scenario:

Class Fee to be reduced by 10%

• Reduced Fee: [Class Fee]*0.9

• Reduced Fee: [Class Fee]*0.1

• Reduced Fee: [Class Fee]*1.1

• Reduced Fee: Class Fee*0.9

What would the formula be to create a calculated query for the following scenario:

Class Fee to be reduced by 2.5%

• Reduced Fee: [Class Fee]*0.25

• Reduced Fee: [Class Fee]*0.975

• Reduced Fee: [Class Fee]*1.025

• Reduced Fee: Class Fee*0.25

What would the formula be to create a calculated query for the following scenario:

Class Fee to be reduced by 12.5%

• Reduced Fee: [Class Fee]*0.125

• Reduced Fee: [Class Fee]*0.875

• Reduced Fee: [Class Fee]*1.125

• Reduced Fee: Class Fee*0.25

What would the formula be to create a calculated query for the following scenario:

Class Fee to be increased by 10%

• Reduced Fee: [Class Fee]*0.9

• Increased Fee: [Class Fee]*0.1

• Increased Fee: [Class Fee]*1.1

• Increased Fee: Class Fee*1.1

What would the formula be to create a calculated query for the following scenario:

Class Fee to be increased by 2.5%

• Reduced Fee: [Class Fee]*0.9

• Increased Fee: [Class Fee]*0.025

• Increased Fee: [Class Fee]*1.025

• Increased Fee: Class Fee*1.1

What would the formula be to create a calculated query for the following scenario:

Joining Fee to be increased by 12.5%

• Increased Joining Fee:[Joining Fee]*1.125

• Increased Joining Fee:[Joining Fee]*0.125

• Decreased Joining Fee:[Joining Fee]*1.125

• Increased Joining Fee:[Joining Fee]*1.5

What would the formula be to create a calculated query for the following scenario:

Price to be increased by 15%

• Increased Price:[Price]*1.015

• Increased Price:[Price]*0.85

• Reduced Price:[Price]*0.85

• Increased Price:[Price]*1.15

What would the formula be to create a calculated query for the following scenario:

Price to be increased by 35%

• Increased Price:[Price]*1.035

• Increased Price:[Price]*1.35

• Reduced Price:[Price]*0.65

• Increased Price:Price*1.35

What would the formula be to create a calculated query for the following scenario:

Price to be reduced by 5%

• Increased Price:[Price]*1.05

• Increased Price:[Price]*0.05

• Reduced Price:[Price]*0.95

• Increased Price:Price*1.05

What would the formula be to create a calculated query for the following scenario:

Price to be reduced by 40%

• Reduced Price:[Price]*0.60

• Increased Price:[Price]*0.60

• Reduced Price:[Price]*1.4

• Reduced Price:[Price]*1.04