CMA examination spreadsheet
Dear CMA Candidate,
This is an important message from the Institute of Certified Management Accountants (ICMA) in regard to your CMA1D or CMA2D exam. There may be a spreadsheet based response tool for one of the questions on the exam. This new functionality will make it easier for you to align columns of numbers and perform certain calculations. Although the tool was created to resemble widely-used electronic spreadsheets, it does not have the same exact functionality of the spreadsheet products with which you may be familiar.
You will be given an opportunity to practice some of these functionalities by following the instructions below. In addition, we have included some of the instructions that you will be provided during the tutorial on your exam test day. For this item you will be graded on the information that you supply as it pertains to the scenario. All work entered on the spreadsheet will be captured and scored. The design or layout of your response will not be graded.
The attached screen shots show some of the available spreadsheet functions. The online demo will allow you the opportunity to practice some of the steps explained here as well as others you may encounter on the exam.
To view a live interactive demo of this spreadsheet please go to www.prometric.com/icma.
Sample Question
Below is a sample test question. Please take this opportunity to practice by using the demo to answer this question.
Matchpoint Racquet Club (MRC) is a sports facility that offers tennis, racquet ball and other physical fitness facilities to its members. MRC owns and operates a large club with 2,000 members in a metropolitan area. The club has experienced cash flow problems over the last five years, especially during the summer months when both court use and new membership sales are low. Temporary bank loans have been obtained to cover the summer shortages.
The owners have decided to take action to improve MRC's net cash flow position. They have asked the club's financial manager to prepare a projected cash budget based on a proposed revised fee structure. The proposal would increase membership fees and replace the hourly tennis and racquet ball court fees with a quarterly charge that would allow unlimited usage of the courts. The new rates would remain competitive when compared to the rates of other clubs in the area. Although there will be some members who do not renew because of the increase in price, management believes that the offer of unlimited court time will increase membership by 10%.
The proposed fee structure is shown below, along with the current membership distribution. The membership distribution is assumed to remain unchanged. All members would be required to pay the quarterly court charges.
If you have problems viewing this page, please click here.
