Week 3 - AK

xlsx

School

Humber College *

*We aren’t endorsed by this school

Course

ACCG70024

Subject

Finance

Date

Nov 24, 2024

Type

xlsx

Pages

4

Uploaded by tastyyum9

Report
Income Statement Balance Sheet 2018 2019 2018 Net sales $ 375.00 $ 450.00 $ 39.00 Less: COGS $ 225.00 $ 270.00 $ 50.00 Gross Profit $ 150.00 $ 180.00 $ 151.00 Less: Operating expenses $ 46.00 $ 46.00 Total current assets $ 240.00 Less: Depreciation $ 25.00 $ 30.00 $ 200.00 Less: Interest $ 4.00 $ 4.00 $ 95.00 Income before taxes $ 75.00 $ 100.00 $ 105.00 Less: Income taxes $ 20.00 $ 30.00 $ 345.00 Net income $ 55.00 $ 70.00 $ 30.00 Cash dividends $ 17.00 $ 20.00 Bank loan $ 20.00 Accrued liabilities $ 10.00 Tax rate 26.67% 30.00% Total current liabilities $ 60.00 $ 15.00 $ 85.00 $ 185.00 Total liabilities and equity $ 345.00 Cash Accounts receivable Inventories Gross fixed assets Less accumulated depreciation Net fixed assets Total assets Accounts payable Long-term debt Common stock Retained earnings
Liquidity 2019 2018 2019 2018 $ 16.00 Cash build = net sales – change in receivables. $ 80.00 $ 420.00 40.00% $ 204.00 $ 300.00 Current ratio = current assets / current liabilities Operatin $ 290.00 4.00 3.16 27.73% $ 125.00 $ 165.00 Net working capital = current assets – current liabilities $ 465.00 $ 180.00 $ 205.00 14.67% $ 45.00 $ 27.00 NWC-to-total-assets ratio = NWC / total assets (or average total assets) $ 23.00 0.52 0.44 20.34% $ 95.00 $ 15.00 $ 120.00 Leverage $ 235.00 total-debt-to-total-assets-ratio $ 465.00 21.74% 23.66% debt-to-equity-ratio 0.28 0.31 the equity multiplier = average total assets / average total equity 1.30 interest coverage ratio = EBITDA / interest payment 26.00 33.50 ROE 22.40% The fixed charges ratio = EBITDA + lease payments / interest payments + rental or lease payments + before-tax cost of debt repayments
Efficiency & Profitability 2019 Gross profit margin = gross profit / venture’s net sales 40.00% ng profit margin = earnings before interest and taxes (EBIT) / venture’s net sales 29.78% Net profit margin = net income (or net profit) / net sales 15.56% NOPAT margin = (EBIT x (1 – tax rate)) / net sales 20.84% Sales-to-total-assets = net sales / average total assets 1.11 Operating return on assets = EBIT / average total assets 25.68% Return on assets = net profit / average total assets 17.28% Return on equity = net income (or net profit) / average owners’ equity 22.40% DuPont net profit margin asset turnover equity multiplier 15.56% 1.11 1.30
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
Company A Company B Sales $ 1,000.00 $ 1,000.00 Costs (excluding tax and interest) $ 400.00 $ 400.00 EBIT $ 600.00 $ 600.00 Interest $ - $ 100.00 EBT $ 600.00 $ 500.00 NI $ 420.00 $ 350.00 ROE 21.00% 35.00% Assets $ 2,000.00 $ 2,000.00 Liabilities $ - $ 1,000.00 S/E $ 2,000.00 $ 1,000.00 Interest Rate 10% 10% Tax rate 30% 30%