View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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