Our Services

Get 15% Discount on your First Order

The total amount is for ALL 3 PARTS!!! Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data First, access the

January 18, 2025

The total amount is for ALL 3 PARTS!!!

Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data

First, access the following database: U.S. Department of Interior Natural Resources Revenue

Next, download the file named: Fiscal year revenue, 2004 – 2023 (csv, 4MB)

Open the document in Excel (or Google Sheets) and perform the following tasks to analyze revenue trends and identify outliers in the data:

Sort the document by State. Which 2 states produce the most revenue? How do you interpret the amounts that are marked as zero?
Sort the document by Revenue Type. What are the top 2 revenue types in terms of revenue amount (Column L)?
Use the Filter tool to filter the data for New Mexico, North Dakota, and Wyoming, individually. Which state would you focus on in terms of unexpectedly large revenue increases between 2020 and 2021?
Filter the sheet by the two largest revenue-producing states and product type: oil. Save a copy of this view or a screenshot to include in your deliverable.
Shift your attention by searching for unusual or outlier observations. Filter the data to identify the two largest oil-producing counties in New Mexico.
Within these two counties, locate the ten smallest (ex. negative amounts) and the ten largest revenue amounts, filtering the revenue into bonuses, other, rents, and royalties. Save a copy of each view to include in your deliverable.
Write a brief 1-page memo to your audit senior explaining your data search, your thoughts on what you observed, and which revenue transactions need further evidence gathering based on their valuation.

Your deliverable will consist of 3 parts:

Part 1: Answering the questions from Steps 1, 2, and 3.Part 2: PDF copies or screenshots from Steps 4 and 6.Part 3: A 1-page memo as outlined in Step 6. Be sure to use complete sentences, be clear and concise in how you write, and have a clear introduction and conclusion.

Your deliverable should conform to APA guidelines

Accounting

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

MGMT 315 Marketing Campaign AssignmentI would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that

MGMT 315 Marketing Campaign AssignmentI would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to what the company sells and who you are trying to reach, your campaign should target that audience. Think

I would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to

I would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to what the company sells and who you are trying to reach, your campaign should target that audience. Think of yourself as a

Hello, I need help with the response to 2 peers on a discussion: When responding to your peers, acknowledge a statement that resonates with you in their

Hello, I need help with the response to 2 peers on a discussion: When responding to your peers, acknowledge a statement that resonates with you in their personal experience and ask a question about their approach. Peer 1 The actional best practice I chose to help promote diversity and equity

Hello I need help with a project: 4-2 Project One Milestone Two Guidelines and Rubric ACC 330 Project One Milestone Two Guidelines and Rubric Overview Tax

Hello I need help with a project: 4-2 Project One Milestone Two Guidelines and Rubric ACC 330 Project One Milestone Two Guidelines and Rubric Overview Tax organizers are used to help perform due diligence and provide an opportunity for tax planning. They assist in organizing the information provided by the

Hello, I need help with a discussion post: 4-1 Discussion: Etiquette of Business Communications Read the article linked below, which lists and describes

Hello, I need help with a discussion post: 4-1 Discussion: Etiquette of Business Communications Read the article linked below, which lists and describes actionable best practices to improve equity and inclusivity in the workplace. Discuss your personal experience with business communication and discuss possible ways to approach communicating in different

Account Excel 3. You will use the completed file from Accounting Excel 2. Complete requirements 11 through 12 of the Jane’s Skateboards case for the third

Account Excel 3. You will use the completed file from Accounting Excel 2. Complete requirements 11 through 12 of the Jane’s Skateboards case for the third milestone of the course project. Use the file you completed in milestone two.

Accounting Excel 2. You will use the completed file first from the previous assignment. Complete requirements 4 through 10 of the Jane’s Skateboards for

Accounting Excel 2. You will use the completed file first from the previous assignment. Complete requirements 4 through 10 of the Jane’s Skateboards for the second milestone of the course project. You will use the file you completed in milestone one. Make sure you updated the file if you received feedback

Instructions Complete the Budget in a Service Company (Cash Budget) assignment. Please use the template provided below. The document must have

Instructions Complete the Budget in a Service Company (Cash Budget) assignment.   Please use the template provided below. The document must have the complete budget and show the entire process along with an explanation. Add a brief explanation of the budget just like what you should do if you were in

InstructionsWrite a research paper. The assignment has two requirements: 1.) Select a publicly-traded company that is traded on U.S. exchange. Locate the a

InstructionsWrite a research paper. The assignment has two requirements: 1.) Select a publicly-traded company that is traded on U.S. exchange. Locate the annual report for at least the last three fiscal years.Analyze the financial statements for the company and review for large movements in specific accounts from one year to

Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor

Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor of Commerce in International Business MODULE Financial Planning and Control YEAR 3 (Three) INTAKE January 2024 Semester 1 Marks 30 Answer ALL questions. [30 MARKS] Read the following case

Hello, I need help with homework: Assume the taxpayer does NOT wish to contribute to the Presidential Election Fund, unless otherwise stated in the

Hello, I need help with homework: Assume the taxpayer does NOT wish to contribute to the Presidential Election Fund, unless otherwise stated in the problem. In addition, the taxpayers did NOT receive, sell, send, exchange, or otherwise acquire any financial interest in any virtual currency during the year. Married taxpayers

Description A.M. Vegas started a business called Blazinsevens. The following is the Trial Balance as of December 31 on the first year of operations. Using

Description A.M. Vegas started a business called Blazinsevens. The following is the Trial Balance as of December 31 on the first year of operations. Using this information, please complete the remainder of the attached worksheet. Office supplies inventory as of December 31, $190. Unexpired insurance as of December 31, $700 Depreciation of

Hello, I need help with assignment: Module Three Assignment Guidelines and Rubric ACC 330 Module Three Assignment Guidelines and Rubric Overview Due

Hello, I need help with assignment: Module Three Assignment Guidelines and Rubric ACC 330 Module Three Assignment Guidelines and Rubric Overview Due diligence is the responsibility of a paid tax preparer. The Internal Revenue Service (IRS) created Form 8867 Paid Preparer’s Due Diligence Checklist for paid tax preparers to certify,

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each year the Internal Revenue Service (IRS) updates the tax code and makes changes to standard documentation. Tax professionals can see sweeping changes over their career.

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a foreign currency such as the Mexican peso or the Indian rupee instead of investing it in the U.S. In April 2024, the latest central bank interest

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income are critical for arriving at

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income is critical for arriving at the adjusted gross income (AGI).

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing portions or all their income through strategies such as altering financial information, falsifying revenue documents, or keeping relevant information from their tax advisor.