Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

just want the formulas for all the caluations in excel 2010 2011 2012 2013 2014 Net Sales 289.9 304.1 316.4 329 345.5 COGS 259.4 273.1

just want the formulas for all the caluations in excel

2010 2011 2012 2013 2014
Net Sales 289.9 304.1 316.4 329 345.5
COGS 259.4 273.1 284.1 295.3 310.4
Gross profit 30.5 31 32.3 33.7 35.1
Operating expenses 20.9 21.6 26.7 28.6 30.3
Depreciation and amortization 1.6 1.6 1.7 1.7 1.8
Operating profit 8 7.8 3.9 3.4 3
Interest expense 0 0 0.3 0.2 0
Income taxes 2.8 2.73 1.365 1.19 1.05
Net income 5.2 5.1 2.3 2.1 2
EPS $1.30 $1.27 $0.58 $0.52 $0.49
Dividend $0.20 $0.20 $0.20 $0.20 $0.20
Balance sheet 2010 2011 2012 2013 2014
Cash 3.6 4.2 3.3 1.5 0.4
Accounts receivable 20.7 22 29.3 30.4 31
Other current assets 6.3 5.1 4.9 5 4.9
Current assets 30.6 31.3 37.5 36.9 36.3
Net PP&E 3.1 5.1 7.2 9.2 11.2
Investments and other assets 45 47.1 47.3 47.6 47.2
Total assets 78.7 83.6 92 93.7 94.6
Accounts payable 5.6 5.3 7.6 8.9 10.4
Bank borrowing 0 0 4 2.5 0
Current liabilities 5.6 5.3 11.6 11.4 10.4
Accrued expenses and deferred taxes 13.9 13.9 15 15.3 15.5
Other non-current liabilities 16.6 17.5 17 17.3 17.9
Total liabilities 36.1 36.7 43.6 44 43.8
Shareholders equity 42.6 46.9 48.4 49.7 50.8
Total liabilities and equity 78.7 83.6 92 93.7 94.6

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

Introduction To Finance Financial Management And Investment Management

Authors: Pamela P. Drake, Frank J. Fabozzi, Francesco A. Fabozzi

1st Edition

9811239657, 978-9811239656

More Books

Students also viewed these Finance questions