Answered step by step
Verified Expert Solution
Question
1 Approved Answer
excel please solve with the formulas Ifthe equation a is NOT the 2014 a to the 2015 2016 2016 408,146 395,966 418,206 532,053 983,618 984,191
excel please solve with the formulas
Ifthe equation a is NOT the 2014 a to the 2015 2016 2016 408,146 395,966 418,206 532,053 983,618 984,191 854,565 467,901 416,712 426,904 247,083 464,936 223,265 19 21 734,301 26 153,801 693,117 509,499 27 967,686 748,524 TOTAL SALES LESS: COST OF GOODS SOLD GROSS PROFIT GEN. e ADM. EXPENSE FREIGHT SALARIEse BENEFITS FACILITIES e NTENANCE TRAVEL e VEHICLE DEPRECIATION MISCELLANEOUS TOTAL GEN. e ADM. EXPENSE OPERATING I NOME INTEREST EXPENSE PRE-TAX I NCOME TAXES NET NCOME AFTER TAXES 2010 12,854,999 12,914,001 2011 14,251,430 2012 29,769,999 13,990,999 15,779,000 9,223,049 2013 28,900,492 8,209,613 1,611,930 2014 16,482,927 2015 500,010 8,546,478 1,868,295 1,084,029 12,713,796 200,205 200,205 200,205 8,340,329 (22,867) 2,194,804 1,073,317 1,121,487 430,001 12,777,009 1,823,991 1,130,874 350,435 189,858 1,054,897 1,416,744 1,258,023 ate Year 2014'" sales 4% inflation per year Year inflation, Whichever is greater Year 2014's%ofsales as pre Vious Year 2014's%ofsales ate ate previous ate 42 % Of Condi to in bold red IF negative
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