Ch07 P15 Build a Model-913649

xlsx

School

National Open and Distance University *

*We aren’t endorsed by this school

Course

122

Subject

Finance

Date

Nov 24, 2024

Type

xlsx

Pages

15

Uploaded by jacque84

Report
Ratio Analysis Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) 2021 2020 Assets Cash $21,525 $20,500 Short-term investments 4,195 2,980 Accounts receivable 52,500 49,000 Inventories 88,000 56,000 Total current assets $166,220 $128,480 Net fixed assets 231,951 210,000 Total assets $398,171 $338,480 Liabilities & Equity Accounts payable $30,975 $29,500 Accruals 10,500 10,000 Notes payable 19,414 5,620 Total current liabilities $60,889 $45,120 Long-term debt 73,032 62,260 Total liabilities $133,921 $107,380 Common stock 182,000 182,000 Retained earnings 82,250 49,100 Total common equity $264,250 $231,100 Total liabilities & equity $398,171 $338,480 Joshua & White Technology: Income Statements for Year Ending on December 31 (Thousands of Dollars) 2021 2020 Sales $430,500 $410,000 COGS excluding depreciation and amortization 308,500 307,500 Depreciation and amortization 20,420 18,900 Other operating expenses 26,500 20,500 EBIT $75,080 $63,100 Interest expense 6,040 4,660 EBT $69,040 $58,440 Taxes (25%) 17,260 14,610 Net income $51,780 $43,830 Common dividends $18,630 $17,532 Additions to retained earnings $33,150 $26,298 Other Data 2021 2020 Year-end stock price $88.00 $96.00 Number of shares (Thousands) 4,046 4,000 Lease payment (Thousands of Dollars) $20,000 $20,000 Sinking fund payment (Thousands of Dollars) $5,000 $5,000
a. Determining whether J&W’s liquidity position has improved or worsened 2021 2020 Current ratio 2.73 2.85 Quick ratio 1.28 1.61 b. Determining whether J&W's ability to manage its assets has improved or worsened Days in a year 365 2021 2020 Inventory turnover 3.74 5.83 Days sales outstanding (days) 44.51 43.62 Fixed assets turnover 1.86 1.95 Total assets turnover 1.08 1.21 c. Determining how J&W's profitability has changed during the last year 2021 2020 Profit margin 12.03% 10.69% Basic earning power 18.86% 18.64% Return on assets 13.00% 12.95% Return on equity 19.60% 18.97% d. Performing an extended DuPont analysis for J&W for 2020 and 2021 Profit margin TA turnover Equity multiplier 2021 12.03% 1.08 1.51 2020 10.69% 1.21 1.46 e. Performing a common size analysis Common Size Balance Sheets 2021 2020 Assets Cash 5.41% 6.06% Short-term investments 1.05% 0.88% Accounts receivable 13.19% 14.48% Inventories 22.10% 16.54% Total current assets 41.75% 37.96% Net fixed assets 58.25% 62.04% Total assets 100.00% 100.00% Liabilities & Equity Accounts payable 7.78% 8.72% Accruals 2.64% 2.95% Notes payable 4.88% 1.66% Total current liabilities 15.29% 13.33% Long-term debt 18.34% 18.39% Total liabilities 33.63% 31.72% Common stock 45.71% 53.77% Retained earnings 20.66% 14.51% Total common equity 66.37% 68.28% Total liabilities & equity 100.00% 100.00%
Common Size Income Statements 2021 2020 Sales 100.00% 100.00% COGS excluding depreciation and amortization 71.66% 75.00% Depreciation and amortization 4.74% 4.61% Other operating expenses 6.16% 5.00% EBIT 17.44% 15.39% Interest expense 1.40% 1.14% EBT 16.04% 14.25% Taxes (25%) 4.01% 3.56% Net income 12.03% 10.69% f. Performing a percentage change analysis Percent Change Balance Sheet Formulas Assets Cash 5.00% =(C7-D7)/D7 Short-term investments 40.77% =(C8-D8)/D8 Accounts receivable 7.14% =(C9-D9)/D9 Inventories 57.14% =(C10-D10)/D10 Total current assets 29.37% =(C11-D11)/D11 Net fixed assets 10.45% =(C12-D12)/D12 Total assets 17.64% =(C13-D13)/D13 Liabilities & Equity Accounts payable 5.00% =(C16-D16)/D16 Accruals 5.00% =(C17-D17)/D17 Notes payable 245.44% =(C18-D18)/D18 Total current liabilities 34.95% =(C19-D19)/D19 Long-term debt 17.30% =(C20-D20)/D20 Total liabilities 24.72% =(C21-D21)/D21 Common stock 0.00% =(C22-D22)/D22 Retained earnings 67.52% =(C23-D23)/D23 Total common equity 14.34% =(C24-D24)/D24 Total liabilities & equity 17.64% =(C25-D25)/D25 Percent Change Income Statement Formulas Sales 5.00% =(C30-D30)/D30 COGS excluding depreciation and amortization 0.33% =(C31-D31)/D31 Depreciation and amortization 8.04% =(C32-D32)/D32 Other operating expenses 29.27% =(C33-D33)/D33 EBIT 18.99% =(C34-D34)/D34 Interest expense 29.61% =(C35-D35)/D35 EBT 18.14% =(C36-D36)/D36 Taxes (25%) 18.14% =(C37-D37)/D37 Net income 18.14% =(C38-D38)/D38 Percent Change in 2021 Percent Change in 2021
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
ROE 19.60% 18.97%
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
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
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
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