Below is my assignment to show the tieout and sources

 

Below is my assignment to show the tieout and sources for each transaction. I have attached the screenshot of example on how it should look like.

Summary:

You will submit an Excel file that provides the tieout and sources for the selected/marked items in the attached file, which includes financial statements and MD&A.

Details:

(1) Create a column with the marked item within your Excel. There are 27 total questions (one post-it has 2 questions within so there is 1 less post it than total questions).

(2) Create a column (or two/more if needed) to provide the source of the disclosure. This could be, for a few examples: (A) directly from the income statement, balance sheet, or statement of cash flow (B) a calculation year over year to show an increase or decrease (C) an amount derived from using two financial statement amounts, such as cash flows less capital expenditures.

(3) You can use review notes or an additional column for text explanation. Review notes are handy and useful for highlighting an item. However to format the text, copy it and reuse it, or see it while using the spreadsheet, a separate column is likely more effective when explanatory comments are warranted

(4) If you desire, downloading the financials from Mergent into Excel on a separate tab may make the process much more efficient as you can then simply calculate within the spreadsheet. I must be able to review the formulas for grading, so if this is not utilized explanatory comments should be given for your calculations. Use tools such as trace dependents and precedents, absolute referencing, and others to make the tieout easier for you. These financials were obtained from Mergent. If you prefer better formatted financials to read than Mergent, you can find the 10K publicly available online.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

To Prepare Review your course announcements for possible information related

To Prepare Review your course announcements for possible information related to this week’s Discussion and Assignment. Identify one need of your community that you would like to address. This need could come from the interviews you conducted in Week 5, or from your research throughout the course into the cultural,

Essay

Part 1 Choose a specific health care organization that has been in existence since the 1980s (e.g., a for-profit hospital by name; nonprofit hospital by name; governmental clinic; military or VA health care facility by name; private health care clinic by name; ambulatory surgery center by name; diagnostic imaging center

As an individual, pick ONE of the Key Organizational Capabilities

   As an individual, pick ONE of the Key Organizational Capabilities to      focus on from Column 1 in the table below. Deliver project management support throughout the       organization to support team projects Next, pick a company that the Key      Organizational Capability you chose in Step 1 applies to. Amazon Determine

How social media influences the stock market? ( topic questyions)

How social media influences the stock market? ( topic questyions) cons and pros of social media influence on the stock market, and give examples how does the stock market look like in the future talk about influencers, Reddit, twitter and how they have a say and influence in the market.

The role of a Project Management Institute (PMI) Project Management

For this assignment, you will take on the role of a Project Management Institute (PMI) Project Management Certification exam instructor and complete a PowerPoint presentation. It is your responsibility to educate individuals who anticipate taking the PMI Project Management Certification exam. The tone of the presentation should be informational and

Week 1 ProjectAssignment Due March 28 at 11:59 PMTopic for

  Week 1 ProjectAssignment Due March 28 at 11:59 PMTopic for Public Health Plan Supporting Lecture: Review the following lecture: Ten Essential Services of Public Health During this course, you will be developing a research study or completing an internship. The first part of doing either of these is to

Week 4 Assignment – University Database Overview A prestigious university

 Week 4 Assignment – University DatabaseOverviewA prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and

Consider the consumer or patient perspective in your focus area.

 Consider the consumer or patient perspective in your focus area. What about family/caregiver needs? How are they/could they be engaged in design or use of informatics tools and solutions? How can data, information, and technology improve consumer/patient/family knowledge and decision-making? • There are numerous contemporary issues that must be considered

you reviewed the case of the Sample Inn. Now you

  you reviewed the case of the Sample Inn. Now you have the opportunity to analyze this case and answer several questions considering different scenarios. To answer the questions, open the report and use the three Excel programs. To complete this assignment: Download the course project document Complete the questions. With

Introduction Training and educating those within an organization who are

  Introduction Training and educating those within an organization who are responsible for implementing and working with changes in organizational policy is a critical step in ensuring that prescribed changes have their intended benefit. A leader in a health care profession must be able to apply effective leadership, management, and

Think about the articles you have been reading each week.

  Think about the articles you have been reading each week. Were there any recommendations for practice that you thought could be implemented in your clinical practice tomorrow? Next week? Next year? Provide rationale to support your response.   The post should be at least 500 words, formatted and cited in current

Book Summary 2 Please write a 3-page (minimum 800 words)

Book Summary 2 Please write a 3-page (minimum 800 words) summary on Chapter 2 of Christianity: An introduction (Christian Creeds and Beliefs). 400 words summary, 400words reflection Please do not use direct quotation of the book. *References should follow the APA 6th or APA 7th edition *Required Textbook:  McGrath, Alister E., Christianity: An Introduction. 3rd ed.; Oxford: Blackwell,

Operational Art and Design / Joint Intelligence Preparation of the

The biggest thing is using this DEEP method for each subject. Operational Art and Design / Joint Intelligence Preparation of the Operational Environment / Joint Planning Process / Mission Command, I don’t need cites, just using DEEP method for each subject Tasks: Define- To state the precise meaning of a

Biology of Humans & Correlation Implying Causation Questions Nursing Assignment Help

  Expert Solution Preview Introduction: As a medical professor, my primary responsibility is to design and conduct lectures, develop assignments and examinations, evaluate student performance, and provide timely feedback to help medical college students excel in their studies. This includes creating challenging and intellectually stimulating tasks that cover a broad

Jewish literature and civilization

Read the Book of Ruth (4 chapters) from this link: https://www.biblegateway.com/passage/?search=Ruth+1&version=CJB Consider what the reading tells us the history and culture of the period – what does it tell us about people’s beliefs, behaviors, interactions, and the ways they lived and thought about the world around them. Write an analysis

Technology made it easier for all of the mis-information

We have heard that the Russians keep trying to change the outcome of our elections by posting inaccurate information in Facebook, Instagram etc… to get people to change their vote. The President claims that there is ‘fake news’ everywhere’. Do some research and give your thoughts on all of this.

For this activity: Create a severance package for a separated

  For this activity: Create a severance package for a separated employee in a fictitious company that includes position differences, years of service, actual compensation amounts, and any additional benefits. Explain whether severance pay is taxable and why or why not. Create a chart depicting a fair and equitable timeline