amit 00000012 1812 00000s82 00000A0TIee 0000020 I2 00000sreA

amit 00.000,012, 1812 00,000.s,82 00.000,A0T.Iee 00.000.20. I?!2 00.000,sreA82 00.000,eAE,5012 00.000,TEeer 00.000,I,082 unsals blo2 abood to to 00.000,21,0E2 00.000,080,212 00.000,8e,01 00.02 00.02 00.000.000 00.000,80I 00.000,800,IER 00.000, 1 00 12 00.000,200,12 00.02 00.000,08,2 12- 00.02 00.000.01 E, I 00.000,e0.s 00.000,8E,0I 00.000,020.1S2 00.000,1a8,c12 00.000,108,42 00.000,00,2 00.000,cesre esansqx viinimbA 00.000,202A2 00.000,0P.I 12 00.000.2E0,2. 00.000,82AS2 00,000,098 12 00.000,TEA,SI2- 00.000,EA S2 00.000,008 12 00.000,TEA,SI2- 00.000,2,S12 00.000,108,22- 00.000,8S,12. 00.000,000,2s2- 00.000,185A2 00.000,000,12 00.000,AST A22 00.000,180,812 00.000, 0, 1 A 00.000,E84.0s2- 00.02 00,000,88A,0S2 00.000,0,0P2 00.00,rS,SI 00.002,e8,082

Solution

Ratio analysis:

Inventory Turnover: Cost of Goods Sold / Average Inventory

2023: Average inventory = ($25200000 + $35480000) / 2 = $30340000

COGS = $84972000

IT = $84972000 / $30340000 = 2.80

2024: Average inventory = ($58463000 + $35480000) / 2 = $46971500

COGS = $89752000

IT = $89752000 / $46971500 = 1.91

Receivables Turnover: Credit Sales / Average Gross Accounts Receivable

2023: Average Gross A/R = ($15600000 + $19650000) / 2 = $17625000

Credit sales = $151765000

RT = $151765000 / $17625000 = 8.61

2024: Average Gross A/R = ($19650000 + $26189000) / 2 = $22919500

Credit sales = $181546000

RT = $181546000 / $22919500 = 7.92

Total Asset Turnover: Sales / Average Total Assets

2023: Average total assets = ($596407000 + $583348000) / 2 = $589877500

TAT: $151765000 / $589877500 = 0.26

2024: Average total assets = ($583348000 + $588115000) / 2 = $585731500

TAT: $181546000 / $585731500 = 0.31

Working Capital Turnover: Sales / Working Capital

Working Capital = Current Assets - Current Liabilities

2023: WC = $73564000 - $139378000 = ($65814000)

WCT = $151765000 / ($65814000) = (2.31)

2024: WC = $92715000 - $121068000 = ($28353000)

WCT = $181546000 / ($28353000) = (6.40)

Current Ratio: Current Assets / Current Liabilities

2023: $73564000 / $139378000 = 0.53

2024: $92715000 / $121068000 = 0.77

Quick Ratio: Quick assets / Current Liabilities

2023: Quick assets = $73564000 – ($35480000 + $1250000) = $36834000

QR = $36834000 / $139378000 = 0.26

2024: Quick assets = $92715000 – ($58463000 + $750000) = $33502000

QR = $33502000 / $121068000 = 0.28

Cash Ratio: Cash + Marketable securities / Current liabilities

2023: ($12684000 + $4500000) / $139378000 = 0.12

2024: ($5813000 + $1500000) / $121068000 = 0.06

Debt to Assets ratio: Total Debt / Total Assets

2023: $299801000 / $583348000 = 0.51

2024: $303775000 / $588115000 = 0.52

Gross profit margin: GP / Sales

2023: $66793000 / $151765000 = 44%

2024: $91794000 / $181546000 = 51%

Net profit margin: NP / Sales

2023: -$20483000 / $151765000 = -13.5%

2024: $41043000 / $181546000 = 22.60%