Category: Accounting

GOVERNMENTAL ACCOUNTING: You can explore the Saudi initiatives towards social responsibility, such as CSR, ESG, local content, etc.
This is just a suggestions; you could do your presentation in whatever way you think is socially responsible.

complete the following cases which shows the types of disclosures of leases made by public companies, and to show the impact of capitalizing leases on the financial statements. Answer thoroughly with explanations. Tip based on grade given. No plagiarism.

Instructions
Write a research paper on the following.  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 the next. In addition, review the notes to the financial statements as these are an integral part of the financial reporting package. Evaluate the balance sheet to determine if there are large changes in the company’s assets, liabilities, or equity accounts. In addition, analyze the income statement and statement of cash flows.
2.)  At a minimum, calculate the following ratios for two years, the debt-to-equity ratio, current ratio, quick ratio, return on equity, and net profit margin. For each ratio, explain what the ratio tells you about the company. 
The research paper must have a minimum of 2-3 pages (excluding the title and reference page) and be formatted in APA 7th edition.
Your goal is to keep direct quotations to a minimum and to make sure that you do not just cut and paste material. Ensure that all your references are cited. A report with a similarity index less than 25% is acceptable for undergraduate-level work.

I have a project and need help with the Excel part. Please create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
The data is all in the excel. 
this is the full instructions for the assignment:
Using the data, calculate an estimate of gross profit on each movie 
Rank the movies from highest to lowest profitability. 
Create a pivot table to summarize and rank the profit by year. 
Create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
Is there an effect based on year of release? Explain. What may be the cause for this effect? 
Please see if everything else is right & help answer the last question (Is there an effect based on year of release? Explain. What may be the cause for this effect? )

Competency
In this project, you will demonstrate your mastery of the following competency:
Apply accounting principles and methods to a variety of financial reporting situations
Overview
It is important for a company to disclose the quantitative
information as well as the qualitative information. Transactions often
occur over the period that may not have a direct financial impact,
however, are still important to disclose to stakeholders.
Directions
For this assignment, you will choose to review the 10-K for either
The Coca-Cola Company or PepsiCo, Inc., and use that company for this
entire project. As you work through this project, you will be
considering the necessity of full disclosures.
Specifically, you must address the following rubric criteria:
Disclosure
Explain the importance of the full disclosure principle.
Provide a rationale for disclosing financial information to stakeholders in a variety of financial reporting situations.
Specific Financials of a Given Company
Use the
financials of either The Coca-Cola Company or PepsiCo, Inc. The company
you choose should be used to address the following:
Explain the disclosure requirements for related-party transactions. Include the following details in your response:
Cite the codification section applicable in your answer.
Identify the type of information that is required or important to disclose for these types of common transactions.
Explain the disclosure requirements for contingent liabilities. Include the following details in your response:
Cite the codification section applicable in your answer.
Identify the type of information that is required or important to disclose for these types of common transactions.
Explain the disclosure requirements for subsequent events. Include the following details in your response:
Cite the codification section applicable in your answer.
Identify the type of information that is required or important to disclose for these types of common transactions.
Explain the disclosure requirements for major business segments. Include the following details in your response:
Cite the codification section applicable in your answer.
Identify the type of information that is required or important to disclose for these types of common transactions.
Explain the disclosure requirements for interim reporting. Include the following details in your response:
Cite the codification section applicable in your answer.
Identify the type of information that is required or important to disclose for these types of common transactions.
Accounting Change and Error Correction
Use the financials of either The Coca-Cola Company or Pepsi Co, Inc. The company you choose should be to address the following:
Determine the impact on a company for an accounting change. Consider the following question to guide your response:
How do companies account for accounting changes? For example, if the
company changed from one GAAP method to another (e.g., LIFO to FIFO for
inventory valuation).
Determine the impact that an error correction can have on a company. Consider the following questions to guide your response:
What are the effects of errors on the financial statements?
If there was an Excel calculation error in a spreadsheet calculating
the depreciation expense for all the property, plant and equipment that
resulted in $3 million less expense, how would this be corrected?
What to Submit
Submit your project as a 3- to 5-page Microsoft Word document with
double spacing, 12-point Times New Roman font, and one-inch margins.
Sources should be cited according to APA style. WILL NEED SCHOOL LOGIN FOR LINKS>

I need my step six done on my project. Step 1-5 have already been done. I have attached the instructions and my done project for steps 1-5.

Describe the DMAIC phases and how a researcher would use them to conduct a consulting project.
RESOURCE LINKS: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC9149925/

