Executed rule: Total charge · retail quote

RX-3

Early loan settlement quote, Riyadh office (VAT 15%)

Context

Total charge = +

= 575.00 EGP

Click a term to unfold it in place; the i shows where a source value lives.

The values this execution used, each with the cell it was read from.

Click a term to unfold it in place; the i shows where a source value lives.

#	Variable_id	Variable_title	Formula_id	Formula / value origin	Type
1	V-1	Quantity [1]	—	INPUT!quantity [1]	Source data
2	V-2	Service fee [500.00]	—	MD-11!SRV-LOAN-SETTLE.fee [500.00]	Source data
3	V-9	Service charge [500.00]	IR-1	×	Calculated
4	V-3	VAT standard rate [15%]	—	MD-22!SA-VAT-STD.rate [15%]	Rule value
5	V-10	VAT amount [75.00]	IR-2	× ÷ 100	Calculated
6	V-11	Total charge [575.00]	IR-3	+	Calculated

Each variable in the order it was evaluated: sources first, then each formula with the values it used.

#1V-1QuantitySource data1 units
Address: INPUT!quantity · Given by whoever runs the calculation (Quantity)
#2V-2Service feeSource data500.00 EGP
Address: MD-11!SRV-LOAN-SETTLE.fee · Master data cell, as of 2026-10-15 · record given by input "service"
Master data table: MD-11 · Retail Service Offerings 2026 · Record SRV-LOAN-SETTLE · Record version 1 · Column fee
#3V-9Service chargeCalculated500.00 EGP
IR-1 · AR-1 Service charge: 1 × 500.00 = 500.00
#4V-3VAT standard rateRule value15% %
Address: MD-22!SA-VAT-STD.rate · Selected from MD-21, MD-22
Master data table: MD-22 · VAT Codes — Saudi Arabia · Record SA-VAT-STD · Record version 1 · In effect from 2020-07-01 to … · Column rate
Selection rule FN-12: jurisdiction = SA (context country), treatment = standard, in effect on 2026-10-15 · Records matched: 1
#5V-10VAT amountCalculated75.00 EGP
IR-2 · AR-2 Value-added tax: 500.00 × 15% ÷ 100 = 75.00
#6V-11Total chargeCalculated575.00 EGP
IR-3 · AR-3 Amount including VAT: 500.00 + 75.00 = 575.00