Urgent - Tiered Pricing
Hello,
I urgently need to update an existing VBA macro to run in rom F7:
March Mkt Value 192,073,275.92
25,000,000.00 0.80% 200,000.00
25,000,000.00 0.60% 150,000.00
50,000,000.00 0.40% 200,000.00
92,073,275.92 0.30% 276,219.83
Annual Fee 826,219.83
Quarterly Fee 138,080.57 = 826,219.83*61/365
Discount 20% (27,616.11)
110,464.46 value in F7
|