Extra Practice for Financial Statement Analysis_2023
.docx
keyboard_arrow_up
School
Brigham Young University *
*We aren’t endorsed by this school
Course
310
Subject
Accounting
Date
Jan 9, 2024
Type
docx
Pages
4
Uploaded by GeneralChinchillaMaster161
Extra Practice for Financial Statement Analysis
PRACTICE PROBLEM SET #1 – COMMON-SIZING
1. Review the common-size balance sheets (all line items were divided by total assets
) below. Identify which is: Facebook, Whirlpool, United/Continental Airlines, Krogers.
Company
1
Company
2
Company
3
Company
4
Cash
1%
4%
16%
62%
A/R
19%
4%
4%
9%
Inventories
19%
22%
1%
0%
Other current assets
8%
2%
4%
2%
Total current assets
47%
32%
25%
73%
PP&E
23%
56%
47%
23%
Other noncurrent assets
30%
12%
28%
4%
Total Assets
100%
100%
100%
100%
A/P
23%
18%
4%
1%
Other current liabilities
19%
21%
29%
13%
Total current liabilities
42%
39%
33%
14%
Long-term debt
12%
29%
31%
6%
Other noncurrent liabilities
60%
49%
57%
2%
Total Liabilities
72%
78%
88%
23%
Shareholders' equity
28%
22%
12%
77%
Total liab. and equity
100%
100%
100%
100%
2. Review the common-size income statements below (
all line items were divided by total sales
). Identify which is: Facebook, Whirlpool, United/Continental Airlines, Krogers.
Compan
y 1
Compan
y 2
Compan
y 3
Compan
y 4
Sales
100%
100%
100%
100%
COGS
N/A
N/A
82%
77%
Gross profit
N/A
N/A
18%
23%
SG&A
6%
35%
9%
18%
Depreciatio
n and amortizatio
n
5%
9%
3%
2%
Other
86%
10%
2%
1%
Pretax income
3%
46%
4%
3%
Taxes
1%
19%
1%
1%
Net income
2%
27%
3%
2%
PRACTICE PROBLEM SET #2 – Ratios
3. Ratios practice
Use the following information from the Philip Company to answer the following questions about 2023.
2023
2022
Current assets
$ 34,000
33,000
Total assets
130,000
150,000
Current liabilities
25,000
35,000
Total liabilities
45,000
60,000
Stockholders’ equity
85,000
95,000
Sales
550,000
600,000
Net income
35,000
40,000
4. What is Phillips Sales Growth?
5. What is ROA for 2023?
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
O
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
Accounts Receivable
Inventory
Total Assets
Dec. 31, 2022 Dec. 31, 2021
460,000
780,000
3,164,000
Example:
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).
400,000
650,000
2,800,000
Accounts Receivable
30000
÷
•1•
500000
6.0
%
olo
%
010
arrow_forward
Problem 3-8 Financial Statements (LO1)
Henry Josstick has just started his first accounting course and has prepared the following balance sheet and income statement for
Omega Corp. Unfortunately, although the data for the individual items are correct, he is very confused as to whether an item should go
in the balance sheet or income statement and whether it is an asset or liability.
BALANCE SHEET
$ 35
Payables
Less accumulated depreciation
Inventories
$50
120
Receivables
35
Total current assets
Total current liabilities
Interest expense
$ 25
Long-term debt
Property, plant, and equipment
$350
520
Total liabilities
Net fixed assets
Shareholders' equity
$90
Total liabilities and
Total assets
shareholders' equity
INCOME STATEMENT
Net sales
$700
Cost of goods sold
Selling, general, and administrative expenses
580
38
ЕBIT
Debt due for repayment
$ 25
Cash
15
Taxable income
Тахes
$ 15
Depreciation
12
Net income
arrow_forward
Need help completing this question
arrow_forward
Please help me
arrow_forward
Find the following using the data bellow
a. Accounts receivable
B. Current assets
C. Total assets
D. Return on assets
E. Common equity
F. Quick ratio
arrow_forward
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
Accounts Receivable
Inventory
Total Assets
Dec. 31, 2022 Dec. 31, 2021
460,000
780,000
3,164,000
Example:
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).
400,000
650,000
2,800,000
Accounts Receivable
30000 ÷ 500000 =
·I.
=
6.0
%
%
arrow_forward
!
Required information
Problem 12-6A (Algo) Use ratios to analyze risk and profitability (LO12-3, 12-4)
[The following information applies to the questions displayed below.]
Income statements and balance sheets data for Virtual Gaming Systems are provided below.
Net sales
Cost of goods sold
Gross profit
Expenses:
VIRTUAL GAMING SYSTEMS
Income Statements
For the Years Ended December 31
2025
$3,495,000
2,477,000
1,018,000
Operating expenses
Depreciation expense
Loss on sale of land
Interest expense
Income tax expense
Total expenses
Net income
952,000
27,000
16,500
7,700
1,003, 200
14,800
2024
$3,021,000
1,947,000
1,074,000
855,000
25,500
7,700
13,500
46,500
948, 200
125,800
arrow_forward
Find the following using the data bellow
Accounts receivable = 111,100,000
Current assets = 316,500,000
Total assets = 600,000,000
A. Return on assets
B. Common equity
C .Quick ratio
arrow_forward
Need the the answer to this question
arrow_forward
How I can calculate in which year Office Depot has the most financial liquidity using the data
arrow_forward
gEnabled: Midterm exami
7:55
Microsoft's current assets consist of cash, short-term investments, accounts receivable, and inventory. The following data were
abstracted from a rccent financial statement:
Inventory
Total assets
Current ratio
Acid-test ratio
Debt to equity ratic
$ 190,000
$ 780,000
Shareholders' equity
2.65
1.70
1.60
Required:
Compute the shareholders' equity for Microsoft:
Saved
arrow_forward
Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheet
arrow_forward
P
(Financial statement analysis) The T. P. Jarmon Company manufactures and sells a line of exclusive sportswear. The firm's sales were $600,100 for the year just ended, and its total assets
exceeded $500,000. The company was started by Mr. Jarmon just 10 years ago and has been profitable every year since its inception. The chief financial officer for the firm, Brent Vehlim, has
decided to seek a line of credit from the firm's bank totaling $83,000. In the past, the company has relied on its suppliers to finance a large part of its needs for inventory. However, in recent months
tight money conditions have led the firm's suppliers to offer sizable cash discounts to speed up payments for purchases. Mr. Vehlim wants to use the line of credit to supplant a large portion of
the firm's payables during the summer, which is the firm's peak seasonal sales period.
The firm's two most recent balance sheets were presented to the bank in support of its loan request. In addition, the firm's income…
arrow_forward
Why i'm i getting this question wrong ?
arrow_forward
The photo is a vertical analysis of Apple Inc balance sheet. discuss the analysis
arrow_forward
Prepare a horizontal analysis of both the balance sheet and income statement.
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet Inc Stmt
Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by
a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as
23.4).)
Assets
Current assets
Cash
Marketable securities
Accounts receivable (net)
Inventories
ALLENDALE COMPANY
Horizontal Analysis of Balance Sheets
Year 4
Prepaid items
Total current assets
Investments
Plant (net)
Land
Total assets
Liabilities and Stockholders' Equity
Liabilities
Current liabilities
Notes payable
Accounts payable
Salaries payable
Total current liabilities
Noncurrent liabilities
Bonds payable
Other
Total noncurrent liabilities
Total liabilities
Stockholders' equity
Preferred stock (par value $10, 4%
cumulative, nonparticipating; 8,000 shares
authorized and issued)
Common stock (no par; 50,000 shares
authorized;…
arrow_forward
Conduct a vertical analysis from the Balance Sheet below and select the INCORERECT observation
Balance Sheet
Particulars
1. Equity And Liabilities:
1. Shareholder's Funds
(a) Share Capital
(b) Reserve and Surplus
2. Non-Current Liabilities
3. Current Liabilities
II. Assets:
1. Non-Current Assets
2. Current Assets
Total
Note
No.
Amount
A Ltd.
8 Ltd.
4,00,000
5,40,000
2,00,000 2,60,000
3,00,000 2,50,000
1,00,000 1,50,000
10,00,000 12,00,000
4,00,000 7,00,000
6,00,000 5,00,000
www.Totalgoel 10,00,000 12,00,000
O a. In comparison to B. Ltd, A Ltd's existing liabilities are (10%) are in a stronger way (12.50%)
O b. In comparison to A Ltd, B Ltd has a higher share capital
O c. B Ltd's Non Current Assets are 18.33% higher than A Ltd
O d. In comparison to A Ltd, B Ltd has a stronger long term status
O e. B Ltd's Current Assets are 18.33% higher than A Ltd
arrow_forward
Please help me with all answers I will give upvote thanku
arrow_forward
Balance Sheet
Prepare a vertical analysis of the balance sheets for Year 4 and Year 3.
Note: Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (L.e., .2345 should be entered
as 23.45).
Assats
Current assets
Cash
Income
Statement
Marketable securities
Accounts receivable (net)
Inventories
Prepaid Items
Total current assets
Investments
Plant (net)
Land
Total long-term assets
Total assets
Liabilities and stockholders' equity
Liabilities
Current liabilities
Notes payable
Accounts payable
Salaries payable
Total current liabilities
Noncurrent liabilities
Bonds payable
Other
FANNING COMPANY
Vertical Analysis of Balance Sheeta
Year 4
Total noncurrent liabilales
Total abilities
Stockholders' equity
Preferred stock (par value $10, 4% cumulative,
nonparticipating: 6,600 shares authorized and issued)
Common stock (no par; 50,000 shares authorized;
10,000 shares issued)
Retained earnings
Total stockholders' equity
Total liabilities and stockholders' equity…
arrow_forward
Balance Sheet
Prepare a horizontal analysis of the balance sheet for Year 4 and Year 3.
Note: Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (1.e., .234 should be
entered as 23.4).
Assets
Current assets
Cash
Income
Statement
Marketable securities
Accounts receivable (net)
Inventories
Prepaid Items
Total current assets
Investments
Plant (net)
Total long-term assets
Total assets
Liabilities and Stockholders' Equity
Liabilities
Current liabilities
Terlam
Notes payable
Accounts payable
Salaries payable
Total current liabilites
Noncurrent liabilities
Bonds payable
Other
Total noncurrent liabilities
Total abilities
Stockholders' equity
FRANKLIN COMPANY
Horizontal Analysis of Balance Sheets
Preferred stock (par value $10, 4% cumulative,
nonparticipating: 6,300 shares authorized and issued)
EMAIA
Common stock (no par; 50,000 shares authorized, 10,000
shares issued)
Retained earnings
Total stockholders' equity
Total habilities & stockholders equity…
arrow_forward
Consider this simplified balance sheet for Geomorph Trading: please answer the general accounting question
arrow_forward
How can I calculate in which year Office Depot has the greatest financial liquidity using the data provided
arrow_forward
I need questions 28, 29, and 30
arrow_forward
Please help me with all answer I will give upvote thanku
arrow_forward
Subject : Accounting
arrow_forward
Pls answer all the questions with solutions
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Related Questions
- O DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 Example: NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). 400,000 650,000 2,800,000 Accounts Receivable 30000 ÷ •1• 500000 6.0 % olo % 010arrow_forwardProblem 3-8 Financial Statements (LO1) Henry Josstick has just started his first accounting course and has prepared the following balance sheet and income statement for Omega Corp. Unfortunately, although the data for the individual items are correct, he is very confused as to whether an item should go in the balance sheet or income statement and whether it is an asset or liability. BALANCE SHEET $ 35 Payables Less accumulated depreciation Inventories $50 120 Receivables 35 Total current assets Total current liabilities Interest expense $ 25 Long-term debt Property, plant, and equipment $350 520 Total liabilities Net fixed assets Shareholders' equity $90 Total liabilities and Total assets shareholders' equity INCOME STATEMENT Net sales $700 Cost of goods sold Selling, general, and administrative expenses 580 38 ЕBIT Debt due for repayment $ 25 Cash 15 Taxable income Тахes $ 15 Depreciation 12 Net incomearrow_forwardNeed help completing this questionarrow_forward
- Please help mearrow_forwardFind the following using the data bellow a. Accounts receivable B. Current assets C. Total assets D. Return on assets E. Common equity F. Quick ratioarrow_forwardDIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a horizontal analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Accounts Receivable Inventory Total Assets Dec. 31, 2022 Dec. 31, 2021 460,000 780,000 3,164,000 Example: NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner). 400,000 650,000 2,800,000 Accounts Receivable 30000 ÷ 500000 = ·I. = 6.0 % %arrow_forward
- ! Required information Problem 12-6A (Algo) Use ratios to analyze risk and profitability (LO12-3, 12-4) [The following information applies to the questions displayed below.] Income statements and balance sheets data for Virtual Gaming Systems are provided below. Net sales Cost of goods sold Gross profit Expenses: VIRTUAL GAMING SYSTEMS Income Statements For the Years Ended December 31 2025 $3,495,000 2,477,000 1,018,000 Operating expenses Depreciation expense Loss on sale of land Interest expense Income tax expense Total expenses Net income 952,000 27,000 16,500 7,700 1,003, 200 14,800 2024 $3,021,000 1,947,000 1,074,000 855,000 25,500 7,700 13,500 46,500 948, 200 125,800arrow_forwardFind the following using the data bellow Accounts receivable = 111,100,000 Current assets = 316,500,000 Total assets = 600,000,000 A. Return on assets B. Common equity C .Quick ratioarrow_forwardNeed the the answer to this questionarrow_forward
- How I can calculate in which year Office Depot has the most financial liquidity using the dataarrow_forwardgEnabled: Midterm exami 7:55 Microsoft's current assets consist of cash, short-term investments, accounts receivable, and inventory. The following data were abstracted from a rccent financial statement: Inventory Total assets Current ratio Acid-test ratio Debt to equity ratic $ 190,000 $ 780,000 Shareholders' equity 2.65 1.70 1.60 Required: Compute the shareholders' equity for Microsoft: Savedarrow_forwardBalance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheetarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning