The following financial statements are taken from the records of Sapphire Inc. a) Use horizontal analysis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following financial statements are taken from the records of Sapphire Inc. a) Use horizontal analysis techniques to compare the changes between 2023 and 2022 balance sheet items. Do not enter dollar signs or commas in the input boxes. Use the negative sign for negative values. Round all percentages to 2 decimal places. Current Assets Cash Accounts Receivable Merchandise Inventory Short-Term Investments Total Current Assets Long-Term Assets Total Assets Current Liabilities Long-Term Liabilities Total Liabilities 2023 $308,200 $319,100 $ $205,000 $163,900 $ Sapphire Inc. Balance Sheet As at April 30 2022 $384,800 $410,100 S $79,400 $92,900 S $977,400 $447,900 $986,000 $ $135.300 $315,300 S $1,425,300 $1,301,300 $ $287,800 $246,300 S $98,800 $ $423.100 $345.100 S Shareholders Equity $1,002,200 $956,200 S Total Liabilities and Equity $1,425,300 $1,301,300 S $ Change % Change 96 96 95 96 for 2025 seating all income statement items as a percentag b) Perform a vertical analysis of the income statement for 2023, stating all income statement items as a percentage of net sales. Sapphire Inc. Income Statement For the Year Ended December 31 2023 Sales Cost of Goods Sold Gross Profit Operating Expenses Advertising Expense Utilities Expense Rent Expense Depreciation Expense Interest Expense Total Expenses $684,000 Income Tax Expense $307,800 Salaries and Wages Expense $48,100 Net Income $376,200 $4,200 $8,500 $5,000 $34,900 $8,500 Income Before Income Tax $267,000 $109,200 $80,100 $136,900 196 96 %6 96 96 1% 96 96 96 96 96 96 The following financial statements are taken from the records of Sapphire Inc. a) Use horizontal analysis techniques to compare the changes between 2023 and 2022 balance sheet items. Do not enter dollar signs or commas in the input boxes. Use the negative sign for negative values. Round all percentages to 2 decimal places. Current Assets Cash Accounts Receivable Merchandise Inventory Short-Term Investments Total Current Assets Long-Term Assets Total Assets Current Liabilities Long-Term Liabilities Total Liabilities 2023 $308,200 $319,100 $ $205,000 $163,900 $ Sapphire Inc. Balance Sheet As at April 30 2022 $384,800 $410,100 S $79,400 $92,900 S $977,400 $447,900 $986,000 $ $135.300 $315,300 S $1,425,300 $1,301,300 $ $287,800 $246,300 S $98,800 $ $423.100 $345.100 S Shareholders Equity $1,002,200 $956,200 S Total Liabilities and Equity $1,425,300 $1,301,300 S $ Change % Change 96 96 95 96 for 2025 seating all income statement items as a percentag b) Perform a vertical analysis of the income statement for 2023, stating all income statement items as a percentage of net sales. Sapphire Inc. Income Statement For the Year Ended December 31 2023 Sales Cost of Goods Sold Gross Profit Operating Expenses Advertising Expense Utilities Expense Rent Expense Depreciation Expense Interest Expense Total Expenses $684,000 Income Tax Expense $307,800 Salaries and Wages Expense $48,100 Net Income $376,200 $4,200 $8,500 $5,000 $34,900 $8,500 Income Before Income Tax $267,000 $109,200 $80,100 $136,900 196 96 %6 96 96 1% 96 96 96 96 96 96
Expert Answer:
Answer rating: 100% (QA)
SAPPHIRE INC Horizontal Analysis of Balance Sheet as at April 30 showing comparison of 2023 and 2022 ... View the full answer
Related Book For
Introductory Financial Accounting for Business
ISBN: 978-1260299441
1st edition
Authors: Thomas Edmonds, Christopher Edmonds
Posted Date:
Students also viewed these accounting questions
-
The following financial statements were provided by Sumsong Electronics Company. The owner, Gillian Sumsong, is applying for a second loan from the bank to buy some new equipment. The bank manager...
-
Link BD is made of brass (E = 105 GPa) and has a cross-sectional area of 240 mm. Link CE is made of aluminum (E = 72 GPa) and has a cross-sectional area of 300 mm. Knowing that they support rigid...
-
Which of the following journal entries is recorded as a result of the bank reconciliation process to record a NSF check for $250? A. Cash 250 Accounts Receivable 250 B. Accounts Receivable 250 Petty...
-
In Exercises find the second derivative of the function. f(x) = x sin x
-
An annuity is defined as a series of payments of a fixed amount for a specific number of periods. Thus, $100 a year for 10 years is an annuity, but $100 in Year 1, $200 in Year 2, and $400 in Years 3...
-
A debt of $20 000 is repaid by making payments of $3500. If interest is 9% compounded monthly, for how long will payments have to be made? (a) At the end of every six months? (b) At the beginning of...
-
An introductory statistics instructor believes that the median number of hours that students study each week is less than 15 . He randomly sampled 20 students, asked them to disclose the number of...
-
Job costing, unit cost, ending work in process. Raymond Company produces pipes for concert- quality organs. Each job is unique. In April 2009, it completed all outstanding orders, and then, in May...
-
Find the equation of the plane tangent to f(x,y)=sin(2x + 7y) +7 at the point (7,-2)- Answer: x+ y+
-
Tony and Suzie are ready to expand Great Adventures even further in 2025. Tony believes that many groups in the community (for example, Boys and Girls Clubs, church groups, civic groups, and local...
-
You are completing a group term paper. Given the project network that follows, complete the forward and backward passes, compute activity slack, and identify the critical path. Use this information...
-
What might be a potential pitfall of preparing and maintaining a rolling budget? Explain.
-
The month of July, the client had a database outage, lose some data, what are there any issues that you would want to bring to the audit manager's attention? What assertions will be?
-
three months ago CruiseEAstern Pty Ltd, a cruise shipping business, borrowed $1 billion from the Federation Bank on security over CruiseEastern Pty Ltd's fleet of cruise ships. CruiseEastern was...
-
A company purchases its inventory from suppliers on account. During the year, its inventory account increased by $20 million and its accounts payable to suppliers decreased by $1 million. If cost of...
-
A $5,000, 8% bond redeemable at par with semi-annual coupons bought twelve years before maturity to yield 5% compounded semi-annually is sold three years before maturity at 99.5. Find the gain or...
-
Divide using long division. State the quotient, q(x), and the remainder, r(x). (6x + 5x-1)+(3x - 2)
-
Which of the following is FALSE regarding the purchasing power parity (PPP). a. The PPP is a manifestation of the law of one price b. The PPP says that a country with a higher expected inflation can...
-
Petes Pizza purchased a delivery van on January 1, Year 1, for $35,000. In addition, Petes paid sales tax and title fees of $1,500 for the van. The van is expected to have a four-year life and a...
-
What is an advantage of using the percent of receivables method of estimating uncollectible accounts expense?
-
Obtain the Target Corporations annual report at http://investors.target.com using the instructions in Appendix B, and use it to answer the following questions: a. Which accounts on Targets balance...
-
Consider a first-order system with a forcing function \(f(t)\) such that input-output differential equation is given by \[\begin{equation*}\dot{y}+3 y=f(t) \text {, } \tag{3.7}\end{equation*}\] where...
-
Find the dynamic system response for the rotational mechanical system shown below. There is a constant input angular speed, \(\omega(t)=\beta\), and zero initial angular speed, \(\omega_{1}(0)=0\)...
-
A dynamic system is described by the following State-Variable Matrix model such that: \(\dot{\mathbf{x}}=\mathbf{A x}\) and \(\mathbf{y}=\mathbf{C x}\), where (a) Obtain the State-Transition Matrix...
Study smarter with the SolutionInn App