You will complete 4 Discussions in this course. For each Discussion, you will post one
thread of at least 300 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. You
must then post 1 reply to one of your peers of at least 300 words by 11:59 p.m. (ET) on Sunday of the assigned Module: Week. For each thread, you must support your assertions with at least 3 peer-reviewed, scholarly citations (besides the possible use of the course texts and the Bible) in current APA format. Each reply must incorporate at least 1 peer-reviewed, scholarly citation (besides the possible use of the course texts and the Bible) in current APA format. Any external sources cited must have been published within the last five years. Acceptable sources include scholarly articles, the course textbooks, the Bible, etc.).
Additional Instructions
• Provide a complete academic and scholarly peer response identifying a point in the classmate’s original post and expound upon it from a suppot, refute or additive perspective. Salutory-type comments such as ‘Thanks, Sue. . ..” or “I loved your post. . .,” or, “Your sources are awesome. . .” are not included in the word count and should be omitted (cover and references are also not included in the word count).
• Paste your text directly into the message window in the Learning Management System.
• Materials submitted to fulfill requirements in one course may not be submitted in another course.
• Be sure to use current APA formatting for all elements of your main threads and replies.
• Scholarly sources must have publication dates within the past 5 years. Do not use any books other than the Bible, Yin, George et al., and Keller (if applicable).
• In-text citations are required to support your statements, points, assertions, issues, arguments, concerns, paragraph topic sentences, and statements of fact and opinion.
• NOTE: In your reply post, when using/referring to a peer’s main thread, you must cite them and include them in the Reference listing.
• Sources of information from Wikipedia, dictionaries, and encyclopedias will not be accepted.
• All parts of the assignment must be based on scholarly, academic work.
• Avoid clichés, slang, jargon, exaggerations, abbreviations, figurative language, and language that is too informal and too subjective.

Please follow the instructions in the cover sheet and make sure to avoid plagiarism. Also, use APA style for references.

The Governmental Accounting Standards Board (GASB) has established accountability as the cornerstone of financial reporting for governments. Accountability, as defined by GASB, includes budgetary and fiscal compliance. In this assignment, you will explore a local government’s Annual Comprehensive Financial Report (ACFR) for the elements of the ACFR and how those elements are incorporated by a local government.
The Annual Comprehensive Financial Report for Cary, North Carolina is assigned as the local government ACFR for use in this assignment. A PDF of the ACFR of Cary, NC has been attached as a file.  I have also provided the link to AFRC Cary NC https://www.carync.gov/home/showpublisheddocument/31907/638374880796730000
Required Instructions:
Write a 4-5 page paper in which you address the following: 
1. Analyze the local government ACFR for Cary, NC for the types of budgets the local government maintains. Provide at least three different
budget types maintained by the local government and an example of what each controls. 
2. Analyze the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provide an example of each of the three assertions you analyzed. 
3. Analyze the Budget-to-Actual reports in the local government ACFR for at least three indications of budgetary and fiscal compliance, such as significant or non-significant variances. Provide the implication for
the local government of each of the three indications. 
4. Analyze the local government ACFR for Cary, NC for at least three local government finance-related legal or contractual requirements. Provide an example of each of the three requirements. 
5. Use at least three quality sources to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment.

