AuditTestCh9Jaycee
docx
keyboard_arrow_up
School
College of Southern Nevada *
*We aren’t endorsed by this school
Course
202
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by BaronCamelPerson675
Analysis 1: Income Statement (Horizontal) Report
At the beginning, there is a $33,205.50 difference between the 2022 and 2023 periods. However, in 2023, Casey Corporation suffered more losses in money, resulting in a much smaller gap by the end of the year. Sales returns and sales discounts accumulated to a $6,709.01 decrease, totaling $26,496.49, which quickly bumped to $27,091.49 due to a $595 increase in the cost of merchandise sold. Both selling and administrative expenses made a combined loss of $18,066.56, bringing the net income down to $9,024.93. A $4,568.66 decrease
from interest expenses closed the period gap further to $3,373.77. Subtracting $1,928.00 from that number due to corporate income tax brings the final total to a measly $1,445.77 change difference between 2022 and 2023.
Analysis 2: Income Statement (Vertical) Report
Based on the vertical analysis, the 2023 period was more profitable than the prior 2022 period. There is 30.55% of gross profit for 2023; a favorable change to 2022’s 28.26%. Net income after tax also declined from last year’s 8.40% to the current year’s 8.31%. This is also supported by the operating revenue increasing from 16.33% to 17.94%.
Analysis 3: Balance Sheet (Horizontal) Report
The 2023 period was more profitable than the 2022 period, with a $61,024.91 change between each period’s assets. Factors such as a $99,660 increase in accounts receivable, $68,562 decrease in merchandise inventory and the $56,216.91 increase in cash contributed to this outcome. Liabilities have also increased as well by $10,113.80. Items such as the $13,290 increase in accounts payable contributed to this total. Stockholder’s equity also increased by $50,911.11, which came from both the net income increase of $1,445.77 and a $49,465.34 increase for retained earnings.
Analysis 4: Balance Sheet (Vertical) Report
All the plant assets had lower profit in 2023 than 2022. For example, the profit for the plant asset of buildings as a percentage was 43.39% in 2023, compared to 2022’s percentage of 47.80%. But the regular assets had enough increase in income to keep 2023’s asset profit ahead
of 2022. Total liabilities in 2023 were 41.85%, which is a decrease in profit compared to last year’s 44.42%. This is balanced by stockholder’s equity, which increased from 2022’s 55.58% to 2023’s 58.15%.
Analysis 5: Ratio Analysis
EARNING PERFORMANCE ANALYSIS
Rate Earned on Average Total Assets
11.26%
Rate Earned on Average Stockholder’s Equity
19.78%
Rate Earned on Net Sales
8.31%
Earnings Per Share
$1.09
Price-Earnings Ratio
4.45 times
EFFICIENCY ANALYSIS
Accounts Receivable Turnover Ratio
7.80 times
Average Days for Payment
47 days
Merchandise Inventory Turnover Ratio
13.58 times
Average Number of Days Sales in Merch Inv.
27 days
SHORT-TERM FINANCIAL STRENGTH ANALYSIS
Working Capital
$193,932.93
Current Ratio
2.63 times
Acid Test Ratio
2.37 times
LONG-TERM FINANCIAL STRENGTH ANALYSIS
Debt Ratio
41.85%
Equity Ratio
58.15%
Equity Per Share
5.91
With both the stockholder’s equity and net sales decreasing from last year’s period, it shows the company is lacking in performance. The company does have average efficiency, since although it takes 47 days (compared to last year’s 31) to collect payment, their turnover ratio has increased to 13.58 times compared to last year’s 9.5 times. The company has great financial
strength, both short and long term, due to both a decrease in debt ratio and increase in working capital.
Analysis 6: Statement of Cash Flows
There is a net increase in $56,216.91, which came from company operations as well as a mortgage payable. Cash was primarily used to buy store and office equipment.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Horizontal analysis of income statement
(What did I do wrong? Anyone know the correct answers to the ones I got wrong?)
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$ 16,800,000
$ 15,000,000
Cost of goods sold
(11,500,000)
(10,000,000)
Gross profit
$ 5,300,000
$ 5,000,000
Selling expenses
$ (1,770,000)
$ (1,500,000)
Administrative expenses
(1,220,000)
(1,000,000)
Total operating expenses
$ (2,990,000)
$ (2,500,000)
Operating income
$ 2,310,000
$ 2,500,000
Other revenue
256,950
225,000
Income before income tax expense
$ 2,566,950
$ 2,725,000
Income tax expense
(1,413,000)
(1,500,000)
Net income
$ 1,153,950
$ 1,225,000
1. Prepare a comparative income statement with horizontal analysis for the two-year period,…
arrow_forward
Following are financial statement numbers and ratios for Martin Corp. for the year ended December 31, Year 1.
Total revenue (in millions)
$47,248
Net operating profit margin (NOPM)
8.8%
Net operating asset turnover (NOAT)
3.3
If we expected revenue growth of 3.5% in the next year, what would projected revenue be for Year 2?
Select one:
a. $47,248.0
b. $44,598.3
c. None of these are correct
d. $48,901.7
e. $53,205.0
arrow_forward
Horizontal analysis of income statement
(No incorrect answers so far most Experts today are giving me false answers)
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$ 16,800,000
$ 15,000,000
Cost of goods sold
(11,500,000)
(10,000,000)
Gross profit
$ 5,300,000
$ 5,000,000
Selling expenses
$ (1,770,000)
$ (1,500,000)
Administrative expenses
(1,220,000)
(1,000,000)
Total operating expenses
$ (2,990,000)
$ (2,500,000)
Operating income
$ 2,310,000
$ 2,500,000
Other revenue
256,950
225,000
Income before income tax expense
$ 2,566,950
$ 2,725,000
Income tax expense
(1,413,000)
(1,500,000)
Net income
$ 1,153,950
$ 1,225,000
1. Prepare a comparative income statement with horizontal analysis for the two-year…
arrow_forward
I want to correct answer general accounting question
arrow_forward
Following are financial statement numbers and ratios for Salsa Incorporated for the year ended December 31, Year 1 (in millions). NOPAT $572.7 NOA $3,460.8 Net operating profit margin (NOPM) 15.9% Net operating asset turnover (NOAT) 1.04If we expected revenue growth of 7% in the next year, what would projected revenue be for the year ended December 31, Year 2?
arrow_forward
Please provide correct answer general accounting question
arrow_forward
Provide correct solution and accounting question
arrow_forward
Financial accounting problem
arrow_forward
None
arrow_forward
Please given answer general accounting
arrow_forward
Answer ?? Financial accounting question
arrow_forward
Financial Accounting Question please give true answer
arrow_forward
Please solve this accounting question
arrow_forward
Sandhill Ltd. reported the following financial results:
Profit was $440,000 in 2023, $409,200 in 2024, and $458,304 in 2025. Calculate the horizontal percentage change from
(a) 2023 to 2024 and (b) 2024 to 2025. (c) Are the changes increases or decreases? (If amount and percentage are a
decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to O decimal places, e.g. 12%.)
(a)
2023-2024
(b) 2024-2025 $
Amount
Percentage
%
%
arrow_forward
Horizontal analysis of income statementFor 2012, McDade Company reported a decline in net income. At the endof the year, T. Burrows, the president, is presented with the followingcondensed comparative income Statement:
Instructions
1. Prepare a comparative income statement with horizontal analysis forthe two-year period, using 20Y1 as the base year. Round percentages toone decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the horizontal analysis prepared in (1).
arrow_forward
General accounting
arrow_forward
Answer? General accounting
arrow_forward
Assume the following sales data for a company:Current year$832,402 Preceding year608,082What is the percentage increase in sales from the preceding year to the current year?
a.136.89%
b.36.89%
c.73.05%
d.26.95%
The relationship of $242,729 to $104,267, expressed as a ratio, is
a.0.8
b.2.3
c.0.4
d.0.7
arrow_forward
Solve this practice problem
arrow_forward
The following data is for questions 4 to 7
MI 1ST 10lsunten
Pettijohn Inc.
The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm has nop
amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years,
MA AUOT
and the notes payable will be rolled over.
Balance Sheet (Millions of S)
Assets
Cash and securities
Accounts receivable
Inventories
Total current assets
Net plant and equipment
Total assets and stai
Liabilities and Equity level wo
Accounts payable
suzu ols eroja
Notes payable
Accruals
Total current liabilities il of bozore al
Long-term bonds
Total debt
Common stock
Retained earnings
Total common equity
Total liabilities and equity
being
Income Statement (Millions of $)
Net sales
Operating costs except depr'n
Depreciation
Earnings bef int and taxes (EBIT)
Less interest
Earnings before taxes (EBT)
Taxes
Net income
Other data:
Shares outstanding (millions)
Common dividends
Int rate on notes payable &…
arrow_forward
ss
arrow_forward
Want to this question answer general accounting
arrow_forward
Need help with this question solution general accounting
arrow_forward
Please provide problem with accounting question
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Related Questions
- Horizontal analysis of income statement (What did I do wrong? Anyone know the correct answers to the ones I got wrong?) For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $ 16,800,000 $ 15,000,000 Cost of goods sold (11,500,000) (10,000,000) Gross profit $ 5,300,000 $ 5,000,000 Selling expenses $ (1,770,000) $ (1,500,000) Administrative expenses (1,220,000) (1,000,000) Total operating expenses $ (2,990,000) $ (2,500,000) Operating income $ 2,310,000 $ 2,500,000 Other revenue 256,950 225,000 Income before income tax expense $ 2,566,950 $ 2,725,000 Income tax expense (1,413,000) (1,500,000) Net income $ 1,153,950 $ 1,225,000 1. Prepare a comparative income statement with horizontal analysis for the two-year period,…arrow_forwardFollowing are financial statement numbers and ratios for Martin Corp. for the year ended December 31, Year 1. Total revenue (in millions) $47,248 Net operating profit margin (NOPM) 8.8% Net operating asset turnover (NOAT) 3.3 If we expected revenue growth of 3.5% in the next year, what would projected revenue be for Year 2? Select one: a. $47,248.0 b. $44,598.3 c. None of these are correct d. $48,901.7 e. $53,205.0arrow_forwardHorizontal analysis of income statement (No incorrect answers so far most Experts today are giving me false answers) For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $ 16,800,000 $ 15,000,000 Cost of goods sold (11,500,000) (10,000,000) Gross profit $ 5,300,000 $ 5,000,000 Selling expenses $ (1,770,000) $ (1,500,000) Administrative expenses (1,220,000) (1,000,000) Total operating expenses $ (2,990,000) $ (2,500,000) Operating income $ 2,310,000 $ 2,500,000 Other revenue 256,950 225,000 Income before income tax expense $ 2,566,950 $ 2,725,000 Income tax expense (1,413,000) (1,500,000) Net income $ 1,153,950 $ 1,225,000 1. Prepare a comparative income statement with horizontal analysis for the two-year…arrow_forward
- I want to correct answer general accounting questionarrow_forwardFollowing are financial statement numbers and ratios for Salsa Incorporated for the year ended December 31, Year 1 (in millions). NOPAT $572.7 NOA $3,460.8 Net operating profit margin (NOPM) 15.9% Net operating asset turnover (NOAT) 1.04If we expected revenue growth of 7% in the next year, what would projected revenue be for the year ended December 31, Year 2?arrow_forwardPlease provide correct answer general accounting questionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub