Aug 08 2022 06:57 AM
Trying to insert formulas for spreadsheet below
RATE 1st $100,000 | RATE next $400,000 | RATE next $2,000,000 | RATE next $2,500,000 | RATE next $2,500,000 | RATE over $7,500,000 | |
RATE | 2.500% | 1.500% | 1.000% | 0.075% | 0.070% | 0.069% |
$100,000 | $400,000 | $2,000,000 | $2,500,000 | $2,500,000 | ||
CONTRACT AMOUNT | ||||||
$8,000,000.00 | $2,500.00 |
Aug 08 2022 07:05 AM
Aug 08 2022 07:12 AM
See the attached demo.
Aug 08 2022 07:28 AM
Aug 08 2022 07:29 AM
Aug 08 2022 07:39 AM
Yes, if you wish:
Aug 08 2022 08:02 AM
Aug 08 2022 08:14 AM
0.075% of $2,500,000 is $1,875 and not $18,750.
0.070% of $2,500,000 is $1,750 and not $17,500.
The remaining amount over $7,500,000 is $500,000.
0.069% of $500,000 is $345.
Perhaps the percentages should have been 0.75%, 0.70% and 0.69%? The jump from 1.00% to 0.075% is very large...
Aug 08 2022 08:16 AM
Aug 08 2022 08:31 AM
Aug 08 2022 08:37 AM
SolutionSee the attached version.
Aug 08 2022 08:55 AM
Aug 08 2022 08:37 AM
Solution