Please tell me the process of calculating those blank part... confusing.... Tren
ID: 2539568 • Letter: P
Question
Please tell me the process of calculating those blank part... confusing.... Trend Percentages Sales of automotive products for Ford Motor Company and General Motors Corporation for a five-year period are: Net Sales of Automotive Products (Millions of Dollars) Year 1 Year 2 Year 3 Year 4 Year 5 Ford Motor Company General Motors Corporation 99,106 97312 94,828 103,00s 108,027 Net sales for Pfizer Inc. and Abbott Laboratories for the same five years follow $82,879 $81,844 $72,051 $84,407 $91,568 Net Sales (Millions of Dollars) Year 1 Year 2 Year 3 Year4 Year 5 $5,672 $6,406 $6,950 $7,230 $7,478 Pfizer Inc Abbott Laboratories 5,380 6,159 6,877 7,852 8,408 Required Calculate trend percentages for all four companies, using Year 1 as the base year. Round to one decimal point Net Sales of Automotive Products- Trend Percentages Year 1 Year 2 Year 3 Year 4 Year 5 Ford Motor Company General Motors CorporationExplanation / Answer
Net sales of automative products-Trend percentages: Ford Motor company: Year 1 100.0% =82879/82879 Year 2 98.8% =81844/82879 Year 3 86.9% =72051/82879 Year 4 101.8% =84407/82879 Year 5 110.5% =91568/82879 General Motors Corporation: Year 1 100.0% =99106/99106 Year 2 98.2% =97312/99106 Year 3 95.7% =94828/99106 Year 4 103.9% =103005/99106 Year 5 109.0% =108027/99106 Net sales: Pfizer Inc. Year 1 100.0% =5672/5672 Year 2 112.9% =6406/5672 Year 3 122.5% =6950/5672 Year 4 127.5% =7230/5672 Year 5 131.8% =7478/5672 Abbott Laboratories: Year 1 100.0% =5380/5380 Year 2 114.5% =6159/5380 Year 3 127.8% =6877/5380 Year 4 145.9% =7852/5380 Year 5 156.3% =8408/5380