Altair Monarch Exercise 7 - NAV for Mutual Funds

Baba_Majekodunmi_703

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.

Altair_CommunityBlog_Default-6.jpg

Investment Management Accounts.pdf

Investment Management Transactions - Excel.xlsx

Investor Name & Codes.xlsx