respuzy
02-26-2018, 09:21 AM
Hello Experts
Good day, please in the sheet attached, i need to share interest in column J (with formula example already provided in the column J2:J10), i need to replicate this dynamically in that column per each valuation date data by taking the column H "NAV after Redemption" dividing it by the total of that valuation date data and multiply it by the corresponding distributable returns in column I.
for instance for valuation date 30-jun-16 , in column I, it should calculate 49.95 (Net NAV)/1529.18 (sum total) *27.44 (distributable return)
For valuation date 31-jul-16, in column I, it should calculate 77.34 (Net NAV)/2342.36 (sum total) *50.64 (distributable return)
please revert for further clarification of need be. thanks
Good day, please in the sheet attached, i need to share interest in column J (with formula example already provided in the column J2:J10), i need to replicate this dynamically in that column per each valuation date data by taking the column H "NAV after Redemption" dividing it by the total of that valuation date data and multiply it by the corresponding distributable returns in column I.
for instance for valuation date 30-jun-16 , in column I, it should calculate 49.95 (Net NAV)/1529.18 (sum total) *27.44 (distributable return)
For valuation date 31-jul-16, in column I, it should calculate 77.34 (Net NAV)/2342.36 (sum total) *50.64 (distributable return)
please revert for further clarification of need be. thanks