$3,091,000 – $860,000
$3,091,000 ÷ $860,000
Quick ratio
$1,866,000 ÷ $860,000
$8,260,000 ÷ [($714,000 + $740,000) ÷ 2]
Number of days' sales in receivables
[($714,000 + $740,000) ÷ 2] ÷ ($8,260,000 ÷ 365)
Inventory turnover
$4,100,000 ÷ [($1,072,000 + $1,100,000) ÷ 2]
Number of days' sales in inventory
[($1,072,000 + $1,100,000) ÷ 2] ÷ ($4,100,000 ÷ 365)
Ratio of fixed assets to long-term liabilities
$2,690,000 ÷ $1,690,000
Ratio of liabilities to
$2,550,000 ÷ $4,055,000
Times interest earned
($976,800 + $127,000) ÷ $127,000
Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts.
Balance Sheet
December 31, 20Y6
Assets
Current assets:
Cash $823,000
Marketable securities fill in the blank 5e07a6079007fd0_1
329,000
Accounts receivable (net) fill in the blank 5e07a6079007fd0_2
714,000
Inventory fill in the blank 5e07a6079007fd0_3
1,072,000
Prepaid expenses fill in the blank 5e07a6079007fd0_4
157,000
Total current assets $fill in the blank 5e07a6079007fd0_5
3,095,000
Long-term investments fill in the blank 5e07a6079007fd0_6
824,000
Property, plant, and equipment (net) fill in the blank 5e07a6079007fd0_7
2,690,000
Total assets $fill in the blank 5e07a6079007fd0_8
6,609,000
Liabilities
Current liabilities $fill in the blank 5e07a6079007fd0_9
Long-term liabilities fill in the blank 5e07a6079007fd0_10
Total liabilities $fill in the blank 5e07a6079007fd0_11
Stockholders' Equity
Common stock, $5 par fill in the blank 5e07a6079007fd0_13
Retained earnings fill in the blank 5e07a6079007fd0_14
Total stockholders' equity $fill in the blank 5e07a6079007fd0_15
Total liabilities and stockholders' equity $fill in the blank 5e07a6079007fd0_16
Profitability Measures
Match each computation to one of the profitability measures in the table.
Profitability Measures Computations
Asset turnover
$8,260,000 ÷ [($5,781,000 + $5,591,000) ÷ 2]
Return on total assets
($791,340 + $127,000) ÷ [($6,605,000 + $6,415,000) ÷ 2]
Return on stockholders' equity
$791,340 ÷ [($4,055,000 + $3,852,250) ÷ 2]
Return on common stockholders' equity
($791,340 – $65,000) ÷ [($3,567,500 + $3,424,800) ÷ 2]
Earnings per share on common stock
($791,340 – $65,000) ÷ 250,000 shares
Price-earnings ratio
$35 ÷ $3.05
Dividends per share
$175,000 ÷ 250,000 shares
Dividend yield
$0.70 ÷ $35
Comparative Income Statement
Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If < 5, round down and if ≥ 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%.
Comparative Income Statement
For the Years Ended December 31, 20Y6 and 20Y5
Increase/(Decrease)
20Y6 20Y5 Amount Percentage
Sales $fill in the blank 80054809ef81fec_1
8,260,000
$7,267,000 $fill in the blank 80054809ef81fec_2
fill in the blank 80054809ef81fec_3
%
Cost of goods sold fill in the blank 80054809ef81fec_4
4,100,000
(3,444,000) fill in the blank 80054809ef81fec_5
fill in the blank 80054809ef81fec_6
%
Gross profit $fill in the blank 80054809ef81fec_7
4,160,000
$3,823,000 $fill in the blank 80054809ef81fec_8
fill in the blank 80054809ef81fec_9
%
Selling expenses $fill in the blank 80054809ef81fec_10
$(1,453,200) $fill in the blank 80054809ef81fec_11
fill in the blank 80054809ef81fec_12
%
Administrative expenses (1,239,000) (1,103,000) fill in the blank 80054809ef81fec_13
fill in the blank 80054809ef81fec_14
%
Total operating expenses $fill in the blank 80054809ef81fec_15
$(2,556,200) $fill in the blank 80054809ef81fec_16
fill in the blank 80054809ef81fec_17
%
Operating income $fill in the blank 80054809ef81fec_18
$1,266,800 $fill in the blank 80054809ef81fec_19
fill in the blank 80054809ef81fec_20
%
Other expense (interest) fill in the blank 80054809ef81fec_21
(120,600) fill in the blank 80054809ef81fec_22
fill in the blank 80054809ef81fec_23
%
Income before income tax expense $fill in the blank 80054809ef81fec_24
$1,146,200 $fill in the blank 80054809ef81fec_25
fill in the blank 80054809ef81fec_26
%
Income tax expense fill in the blank 80054809ef81fec_27
(179,460) fill in the blank 80054809ef81fec_28
fill in the blank 80054809ef81fec_29
%
Net income $fill in the blank 80054809ef81fec_30
$966,740 $fill in the blank 80054809ef81fec_31
fill in the blank 80054809ef81fec_32
%
Final Questions
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
- Q4 Libscomb Technologies' annual sales are $6,743,847 and all sales are made on credit, it purchases $3,304,291 of materials each year (and this is its cost of goods sold). Libscomb also has $535,216 of inventory, $1,475,000 of accounts receivable, and $1,400,000 of accounts payable. Assume a 365 day year. What is Libscomb’s Receivables Period (in days)?arrow_forwardUse the cash flows and competitive spreads shown in the table below. ($ millions) Year 0 Year 1 Year 2 Years 3–10 Investment 190 Production (millions of pounds per year) 0 0 49 89 Spread ($ per pound) 1.04 1.04 1.04 1.04 Net revenues 0 0 50.96 92.56 Production costs 0 0 39.00 39.00 Transport 0 0 0 0 Other costs 0 29 29 29 Cash flow –190 −29 –17.04 24.56 NPV (at r = 6%) = 0 Assume the dividend payout ratio each year is 100%.a. Calculate the year−by−year book and economic profitability for investment in polyzone production. Assume straight−line depreciation over 10 years and a cost of capital of 6%. (Negative answers should be indicated by a minus sign. Leave no cells blank − be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your income answers in millions rounded to 2 decimal places and enter the rate of return as a percent rounded to 2 decimal places.)…arrow_forwardSpeed City supplies helicopters to corporate clients. i (Click the icon to view additional information.) Requirement a. What is Speed City's weighted average cost of capital? Begin by determining the formula to calculate WACC. X Requirements )+( + a. What is Speed City's weighted average cost of capital? b. Compute each division's Economic Value Added. X The company's results for 2020 are as follows: (Click the icon to view the data.) Read the requirements. X = WACCarrow_forward
- Match the following measurements with the terms below: Question 15 options: 12345 cash conversion efficiency ratio 12345 economic ordering quantity 12345 credit terms 12345 net working capital 12345 days of working capital 1. 5.1% 2. 47.2 days 3. 1/10, n/30 4. $200,000 5. 700 unitsarrow_forwardHi There, I need ask a favor... How to calculate "Current Liabilites" if I only know, these following data : - Cash and Equivalents : $ 100.00 - Fixed Assets : # 283.50 - Sales : $ 1,000.00 - Net Income : $ 50.00 - Quick Ratio : 2.0 x - Current Ratio : 3.0 x - DSO : 40 Days - ROE : 12% Thank youarrow_forwardCash $ 30,000 Marketable securities $ 25,000 Accounts Receivable Inventory Total current Assets Net Fixed Assets Total Assets Accounts Payable $ 120,000 Short-term Notes Payable Accrued Liabilities $ 20,000 Total Current Liabilities Long-Term Debt Total Debt Stockholder's Equity $ 600,000 Total Liabilites and Equity Assumptions: Sales = $1,825,000 Gross profit margin = 30% Inventory Turnover = 7.0 365 days per year DSO = 40 days Current ratio = 1.40 Total Asset Turnover = 1.25 Complete the Balance Sheet below based on the given informationarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education