Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please solve the columns for 2015 and 2016 ! PLEASE PUT THE FORMULAS USED IN EACH SQUARE Ifthe equation a is NOT the 2014 a
please solve the columns for 2015 and 2016 ! PLEASE PUT THE FORMULAS USED IN EACH SQUARE
Ifthe equation a is NOT the 2014 a to the 2015 2016 2016 408,146 395,966 532,053 418,206 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 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 2014 16,482,927 2015 500,010 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 8,209,613 350,435 189,858 430,001 12,777,009 1,823,991 1,130,874 1,054,897 1,416,744 1,258,023 ate Year 2014'" sales 4% inflation per year inflation, Whichever is greater Year 2014's%ofsales as pre Vious Year 2014's%ofsales ate ate ate 42 % Of Condi to in bold red IF negative Ifthe equation a is NOT the 2014 a to the 2015 2016 2016 408,146 395,966 532,053 418,206 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 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 2014 16,482,927 2015 500,010 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 8,209,613 350,435 189,858 430,001 12,777,009 1,823,991 1,130,874 1,054,897 1,416,744 1,258,023 ate Year 2014'" sales 4% inflation per year inflation, Whichever is greater Year 2014's%ofsales as pre Vious Year 2014's%ofsales ate ate 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