Category: Accounting

I need questions 3 done (The final tab) it involves cross examining two lists. This is an audit class so these questions must be answered from an audit perspective and you might need to use excel formulas

there are comments, instructions, and areas where (CITE) are highlighted. These all need to be updated and changed. Also need all paragraphs to make sense. Cites within 3 years

there are comments, instructions, and areas where (CITE) are highlighted. These all need to be updated and changed. Also need all paragraphs to make sense. Cites within 3 years

Chapter 21 discusses the theory and practice behind the preparation of a statement of cash flows; however, it’s also critical that we learn how analysts examine and interpret the statement of cash flows to assess a company’s performance and condition. Please discuss the following:
What do the results of the three classifications of cash flows reveal about a company?
Operating (suggested topics of discussion below):
Positive or negative operating cash flow.
Development/growth of a company.
Unprofitable operations.
Ability to meet short term financial obligations.
Investing (suggested topics of discussion below):
Heavy investing for future growth.
Performance of existing investments.
Financing
Which financial ratios can be derived from the state of cash flows and what do they reveal about a company?
Please discuss any other methods of analyzing a statement of cash flows to assess a company’s performance and health.

As a manager, you will be required to understand and draw conclusions based on enterprise data. This unit’s application exercise uses data from a simpler CRM system. The CRM data is available for you in two different formats: Excel and Microsoft Access. Please feel free to use any one of these formats. These files contain data on the following:
Customer data including name, address, emails, phone numbers etc.
Customer demographics data
Customer call data
Customer sales data via different channels: web sales, telephone sales, field sales retail sales
Data on advertisements directed towards the customers
PART A:
Using this data, you can address questions such as the following:
Is there a relationship between the income ranges of customers (consider four income ranges: 0-25K, 25-50K, 51-75K, 76-100K, 100+K) and the total purchases made by customers? In the Excel file, these income ranges are already codes as income levels 1, 2, 3, 4, and 5. Depict this as a chart.
Is there a relationship between the race of customers and the total purchases made by customers? Depict this as a chart.
What is the distribution of total sale amounts into field sales, web sales, retail sales, and telephone sales? What are the percentages? Based on the data, what conclusions do you draw in terms of the type of sales you should focus on?
Compare the total customer purchases made by different genders in the categories of field sales, web sales, retail sales, and telephone sales? Are there trends based on gender in terms of these sales?
What are the total number of customer service calls by each gender? What are the percentages?
The original data was distributed among different worksheets in the Excel file. I combined the data into single Excel file for your convenience. You may not be able to find answers to the above questions using a single pivot table (or a single query). It is fine to use multiple pivot tables (or multiple queries in Microsoft Access) to find answers to these questions. Any methods you use to analyze the data is fine.
For this part (Part A), you are expected to complete this assignment in Microsoft Excel or Microsoft Access. Also, submit a Microsoft Word document with your answers to the five questions above.
PART B:
Follow the steps below.
Review the practice work on the level of detail calculations at this course page.
Download the online retail data file. ((Source: This file is adapted from the data set UCI Machine Learning Repository: https://archive.ics.uci.edu/ml/index.phpLinks to an external site.)
Using Tableau, connect to the online retail data file. Create a calculated field called “Sale Amount” using the following formula:
[Unit Price] * [Quantity]
Create a calculated field called “ValuedCustomer” using the formula (a customer is a valued customer if the total sale amount is above $5000): {FIXED[Customer ID] : SUM([Sale Amount])} > 5000
Create a new worksheet called “Valued Customer 1”. Show “Customer ID”, “ValuedCustomer” as rows on this sheet and SUM(Sale Amount) as columns.
Create a new worksheet called “Valued Customer 2”. Show “Customer ID”, “Year(Invoice Date)”, “ValuedCustomer” as rows on this sheet and SUM(Sale Amount) as columns.
For the remaining steps below, refer to the attached annotated PowerPoint file which depicts how the visualizations should look like. (This PowerPoint file is produced from the Tableau visualizations and each PPT slide is annotated with hints/directions on how to create the visualization.)
Create a new worksheet called “# Valued Customers by Country”. Use Country as row, “ValuedCustomer” and CNTD(Customer ID) as columns. Refer to slide 1 of the above PPT file.
Create a new calculated field called “Orders by Customers” with the following calculation: {INCLUDE [Customer ID] : COUNTD( [Invoice No])}. Create a new worksheet called “Sum of Orders by Customer by Country”. Drag and drop country to the details area of Marks. Drag and drop “Orders by Customers” into the “Color” area of Marks. This should show “Orders by Customers” using SUM function. Refer to slide 2 of the above PPT file.
Create a new worksheet called “Ave # of Orders by Customer by Country”. This is similar to step 7, except that use AVE function instead of SUM. Refer to slide 3 of the above PPT file.
Create a new worksheet called “Total Sale Amount by Country”. Use Country as row, “SUM(Sale Amount)” as columns. Refer to slide 4 of the above PPT file.
Create a new worksheet called “Avg Sale Amount by Country”. Use Country as row, “AVG(Sale Amount)” as columns. Refer to slide 5 of the above PPT file.
Create a new worksheet called “Avg. Sale Amount by Country by Year”. Use Country as row, “YEAR(Invoice Date)” as columns, and “AVG(Sale Amount)” as columns. Refer to slide 6 of the above PPT file.
Create a new calculated field “Avg Sale Amount Exclude Invoice Date” using the formula below:
{EXCLUDE [Invoice Date] : AVG([Sale Amount])}
Create a new calculated field “DiffBetweenSaleAmtAvgSaleAmt” using the formula below:
AVG([Sale Amount])-AVG([Avg Sale Amount Exclude Invoice Date])
Create a new worksheet called “Average Sale Amount by Country by Year II”. Use Country as row, “YEAR(Invoice Date)” as columns, and “AVG(Sale Amount)” as columns. Drag and drop “Avg Sale Amount Exclude Invoice Date” as columns. Drag and drop “DiffBetweenSaleAmtAvgSaleAmt” as columns. Refer to slide 7 of the above PPT file.
For this part (Part B), export your work into one file, Tableau packaged workbook file (.twbx file), and submit the .twbx file.
Instructions:
You need to submit the following:
(1) For part (A), you need to submit the Microsoft Excel or Microsoft Access files and a Microsoft Word document with your answers to the five questions.
(2) For part (B), you need to submit one .twbx file with all your work

summarize a journal paper for google scholar website related to managerial accounting
i have uploaded the guideline on how to summarize the journal paper and an example from a student

In your report to upper management, analyze the company’s financial statements for 20Y7 and 20Y8:
Discuss the purpose of the report and the role of accounting in business.
What are the two major objectives of accounting and how are they achieved?
What kind of information do these financial statements provide to internal stakeholders, such as organizational leaders within the company, and to external stakeholders, such as lenders and current or potential investors?
How do internal and external stakeholders use financial accounting information?
Prepare a liquidity analysis by computing and using the appropriate ratios to assess liquidity.
Compute a minimum of three liquidity ratios for the years ended Dec 31, 20Y8 and Dec. 31, 20Y7 and show your supporting calculations. Use the same three liquidity ratios for both years.
Analyze the ratios computed and discuss any insights or conclusions that can be drawn from your analysis.
Prepare a solvency analysis by computing and using the appropriate ratios to assess solvency.
Compute a minimum of three solvency ratios for the years ended Dec 31, 20Y8 and Dec. 31, 20Y7 and show your supporting calculations. Use the same three solvency ratios for both years.
Analyze the ratios computed and discuss any insights or conclusions that can be drawn from your analysis.
Prepare a profitability analysis by computing and using the appropriate ratios to assess profitability.
Compute a minimum of three profitability ratios for the years ended Dec 31, 20Y8 and Dec. 31, 20Y7 and show your supporting calculations. Use the same three profitability ratios for both years.
Analyze the ratios computed and discuss any insights or conclusions that can be drawn from your analysis.
Draft a summary of what the financial statements indicate about the company’s overall financial health and performance, strengths and weaknesses of the company, as well as any identified positive or negative trends and the risk of investing in the company.
The Financial Statement Analysis final paper
must be 3 to 5 double-spaced pages in length (not including title and references pages) and formatted according to APA Style as outlined in the Writing Center’s APA Formatting for Microsoft Word resource.
must include a separate title page with the following in title case:
title of final paper in bold font
Space should appear between the title and the rest of the information on the title page.
student’s name
name of institution (The University of Arizona Global Campus)
course name and number
instructor’s name
due date
must utilize academic voice. Review the Academic Voice resource for additional guidance.
must include an introduction and conclusion paragraph.
Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & Conclusions and Writing a Thesis Statement, refer to the Writing Center resources.
must use APA Level Headings, found on the Writing Center’s APA Style Elements page, for each one of the topics discussed in the research paper as shown:
Introduction Level 1
Liquidity Analysis Level 1
Solvency Analysis Level 1
Profitability Analysis Level 1
Summary and Conclusion Level 1
must use at least four scholarly and/or credible sources in addition to the course text.
The Scholarly, Peer-Reviewed, and Other Credible Sources table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source.
To assist you in completing the research required for this assignment, review the Quick and Easy Library Research tutorial, which introduces the University of Arizona Global Campus Library and the research process, and provides some library search tips.
To assist you in completing the research for this assignment, review Company Research in the UAGC Library tip sheet and How to Use Library OneSearch video.
must document any information used from sources in APA Style as outlined in the Writing Center’s APA: Citing Within Your Paper guide.
must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.
Review the APA: Formatting Your References List resource in the Writing Center for specifications.

Another inventory valuation method is the lower-of-cost-or-market. What inventory methodology is allowed to use this and what are some major variances to the lower-of-cost-or-net realizable value?

Another inventory valuation method is the lower-of-cost-or-market. What inventory methodology is allowed to use this and what are some major variances to the lower-of-cost-or-net realizable value?

In-class Exercise
The Wellington Company issued 9% bonds, dated January 1, with a face amount of $70 million on January 1, year 1.
The bonds mature on December 31, year 10. For bonds of similar risk and maturity, the market yield is 10%, Interest is paid semiannually on June 30 and December 31.
Required:
year 1.
1. Determine the price of the bonds at January 1,
2. Prepare the journal entry to record their issuance by The Wellington Company on January 1, year 1.
3. Prepare the journal entry to record interest on June 30, year 1 (at the effective rate).
4. Prepare the journal entry to record interest on December 31, year 1 (at the effective rate.
See attached picture with the problem