AuditTestCh9Jaycee
docx
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
(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
Please provide correct answer general accounting question
arrow_forward
Provide correct solution and accounting question
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
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars):
Sales
Operating costs (excluding depreciation)
EBITDA
Depreciation
$4,280.00
3,021.00
$1,259.00
315.00
$944.00
150.00
$ 794.00
198.50
595.50
Looking ahead to the following year, the company's CFO has assembled this information:
EBIT
Interest
EBT
Taxes (25%).
Net income
Year-end sales are expected to be 6% higher than $4.28 billion in sales generated last year.
▪ Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales.
Depreciation costs are expected to increase at the same rate as sales.
Interest costs are expected to remain unchanged.
▪ The tax rate is expected to remain at 25%.
On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers as positive values. Enter your answers in millions. For example, an
answer of $10,550,000 should be entered as 10.55. Do not round…
arrow_forward
Problem 18 (Profitability Ratios)
a. Alpha Industries had an asset turnover of 1.4 times per year. If the retum on
total assets (investment) was 8.4 percent, what was Alpha's profit margin?
b. The following year, on the same level of assets, Alpha's asset turnover
declined to 1.2 times and its profit margin was 7 percent. How did the retum
on total assets change from that of the previous year?
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
Answer? General accounting
arrow_forward
Solve this practice problem
arrow_forward
Provide answer general accounting question
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
Provide correct answer general accounting
arrow_forward
Accounting question please solve this one
arrow_forward
Need help with this question solution general accounting
arrow_forward
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars):
Sales
$4,300.00
Operating costs (excluding depreciation)
3,095.00
EBITDA
$1,205.00
Depreciation
325.00
EBIT
$880.00
Interest
160.00
EBT
$720.00
Taxes (40%)
288.00
Net income
$432.00
Looking ahead to the following year, the company's CFO has assembled this information:
Year-end sales are expected to be 6% higher than $4.3 billion in sales generated last year.
Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales.
Depreciation costs are expected to increase at the same rate as sales.
Interest costs are expected to remain unchanged.
The tax rate is expected to remain at 40%.
On the basis of this information, what will be the forecast for Edwin's year-end net income? Round your answers to two decimal places. Do not round intermediate calculations. Enter all values as positive numbers.
(in…
arrow_forward
Please provide problem with accounting question
arrow_forward
Answer this accounting problem
arrow_forward
provide solution
arrow_forward
I want to correct answer general accounting question
arrow_forward
Question
arrow_forward
Quick answer of this accounting questions
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 (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_forwardPlease provide correct answer general accounting questionarrow_forwardProvide correct solution and accounting questionarrow_forward
- Financial Accounting Question please give true answerarrow_forwardPlease solve this accounting questionarrow_forwardQuantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales Operating costs (excluding depreciation) EBITDA Depreciation $4,280.00 3,021.00 $1,259.00 315.00 $944.00 150.00 $ 794.00 198.50 595.50 Looking ahead to the following year, the company's CFO has assembled this information: EBIT Interest EBT Taxes (25%). Net income Year-end sales are expected to be 6% higher than $4.28 billion in sales generated last year. ▪ Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales. Depreciation costs are expected to increase at the same rate as sales. Interest costs are expected to remain unchanged. ▪ The tax rate is expected to remain at 25%. On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers as positive values. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round…arrow_forward
- Problem 18 (Profitability Ratios) a. Alpha Industries had an asset turnover of 1.4 times per year. If the retum on total assets (investment) was 8.4 percent, what was Alpha's profit margin? b. The following year, on the same level of assets, Alpha's asset turnover declined to 1.2 times and its profit margin was 7 percent. How did the retum on total assets change from that of the previous year?arrow_forwardHorizontal 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_forwardAnswer? General accountingarrow_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