Excel Assignment Financial Accounting

Follow the videos instruction to the last detail with the given data sets then submit the excel files.

Data Sets:














Apply Your Skills, Chapter 5, EA5-A2
Apply Your Skills, Chapter 6, EA6-A2
Apply Your Skills, Chapter 7, EA7-A1
Apply Your Skills, Chapter 8, EA8-A1


How do your opportunities align with the strengths you’ve identified?
Which of the threats could hinder your top two opportunities?
What information do you need to gather to mitigate the risks associated with the threats you’ve identified?



“8-3. Some analysts say that huge New York Stock Exchange IPOs from companies such as Alibaba, headquartered in China, should be illegal in the United States because under communist governments there are not sufficient safeguards in place for financial transactions. Do you agree or disagree? Why?

8-16. Show algebraically that the price-earnings ratio formula is identical to the number of shares outstanding multiplied by the stock price formula. Why are the values obtained from these two methods sometimes different?

8-23. Explain why projected financial statement analysis is considered both a ­strategy-formulation and a strategy-implementation tool.”





3 Questions Need Now Taking Exam

1.Otis, the taxpayer, has the following capital gains and losses for the year:
Short-term capital loss$1,750Short-term capital gain$1,000Long-term capital loss$2,000Long-term capital gain$4,860

What is his net short-term gain (loss)?
What is his net long-term gain (loss)?
What amount of the gain (loss) is entered on his 1040, (line 13) Capital gain or (loss) from Schedule D?

2. Edith owns farm land in western Montana. Her adjusted basis is $300,000 and the land is subject to a mortgage of $150,000. She exchanges her land for investment land in Wyoming owned by Dale. The investment land is worth $450,000. Dale assumes Edith’s mortgage on the land. What is the amount of Edith’s recognized gain or loss on the exchange and what is her adjusted basis in the land she received?

3. Claude works as a teacher during the year at the local high school. He also prepares taxes on a part-time basis. During 2019, Claude earned $84,800 from his job as a teacher. He also earned $12,000 preparing taxes from January to April 2019. He operates his tax preparation business as a sole proprietorship. Claude estimates that he will owe $2,036 more in income taxes for 2019. Explain what Claude should do so that he does not incur any underpayment penalties.

Amazon’s Financial Returns And Capital Constraints

Be sure to review the instructor mentorship video for this assignment in the gradebook and note the specific feedback provided by your instructor/mentor prior to beginning your revisions for this assignment. Review the elements from the textbook.You may also revisit the required the Adaptive Coach materials as necessary. You may review the full set of requirements for the final project in order to see how this fits into the finished report.

In order to be successful, companies must leverage their spending in ways that will add to their value and propel them in the marketplace. In this portion of your report you will use the skills and content you mastered in your Adaptive Coach this week, to analyze the business conditions and begin to create the big financial picture of how the chosen company is spending their money and managing their investments in the future value of their organization through purchases and research and development.

Include the following content in this section.

· Formulate the expected financial returns and associated risks by completing the following calculations.

o Calculate the Return on Equity (ROE) using the DuPont system.

o Calculate the Constant Growth Stock Valuation (CGSV) and compare it to the current stock price.

· Research your company’s industry and evaluate what type(s) of capital constraints your company must consider in order to be competitive in the market. Explain the appropriate financial techniques that would be used in this evaluation.

The Financial Returns and Capital Constraints

· Must be two double-spaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center.

Accrual Accounting Concepts Assignment

Before you begin writing, review, and follow these guidelines to help prepare your case study response.

Estimated Time to Completion: 1hr

Complete Case 3-1 Accrued Revenue at the end of Chapter 3 under the “Cases” section

Submitting your assignment

Please complete the assignment using a Microsoft Word document


I believe that, even though we do not have intentions to major in accounting but having an understanding of how a company operates financially is very important. Especially when we have a creer objective of reaching on a ledership role. Management accounting and Financial accounting are the major basic pillars in the accounting field and both also have similarities and differences as well.

Management accounting, also referred to as managerial accounting, is used by managers and directors to make decisions regarding the daily operations of a company. A distinguishing feature of managerial accounting is that it is not based on past performance, but on current and future trends (Manson, 2017). For example, determining how much your business should charge for a new product and analyzing much revenue a future product line is creating are both examples of business problems within the field of managerial accounting. Since business leaders constantly need to make operational decisions in a short amount of time, management accounting must rely on predicting markets and future trends.

On the other hand, Financial accounting is used to present the financial health of a company to external stakeholders. This allows the board of directors, stockholders, potential investors and financial institutions to see how the company has performed during a specific period of time in the past (Williams, 2020). These reports are filed on an annual basis. If a business is considered a publicly-traded company on the stock market, the reports must be made part of the public record. In a financial accounting course, students learn how to prepare, read and analyze financial statements.

Few differences are:

1) Financial accounting heavily used by public regulators, creditors and shareholders but on the other hand, Managerial accounting information is confidential and used largely by managers only inside the company.

2) Information in financial accounting computation follows the general accepted financial accounting norms and standards and on the other hand, Information for managerial accounting computation is guided by the managerial needs identified within a specific company.

3) Financial accountancy is legally required and expected by law but Managerial accounting is not required by any law or norm.

4) Financial accounting is encompassing, focusing on the entire organization but Managerial accounting is specific offering detailed and divided information on diverse things such as tasks, department, operations, specific activities, sales, products.


Mason, M. (2017, August 28). What are the Differences Between Financial Accounting and Management Accounting? Retrieved October 23, 2020, from https://www.bentley.edu/news/what-are-differences-between-financial-accounting-and-management-accounting

Williams, E. (2020, September). PDFelement. Retrieved October 23, 2020, from https://pdf.wondershare.com/accounting/financial-and-managerial-accounting.html

Taxation Exam

Please answer the Multiple Choice Taxation Questions. Its is in the attached word document. Thank you!



University of Phoenix Material​

Week One Self-Guided Quiz

The questions below generally follow the order of the topics as presented in the text in Chapters 1 and 2. However, you will need to read all chapters (1, 2, 25, 26) in order to get the complete picture of most of these topics as Chapters 25 and 26 and additional insight to topics found in Chapters 1 and 2 and contain original material addressed in later questions.

Write a brief response, 30-90-words, for each question below.

1. In your own words, define “Auditing.”2. Discuss the importance of “Evidence” in auditing.3. Define “Independence” and “Objectivity” as they relate to auditing.4. Audits typically consist of three phases: Planning; Fieldwork; Reporting. Describe activities that accompany each phase. 5. Distinguish between Assurance and Attestation Services.6. Describe the following types of Audits:a. Operational Auditsb. Compliance Auditsc. Financial Statement Auditsd. Informational Technology Audits (may need to go outside the text to address this)7. Discuss the following types of Auditors:a. Auditors Working for CPA Firmsb. Governmental Auditors (e.g. GAO, IRS, health inspectors)c. Internal Auditors 8. Identify the roles CPA firms play in society.9. Briefly explain Sarbanes-Oxley (SOX) and the role the Securities and Exchange Commission (SEC) plays in regulating audits.10. What is the role of the AICPA? The PCAOB? The Institute of Internal Auditors (IIA)?11. Summarize the 10 components of Generally Accepted Auditing Standards (GAAS)12. What are SAS, and for what are they used?13. True or False – CPA firms are required to engage in quality control efforts of its audits? Why or Why not?14. What is a Peer Review and how and when are they performed?15. Why does government often have different auditing and accounting standards?