Answered step by step
Verified Expert Solution
Link Copied!

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

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

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

Global Financial Accounting And Reporting Principles And Analysis

Authors: Peter Walton, Walter Aerts

2nd Edition

1408017725, 978-1408017722

More Books

Students also viewed these Accounting questions

Question

What online recruitment methods are available?

Answered: 1 week ago

Question

Differentiate between gender equality and gender equity.

Answered: 1 week ago