Horizontal analysis refers to changes in financial statement numbers across two or more years. Vertical analysis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Horizontal analysis refers to changes in financial statement numbers across two or more years. Vertical analysis refers to financial amounts for each year expressed as proportions of a base such as sales for the income statement accounts and assets for the balance sheet accounts. These analyses and other facts can assist auditors to discern relationships that raise questions about misleading financial statements. Attached is an Excel sheet with select financial statement for Inter-Galactic Services, Inc. for fiscal years 2021 and 2022. Consider the following: a. The company is a cloud service provider that offers one and two year contracts. The majority of clients pay the full contract price in advance. b. The fiscal year end is December. c. The 2021 financial statements is audited. Assume these statements contained no material error or misstatements and relationships represent historic norms. d. Prior years' performance has been flat. e. A new CEO was appointed in December 2021. f. Debt and equity capital was obtained early January 2022 and the proceeds immediately deployed to partially fund the acquisition of property plant & equipment. No principal payment on any of the company's borrowing is due until 2024. Required 1. Prepare horizontal and vertical analyses schedule in Excel. Use the provided Excel sheet. 2. Identify and explain apparent errors or misstatements in the unaudited 2022 financial statements and describe your estimate of the amount of the error or misstatement. 3. Prepare a schedule to adjust the unaudited net income for 2022. Begin with the unaudited net income and end with the revised net income. 4. Submit a properly formatted Excel document for requirement 1 and 3 and a Word document for requirement 2 to the Folio dropbox. You must use formulae for all cells in Excel that are computed and the formulae are not to be hidden. Inter-Galactic Services, Inc Assets Cash Short term investments Accounts receivable Other receivables Total current assets Property, plant & equipment Accumulated Depreciation Total assets Liabilities and equity Accounts Payable Unearned revenue - current Other liabilities Total Current Liabilities Long term loans (5% interest rate) Unearned revenue - noncurrent Total Long-term liabilities Total liabilities Capital Stock Retained earnings Total Liabilities & equity Service revenue Cost of revenue Gross profit SGA expense Depreciation expense Operating expenses Operating income Other revenue Interest expense Other income, net Income before income tax expense Income tax expense Net income Balance 2021 635,050 359,000 100,000 100,000 1,194,050 1,535,000 (614,000) 2,115,050 115,000 230,600 130,000 475,600 390,000 270,000 660,000 1,135,600 800,000 179,450 2,115,050 1,030,000 400,000 630,000 185,000 307,000 492,000 138,000 45,000 19,500 25,500 163,500 49,050 114,450 Common Size Balance 2022 1,028,050 734,000 80,000 50,000 1,892,050 2,225,000 (959,000) 3,158,050 176,000 278,600 187,000 641,600 591,000 341,000 932,000 1,573,600 1,143,000 441,450 3,158,050 1,357,000 475,000 882,000 225,000 345,000 570,000 312,000 65,000 46,000 19,000 331,000 69,000 262,000 Common Size Change Amount Percent Horizontal analysis refers to changes in financial statement numbers across two or more years. Vertical analysis refers to financial amounts for each year expressed as proportions of a base such as sales for the income statement accounts and assets for the balance sheet accounts. These analyses and other facts can assist auditors to discern relationships that raise questions about misleading financial statements. Attached is an Excel sheet with select financial statement for Inter-Galactic Services, Inc. for fiscal years 2021 and 2022. Consider the following: a. The company is a cloud service provider that offers one and two year contracts. The majority of clients pay the full contract price in advance. b. The fiscal year end is December. c. The 2021 financial statements is audited. Assume these statements contained no material error or misstatements and relationships represent historic norms. d. Prior years' performance has been flat. e. A new CEO was appointed in December 2021. f. Debt and equity capital was obtained early January 2022 and the proceeds immediately deployed to partially fund the acquisition of property plant & equipment. No principal payment on any of the company's borrowing is due until 2024. Required 1. Prepare horizontal and vertical analyses schedule in Excel. Use the provided Excel sheet. 2. Identify and explain apparent errors or misstatements in the unaudited 2022 financial statements and describe your estimate of the amount of the error or misstatement. 3. Prepare a schedule to adjust the unaudited net income for 2022. Begin with the unaudited net income and end with the revised net income. 4. Submit a properly formatted Excel document for requirement 1 and 3 and a Word document for requirement 2 to the Folio dropbox. You must use formulae for all cells in Excel that are computed and the formulae are not to be hidden. Inter-Galactic Services, Inc Assets Cash Short term investments Accounts receivable Other receivables Total current assets Property, plant & equipment Accumulated Depreciation Total assets Liabilities and equity Accounts Payable Unearned revenue - current Other liabilities Total Current Liabilities Long term loans (5% interest rate) Unearned revenue - noncurrent Total Long-term liabilities Total liabilities Capital Stock Retained earnings Total Liabilities & equity Service revenue Cost of revenue Gross profit SGA expense Depreciation expense Operating expenses Operating income Other revenue Interest expense Other income, net Income before income tax expense Income tax expense Net income Balance 2021 635,050 359,000 100,000 100,000 1,194,050 1,535,000 (614,000) 2,115,050 115,000 230,600 130,000 475,600 390,000 270,000 660,000 1,135,600 800,000 179,450 2,115,050 1,030,000 400,000 630,000 185,000 307,000 492,000 138,000 45,000 19,500 25,500 163,500 49,050 114,450 Common Size Balance 2022 1,028,050 734,000 80,000 50,000 1,892,050 2,225,000 (959,000) 3,158,050 176,000 278,600 187,000 641,600 591,000 341,000 932,000 1,573,600 1,143,000 441,450 3,158,050 1,357,000 475,000 882,000 225,000 345,000 570,000 312,000 65,000 46,000 19,000 331,000 69,000 262,000 Common Size Change Amount Percent
Expert Answer:
Answer rating: 100% (QA)
Here are the requirements in separate files 1 Horizontal and Vertical Analysis in Excel See attached ... View the full answer
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
Horizontal analysis refers to changes in financial statement numbers and ratios across two or more years. Vertical analysis refers to financial statement amounts expressed each year as proportions of...
-
Horizontal analysis refers to changes of financial statement numbers and ratios across two or more years. Vertical analysis refers to financial statement amounts expressed each year as proportions of...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
(a) Compute the primary Class 1 NICs payable by the following weekly-paid employees for the week ending 14 August 2020: (i) Employee A has earnings for the week of 110. (ii) Employee B has earnings...
-
Ronald Armstead worked for First American Bank as a courier. His duties included making deliveries between the banks branches in Washington, D.C. Armstead parked the banks station wagon near the...
-
Solve the system of equations graphically. If the system does not have a single ordered pair as a solution, state whether the system is inconsistent or dependent. x + 2y = 5 2x - 4y = 4
-
Fill in the Blank. Different orientations of finite elements require ____________ of element matrices.
-
A straddle occurs when an investor purchases both a call option and a put option. Such a strategy makes sense when the individual expects a major price movement but is uncertain as to the direction....
-
Find the minimum price associated with the lowest sales using excel such as vlookup, filter, or pivot table. price sales volume 216.70 1850 548.71 1948 5918.25 1978 103.89 1938 2090.30 1832 837.20...
-
A 95% confidence interval for the proportion of viewers of a certain reality television show who are over 30 is (0.26, 0.35). Suppose the show's producers want to test the hypothesis Ho P = 0.25...
-
Presented below are selected transactions for Werley Company for 2021. Jan. 1 Received $9,000 scrap value on retirement of machinery that was purchased on January 1, 2011. The machine cost $90,000 on...
-
In small groups, pick countries that are culturally very different from your own. Imagine that you are preparing to visit that country and need to adjust your communication style. Describe what...
-
Communication styles differ and there is no one-size-fitsall winning negotiation style. Provide examples of how different cultures establish trust when negotiating.
-
How can a cultures decision-making process (top-down, consensus, or coalition building) affect negotiations? Provide examples.
-
Historically, many companies started to look for exporting or international opportunities and markets when the domestic market was saturated. Today, however, some companies are born global, such as...
-
Assume the Fed undertakes open-market operations and buys Treasury securities. Explain what should happen to interest rates. What is the expected change in nominal GNP? How is nominal GNP then...
-
A fixed crane has a mass of 1000 kg and is used to lift a 2400-kg crate. It is held in place by a pin at A and a roller at B. The center of gravity of the crane is located at G. Determine the...
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
Describe a walk-through of a production transaction from production orders to entry in the finished goods perpetual inventory records. What document copies would be collected? What controls noted?...
-
How do risks of IT and e-commerce affect the risks of financial statement misstatements?
-
You are in charge of the audit of the financial statements of the Demot Corporation for the year ended December 31. The corporation has had the policy of investing its surplus funds in marketable...
-
Previously, we solved Laplace's equation using separation of variables for the velocity potential about a cylinder with circulation. The solution was of the form: \[\phi=c_{1}...
-
The method of images uses precisely oriented collections of sources, sinks, and vortices to establish artificial walls and so simulate more complicated flow fields. One such flow field is formed by...
-
A stream function is given by: \[\psi=\sin \left(\frac{x}{L} ight) \sinh \left(\frac{y}{K} ight)\] where \(L\) and \(K\) are constants, \(0 \leq x \leq \pi L\) and \(y \geq 0\). a. Does \(\psi\)...
Study smarter with the SolutionInn App