Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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 . quired 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Operational Auditing Handbook Auditing Business And IT Processes

Authors: Andrew Chambers, Graham Rand

2nd Edition

0470744766, 978-0470744765

More Books

Students also viewed these Accounting questions

Question

Distinguish treaties from executive agreements.

Answered: 1 week ago