You are a staff accountant at Anderson & Paul, a CPA firm located in downtown San Diego. A long-time client, Brady Patterson, has contacted you with a request. Brady is 32 years old, is beginning to think about saving for retirement, and has some questions. He is confused about the differences between a Roth IRA and a Traditional IRA and needs your advice. He wants you to prepare an Excel model that he can use to test the differences in a Traditional versus Roth IRA. Based on your discussion with Brady, the Excel model should cover a ten-year period. Your model should be comprised of the following parts:Part 1 Input SectionBrady would like to be able to change the following items in the model:1.Year analysis begins2.Amount of the IRA contribution (only one contribution in this analysis – not one per year)3.Tax rate at date of contribution (assume the contribution is made on January 1 of the initial year)4.Annual growth rate (constant growth throughout the analysis period)5.Tax rate at date of withdrawal (assume entire account balance withdrawn at end of tenth year)Prepare an input section where Brady can enter different values for the five variables listed above. It doesn’t matter what values you leave in the sections, only that when they are changed Parts 2 and 3 of the model are updated automatically. Part 2 Tables for Roth & TraditionalPrepare one table showing the Roth IRA and one showing Traditional IRA balances over a ten-year period. The balances should grow by the growth rate and should reflect the taxes at contribution and withdrawal as appropriate for the IRA type. All of these values should change when inputs from Part 1 change.Part 3 Graph Showing Roth & Traditional Balances Year-Over-YearPrepare a graph showing the account balance at each year-end for the Roth and Traditional IRAs. The final year data point should be the net of tax amount of the distribution. The lines on the graph should move as inputs from Part 1 are edited, which in turn affects values in Part 2.Part 4 Client NotePrepare a note to Brady explaining the main differences in the two IRA’s, and what factors might make one preferable over the other. This note should be typed out in your Excel model and formatted well.Remember, a professional presentation includes proper titles and headings, is centered on the page when printed, and is a reasonable size on the page. You should have nice headers and an overall clean look – impress me! Test the appearance of the worksheet by using the print preview function in Excel. Professional appearance is important so don’t overlook this part of the assignment. Make sure your file is uploaded to Turnitin by 9PM Tuesday 10/27, no exceptions.

Why is whistleblowing a controversial activity? Do a quick google search and see if you can bring an examples to the class discussion.

Please help with this assignment. Examine basic descriptive statistics, and demonstrate results using calculated values and statistical charts.Scenario A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:A listing of the jobs by title The salary (in dollars) for each jobThe client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.Background information on the DataThe data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations. The research and analysis should be present within the answers provided on the worksheet.Now he wants you to also analyze the confidence intervals. boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present within the answers provided on the worksheet. The worksheets will be attached and there are 2 different worksheets. One for preliminary findings of basic statistics. The other is to analyze confidence intervals.