Calculate cash flow based on criteria from type

Assignment Help Business Management

Reference no: EM133242120

Case Study Assignment

You will read and complete the secondcase study from our Business Analytics eText. Your case study will require you to demonstrate your understanding and application of business analytics concepts. You will be asked to complete Excel functions and tasks and answer questions from the text. Your case study will be found in Chapter 2, People's Choice Bank.

Worth 50 points, your case studywill explore concepts covered in Weeks 4, 5 and 6 and encourage critical analysis. Your case studywill ask for opinions and recommendations. Your claims should be supported by evidence including references from the text, valid outside resources, or rational arguments. Your case study should exhibit strong structure and organization. A concise introduction with a clear preview, a well-written body using complete sentences, in-text citations when necessary and a clear summary in the conclusion are expected.

Excel functions you will use include PivotTables to provide a summary of the key information.

Aside from just describing the analysis, discuss your interpretation of the data. You may include images from your analysis in the report, but images should not constitute the majority of the report. If you use a table or image, you must spend some time discussing it within the body of the text. A good rule of thumb is at least a paragraph of text to describe each image.

College-level writing is expected, points will be deducted for grammar and spelling errors.Include and upload your accompanying Excel file.Your Word file submission must be in APA format. Include a title page with your name, case study title, and date. Your report should be at least 2 full pages, 1-inch margins 12-point Times New Roman font, double-spaced. References and citations when sources are used must be provided on a separate page. Your report should be submitted in Word (.docx) format. Information for downloading MS Office 2016 for free is provided in the "Start Here" module. Please refer to the Case Study Assignment tab in the Assignment Overview module for a copy of the rubric for evaluation of your Case Study. Your Excel file will be evaluated under the Content section of the rubric.

Make sure you complete each of the tasks listed in your eText for People's Choice Bank.

Here are some details you need to complete the file.

Question 1. You will need to add a column and create a function that calculates Cash Flow based on criteria from Type. Create anIF statement that returns a negative cash flow (looks like ($500.00) for example) if the type was a Withdrawal. For all other types, the cash flow should be positive.

Question 2. In running your pivot tables, some suggestions are to look at things like branch, account type, customer, etc. These are suggestions only. You will probably run more than just those types. Remember to run more than just SUMs in your pivot tables. You can also run MIN, MAX, COUNT, PERCENT and more. Run at least different 3 pivot tables, saving each as a separate sheet with each tab descriptively labeled (For example: Pivot 1, Pivot 2, etc.). Include your pivot tables andgenerate charts from each pivot table; include your pivots and/or charts as images in your Word document report. (One final tip, don't' forget about time such as dates and days of the weekand percentages in your analysis and data set.)

Question 3. Place your name in each worksheet in cell U1 and your student number in U2 to receive credit for your Excel worksheets for this assignment. Do not work with another student or copy from any websites or sources. Your work must be your own and you must use the file provided in our course.

Question 4. Include your observations, recommendations and analysis in your report.

Attachment:- Case Study File.rar

Reference no: EM133242120

Questions Cloud

Script a counter-argument to the aforementioned challenge : What is the biggest personal challenge that lowers your confidence in being able to enact the solution to the moral problem

What one strategy could be adopted : Describe the options you justified above and outline specific methods you would adopt in using those 2 options. Discuss specific uses, platforms, and messages

Health information services : You are the hospital's Director of Health Information Services and you report to the Vice President of Finance.

What phm policies did the literature say was applied : What PHM policies did the literature say was applied to solve the problem(s) or PHM policies suggested that should be applied to solve the problem

Calculate cash flow based on criteria from type : Calculate Cash Flow based on criteria from Type. Create anIF statement that returns a negative cash flow - Place your name in each worksheet in cell U1

Difference between slack time and cycle-time efficiency : Provide the difference between Slack time and Cycle-time efficiency. There are how many ways to compute the Cycle time? Explain only one way

How are the amendment elements relevant today : How are the amendment's elements relevant today? What are the modern-day challenges of applying them to current issues

What did researchers conclude about stereotypes : In your own words describe this study. What was it about? What were the main findings? What did researchers conclude about stereotypes

Functionality-legal and personnel development : Evaluate the different healthcare organizations committees to assure oversight of functionality, legal, and personnel development.

User Account

All Pages