Question
Perform the following ratio analysis for NSI, Competitor A, and Competitor B for each of the 3 years (for relevant ratios use formulas provided in
Perform the following ratio analysis for NSI, Competitor A, and Competitor B for each of the 3 years (for relevant ratios use formulas provided in the textbook): Inventory turnover, days in inventory, reserve for spoilage as % of inventory. Cost of goods sold as a % of sales
Competitor A Competitor B NSI
2021. 2020 2019 2021 2020 2019 2021 2020 2019
Sales $1,500,000 $1,800,000 $1,600,000 $350,000 $450,000 $400,000 $3,200,000 $2,400,000 $2,000,000
COGS. $1,200,000 $1,215,000 $1,080,000 $280,000 $301,500 $268,000 $1,937,500 $1,500,000 $1,250,000
A/R $200,000 $200,000 $200,000. $50,000. $50,000 $50,000 $1,600,000. $800,000 $600,000
Allowance for DA $(8,000) $(8,000) $(8,000) $(2,000) $(2,000) $(2,000) $(50,000). $(50,000) $(50,000)
Inventory $105,000 $102,700 $101,000 $26,000. $24,000. $22,000. $200,000 $100,000 $98,000
Reserve for Spoilage $(10,500) $(5,135) $(5,000) $(2,600) $(1,200) $(1,100) $(10,000) $(5,000) $(3,000)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started