Altair Monarch Exercise 7 - NAV for Mutual Funds

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited February 2023 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Data Prep Studio
  • Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
  • Skills/Features Tested: Report Trapping, Group By, Join, Formula Fields
  • Systems of Record: Not Applicable
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached
    • Investment Management Accounts.pdf
    • Investment Management Transactions -Excel.xlsx
    • Investor Name & Codes.xlsx

Exercise Overview

You are a Mutual Fund Accountant and you need to accomplish the following two tasks using the Data Prep Studio.

  1. Determine Net Asset Value (NAV) for the portfolio based on the calculation; [(Current Balance + Contributions + Dividends & Capital Gains) - (Redemption's + Administrative Fees)]/100,000,000 shares outstanding.
  2. Create a Group-By Summary for NAV by the different Investor Codes & the Investor Names

Hint: You need to perform the NAV for the period of transactions for the Month of February 2020. Make sure you apply a filter for the transactions to be in align with that time frame.

Answer

  • Please upload your answers below in the comment section for the exercise
  • A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.
Tagged:

Categories