Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedplease 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers And Executives

Authors: Cheryl Jones, Steven A. Finkler, Christine T. Kovner

4th Edition

ISBN: 1455700886, 9781455700882

More Books

Students also viewed these Finance questions

Question

Have a brief review of human motivation theories

Answered: 1 week ago