Chapter 14

.xlsx

School

Temple University *

*We aren’t endorsed by this school

Course

3101

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

7

Uploaded by nidhipatel200416

Report
ABC COMPANY 1. Using the financial data in the yellow cells, solve for the total debt ratios in the blue cells. ($ Millions) Revenue (Sales) $ 226,094.00 Net Income $ 7,840.00 Total Assets $ 330,314.00 Total Equity $ 167,325.00 Total Debt/Assets 0.49 Total Debt/Equity 0.97 2.Using the financial data in problem #1, solve for the related dupont values in the blue cells. Dupont Measure Of Operating Efficiency 0.0347 Dupont Measure Of Asset Management Efficiency 0.6845 Dupont Measure Of Financial Leverge 1.9741 Dupont Measure Of Use Of Debt. 0.9741 Calculated Roe Using Dupont Framework 0.0469 Calculated Roe Using Roe Formula 0.0469
97609
3. Use the figures in the yellow cells to compute common-size values in the blue cells. COMMON SIZING ($ Thousands) Income Statement COMMON SIZE Total Revenue (Sales) $ 33,990,000 100.00% Cost of Goods Sold $ 14,053,000 41.34% Gross Margin $ 19,937,000 58.66% SG&A $ 10,671,000 31.39% Depreciation $ 2,231,000 6.56% EBIT $ 7,035,000 20.70% Interest Expense $ 355,000 1.04% Income Before Taxes $ 6,680,000 19.65% Income Taxes $ 1,670,000 4.91% Net Income $ 5,010,000 14.74% Balance Sheet Assets Current Assets Cash and Equivalents $ 6,959,000 14.30% Short Term Investments $ 2,192,000 4.50% Net Receivables $ 3,758,000 7.72% Inventories $ 2,354,000 4.84% Other Current Assets $ 2,288,000 4.70% TOTAL Current Assets $ 17,551,000 36.06% Long-term Investments $ 6,755,000 13.88% Plant, Prop. & Equip. (NET) $ 9,561,000 19.64% Goodwill $ 4,224,000 8.68% Intangible Assets $ 8,604,000 17.68% Other Assets $ 1,976,000 4.06% TOTAL ASSETS $ 48,671,000 100.00% Liabilities Current Liabilities Accounts Payable $ 6,921,000 14.22% Short/Current Debt $ 6,800,000 13.97% Total Current Liab. $ 13,721,000 28.19% Long-Term Debt $ 5,059,000 10.39% Other Liabilities $ 2,965,000 6.09% Deferred Long-Term Debt $ 1,580,000 3.25% Minority Interests $ 547,000 1.12% TOTAL LIABILITIES $ 23,872,000 49.05% Stockholder's Equity
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