If you do not already have Excel installed on your computer, please download it (for free) from the UMaine IT page here: https://umaine.edu/it/microsoft-office365/ . Please do NOT do the project in Numbers or Google Sheets. I cannot open them and will not grade them. Virtually no one in the business world uses either, so get used to it.
Download the FSA Spreadsheet from its folder in Brightspace (if you’re reading this, you’re already there) and open it.
Identify which two companies you will be comparing: Enter your first and last names in the boxes as indicated (D3 and K3). Use the first letter of your first and last names to select companies from columns R-AC (First name) and AE-in the appropriate cells (D5 and K5).
Copy the financial statements from 2020 for Company 1 and paste it in Column B. To do so, highlight the cells you want to copy (Rows 9 through 31 and Rows 35 to 48 – do these separately!) and use Ctrl-C. Then select cell B9 and use Ctrl-V to Paste. (You can also right-click and select copy and paste from the popup menu)
IMPORTANT NOTE: YOU SHOULD NOT TYPE ANY NUMBERS ANYWHERE IN THIS SPREADSHEET. ALL DATA CAN EITHER BE COPIED FROM ELSEWHERE WITHIN THE SHEET OR CALCULATED USING FORMULAS. UNDER NO CIRCUMSTANCES SHOULD YOU CALCULATE SOMETHING ON YOUR CALCULATOR AND THEN TYPE THE NUMBER INTO EXCEL. IF YOU DO SO I WILL TAKE POINTS OFF!
Repeat the process for 2019 for Company 1 and for 2020 and 2019 for Company 2 (pasting the numbers into columns D, I, and K).
Do you see a bunch of ####s? If so, that just means that the numbers are too big for the cell. You can click and drag the column borders up at the top of the worksheet to make them larger! Or you can doubleclick the column’s right border up top and it will auto-size the column for you.
Create Common Size Financial Statements for both companies and both years.
Divide all Balance Sheet accounts by Total Assets. 
Divide all Income Statement accounts by Total Revenue
See the following Excel Videos for help:
Mathematical formulas: divide, subtract (Chapter 2)
How to use Absolute Cell Referencing in Excel (Chapter 10)
This will allow you to copy and paste the formula from Cell C9 to the rest of the balance sheet accounts and Cell B35 to the rest of the income statement accounts
Note that you will need a new absolute reference for each year’s financial statements. Don’t divide 2020’s Cash by 2019’s Total Assets!
Highlight your common size calculations and click the % button within the “Number” section of the top menu ribbon (Under the Home tab). This will turn all those decimals into nice pretty %s.
Calculate % Change of All Balance Sheet and Income Statement accounts for both companies. 
To calculate the change in cash, enter =(B9 – D9)/D9 into cell G9.
Copy and paste that cell’s formula into Column G for the rest of the financial statement lines for Company 1
Repeat the process for Company 2 using a similar formula.
Use that little % button here too! No ugly decimals for us!
Perform Ratio Calculations with Excel formulas for Company 1 in Cells D50 to D63. Please note that I only want ratios for a single year.
Current Ratio: Total Current Assets / Total Current Liabilities
Working Capital: Total Current Assets – Total Current Liabilities
Accounts Receivable Turnover: Revenue / Average Accounts Receivable
Use the formula B35/(AVERAGE(B10, D10))
Make sure you have two )s at the end!
Assume that all revenues were Credit Sales. That’s how business typically works.
Average Collection Period: 365 / Accounts Receivable Turnover
Use the formula = 365/B52
For funsies, type a different number into B35 and see how both AR Turnover and Average Collection Period update!
Click the undo button to return Revenue to the correct number.
Inventory Turnover: Cost of Goods Sold / Average Inventory
Adapt the formula from c. above 
Don’t forget that this is COGS, not Sales!
Days inventory Held: 365 / Inventory Turnover
Adapt the formula from d above. 
Funsies again, if you wish, followed by undo.
Debt to Assets: Total Liabilities / Total Assets
Debt to Equity: Total Liabilities / Total Equity (note that this is different than Total Assets. If your number is the same as g above, you screwed up!)
Times Interest Earned: “Operating Income” / Interest Expense
Asset Turnover: Revenue / Average Total Assets
See c. above for how to do the average
Return on Assets: Net Income / Average Total Assets
See c. above for how to do the average
Return on Equity: Net Income / Average Total Equity (note that this is different than Total Assets)
See c. above for how to do the average
Let’s make these ratios pretty! 
For the two return ratios, use that % button again.
For all the others, click on the button that looks like 00->0 to the right of the % button. This will decrease the number of decimal places shown. We don’t need more than one, so turn that 2.353672346 into 2.4!
Verify that the numbers make sense. If a company has an AR turnover of 500, that means they are collecting 100% of their receivables more than once a day. This is, obviously, dumb. We have numbers from the examples in the text and the notes. If your calculation is a factor of 10 different from those, you’re probably wrong.
Copy the formulas from Column D to column K.
Highlight cells B50 toB63 and type Ctrl-C
Click in Cell I50
Type Ctrl-V
Look! Now you don’t have to type in all those formulas again! Or even redo the formatting! Yay Excel!
Analyze the data!
For each ratio, indicate which Company (1 or 2) has a better ratio in Column N.
Note that higher is not always better. Think about what each ratio means and whether you would like that number to be higher or lower. Review the notes or the text (or the internet) if necessary. This is part of the Big Payoff of making all MBS students take ACC 201.
Be consistent! Average Collection Period is just AR Turnover divided into 365. If company 1 is better for Turnover, it’s going to be better for Average Collection Period.
Do not enter anything in cells N57 or N58. Debt to Assets and Debt to Equity, being leverage ratios, are ambiguous without deeper analysis. That is, you can’t say that one company’s ratio is better or worse, just higher or lower.