Question

How to calculate in excel?

Profit after tax?

Balance sheet:

COCA-COLA CO  (KO) CashFlowFlag BALANCE SHEET
Fiscal year ends in December. USD in millions except per share data.	2015-12	2016-12	2017-12	2018-12	2019-12
Assets
Current assets
Cash
Cash and cash equivalents	7309	8555	6006	8926	6480
Short-term investments	12591	13646	14669	7038	4695
Total cash	19900	22201	20675	15964	11175
Receivables	3941	3856	3667	3396	3971
Inventories	2902	2675	2655	2766	3379
Prepaid expenses	2752	2481	2000	1962	1886
Other current assets	3900	2797	7548	6546
Total current assets	33395	34010	36545	30634	20411
Non-current assets
Property, plant and equipment
Gross property, plant and equipment	22354	21256	16449	16245	18921
Accumulated Depreciation	-9783	-10621	-8246	-8013	-8083
Net property, plant and equipment	12571	10635	8203	8232	10838
Equity and other investments	15788	17249	21952	20274	19879
Goodwill	11289	10629	9401	10263	16764
Intangible assets	12843	10499	7235	7007	10002
Deferred income taxes				2667	2412
Other long-term assets	4207	4248	4560	4139	6075
Total non-current assets	56698	53260	51351	52582	65970
Total assets	90093	87270	87896	83216	86381
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	15806	16025	16503	18191	15247
Accounts payable	2795	2682	2288	2498	3804
Deferred income taxes		692
Taxes payable	775	679	757	693	856
Accrued liabilities	5485	4887	5259	5225	6045
Other current liabilities	2069	1567	2387	2616	1021
Total current liabilities	26930	26532	27194	29223	26973
Non-current liabilities
Long-term debt	28407	29684	31182	25364	27516
Deferred taxes liabilities	4691	3753	2522	1933	2284
Minority interest	210	158	1905	2077	2117
Other long-term liabilities	4301	4081	8021	7638	8510
Total non-current liabilities	37609	37676	43630	37012	40427
Total liabilities	64539	64208	70824	66235	67400
Stockholders' equity
Common stock	1760	1760	1760	1760	1760
Additional paid-in capital	14016	14993	15864	16520	17154
Retained earnings	65018	65502	60430	63234	65855
Treasury stock	-45066	-47988	-50677	-51719	-52244
Accumulated other comprehensive income	-10174	-11205	-10305	-12814	-13544
Total stockholders' equity	25554	23062	17072	16981	18981
Total liabilities and stockholders' equity	90093	87270	87896	83216	86381

Income statement:

COCA-COLA CO  (KO) CashFlowFlag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data.	2015-12	2016-12	2017-12	2018-12	2019-12	TTM
Revenue	44294	41863	35410	31856	37266	34326
Cost of revenue	17482	16465	13256	11770	14619	13717
Gross profit	26812	25398	22154	20086	22647	20609
Operating expenses
Sales, General and administrative	16427	15262	12496	10307	12103	10971
Restructuring, merger and acquisition			1088	598	405
Other operating expenses	1657	1510	-857	-600	-394	167
Total operating expenses	18084	16772	12727	10305	12114	11138
Operating income	8728	8626	9427	9781	10533	9471
Interest Expense	856	733	841	919	946	932
Other income (expense)	1733	243	-1844	-512	1199	2180
Income before taxes	9605	8136	6742	8350	10786	10719
Provision for income taxes	2239	1586	5560	1623	1801	1511
Net income from continuing operations	7366	6550	1182	6727	8985	9208
Net income from discontinuing ops			101	-251
Other	-15	-23	-35	-42	-65	-19
Net income	7351	6527	1248	6434	8920	9189
Net income available to common shareholders	7351	6527	1248	6434	8920	9189
Earnings per share
Basic	1,69	1,51	0,29	1,51	2,09	2,15
Diluted	1,67	1,49	0,29	1,5	2,07	2,12
Weighted average shares outstanding
Basic	4352	4317	4272	4259	4276	4287
Diluted	4405	4367	4324	4299	4314	4322
EBITDA	12431	10656	8843	10355	13097	13162

Answer 1

Profit after Tax = Income before Taxes - Provision for Income Tax

So to calculate the profit after tax in excel , we need to follow the below steps :

Step 1 - Get the data in excel file

Step 2 : Go to 'Income before Taxes'

Step 3: We need data from two rows to calculate Proft after Tax

Step 4 : Add a row below ' Provision for Taxes'

Step 5: Write in the column 1, ' Profit after Tax '

Step 6: Now put a formula in column 2, b68 - b69 (i.e. Income before Taxes - Provision for Income Taxes)

Step 7 : Press enter to get the value.

Step 8: Now Copy paste or drag the formula among other cells on RHS and press enter -- Answer is Ready .