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 Questions
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
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 given answer general accounting
arrow_forward
Question: The ABC Company has forecast a sales growth rate of . Percent (see appendix) for next year.
The current financial statements are shown here:
Income Statement
sales growth rate 14.5%
Amount (Tk.)
26,000
21,000
5,000
1,350
3,650
Sales
Costs
Taxable Income
-Taxes
Net Income
1,095
2,555
Dividends
Addition to Retained Earnings
arrow_forward
See attached picture
arrow_forward
Horizontal Analysis of Income StatementFor 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensedcomparative income statement:Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y120Y2 20Y1Sales $910,000 $700,000Cost of goods sold 441,000 350,000Gross profit $469,000 $350,000Selling expenses $139,150 $115,000Administrative expenses 99,450 85,000Total operating expenses $238,600 $200,000Income from operations $230,400 $150,000Other income 65,000 50,000Income before income tax $295,400 $200,000Income tax expense 65,000 50,000Net income $230,400 $150,000Required:1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round to one decimal place. Use theminus sign to indicate a decrease in the "Difference" columns.Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2…
arrow_forward
Please solve this accounting question
arrow_forward
Main assumptions:• Sales has increased by 25% in 2017• "Cost of good sold" is 80% of sales in the income statement at all times. All other items are independent of sales.• Each current asset and acoounts payable are fractions of sales in the balance sheet. All other items are independent of sales.• Current ratio is 3, accounts receivable turnover is 2, inventory turnover is 4, accounts payable turnover 5 at all times. Turnovers are calculated with rescpect to the current period balances without averaging with pays year balances.• Throughout the year 2017:-the company raised funds through short-term debt first.- the company raised the remaining funds through 50% long-term debt and 50% equity offering (common stock).Consider the following financial statements (in millions of TL). In 2016, the company did not pay any dividends. What is the cash conversion cycle in year 2017? (1 year = 360 days)
A) 18 daysB) 198 daysC) 162 daysD) 342 daysE) other
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
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
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
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
The increase in gross profit due to increase in volume is:
arrow_forward
provide solution
arrow_forward
Following is information from Skyway Inc. for the year (in thousands).
Total annual revenue
$3,206,980
Total revenue growth rate
5.0%
Terminal revenue growth rate
2%
Net operating profit margin (NOPM)
8.2%
Net operating asset turnover (NOAT)
3.42
Projected total revenue for the following year would be:
Select one:
a. $3,469,952
b. None of these are correct
c. $3,316,659
d. $3,271,120
e. $3,367,329
arrow_forward
The following data pertain to cowl, inc. for the year ended December 31,2017
arrow_forward
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:
Instructions
Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place.
Answer
Check Figure: Sales, 12.0% increase
To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1).
PR 17-2A
Vertical analysis of incom
arrow_forward
Question
arrow_forward
Attempt in Progress
Suppose the 2022 income statement for McDonald's Corporation shows cost of goods sold $4,832.6 million and operating expenses
(including depreciation expense of $1,224.0 million) $10,649.8 million. The comparative balance sheets for the year show that
inventory decreased $5.3 million, prepaid expenses increased $42.6 million, accounts payable (inventory suppliers) increased $15.9
million, and accrued expenses payable increased $199.7 million.
Using the direct method, compute (a) cash payments to suppliers and (b) cash payments for operating expenses. (Enter answers in
millions to 1 decimal place, e.g. 527.5.)
Cash payments to suppliers
Cash payments for operating expenses
$
$
million
million
arrow_forward
Please provide correct answer general accounting
arrow_forward
ROA
arrow_forward
SENSITIVITY ANALYSIS IN FORECASTING FINANCIAL STATEMENTS
Colossal Chemical Corporation Year Ended December 31, 2011
Year Ended December 31, 2011
('000,000 omitted)
Given the base case below, calculate the independent effects of a one percent ( 1%) increase in Gross Margin, a one percent (1%) decline in
the tax rate, and a five percent (5%) increase in Sales.
Sales
Cost of goods sold
Selling, general, and administrative expenses
Depreciation
Research and development
Total cost and expenses
Operating Income
Interest expense
Interest (income)
Earnings before income taxes
Provision for income taxes
Net income.
Base Case
Amount
$2,110
1,161
528
121
84
1,894
216
34
-5
187
64
$123.00
% to Sales
100%
55%
25%
6%
4%
90%
10%
2%
0%
9%
3%
6%
1% Increase in Gross Margin
Amount.
% to Sales
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
O #DIV/0!
#DIV/0!
#DIV/0!
O #DIV/0!
#DIV/0!
$0 #DIV/0!
100%
54%
1% Decline in Tax.
Amount
% to Sales
100%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
O #DIV/0!
#DIV/0!
#DIV/0!
0 #DIV/0!…
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
- 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.0arrow_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 given answer general accountingarrow_forward
- Question: The ABC Company has forecast a sales growth rate of . Percent (see appendix) for next year. The current financial statements are shown here: Income Statement sales growth rate 14.5% Amount (Tk.) 26,000 21,000 5,000 1,350 3,650 Sales Costs Taxable Income -Taxes Net Income 1,095 2,555 Dividends Addition to Retained Earningsarrow_forwardSee attached picturearrow_forwardHorizontal Analysis of Income StatementFor 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensedcomparative income statement:Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y120Y2 20Y1Sales $910,000 $700,000Cost of goods sold 441,000 350,000Gross profit $469,000 $350,000Selling expenses $139,150 $115,000Administrative expenses 99,450 85,000Total operating expenses $238,600 $200,000Income from operations $230,400 $150,000Other income 65,000 50,000Income before income tax $295,400 $200,000Income tax expense 65,000 50,000Net income $230,400 $150,000Required:1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round to one decimal place. Use theminus sign to indicate a decrease in the "Difference" columns.Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2…arrow_forward
- Please solve this accounting questionarrow_forwardMain assumptions:• Sales has increased by 25% in 2017• "Cost of good sold" is 80% of sales in the income statement at all times. All other items are independent of sales.• Each current asset and acoounts payable are fractions of sales in the balance sheet. All other items are independent of sales.• Current ratio is 3, accounts receivable turnover is 2, inventory turnover is 4, accounts payable turnover 5 at all times. Turnovers are calculated with rescpect to the current period balances without averaging with pays year balances.• Throughout the year 2017:-the company raised funds through short-term debt first.- the company raised the remaining funds through 50% long-term debt and 50% equity offering (common stock).Consider the following financial statements (in millions of TL). In 2016, the company did not pay any dividends. What is the cash conversion cycle in year 2017? (1 year = 360 days) A) 18 daysB) 198 daysC) 162 daysD) 342 daysE) otherarrow_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
- 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_forwardSolve this practice problemarrow_forwardThe 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
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