finance statements
docx
keyboard_arrow_up
School
Washington State University *
*We aren’t endorsed by this school
Course
100
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by EarlAlligatorPerson375
Avista Utilities & Rite Aid Financial
Statements – Pre-Work
1.
How much net income or net loss did Avista Utilities and Rite Aid each make in the most recent year they reported? HINT: be sure to look at the last line of the heading so you are accurate in the numbers you report.
538,478 for Rite Aid
147,334 for Avista 2.
Review Avista and Rite Aid’s current and quick ratios. Why are these ratios the same as each other for Avista but different for Rite Aid? Explain why this makes sense given the type of companies Avista Utilities and Rite Aid are.
Return on sales =net income 147.334/1.438.936=.102
3.
a) Provide the formula for the debt to equity ratio for Rite Aid. b) Then provide the actual numbers you would use to calculate the debt to equity ratio for the fiscal year ending February 26, 2022. Calculate the ratio and verify it matches the value provided on the ratios tab. c) Then describe what the ratio means.
Debt to equity=total liability 8.529.003/8.529.003=86.12 These ratios look at how much capital comes in the form of debt
4.
a) Provide the formula for Return on Equity and Net Profit Margin ratios for Avista Utilities. b) Then provide the actual numbers you would use to calculate these two ratios for 2021. Calculate the ratios and verify they match the values provided on the ratios tab. c) Then describe what the ratios mean.
As the years pass, it appears that the return on sales is declining.
5.
Review Avistas’ Net Profit Margin ratio across 2019, 2020, and 2021. Describe the trend in the ratio. Using values from the income statement, explain what is causing the trend.
Avista current ratio 0.48
Avista quick ratio 0.48
Rite aid current ratio 1.18 Rite aid qick ratio 0.51
6.
On each of the income statement and balance sheet tabs, your are provided with each value as a % of revenue. Analyzing these values allows you to look for trends in expenses and compare financial statements across companies. (This is what we did in class when introducing financial statements where we compared a bank to a pharmaceutical company.) Review the %ages of revenue and identify and describe 2 observations about either a trend in expenses or a difference between Avista Utilities and Rite Aid.
Rite aid went to -14 to -543 Avista went to 10-14
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
eBook
Print
References
INCOME STATEMENT
(Figures in 5 millions)
Net sales
Cost of goods sold
Other expenses
Depreciation
Earnings before interest and taxes (EBIT)
Interest expense
Income before tax
Taxes (at 21%)
Net income
Dividends
Assets
Cash and marketable securities
Receivables
Inventories
Other current assets
Total current assets.
BALANCE SHEET
(Figures in $ millions)
Net property, plant, and equipment
Other long-term assets
$ 12,600
3,760
4,127
2,338
$ 2,375
655
Total assets
Liabilities and shareholders' equity
Payables
Short-term debt
$1,720
361
$ 1,359
$816
Other current liabilities
Total current liabilities
Long-term debt and leases
Other long-term liabilities
Shareholders' equity
Total liabilities and shareholders' equity
End of Year Start of Year
$ 152
2,370
208
902
$ 3,632
19,855
3,710
$ 27,197
$83
2,082
157
837
$ 3,159
19,913
4,156
$ 27,228
$ 2,504
1,389
781
$ 4,674
8,512
6,118
7,924
$ 27,228
$ 2,980
1,543
757
$5,280
7,907
6,089
7,921
$ 27,197
Calculate the following…
arrow_forward
What is the Days Payables Outstanding? Use the attached financial data to calculate the
ratios. Round to the nearest decimal.
Abercrombie & Fitch Co (ANF)
Financial Data
Revenues
Cost of Sales
Total Operating Expenses
Interest Expense
Income Tax Expense
Diluted Weighted Shares
Outstanding
Cash + Equivalents
Accounts Receivable
Inventories
Total Current Assets
Total Assets
Accounts Payable
Total Current Liabilities
Total Stockholders' Equity
ANF Stock Price = $10.30
Select one
O A. 42.3 days, 37.0 days
OB. 76.1 days, 89.4 days
OC. 89.4 days, 37.0 days
OD. 76.1 days, 97.7 days
2022
$3,659.3
$1,545.9
$2,026.9
$28.5
$37.8
52.8
$257.3
$108.5
$742.0
$1,220.4
$2,694.0
$322.1
$935.5
$656.1
2021
$3,712.8
$1,400.8
$1,968.9
$34.1
$38.9
62.6
$823.1
$69.1
$525.9
$1,507.8
$2,939.5
$374.8
$1,015.2
$826.1
arrow_forward
2) Ratios
Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x)
Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav.
Current Ratio (X)
{Total. Current Assets/
Total Current Liabilities}
Quick Ratio (X)
{Cash + Short term Investments +
Current Receivables/ Current Liabilities}
Day's Sales Uncollected (days)
{Total Accounts Receivables / Sales x 365}
arrow_forward
2) Ratios
Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x)
Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav.
Current Ratio (X)
{Total. Current Assets/
Total Current Liabilities}
Quick Ratio (X)
{Cash + Short term Investments +
Current Receivables/ Current Liabilities}
Day's Sales Uncollected (days)
{Total Accounts Receivables / Sales x 365}
arrow_forward
Compute the ratios for the current and past year for Dollar Tree In. on the Ratio and Comments worksheet.
arrow_forward
Using available data in the case, calculate the requested financial ratios. Round all numbers to the nearest hundredth. For example,
answers should look like -0.05 or 1.33.
Use the following table to calculate Current Ratios for the years 2014, 2015, and 2016:
Year
2014
2015
2016
Current Assets Current Liabilities
6,086
5,914
8,137
ROA
ROE
Current Ratio
2016
0.78
%
%
8,532
8,516
10,397
2015
0.69
%
%
2014
0.71
%
%
arrow_forward
Please do not give image format and explanation
arrow_forward
The following financial data (in thousands) were taken from recent financial statements of Staples, Inc.:
Please see the attachment for details:
1. Determine the times interest earned ratio for Staples in Year 3, Year 2, and Year 1? Round your answers to one decimal place.2. Evaluate this ratio for Staples.
arrow_forward
Compute the following ratios. Note: Use a 360-day year. Do not round intermediate calculations. Input your profit margin, return on assets, return on equity, and debt to total assets answers as a percent rounded to 2 decimal places. Round all other answers to 2 decimal places.
Jones Corp Smith Corp
Find the profit margin, return on assets(investments), return on equity, receivable turnover, average collection period, inventory turnover, fixed asset turnover, total asset turnover, current ratio, quick ratio, debt to total assets, times interest earned, and fixed charge coverage. For each Corporation.
arrow_forward
Please correct Solution with Explanation and do not give image format
arrow_forward
Using Yahoo Finance for your data & information, calculate the following
items for the public company, WK Kellogg Co (KLG), showing your work:
a. Value using industry average P/E ratio for trailing 12 months EPS.
b. P/E ratio for most recent fiscal year end earnings.
c. How does Kellogg's P/E ratio compare to others in the industry?
arrow_forward
Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3.
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet Inc Stmt
Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages
may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345
should be entered as 23.45).)
Revenues
Sales (net)
Other revenues
Total revenues
RUNDLE COMPANY
Vertical Analysis of Income Statements
Year 4
Expenses
Cost of goods sold
Selling, general, and
administrative expense
Net income
Interest expense
Income tax expense
Total expenses
Amount
$
230,300
8,900
239,200
Percentage
of Total
119,400
54,300
6,700
22,100
202,500
$
36,700
Show less
arrow_forward
The following financial statements apply to Jordan Company:
Year 2
Year 1
Revenues
$ 220,000
$ 180,300
Expenses
Cost of goods sold
125,200
102,300
Selling expenses
21,000
19,000
General and administrative expenses
10,500
9,500
Interest expense
1,100
1,100
Income tax expense
19, 200
17, 200
Total expenses
177,000
149, 100
Net income
$ 43,000 $
31, 200
Assets
Current assets
Cash
$
$
7,500
5,800
1,700
1,700
Marketable securities
Accounts receivable
Inventories
35,300
30,800
101,500
94,000
Prepaid expenses
4,700
3,700
Total current assets
149,000
137,700
Plant and equipment (net)
105,400
105,400
Intangibles
22,000
0
Total assets
$ 276,400 $ 243,100
Liabilities and Stockholders' Equity
Liabilities
Current liabilities
Accounts payable
$ 39,000
$ 34,000
Other
15,800
16,100
Total current liabilities
54,800
50, 100
Bonds payable
65,700
66,700
Total liabilities
120,500
116,800
Stockholders' equity
114,100
114, 100
Common stock (49,000 shares)
Retained earnings
41,800
12,200
Total stockholders'…
arrow_forward
A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.
B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.
arrow_forward
Comparative information taken from the Friction Company's financial statements is shown below:
(a) Notes receivable
(b) Accounts receivable
(c) Retained earnings
(d) Sales
(e) Operating expenses
(f) Income taxes payable
a.
b.
Required:
Using horizontal analysis, show the percentage change and direction (increase or decrease) from Year 1 to Year 2 with Year 1 as the base year. If an item is impossible to compute, enter a "0" in the percentage box and select "Not possible to
compute" in the narrative box.
C.
d.
e.
f.
%
%
%
%
%
Year 2
%
Year 1
$25,500
$30,000
106,200
90,000
77,000
70,000
654,000 600,000
160,000 200,000
28,000 20,000
arrow_forward
Compute the following ratios:
#
Metric
1
Current Ratio
Formula
Meaning
Expressed
Current Year
Numerator Denominator Answer
as
1 Year Ago
Numerator Denominator Answer Metric Improved
/ Worsened
Ratio:1
Current Assets / Current Measures the short-term
Liabilities
2
Quick Ratio
(Cash + Short Term
3
Day Sales
Outstanding
4
Days in
Inventory
Investments + Accounts
Receivable) / Current
Liabilities
(Accounts Receivable/
Sales)*365
(Inventory / Cost of
goods sold)*365
5
Debt Equity
Ratio
Total Liabilities / Total
Equity
debt-paying ability of the company.
A higher current ratio suggests a
strong ability to meet current
obligations.
This ratio is like the current ratio but Ratio:1
excludes current assets such as
inventories and prepaid expenses
that may be difficult to quickly
convert into cash
Measures how quickly a company
collects its accounts receivable. A
lower number is better as it
converts AR to cash quicker
# of days
Measure inventory liquidity. A high # of days.
number indicates too…
arrow_forward
Calculate the following five ratios for each of the two years:(i) Return on capital employed(ii) Net profit margin(iii) Current ratio(iv) Average Receivable days/ Debtors collection period(v) Average Payable days/ Creditors collection period
arrow_forward
Calculate the Current Ratio, Debt Ratio, Return on Assets (ROA) and Return on Equity (ROE). For the ROA and ROE, you should use the average total assets and the average total equity in your calculations. (The average is the total across two years divided by two). Calculate these values for each of 2011-2014. Interpret your calculations: what does this information mean? How is the company doing?
arrow_forward
compute the following ratios using the Balance Sheet (Current Year) and Income Statement provided in the images below
Current Ratio (in numeric format, 2 decimal places):
Debt to Equity (in numeric format, 2 decimal places():
Return on Equity (stated as a percentage, 2 decimal places):
Return on Assets (stated as a percentage, 2 decimal places):
arrow_forward
Loomis, Inc. reported the following on the company’s income statement in two recent years:
Please see the image for details:
a. Determine the times interest earned ratio for the current year and the prior year. Round to one decimal place.b. Is this ratio improving or declining?
arrow_forward
Some recent financial statements for Smolira Golf Corporation follow.
Find the following financial ratios for Smolira Golf Corporation (use year-end figures rather than average values where appropriate): (Enter the profitability ratio answers as a percent rounded to 2 decimal places, e.g., 32.16. Round the remaining answers to 2 decimal places, e.g., 32.16.)
1.
Long-term Solvency Ratios
2020
2021
Total debt ratio
times
times
Debt-equity ratio
times
times
Equity multiplier
times
times
2.
Times interest earned
times
Cash coverage ratio
times
3.
Profitability Ratios
Profit margin
%
Return on Assets
%
Return on Equity
%
arrow_forward
Please try to answer handwritten i will rate you for sure
arrow_forward
Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2. (Round your answers to 2 decimal places.)
Windswept Woodworks, Inc.
Input Data
(millions of dollars)
Year 2
Year 1
Accounts payable
496
434
Accounts receivable
1,340
880
Accumulated depreciation
6,806
6,682
Cash & equivalents
284
178
Common stock
1,244
1,170
Cost of goods sold
1,500
n.a.
Depreciation expense
?
n.a.
Common stock dividends paid
?
n.a.
Interest expense
140
n.a.
Inventory
1,074
1,076
Addition to retained earnings
602
n.a.
Long-term debt
872
786
Notes payable
230
380
Gross plant & equipment
10,260
10,000
Retained earnings
3,122
2,526
Sales
3,018
n.a.
Other current liabilities
116
96
Tax rate
34
%
n.a.
Market price per share – year end
$
19.80
$…
arrow_forward
V. Direction: Solve the following problems using financial ratios. Write the answer on the blank.
1. Current assets is P20,000, current liabilities is P30,000. What is the current ratio?
2. Inventory is P15,000; Accounts Payable is P45,000. Cash and accounts receivable total P8,000.
What is the current ratio?
What is the quick ratio?
3. If current ratio is 1.5, what is the total accounts receivable if cash is P220,000, inventory is P75,000,
and accounts payable is P330,000?
4. Cash is 30% of total current assets. If current ratio is 2.5, what is the new current ratio if total non-
cash current assets grow by 50%?
5. The total asset is P1,500,000. Sales is P4,500,000. What is the asset turnover?
6. Accounts receivable turnover is 8. What is the average collection period assuming annual data
What is the average collection period if quarterly data are used?
are used?
7. Sales for the year amount to P3,000,000, Accounts receivable is P360,000. What is the average
collection period assuming…
arrow_forward
Compute the missing amounts on the company’s financial statements. (Hint: What’s the difference between the acid-test ratio and the current ratio?)10. Gross margin11. Selling and administrative expenses12. Bonds payable
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Related Questions
- eBook Print References INCOME STATEMENT (Figures in 5 millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Income before tax Taxes (at 21%) Net income Dividends Assets Cash and marketable securities Receivables Inventories Other current assets Total current assets. BALANCE SHEET (Figures in $ millions) Net property, plant, and equipment Other long-term assets $ 12,600 3,760 4,127 2,338 $ 2,375 655 Total assets Liabilities and shareholders' equity Payables Short-term debt $1,720 361 $ 1,359 $816 Other current liabilities Total current liabilities Long-term debt and leases Other long-term liabilities Shareholders' equity Total liabilities and shareholders' equity End of Year Start of Year $ 152 2,370 208 902 $ 3,632 19,855 3,710 $ 27,197 $83 2,082 157 837 $ 3,159 19,913 4,156 $ 27,228 $ 2,504 1,389 781 $ 4,674 8,512 6,118 7,924 $ 27,228 $ 2,980 1,543 757 $5,280 7,907 6,089 7,921 $ 27,197 Calculate the following…arrow_forwardWhat is the Days Payables Outstanding? Use the attached financial data to calculate the ratios. Round to the nearest decimal. Abercrombie & Fitch Co (ANF) Financial Data Revenues Cost of Sales Total Operating Expenses Interest Expense Income Tax Expense Diluted Weighted Shares Outstanding Cash + Equivalents Accounts Receivable Inventories Total Current Assets Total Assets Accounts Payable Total Current Liabilities Total Stockholders' Equity ANF Stock Price = $10.30 Select one O A. 42.3 days, 37.0 days OB. 76.1 days, 89.4 days OC. 89.4 days, 37.0 days OD. 76.1 days, 97.7 days 2022 $3,659.3 $1,545.9 $2,026.9 $28.5 $37.8 52.8 $257.3 $108.5 $742.0 $1,220.4 $2,694.0 $322.1 $935.5 $656.1 2021 $3,712.8 $1,400.8 $1,968.9 $34.1 $38.9 62.6 $823.1 $69.1 $525.9 $1,507.8 $2,939.5 $374.8 $1,015.2 $826.1arrow_forward2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav. Current Ratio (X) {Total. Current Assets/ Total Current Liabilities} Quick Ratio (X) {Cash + Short term Investments + Current Receivables/ Current Liabilities} Day's Sales Uncollected (days) {Total Accounts Receivables / Sales x 365}arrow_forward
- 2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav. Current Ratio (X) {Total. Current Assets/ Total Current Liabilities} Quick Ratio (X) {Cash + Short term Investments + Current Receivables/ Current Liabilities} Day's Sales Uncollected (days) {Total Accounts Receivables / Sales x 365}arrow_forwardCompute the ratios for the current and past year for Dollar Tree In. on the Ratio and Comments worksheet.arrow_forwardUsing available data in the case, calculate the requested financial ratios. Round all numbers to the nearest hundredth. For example, answers should look like -0.05 or 1.33. Use the following table to calculate Current Ratios for the years 2014, 2015, and 2016: Year 2014 2015 2016 Current Assets Current Liabilities 6,086 5,914 8,137 ROA ROE Current Ratio 2016 0.78 % % 8,532 8,516 10,397 2015 0.69 % % 2014 0.71 % %arrow_forward
- Please do not give image format and explanationarrow_forwardThe following financial data (in thousands) were taken from recent financial statements of Staples, Inc.: Please see the attachment for details: 1. Determine the times interest earned ratio for Staples in Year 3, Year 2, and Year 1? Round your answers to one decimal place.2. Evaluate this ratio for Staples.arrow_forwardCompute the following ratios. Note: Use a 360-day year. Do not round intermediate calculations. Input your profit margin, return on assets, return on equity, and debt to total assets answers as a percent rounded to 2 decimal places. Round all other answers to 2 decimal places. Jones Corp Smith Corp Find the profit margin, return on assets(investments), return on equity, receivable turnover, average collection period, inventory turnover, fixed asset turnover, total asset turnover, current ratio, quick ratio, debt to total assets, times interest earned, and fixed charge coverage. For each Corporation.arrow_forward
- Please correct Solution with Explanation and do not give image formatarrow_forwardUsing Yahoo Finance for your data & information, calculate the following items for the public company, WK Kellogg Co (KLG), showing your work: a. Value using industry average P/E ratio for trailing 12 months EPS. b. P/E ratio for most recent fiscal year end earnings. c. How does Kellogg's P/E ratio compare to others in the industry?arrow_forwardPrepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues RUNDLE COMPANY Vertical Analysis of Income Statements Year 4 Expenses Cost of goods sold Selling, general, and administrative expense Net income Interest expense Income tax expense Total expenses Amount $ 230,300 8,900 239,200 Percentage of Total 119,400 54,300 6,700 22,100 202,500 $ 36,700 Show lessarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning

Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning