Category: Accounting

  • Module 8 Excel 504

    Overview

    A dashboard is a collection of charts and analyses. Executive dashboards play a significant role in business intelligence. They provide vital information at a glance and a deeper understanding of an organizations current situation. Dashboards are used as a point in time, a high-level view of a business or organization.

    In this scenario, you will continue to work as a consultant trainee with the TC Ice Cream management team. The team has requested that you create a dashboard so leadership can effectively and efficiently have key insights about their sales revenue. Remember that TC Ice Cream is interested in whether specific trends are identified that can help grow its business through improved operations and sales. You are required to identify three key charts and a regression for presenting your analysis. The dashboard should depict clear insights from your analysis and findings.

    Prompt

    Specifically, you must address the following rubric criteria:

    1. Identify key charts for the dashboard.
      • Use your completed worksheets in the to complete this step.
      • Identify three charts that you created in previous modules to include in your dashboard.
    2. Create key slicers for the dashboard.
      • Use the Dashboard sheet to create the dashboard.
      • You should have three slicers for the dashboard that interact with the three charts on the dashboard sheet.
      • The slicers will enable the dashboard user to filter (slice) the data by date and flavor.
    3. Identify a key regression for the dashboard.
      • Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.
      • Identify one regression that you created in previous modules to include in your dashboard.
    4. Create a table that summarizes the regression models created in previous modules.
      • The table should show your dependent variable, independent variable(s), the linear regression formula, p values for the independent variable, and R2.
      • The table should consist of all regression models created.
      • You do not need to paste the entire output of the regression models.
    5. Create a dashboard that includes the following:
      • Three key charts identified from previous modules
      • One table that summarizes the identified regression from previous modules
      • Slicers that interact with the three key charts on the dashboard sheet
      • A header and title
    6. Create a PowerPoint Presentation to explain why you chose the identified charts and regression, including key visualizations and analysis to support your answers.
      • Using the three charts you created in the dashboard, along with the slicers, display the charts summarizing your specific division and flavors you have used throughout the modules.
      • Display the regression table and provide a high-level analysis. Which of the regression models have a greater impact on the quantity sold variable for the division and flavors used throughout the modules?

    What to Submit

    • TC Ice Cream Excel Workbook: Submit the . For this assignment, work should be completed in the Dashboard sheet. Do not remove any sheets from the workbook.
    • PowerPoint Presentation: Submit a PowerPoint presentation using the . If references are included, they should be cited in APA format. Consult the for more information on citations.

    Module Eight Excel Workbook Rubric

    Criteria Exceeds Expectations (100%) Meets Expectations (90%) Partially Meets Expectations (70%) Does Not Meet Expectations (0%) Value
    Identify: Key Charts Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Identifies key charts for the dashboard Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include identifying charts for the dashboard that provide key insights into the status of the business Does not attempt criterion 10
    Create Key Slicers Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Creates slicers for date and flavor for the dashboard Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating slicers for date and flavor Does not attempt criterion 10
    Identify: Key Regression Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Identifies a key regression for the dashboard Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include identifying a regression for the dashboard that provides key insights into the status of the business Does not attempt criterion 10
    Create Table Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Creates a table that summarizes the key regression Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating a table that summarizes the key regression Does not attempt criterion 15
    Create Dashboard Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Creates a dashboard Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating a dashboard that includes all required elements Does not attempt criterion 25
    PowerPoint Presentation: Explanation Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner Explains why the identified charts and regression were chosen Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include explaining why the identified charts and regression were chosen with greater detail and insight Does not attempt criterion 25
    Clear Communication Exceeds expectations with an intentional use of language that promotes a thorough understanding Consistently and effectively communicates in an organized way to a specific audience Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding Shows no evidence of consistent, effective, or organized communication 5
    Total: 100%
  • Accounting Question

    1. Enron & Lehman Brothers (Fraud Triangle Application)
      • Compare the motivations of Enrons executives to those of Lehman Brothers leaders using the Fraud Triangle framework. Which element (Pressure, Opportunity, or Rationalization) do you think played the biggest role in each case? Why?
    2. ZZZZ Best & Just For Feet (Auditor Responsibility)
      • Both cases involved failures by auditors. Based on auditing standards discussed in Contemporary Auditing (Knapp), identify two red flags that auditors missed in each case and explain what audit procedures could have uncovered the fraud.
    3. Bernie Madoffs Ponzi Scheme (Investor Red Flags)
      • Madoffs fraud lasted for decades despite several warning signs. Describe two financial indicators that should have raised concerns for investors and explain why they were overlooked.
    4. Golden Bear Golf (Corporate Governance & Ethics)
      • Golden Bear Golf relied on celebrity branding and investor confidence. How did weak corporate governance allow fraud to persist in this case? What changes in oversight might have prevented this fraud?


    Please answer each of the following essay questions. Responses should be 1-2 pages each with proper APA citations.

    1. Custom Fraud Scenario (Enron & Lehman Brothers Application)
      • You are a forensic accountant investigating a company suspected of using accounting gimmicks similar to Enrons mark-to-market accounting and Lehman Brothers Repo 105 transactions. Describe the specific signs you would look for in the financial statements and explain what questions you would ask management.
    2. Auditing in the Digital Age (Madoff & ZZZZ Best Comparison)
      • If Bernie Madoff and Barry Minkow (ZZZZ Best) had access to modern cryptocurrency markets and blockchain technology, how might they have altered their fraud schemes? Would todays auditors be better equipped to catch them? Why or why not?
    3. Regulatory Impacts & Preventative Measures (SOX & Post-2008 Reforms)
      • How did the Sarbanes-Oxley Act (SOX) impact financial reporting after the Enron scandal? Based on what you learned from Lehman Brothers and Just For Feet, do you think current regulations are enough to prevent future frauds? Explain why or why not.
    4. Whistleblower Dilemmas & Ethical Decision-Making (Enron & Just For Feet Application)
      • You are an internal accountant at a publicly traded company and have uncovered evidence that revenue figures are being fraudulently inflated, similar to the tactics used in Just For Feet and Enron. You are concerned that reporting this issue internally could cost you your job, and you are unsure whether regulators will take action if you go public.
      • In your response:
        • Describe the ethical considerations and risks of speaking up.
        • Identify whistleblower protection laws that could protect you.
        • Explain how the Sarbanes-Oxley Act (SOX) would impact your decision.
    5. Fraudulent Loan Collateral & Banking Risks (Golden Bear Golf & Lehman Brothers Application)
      • You are a risk manager for a major investment bank that is considering issuing a large loan to a well-known sports celebritys new business venture. After reviewing the companys financials, you notice that their revenues are primarily based on aggressive future projections and questionable asset valuationssimilar to issues in the Golden Bear Golf and Lehman Brothers cases.
      • In your response:
        • Identify the red flags that would make you hesitant to approve the loan.
        • Explain how asset overstatement and improper loan collateralization led to financial instability in Golden Bear Golf.
        • Discuss how investment banks, such as Lehman Brothers, collapsed due to risky lending and over-leveraged financial positions.
    6. Investor Trust & Fraudulent Business Models (ZZZZ Best & Bernie Madoff Application)
    • You are a fraud examiner hired to investigate an investment firm that claims to generate consistent, above-market returns, similar to Bernie Madoffs strategy. Meanwhile, another company you are investigating has built its reputation on a rapidly growing business model that depends on aggressive revenue recognition, similar to ZZZZ Best.
    • In your response:
      • Compare the red flags present in each type of fraud scheme (Ponzi vs. Phantom Revenue).
      • Explain the due diligence procedures you would use to verify the legitimacy of both companies.
      • Describe at least two fraud detection techniques that could have been used to uncover these schemes earlier
      • Reference
      • Contemporary Auditing, 12 Edition. Cengage Learning. Knapp, M.C., 2022. ISBN 9780357515402
  • Accounting Question

    Please read the questions carefully and answer them completely and clearly

    Please pay attention to the spelling rules in your answers to the questions

    Please submit it on 03/04/2026 ( 12 PM ) ( KSA TIME )

    Please do not repeat the solution with others

    Words should be 400 to 500 words

    Please list 5 references

    The answer file for the question is named : Assignment 1 – ACCT 401 – from teacher

  • Accounting Question

    Case study:The goal is to provide a detailed analysis of the case, applying fraud examination principles, Generally Accepted Auditing Standards (GAAS), and regulatory changes that resulted from the fraud.

    Report Structure & Grading Breakdown

    • Use APA format. Include a running head, title, student name, course name, instructor name, and submission date
    • Create a structured table of contents following APA guidelines.
    • Ensure page numbers align with each section
    • Introduce the fraud case you selected.
    • Explain why this case is important in the study of fraud and auditing.
    • Briefly outline the major topics covered in your paper.
    • Provide a detailed summary of the fraud case, including:
      • The company or individuals involved
      • Timeline of events
      • How the fraud was executed
      • The scale of financial damage and key stakeholders affected
    • Break down how the fraud was committed.
    • Identify the specific fraud schemes used (e.g., revenue recognition fraud, Ponzi scheme, asset misappropriation).
    • Discuss internal control weaknesses that allowed the fraud to occur
    • Explain how the fraud was uncovered.
    • Discuss which Generally Accepted Auditing Standards (GAAS) were violated or should have helped detect the fraud.
    • Describe audit procedures that could have caught the fraud earlier.
    • Identify any new laws, regulations, or business practices that were implemented due to this fraud case.
    • Discuss the impact of reforms such as:
      • Sarbanes-Oxley Act (SOX)
      • Dodd-Frank Act
      • Accounting and auditing standard changes
    • Summarize the key lessons learned from this fraud case.
    • Explain how this case impacted the accounting profession and corporate governance
    • APA-formatted reference list with a minimum of five (5) scholarly sources.
    • Sources must be peer-reviewed journals, professional auditing sources (e.g., ACFE, SEC, PCAOB), and reputable business publications.
    • Citations should be properly formatted in APA style.
    • Case 1.4. Gemstar
    • The United States prides itself on being first in a wide range of socioeconomic, scientific, and cultural top ten lists. Watching more television programming per capita than any other nation, however, is not among our most flattering claims to fame. Recent global surveys reveal that Americans spend approximately five hours per day watching the boob tubePoland ranks second in the worldwide TV viewing derby.During the 1990s, surfing the World Wide Web began rivaling TV viewing as a favorite activity of the most sedentary among us. The Internets growing popularity convinced several e-commerce companies, principal among them AOL and Yahoo!, to establish massive websites intended to serve as portals to the Internet. These Internet portals were designed to capture Internet users when they went online and then direct them to the specific entertainment, business, sports, or other sites they wanted to visit. AOL, Yahoo!, and their competitors expected to produce huge revenue streams by selling advertising on their portal websites to companies wanting to market their products and services to Internet users.Tech-savvy experts soon realized the portal concept could be applied to the rapidly evolving television medium as well. A companys determined effort to establish a new, high-tech television portal ultimately triggered a large-scale accounting fraud that imposed billions of dollars of losses on investors worldwide.

      From the Far East to the West Coast

      Che-Chuen Yuen was born in 1948 in Shanghai during the bloody civil war that rocked China following the conclusion of World War II. After the Chinese civil war ended in 1949, Mao Zedong, the leader of the Communist forces that gained control of the country, established an authoritarian central government and renamed the nation the Peoples Republic of China. The new Communist government forced business owners, professionals, and other alleged counter-revolutionaries to leave the country. Che-Chuens father, a businessman, was among those banished. The elder Yuen moved his family, including his infant son, to Hong Kong, which had been a British colony since the mid-1800s. Fifteen years later, Che-Chuen immigrated to the United States, where he assumed the name Henry.After obtaining an undergraduate degree in mathematics at the University of Wisconsin, Yuen earned a doctorate in applied mathematics at the prestigious California Institute of Technology in Pasadena, California. Yuen remained in southern California after completing his doctorate, working for 14 years as a research scientist for TRW, a large conglomerate. Because he had always been fascinated by the U.S. legal system, Yuen attended law school on a part-time basis while employed by TRW. He eventually earned a law degree from Loyola Law School near downtown Los Angeles.While working toward his doctorate at CalTech, Henry Yuen became close friends with Daniel Kwoh, a doctoral student in the universitys physics department. Like Yuen, Kwoh accepted a research position with TRW after completing his degree. In addition to having the same employer, the two friends shared a mutual interest in sports.As a young man, Yuen had aspired to become a professional soccer player. When he failed to achieve that goal, he became a martial arts expert, specializing in wing chun, a form of martial arts involving aggressive, close-range combat. After coming to the United States, Yuen became a hardcore baseball fanhis favorite team was the Boston Red Sox. Yuens full-time job at TRW and his evening law school classes frequently prevented him from watching Red Sox games televised live on the West Coast, so he would program his VCR to record those games. Too often, Yuens VCR failed to record a game, leaving him frustrated and angry. In his mind, if a research scientist with a CalTech doctorate could not successfully use a VCRs recording technology, there was something wrong with the technology.In 1988, Yuen and Kwoh teamed together to develop a simplified method for programming VCRs referred to as VCR Plus. This technology became the initial product of a small company they co-founded, Gemstar Development Corporation, which was later renamed Gemstar International Group Ltd. Gemstar produced only modest revenues during its first few years of operation, but in 1990 the companys seemingly bright future persuaded Business Week to name Yuen and Kwoh the nations best entrepreneurs. Five years later, the men took their company public, listing its stock on the NASDAQ stock exchange. In 1997, after a reported falling out between the two Gemstar founders, Kwoh left the company to become an independent venture capitalist.Gemstars revenues increased from $42 million in 1995, its first year as a public company, to $167 million in 1999. After incurring operating losses from 1995 through 1997, the company posted a profit of $39 million in 1998. The following year, the companys net income rose to $74 million.A strategic initiative implemented by Yuen during the 1990s accounted for Gemstars steadily improving operating results. That initiative involved acquiring a wide range of patents that allowed the company to gain effective control over programming and search processes vital to the broadcasting and electronic communications industries. Gemstar generated revenues by licensing its patented technologies to companies in those industries. Yuen and his subordinates closely monitored the efforts of other companies to develop technologies similar to those for which Gemstar held a patent. When Yuen discovered a potential infringement of a Gemstar patent, he would sue the offending company. Yuens legal background helped Gemstar prevail in most of those lawsuits.

      Patent Terrorist

      Henry Yuen quickly earned a reputation as a ruthless competitor because of his litigious business strategy. So ruthless, in fact, rivals began referring to him as a patent terrorist. During an interview with Business Week, a cable TV executivewho asked to remain anonymouscandidly admitted he scares the hell out of us. Yuen defended his aggressive tactics and insisted they were not improper or unethical. I am no terrorist. A terrorist is someone who breaks the law. I am only doing what the U.S. Congress and patent law allow. U.S. News and World Report referred to Yuen, who was unknown to the general public, as the Bill Gates of television.Among the first companies to provide on-screen navigation guides was United Video. During the mid-1980s, the small company based in Tulsa, Oklahoma, began marketing the Prevue Network, a scrolling on-screen programming guide, to cable TV networks. United Videos executives surprised their much larger competitors in 1999 when they orchestrated a successful takeover of TV Guide International, a company they purchased from Rupert Murdochs News Corporation. Following the takeover, Murdoch became the largest shareholder of the new company, which assumed the name TV Guide, Inc. The company rebranded its on-screen programming guide the TV Guide Network.Following the merger of United Video and TV Guide International, the new companys management team began butting heads with Henry Yuen. By this time, Gemstar controlled most patents relevant to what had become known as IPG (interactive program guide) technology. Yuen blocked every effort by TV Guide to upgrade its on-screen navigation guide. To solve this problem, Rupert Murdoch goaded TV Guide to make a hostile takeover bid for Gemstar. Murdoch and the TV Guide management team were no match for the crafty and temperamental Yuen, who forced them to sell their company to him in 2000. To take advantage of TV Guides brand name, Yuen named the newly-formed company Gemstar-TV Guide International, Inc. (GTGI).Financial analysts and other members of the investment community had high expectations for the new company. Those expectations caused GTGIs stock price to surge, creating a market capitalization of $20 billion for the company shortly after the merger. Thanks to that surging stock price, Henry Yuen became a billionaire and secured a spot in the Forbes 400, the annual compilation of the 400 richest U.S. citizens. At the age of 51, the immigrant whose family had been forced to leave China following the Communist takeover ranked among the most successful capitalists in the world and was proudly living the American dream. But Yuen wasnt satisfied with his accomplishments. According to the New York Times, he believed his companys on-screen guide would be the ultimate toll-keeper for the media [television] and told colleagues that Gemstar would someday be bigger than Microsoft.

      Post-Merger Blues

      Following the merger creating GTGI, Henry Yuen and Rupert Murdoch, the formerly fierce rivals, became the new companys largest and most influential stockholders. Yuen also served as the companys chief executive officer (CEO) and chairman of the board of directors. Gemstars former stockholders, led by Yuen, controlled 55 percent of the companys common stock, while TV Guides former stockholders, led by Murdoch, controlled the remainder.Yuen organized GTGI into three business segments. Easily the largest of these segments was the Media and Services Sector, which accounted for approximately 70 percent of the companys consolidated revenues. That division produced the bulk of its revenues from TV Guide, which at the time was the worlds largest weekly publication in terms of circulation and readership. The second business segment was the Technology and Licensing Sector, which included the former operations of Gemstar International.Following the acquisition of TV Guide International in 2000, Yuens principal strategic initiative was to use Gemstars IPG patents and TV Guides brand name to establish a product line of interactive information and navigation services for cable TV networks. This product line of services made up GTGIs third and smallest business segment, the Interactive Platform Sector. Advertising served as the principal revenue producer for this division. Yuen was convinced that over the years to come major retailers and service companies would allocate large portions of their promotional budgets to ads placed on GTGIs electronic navigation guides, most notably an overhauled, high-tech version of the TV Guide Network which reached more than 50 million households in the U.S. alone.Henry Yuen began pressuring his subordinates in late 2000 to ramp up their marketing efforts for the Interactive Platform Sector. In an email sent to Joe Kiener, GTGIs co-president, Yuen characterized a revenue forecast prepared for the Interactive Platform Sector as being completely unacceptable because it was too conservative. Yuen told Kiener the street expects some sort of explosive growth [for the division] and we cannot suffer any departure from the trend that I have laid out, or else no one will believe the synergy story we have. After adding that we are shooting for the moon, Yuen insisted any GTGI executives not committed to that goal should leave immediately before contaminating the sales force.

      Henry & Rupert: An Unhappy Marriage

      When Henry Yuen oversaw the takeover of TV Guide, he realized the newly-created company would face major challenges. Paramount among those challenges was the companys schizoid business model and the strong personalitiesincluding his ownthat would play key roles in its operations. Yuen was intent on creating a New Age, high-technology company that would eventually serve as a traffic cop for literally billions of television viewers around the world. TV Guides former executives and major stockholders, led by Rupert Murdoch, wanted to maintain and increase the revenues from the old school media empire that had revolved for decades around the TV Guide.The composition of GTGIs twelve-member board of directors exacerbated the companys split personality. Six directors were former Gemstar executives, while the remaining six directors, among them Rupert Murdoch, were former TV Guide heavyweights. The Gemstar-TV Guide merger agreement gave Yuen the right to cast the tie-breaking vote to resolve deadlocks between the two factions of the GTGI board. To counterbalance Yuens powerful position on the board, Murdoch included a stipulation in the merger agreement allowing the former TV Guide directors to dismiss Yuen as chairman of the board and CEO after five years. Yuen accepted the unusual proviso of the merger agreement on the condition that he would receive a huge severance payment if the board dismissed him.Following the merger of Gemstar and TV Guide International, Yuens preoccupation with the Interactive Platform Sector at the expense of the Media and Services Sector angered and frustrated Murdoch. The business operations embedded in the Media and Services Sector had been consistently profitable for decades due to TV Guides popularity. However, during the first two years Yuen oversaw GTGIs operations, TV Guides circulation dropped dramatically. TV Guides sharp drop in advertising revenues due to its declining circulation was the principal factor responsible for the large loss GTGI reported for fiscal 2001.By early 2002, Murdoch was pressuring Yuen to resign as GTGIs CEO. Yuen resisted that pressure. When Murdoch initiated weekly management meetings to address the companys declining health, Yuen often skipped them. When he did attend, Yuen typically refused to participate, choosing instead to carry on conversations in Cantonese with his longtime confidante, Elsie Leung, GTGIs chief financial officer (CFO). As GTGIs financial condition continued to deteriorate, Yuen became increasingly abrupt and secretive, further undercutting his ability to work with Murdoch and key company executives. Years later, his personal attorney defended Yuens management style, while admitting his interpersonal skills, a skill set so critical to top corporate executives, were subpar: I would not say of Henry that sweetness and diplomacy were his strong suit.

      Re-Re-Restatements

      In April 2002, Henry Yuen and GTGI faced a major crisis when financial analysts questioned the companys revenue recognition policies. Two suspect accounting decisions documented in GTGIs 2001 Form 10-K had kept the companys operating results for that year from being more dismal than reported. Those decisions involved $100 million of disputed licensing fees revenue and $20 million of revenue from an unusual barter transaction. The controversy ignited by those items caused several investment ratings services to downgrade GTGIs stock, which, in turn, caused the stocks price to plunge more than 40 percent in one day.In an interview a few days later with a USA Today reporter, Yuen dismissed the concern over GTGIs revenue recognition policies by pointing out that the companys auditor, KPMG, had no problem with the accounting. Another source reinforced Yuens position by noting that KPMG had blessed the companys revenue numbers. Two months later, in June 2002, Business Week revealed that Rupert Murdoch had forced Yuen to highlight the two questionable accounting decisions in GTGIs 2001 Form 10-K despite KPMG having approved them.Shortly after the release of the audit committee report, Henry Yuen resigned as CEO and was replaced by one of Rupert Murdochs top subordinates. A few weeks later, GTGI dismissed KPMG and retained Ernst & Young as its audit firm; at the same time, the company announced a planned financial restatement. In fact, GTGI would issue multiple restatements. Those restatements reduced the companys revenues for 1999-2001 by $250 million and increased the companys losses for that period by nearly $200 million.In June 2003, the SEC filed securities fraud charges against Henry Yuen and Elise Leung for misrepresenting GTGIs financial statements. The SEC also charged the company, as a separate entity, with releasing misleading financial statements. In June 2004, the SEC settled the charges pending against GTGI by fining the company $10 million and permanently enjoining it from future violations of federal securities laws. In the settlement agreement, the SEC disclosed a series of accounting gimmicks GTGI had used to distort its financial statements, each of which involved intentional misapplication of the revenue recognition principle.The methods GTGI used to inflate its operating results included recognizing revenue under expired, disputed, or non-existent contracts. The company also accelerated revenue recognized under certain long-term contracts and improperly recorded revenue for large non-monetary and barter transactions. Finally, the SEC reported that GTGI had diverted revenues earned by its other two divisions to the highly touted Interactive Platform Sector.

      Repeated Audit Failures

      The SEC issued multiple enforcement and litigation releases addressing the GTGI accounting fraud. One of those releases analyzed the repeated audit failures of KPMG, which had issued unqualified audit opinions on the companys annual financial statements during the course of the fraud. The SECs criticism of KPMG focused on three facets of the firms audits.According to the SEC, the GTGI audit engagement team should have consulted with KPMGs technical staff in the firms headquarters office when the auditors uncovered suspicious transactions recorded by the client. Such consultation would have allowed the auditors to obtain a more thorough understanding of those transactions and potentially resulted in KPMG discovering their fraudulent nature. Although KPMG had a consultation policy at the time, the SEC suggested the policy was not sufficiently rigorous.The SEC also faulted the materiality determinations made by the GTGI audit engagement team. Henry Yuens effort to embellish the Interactive Platform Sectors operating results was a key feature of the GTGI fraud. According to the SEC, the GTGI auditors should have been aware of that divisions disproportionate importance to not only Yuen but also to financial analysts and other parties tracking the companys financial performance. Because the KPMG auditors relied on conventional quantitative measures of materiality, they failed to adequately investigate the relatively nominal operating results of the Interactive Platform Sector. the KPMG auditors unreasonably determined that the [Interactive Platform Sector] revenues were immaterial to Gemstars financial statements. The KPMG auditors materiality determinations were unreasonable in that they only considered quantitative materiality (i.e., that the amount of revenue was not a large percentage of Gemstars consolidated financial results) and failed to also consider qualitative materiality (i.e., that the revenue related to business lines that were closely watched by securities analysts and had a material effect on the valuation of Gemstar stock).

      Disputed Scientific-Atlanta Revenue

      Scientific-Atlanta manufactures equipment used by Internet service providers, cable TV networks, and other telecommunications companies. Prior to the merger with TV Guide International, Gemstar had a three-year licensing agreement with Scientific-Atlanta that allowed the company to use certain patented technologies controlled by Gemstar. The agreement expired in 1999 and was not renewed. A few months later, Gemstar sued Scientific-Atlanta. The lawsuit charged Scientific-Atlanta with infringing on patented technologies that were Gemstars exclusive intellectual property.During this ongoing litigation, Gemstar continued to record licensing revenue from Scientific-Atlanta as if it still had a contractual relationship with the company. Following the 2000 merger with TV Guide, GTGIs accounting staff did the same. From early 2000 through the first quarter of fiscal 2002, GTGI recorded more than $100 million of disputed licensing revenue from Scientific-Atlanta.The SEC ruled there was no defensible basis for Gemstar/GTGI to record revenue from Scientific-Atlanta after the contract with the company had expired. The federal agency identified the following four conditions supporting its ruling. 1)GTGI did not have a current contract with Scientific-Atlanta; 2)GTGI did not receive any payments of the disputed revenues; 3)Scientific-Atlanta was insisting that it did not owe the revenues to GTGI; and, 4)any subsequent receipt of the disputed revenues by GTGI was contingent on a favorable outcome to the litigation between it and Scientific-Atlanta.Because KPMG knew or reasonably should have known of these conditions, the auditors should have contested their clients decision to record the Scientific-Atlanta revenue.

      Licensing Agreement with AOL

      In 2000, AOL paid GTGI a nonrefundable fee of $23.5 million in exchange for an eight-year license on a patented technology controlled by GTGI. The agreement between the two companies required GTGI to provide AOL with technical assistance and support over the entire eight-year term of the contract. Despite these contractual terms, GTGI management convinced the KPMG auditors that the $23.5 million fee was for transfer of the license and for 12 months of technical assistance and engineering support. The KPMG auditors unreasonably failed to exercise professional care and skepticism in reviewing the [AOL-GTGI] contract and in testing Gemstars representations regarding the purpose of the upfront nonrefundable fee. If the auditors had properly investigated the contract, they would have determined the $23.5 million fee should have been prorated for revenue recognition purposes over the contracts eight-year term.

      Improper Recording of Revenue from Barter Transaction

      In fiscal 2001, GTGI acquired intellectual property from another company, Fantasy Sports. In exchange for that property, which was supposedly worth $20.75 million, GTGI gave Fantasy Sports $750,000 cash and $20 million of future advertising credits. Fantasy Sports used these advertising credits during fiscal 2001, which produced $20 million of advertising revenue for the Interactive Platform Sector that period. The SEC faulted KPMG for not recognizing that GTGI had insufficient stand-alone IPG [Interactive Program Guide] advertising revenue to provide a basis on which to fair value the $20 million of advertising credits.

      Improper Recording of Revenue from Multiple-Element Transactions

      During 2001, GTGI engaged in large multiple-element revenue transactions with Motorola, Inc., a manufacturer of various electronic products, and the Tribune Company, a broadcasting company. In each of these transactions, Motorola and the Tribune Company purchased assets from GTGIs Media and Services Sector. GTGI executives negotiated payment terms for the transactions requiring Motorola and the Tribune Company to purchase large amounts of advertising from the Interactive Platform Sector. Collectively, those payment terms produced more than $100 million of advertising revenues for that division.GTGIs business segment disclosures in the notes to its audited financial statements did not reveal that a material portion of the Interactive Platform Sectors revenues resulted from the two multiple-element transactions. In fact, GTGI structured the Motorola and Tribune Company transactions to divert disproportionate amounts of the revenues from them to the Interactive Platform Sector and took explicit steps to conceal this fact from the public and other parties. In the case of the Tribune Company transaction, for example, a GTGI executive threatened to cancel the deal if Tribunes management insisted on complete disclosure of its terms.Similar to the Fantasy Sports transaction, the SEC criticized KPMG for not collecting sufficient competent evidence to substantiate the fair value of the advertising revenues that the Motorola and Tribune Company transactions produced for the Interactive Platform Sector. Instead, KPMG accepted managements representations that those revenues were determined on an arms length basis. The SEC also criticized KPMG for failing to persuade GTGI to disclose that a major portion of the revenues reported by the Interactive Platform Sector was attributable to multiple-element transactions.After reviewing these and similar GTGI revenue transactions audited by KPMG, the SEC ruled the firm had failed to comply with generally accepted auditing standards. This lack of compliance had been manifested in the following ways: 1)Failure to exercise professional care and skepticism, failure to obtain sufficient competent evidential matter, and over-reliance on management representations. 2)Failure to take appropriate action to correct disclosure that did not comply with GAAP and/or was not consistent with GTGIs financial statements. 3)Failure to render accurate reports.

      In June 2004, the SEC and KPMG reached an agreement to resolve the allegations that the firms GTGI audits had been deficient. KPMG agreed to pay a $10 million fine, which at the time was the largest fine ever imposed on an audit firm by the SEC. The SEC also censured KPMG and issued SEC practice suspensions of varying lengths to four of the firms GTGI auditors. Those individuals included the engagement audit partner, co-engagement audit partner, review partner, and senior audit manager for one or more of the relevant GTGI audits.In February 2006, Elsie Leung, GTGIs former CFO, agreed to pay $1.3 million to settle pending SEC charges that she had participated in the fraudulent scheme to misrepresent GTGIs financial statements. The SEC also permanently barred Leung from serving as an officer or director of a public company.After a three-year court battle that ended in March 2006, a federal judge found Henry Yuen guilty of securities fraud, falsifying GTGIs accounting records, and lying to his former companys independent auditors. The judge required Yuen to pay the victims of the accounting fraud $22.3 million and permanently barred him from serving as an officer or director of a public company. In May 2007, the SEC asked the judge to hold Yuen in contempt and jail him for not having made the mandated payment. The judge denied the SECs request and granted Yuen additional time to pay the reparations.One year later, in May 2008, a federal prosecutor filed obstruction of justice charges against Yuen for allegedly destroying documents subpoenaed by the SEC. When Yuen failed to turn himself in to be arraigned on those charges, he was declared a fugitive from justice. Federal law enforcement authorities have yet to find Yuenhe is assumed to be in hiding outside the United States.In December 2007, Macrovision Corporation purchased GTGI for $2.8 billion, which was a small fraction of the companys market value shortly after the merger with TV Guide International. Ten months later, Macrovision sold GTGIs former TV Guide division for the token amount of $1 to a private equity fundto sweeten the deal, Macrovision provided a large, low-interest loan to the buyer. By 2020, TV Guides paid circulation had dropped to fewer than 2 million subscribers, down from its high-water mark of 20 million subscribers a few decades earlier.Yuens much-hyped IPG technology never lived up to its great expectations, at least from a money-making point of view. The broadcasting and electronic communications industries have made extensive use of much of that technology. Nevertheless, legal and technical complexities have largely prevented companies holding the relevant patents from effectively monetizing their ownership interests in the IPG technology.

      Questions

      1. Do you agree with Henry Yuens assertion that a businessperson who is complying with all applicable laws and regulations is, by definition, behaving ethically? Defend your answer.2. The newly-created Interactive Platform Sector played an important role in the business model developed by Henry Yuen for his company following the merger that established GTGI. How should a major revision of an audit clients business model impact subsequent audits of the company? What responsibility do auditors have, if any, to consider the viability of new and untested business segments created by an audit client?3. The SEC criticized KPMG for relying on conventional quantitative measures in arriving at materiality judgments while ignoring important qualitative issues relevant to those judgments. When should auditors rely more heavily on quantitative measures than qualitative issues in making materiality judgments? When should auditors rely more heavily on qualitative issues than quantitative measures in making materiality judgments? Explain.4. The SEC charged KPMG with repeated audit failures in this case. Identify general conditions, specific circumstances, and other factors that are common causes of, or, at a minimum, commonly associated with audit failures. What quality control mechanisms can audit firms implement to minimize the likelihood of audit failures?5. The GTGI accounting fraud took place well before the Financial Accounting Standards Board issued Accounting Standards Update (ASU) No. 2014-9, Revenue from Contracts with Customers (Topic 606), in May 2014. Identify the core revenue recognition principle discussed in that document and the five steps organizations should follow in applying that principle. Assume now that ASU No. 2014-9 was in effect during the timeframe of the GTGI accounting fraud. Explain how GTGIs accounting for the following transactions was inconsistent with one or more of the five steps that should be invoked in applying the core revenue recognition principle: licensing agreement with Scientific-Atlanta, licensing agreement with AOL, barter transaction with Fantasy Sports, and the multiple-element transactions with Motorola and Tribune Company.

    • Reference
    • Contemporary Auditing, 12 Edition. Cengage Learning. Knapp, M.C., 2022. ISBN 9780357515402
  • 4065 ass3

    Apply the rules associated with inclusions and exclusions to an individual’s gross income and apply another set of code rules to determine a taxpayer’s AGI.

    Note: Completing a tax form requires specific steps that need to be executed in a sequence. The assessments in this course are presented in a sequence and must be completed in order. Incorrect entries in previous assessments will result in incorrect entries in future assessments. Do not complete Assessment 3 until you have submitted and received faculty feedback for Assessment 2.

    “I don’t know what to do or where to turn in this taxation matter. Somewhere there must be a book that tells all about it, where I could go to straighten it out in my mind. But I don’t know where the book is, and maybe I couldn’t read it if I found it.”

    Warren G. Harding, the 29th President of the United States, 19211923.

    About now, you may be nodding your head in agreement with President Harding’s quote about the complexity of the tax code, with its many inclusions and exclusions. What started out as a simple document, designed to raise capital to make the new nation independent from the British Empire, has evolved over the centuries and decades into a complex maze of rules and regulations.

    Nowhere is that more pronounced than in the rules for including and excluding income in the calculation of a taxpayer’s adjusted gross income (AGI) for income tax purposes. Gross income is commonly defined as the amount of a company’s or a person’s income before all reductions, except that which is specifically excluded by the Internal Revenue Code, before taking deductions or taxes into account. Since not all of an individual’s personal income is subject to taxation, one must crack open the voluminous tax codebook to discover exclusions from the tax collector’s grasp.

    Understanding the ever-changing rules for including and excluding income in the calculation of a taxpayer’s adjusted gross income (AGI) for income tax purposes is a skill that is developed through practice.

    Note: The assessments in this course are presented in a sequence and must be completed in order. In Assessments 25, you will work step-by-step toward completing a 1040 tax return and all the necessary related forms, based on a provided scenario. Do not complete Assessment 3 until you have submitted and received faculty feedback for Assessment 2. Incorrect entries in Assessment 2 affect the entries in Assessment 3.

    For this assessment, use information and publications from reading list to determine the adjusted gross income (AGI) for Jacob and Taylor Weaver, based on the provided scenario.

    The primary purpose of the Internal Revenue Service is to raise revenue for the government. However, the U.S. Congress has chosen to exempt certain income from taxation, such as scholarships, gifts, life insurance proceeds, municipal bond interest, and employee fringe benefits.

    Jacob and Taylor Weaver, ages 45 and 42 respectively, are married and are filing jointly in 2021.

    • They have three children, Ashley, age 9; Patrick, age 6; and John, age 17.
      • Social Security numbers are: Jacob, 222-33-4444; Taylor, 555-66-7777; Ashley, 888-99-1234; Patrick, 789-56-4321; John, 123-45-6789.
    • Taylor works part-time as a paralegal.
      • She earned $31,000 in 2021.
    • Income Taxes: $4,200 withheld.
    • Interest received from Local Bank: $6,575.
    • Estimated tax payments: $25,000.
      • $350 paid with their 2020 state tax return.
    • Jacob and Taylor bought their first house in 2021.
      • Home mortgage interest: $12,246.
      • Property tax: $12,230.
    • Federal income withholding: $2,350.
    • Charities: $4,500.
    • $435 to rent a moving truck.
    • $8,000 to put new siding on the house.
    • $11,600 for child care expenses ($5,800 for each child).
      • It was paid to Lil Tigers Daycare, 1115 S. Garrison St., Muncie, IN 47305 (EIN 98-7654321).
    • Taylor is a part-time student at Ball State University in Muncie.
      • She received a 1098-T indicating tuition and fees for 2021 in the amount of $6,011.
    • Health insurance for the family, through Taylor’s job, cost $7,500 for all 12 months of 2021.
      • They paid deductibles and co-payments of $2,550.

    Complete the following:

    • Read the information in the scenario below.
    • Download the appropriate forms and publications from IRS.gov.
    • Enter information from Assessment 2, Schedules C and SE, into the 1040 form.
    • Apply the rules for adjustments to adjusted gross income.
      • Enter applicable information from the scenario into the 1040 form.
      • Interpret official rules and instructions to record correct entries on the tax form.
    • Calculate the AGI for the Weavers.
    • Submit the tax form.

    By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

    • Competency 2: Analyze the basics of individual income tax return preparation.
      • Analyze official rules and instructions to correctly calculate deductible self-employment taxes.
      • Interpret official rules and instructions to record correct entries on tax forms.
      • Apply rules and instructions to correctly compute AGI for the year.
  • 4065 ass 2

    Analyze official rules and instructions to complete a Schedule C and related required tax forms, to reflect income and deductions related to self-employment as a sole proprietor.

    Note: Completing a tax form requires specific steps that need to be executed in a sequence. The assessments in this course are presented in a sequence and must be completed in order. Incorrect entries in previous assessments will result in incorrect entries in future assessments. Do not complete Assessment 2 until you have submitted and received faculty feedback for Assessment 1.

    “The government’s view of the economy could be summed up in a few short phrases: If it moves, tax it. If it keeps moving, regulate it. And if it stops moving, subsidize it.”

    Ronald Reagan.

    If an individual is searching for a tax strategy to offset his or her income from a primary job, being self-employed on the side is quite possibly one of the best options, along with being a real estate property owner or an investor. Each of these has the advantage of allowing an individual to reduce current income by any losses suffered from freelancing, renting out a property, or investing.

    However, the individual takes on additional work for the filing process. Schedule C must be completed, a task that requires an individual to know much more about the tax rules for recognizing income and maximizing expenses than many persons are willing to invest the time to research.

    The use of Schedule C is required when the individual’s business is not incorporated or formed as a partnership or limited liability company.

    Note: The assessments in this course are presented in a sequence and must be completed in order. In Assessments 25, you will work step-by-step toward completing a 1040 tax return and all the necessary related forms, based on a provided scenario. Do not complete Assessment 2 until you have submitted and received faculty feedback for Assessment 1.

    Calculating correct entries for self-employment requires significant research. For those are who self-employed, entries from self-employment tax forms are necessary to complete the 1040 form.

    For this assessment, use information and publications from reading list to research the regulations and complete the appropriate self-employment schedules, based on the provided scenario.

    Jacob Weaver is a contractor operating as a sole proprietorship (EIN 12-3456789). 2021 Gross income: $278,322.25.

    • Business expenses:
      • Fuel for equipment $64,080.00
      • Repairs and maintenance $17,342.00
      • Lubricants for Equipment $9,670.00
      • Insurance $6,500.00
      • Wages $6,300.00
      • Vehicles $1,768.00
      • Legal and Professional Expenses $1,750.00
      • Taxes and Licenses $1,412.00
      • Advertising $300.00
    • Clients owe him a total of $53,000, for work completed in 2021.
    • 2021 estimated tax payments were $25,000.
    • He is using a bedroom in his house as a home office. (Square footage of home 5,600 Office 240 sq. ft.)

    Complete the following:

    • Read the information provided in the scenario above.
    • Download the appropriate forms and publications from IRS.gov to complete this assessment.
    • Complete the entries on tax forms required for a sole proprietorship return.
    • Analyze official rules and instructions to correctly compute SE tax and SE deduction.
      • 1040sc.
      • 1040sse.
    • Determine eligible business deductions.
    • Interpret official rules and instructions to record correct entries on tax forms.
    • Submit the tax forms

    By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

    • Competency 1: Analyze the background of the federal income tax system.
      • Analyze official information to identify tax forms required for a sole proprietorship.
    • Competency 2: Analyze the basics of individual income tax return preparation.
      • Analyze official rules and instructions to determine eligible business tax credits.
      • Analyze official rules and instructions to determine eligible deductions.
      • Analyze official rules and instructions to correctly compute SE tax and SE deduction.
      • Interpret official rules and instructions to record correct entries on all tax forms.
  • 4065 ass 1

    Analyze official rules and instructions to determine an individual’s tax liability and complete a basic tax return.

    Note: Completing a tax return requires specific steps that need to be executed in a sequence. The assessments in this course are presented in a sequence and must be completed in order. Incorrect entries in this assessment will result in incorrect entries in future assessments. Do not complete Assessment 2 until you have submitted and received faculty feedback for Assessment 1.

    Using an official primary source to obtain answers to tax questions is an essential academic skill and step toward financial literacy. In this assessment you will consult the primary sources available to all citizens from the IRS to identify rules such as the age limit of a dependent child, the amount of earnings that trigger a filing requirement, and whether or not tax software is necessary to purchase for every return.

    Note: The assessments in this course are presented in a sequence and must be completed in order. Do not proceed to Assessment 2 until you have submitted and received faculty feedback for Assessment 1.

    This assessment has two parts.

    • Part 1: Submit a Word document in which you analyze official rules and instructions to determine an individual’s tax liability.
    • Part 2: Submit a completed basic tax form.

    Read the following scenario before beginning the assessment. Then complete the two parts below.

    Your relatives, Jacob and Taylor Weaver, have asked for your help in completing their tax return because they know you took an income tax course at Capella. You caution them that while you plan on eventually becoming an accountant, you are no expert. You agree to informally assist them with basic information gleaned from the IRS Web site. At least you know how to find information.
    John Weaver, Jacob and Taylor’s son, is a 17-year-old high school graduate, lives at home, and works part-time at a service station, saving money for college. In 2021, he earned $5,242.00, as reported on his W-2 form. Federal taxes withheld were $940; state taxes withheld were $179.
    He does not know his filing status, or if he even has to file a tax return. He is covered by his parents’ health insurance. His father thinks he can claim John as a dependent. John has no other income. John’s Social Security number is 123-45-6789. His address is 1234 Happy Lane, Happytown, MN 50000.

    Part 1: Provide evidence of requirements for John’s tax return from an official primary resource.

    Use reading list tools to find answers to the following tax questions. Copy and paste answers to these questions from the IRS resources into a Word document for submission.

    • What is John’s filing status?
    • Is John required to file a tax return? Determine requirements for mandatory filing of a return.
    • Is John a dependent?
    • What is the simplest tax form to use for John? Use information from an official primary source to select a tax form.
    • How much would John have to pay to file his return electronically?

    Part 2: Complete John’s tax return.

    • Download the most appropriate form from IRS.gov and complete a tax return for John. Show all calculations in the Word document.
      • Analyze official rules, instructions, and tax tables to determine the tax owed.
      • Analyze official rules, instructions, and tax tables to determine the amount of a refund.

    By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

    • Competency 1: Analyze the background of the federal income tax system.
      • Provide evidence of requirements for a tax return from an official primary source.
      • Determine whether filing a return is mandatory for a scenario.
      • Determine filing status.
      • Determine filing cost for an e-return.
    • Competency 2: Analyze the basics of individual income tax return preparation.
      • Analyze official rules, instructions, and tax tables to determine the tax owed.
      • Analyze official rules, instructions, and tax tables to determine the amount of a refund.
    • Competency 4: Communicate in a manner that is professional and consistent with expectations for members of the business professions.
      • Communicate in a manner that is professional and consistent with expectations for members of the business professions.
  • Complete the financials

    This assignment is for a venture project in which we created a corporation that collects colostrum from farms, processes it, gives farmers back 30% of the powder, and sells the remaining 70% or keeps it as inventory. The sheet contains the company’s financials for 3 years. We estimated costs and estimated how much would be inventory, how much would be sold each year. Please complete them, correct what needs correcting, and balance them. Also, please do a short write-up/summary for each year. thank you

  • Please complete the financials and do a short summary write…

    This assignment is for a venture project in which we created a corporation that collects colostrum from farms, processes it, gives farmers back 30% of the powder, and sells the remaining 70% or keeps it as inventory. The sheet contains the company’s financials for 3 years. We estimated costs and estimated how much would be inventory, how much would be sold each year. Please complete them, correct what needs correcting, and balance them. Also, please do a short write-up/summary for each year. thank you

  • week 12 accountig

    Requirements:

    Writing, using software, and interpreting results is a large part of your learning experience. These assignments are designed to improve your use of technology and communication skills. Ensure that you are utilizing features from applicable business software to supplement your project, such as the use of an embedded table, graph or other useful aids.

    Using proper business English and resources from the library or other scholarly sources you will comment and share your research with your classmates. Make sure you note your sources in proper APA format.

    Grading Rubric: Please refer to the grading rubric specific requirements. Each week may be different.

    Managerial Accounting Writing Assignment: Break-Even Analysis

    Assignment Overview

    This assignment integrates quantitative analysis and managerial interpretation. You will complete a break-even analysis and then evaluate its implications for business decision-making.

    Scenario

    You are serving as a managerial accountant for Precision Auto Key Services, a mobile automotive locksmith business specializing in high-end key replacement.

    The owner wants to determine how many jobs must be completed monthly to cover costs and begin generating profit.

    Given Data

    • Fixed Costs (monthly): $6,000
    • Average Revenue per Job: $250
    • Variable Cost per Job: $90

    Page 1: Break-Even Analysis (Required Calculations)

    Complete the following calculations and show all work clearly:

    1. Contribution Margin per Job
    2. Break-Even Point in Units (Number of Jobs)
    3. Break-Even Point in Sales Dollars

    You may present this section in a clean, structured format (tables or step-by-step calculations are encouraged).

    Pages 23: Written Analysis (2 Pages, Double-Spaced)

    Using your calculations, write a 2-page analysis addressing the following:

    1. Interpretation of Break-Even Results

    • What is the break-even point, and what does it mean for the business?
    • Is this level of activity realistic based on the business model?

    2. Cost Structure Insight

    • Explain the relationship between fixed and variable costs
    • How would changes in costs impact the break-even point?

    3. Pricing and Profitability

    • Assess whether the current price of $250 per job is appropriate
    • Explain how price changes would affect profitability and risk

    4. Managerial Recommendations

    • Provide at least two recommendations to improve profitability or reduce risk

    5. Assumptions and Limitations

    • Identify two assumptions of break-even analysis
    • Briefly explain how real-world factors could affect accuracy

    Formatting Requirements

    • Total Length:
    • Page 1: Calculations
    • Pages 23: Written analysis (2 full pages)
    • Double-spaced (written portion only)
    • Include a brief introduction and conclusion in the written section