Answer:
see attached
Explanation:
The formulas given work perfectly.
It might help you to think of the tax rate as a percentage. For example, $2.37 per $100 is a rate of 2.37/100 = 0.0237 = 2.37%
Each dollar value is the product of the previous two columns.
$400,000 × 0.19 = $76,000; $76,000 × 0.0237 = $1801.20 (tax)
$235,000 × 0.10 = $23,500; $23,500 × 0.0993 = $2333.55 (tax)
$215,000 × 0.15 = $32,250; $32,250 × 0.1240 = $4000.00 (tax)
__
Where the rates are missing (as on the third line), they can be found by dividing the dollar value on the right of it by the dollar value on the left of it.
32,250/215,000 = 0.15 = 15%
4000/32,250 = 0.1240 = $12.40 per $100
_____
Additional comment
To get a tax of exactly $4000 on the last line, the tax rate needs to be specified to 4 decimal places: $12.4031 per $100. Otherwise the value rounds to something less than $4000.