Dear All,
How to achieve Minority Interest on Ownership Change in the same financial Year.
For Example: For April Ownership and Minority interest is 60% and 40% respectively and PROFIT is YTD 1000.
On that period, Minority will be calculated at 40% and value would be 400.
Next Period, May month - ownership has been changed to 80% and 20% and profit value is YTD 2000.
In this period, Minority should be calculated on two values, which 40% is on 1000 (april's value) and 20% on 1000 which May's value.
Total would be 400 + 200 = 600
How to achieve this in HFM. If we uncheck ConsolidateYTD in scenario view, then system will calculate minority as per the requirement. But, if we uncheck this, then ZeroviewforAdj and ZeroviewfornonAdj has to be periodic and any adjustment requiered, then only periodic value needs to be inputed. But, data load is happening with YTD values (TB values been loaded with YTD value). Any impact on Flow(P&L) / Balance (Balancesheet) accounts if we use periodic values for adjustment.
If we check ConsolidateYTD, then minority interest will be calculated at that month's minority interest % on YTD value.
If month is april then, 40% on 1000 and if month is may then 20% on 2000 = 400 ( which is not right on profit value).
Also, if we uncheck ConsolidateYTD, and having ZeroviewforAdj and ZeroviewfornonAdj with YTD will not give right figure.
Is any other way to approach or achieve minority interest calculation as shown above.
Kindly share your ideas and approach.
Regards,
Raj-