Make sure you carefully apply the theory and make reasonable choices for all the variables included in the analysis Calculate OCF of the company Estimate a reasonable choice of growth of the cash flows (arithmetic or geometric average from historical growth rate etc ) Company Fundamentals Balance Sheet Company Name Sharjah Cement and Industrial Development CompanyPSC (SCIDC AD) Country of Exchange United Arab Emirates Country of Headquarters United Arab Emirates TRBC Industry Group Construction Materials CF Template IND Consolidation Basis Consolidated Scaling Millions Period Annual Export Date 17 06 2023 Statement Data 2022 2021 2020 Period End Date 31 12 2022 31 12 2021 31 12 2020 Standardized Currency AED AED AED Balance Sheet Standardized (Currency UAE Dirham) Field Name 30 12 2022 30 12 2021 30 12 2020 Current Assets Cash Short Term Investments 43 20 47 46 49 29 Cash Cash Equivalents 13 09 13 80 26 64 Short Term Investments Total 30 11 33 66 22 65 Loans Receivables Net Short Term 223 8 173 3 177 9 Trade Accounts Trade Notes Receivable Net 221 3 168 7 172 3 Trade Accounts Trade Notes Receivable Gross 227 5 174 9 178 5 Provision Trade Accounts Trade Notes Receivable 6 23 6 23 6 24 Receivables Other Total 2 51 4 65 5 63 Inventories Total 290 9 220 0 236 7 Inventories Raw Materials 101 9 76 20 94 36 Inventories Work in Progress 80 60 57 92 59 07 Inventories Finished Goods 16 63 15 11 11 21 Inventories Other Total 91 82 70 77 72 06 Prepaid Expenses Short Term 16 52 12 10 5 84 Assets Held for Sale Discontinued Operations Short Term 47 29 47 29 45 02 Total Current Assets 621 7 500 2 514 7 Non Current Assets Investments Long Term 376 8 415 4 385 3 Investment Property Net 242 3 250 9 259 7 Investment Property Accumulated Depreciation Impairment 80 64 72 11 63 30 Investment Property Gross 323 0 323 0 323 0 Investments Available for Sale Held to Maturity Long Term 134 4 164 6 125 6 Receivables Loans Long Term 0 Receivables Other Net Long Term 0 Property, Plant Equipment Net Total 910 1 917 0 970 6 Property, Plant Equipment excluding Assets Leased Out Net Total 910 1 917 0 970 6 Land Buildings Net 177 0 184 2 198 2 Land Improvements Net 23 85 23 85 23 85 Buildings Net 153 2 160 4 174 3 Plant, Machinery Equipment Net 687 2 721 4 738 4 Transportation Equipment Net 2 99 2 83 1 33 Construction in Progress Net 43 02 6 12 26 58 Property, Plant Equipment Other Net 2 84 5 33 7 48 Property, Plant Equipment Gross Total 2,149 9 2,086 6 2,071 4 Property, Plant Equipment excluding Assets Leased Out Gross 2,149 9 2,086 6 2,071 4 Land Buildings Gross 460 6 453 5 453 3 Land Improvements Gross 23 85 23 85 23 85 Buildings Gross 436 7 429 6 429 5 Plant, Machinery Equipment Gross 1,596 4 1,577 0 1,542 0 Transportation Equipment Gross 47 64 47 08 45 29 Construction in Progress Gross 43 02 6 12 26 58 Property, Plant Equipment Other Gross 49 89 49 99 49 45 Property, Plant Equipment Accumulated Depreciation Impairment Total 1,239 8 1,169 5 1,100 7 Property, Plant Equipment excluding Assets Leased Out Accumulated Depreciation Impairment Total 1,239 8 1,169 5 1,100 7 Land Buildings Accumulated Depreciation Impairment 283 5 269 3 255 2 Land Improvements Accumulated Depreciation Impairment 0 0 0 Buildings Accumulated Depreciation Impairment 283 5 269 3 255 2 Plant, Machinery Equipment Accumulated Depreciation Impairment 909 2 855 6 803 6 Transportation Equipment Accumulated Depreciation Impairment 44 66 44 25 43 96 Construction in Progress Accumulated Depreciation Impairment 0 0 0 Property, Plant Equipment Other Accumulated Depreciation Impairment 47 05 44 66 41 98 Total Non Current Assets 1,286 9 1,332 4 1,355 9 Total Assets Total Assets 1,908 6 1,832 6 1,870 7 Current Liabilities Trade Accounts Payable Accruals Short Term 174 1 91 40 67 09 Trade Accounts Trade Notes Payable Short Term 120 5 53 31 38 87 Accrued Expenses Short Term 53 60 38 09 28 22 Short Term Debt Current Portion of Long Term Debt 320 5 266 0 241 8 Short Term Debt Notes Payable 271 5 207 3 183 1 Current Portion of Long Term Debt including Capitalized Leases 48 94 58 76 58 76 Current Portion of Long Term Debt excluding Capitalized Leases 48 94 58 76 58 76 Dividends Distributions Payable 13 04 13 36 14 19 Other Current Liabilities Total 1 10 1 64 16 21 Other Current Liabilities 1 10 1 64 16 21 Total Current Liabilities 508 8 372 4 339 3 Non Current Liabilities Debt Long Term Total 94 93 113 9 183 3 Long Term Debt excluding Capitalized Leases 94 93 113 9 183 3 Debt Non Convertible Long Term 94 93 113 9 183 3 Other Non Current Liabilities Total 31 10 27 96 27 45 Provisions Long Term 31 10 27 96 27 45 Provisions Other Long Term 31 10 27 96 27 45 Total Non Current Liabilities 126 0 141 8 210 8 Total Liabilities Total Liabilities 634 8 514 3 550 1 Shareholders' Equity Shareholders' Equity Attributable to Parent Shareholders Total 1,273 8 1,318 4 1,320 6 Common Equity Attributable to Parent Shareholders 1,273 8 1,318 4 1,320 6 Common Equity Contributed 608 3 608 3 608 3 Common Stock Issued Paid 608 3 608 3 608 3 Equity Non Contributed Reserves Retained Earnings 665 5 710 1 712 4 Retained Earnings Total 436 2 465 0 498 3 Comprehensive Income Accumulated Total 2 93 18 76 12 31 Investments Unrealized Gain Loss 2 93 18 76 12 31 Other Reserves Equity Total 226 4 226 4 226 4 Common Equity Total 1,273 8 1,318 4 1,320 6 Total Shareholders' Equity Total Shareholders' Equity including Minority Interest Hybrid Debt 1,273 8 1,318 4 1,320 6 Total Liabilities Shareholders' Equity Total Liabilities Equity 1,908 6 1,832 6 1,870 7 Share Per Share Common Common Shares Issued Total 608 3 608 3 608 3 Common Shares Outstanding Total 608 3 608 3 608 3 Common Shares Treasury Total 0 0 0 Common Shares Authorized Issue Specific 608 3 608 3 608 3 Common Shares Issued Issue Specific 608 3 608 3 608 3 Common Shares Outstanding Issue Specific 608 3 608 3 608 3 Common Shares Treasury Issue Specific 0 0 0 Share Per Share Other Asset Allocation Factor Issue Specific 1 00 1 00 1 00 Right of Use Liabilities Debt including Finance and Operating Lease Liabilities 415 4 379 9 425 1 Long Term Short Term Investments Total 406 9 449 1 407 9 Loans Receivables Total 223 8 173 3 177 9 Accounts Notes Receivable Trade Gross Total 227 5 174 9 178 5 Assets Held for Sale Discontinued Operations Long Term Short Term 47 29 47 29 45 02 Dividends Payable 13 04 13 36 14 19 Payables Accrued Expenses 174 1 91 40 67 09 Trade Account Payables Total 120 5 53 31 38 87 Accrued Expenses 53 60 38 09 28 22 Debt Related Net Debt 372 2 332 4 375 8 Debt Total 415 4 379 9 425 1 Other Accruals Short Term 99 85 114 0 148 8 Asset Accruals 1,895 5 1,818 8 1,844 0 Cash Cash Equivalents Total 13 09 13 80 26 64 Cash Short Term Investments Total 43 20 47 46 49 29 Debt including Preferred Equity Minority Interest Total 415 4 379 9 425 1 Investments Permanent 376 8 415 4 385 3 Net Book Capital 1,646 0 1,650 8 1,696 4 Net Operating Assets 1,646 0 1,650 8 1,696 4 Provisions Total 31 10 27 96 27 45 Shareholders Equity Common 1,273 8 1,318 4 1,320 6 Tangible Total Equity 1,273 8 1,318 4 1,320 6 Tangible Book Value 1,273 8 1,318 4 1,320 6 Total Book Capital 1,689 2 1,698 3 1,745 7 Total Capital 1,689 2 1,698 3 1,745 7 Total Long Term Capital 1,399 8 1,460 2 1,531 4 Total Fixed Assets Net 1,286 9 1,332 4 1,355 9 Working Capital 112 9 127 8 175 4 Working Capital Non Cash 69 74 80 31 126 2 Working Capital excluding Other Current Assets Liabilities 114 0 129 4 191 7 Book Value excluding Other Equity 1,047 4 1,092 0 1,094 2

The Answer is in the image, click to view ...

Question: Make sure you carefully apply the theory and make reasonable choices for all the variables included in the analysis. -Calculate OCF of the company -

Make sure you carefully apply the theory and make reasonable choices for all the variables included in the analysis.

-Calculate OCF of the company

- Estimate a reasonable choice of growth of the cash flows (arithmetic or geometric average from historical growth rate etc.)

Company Fundamentals - Balance Sheet
Company Name	Sharjah Cement and Industrial Development CompanyPSC (SCIDC.AD)
Country of Exchange	United Arab Emirates
Country of Headquarters	United Arab Emirates
TRBC Industry Group	Construction Materials
CF Template	IND
Consolidation Basis	Consolidated
Scaling	Millions
Period	Annual
Export Date	17-06-2023
Statement Data	2022	2021	2020
Period End Date	31-12-2022	31-12-2021	31-12-2020
Standardized Currency	AED	AED	AED
Balance Sheet - Standardized (Currency: UAE Dirham)
Field Name	30-12-2022	30-12-2021	30-12-2020
Current Assets
Cash & Short-Term Investments	43.20	47.46	49.29
Cash & Cash Equivalents	13.09	13.80	26.64
Short-Term Investments - Total	30.11	33.66	22.65
Loans & Receivables - Net - Short-Term	223.8	173.3	177.9
Trade Accounts & Trade Notes Receivable - Net	221.3	168.7	172.3
Trade Accounts & Trade Notes Receivable - Gross	227.5	174.9	178.5
Provision - Trade Accounts & Trade Notes Receivable	6.23	6.23	6.24
Receivables - Other - Total	2.51	4.65	5.63
Inventories - Total	290.9	220.0	236.7
Inventories - Raw Materials	101.9	76.20	94.36
Inventories - Work in Progress	80.60	57.92	59.07
Inventories - Finished Goods	16.63	15.11	11.21
Inventories - Other - Total	91.82	70.77	72.06
Prepaid Expenses - Short-Term	16.52	12.10	5.84
Assets Held for Sale/Discontinued Operations - Short-Term	47.29	47.29	45.02
Total Current Assets	621.7	500.2	514.7
Non-Current Assets
Investments - Long-Term	376.8	415.4	385.3
Investment Property - Net	242.3	250.9	259.7
Investment Property - Accumulated Depreciation & Impairment	80.64	72.11	63.30
Investment Property - Gross	323.0	323.0	323.0
Investments - Available for Sale/Held to Maturity - Long-Term	134.4	164.6	125.6
Receivables & Loans - Long-Term			0
Receivables - Other - Net - Long-Term			0
Property, Plant & Equipment - Net - Total	910.1	917.0	970.6
Property, Plant & Equipment - excluding Assets Leased Out - Net - Total	910.1	917.0	970.6
Land & Buildings - Net	177.0	184.2	198.2
Land/Improvements - Net	23.85	23.85	23.85
Buildings - Net	153.2	160.4	174.3
Plant, Machinery & Equipment - Net	687.2	721.4	738.4
Transportation Equipment - Net	2.99	2.83	1.33
Construction in Progress - Net	43.02	6.12	26.58
Property, Plant & Equipment - Other - Net	2.84	5.33	7.48
Property, Plant & Equipment - Gross - Total	2,149.9	2,086.6	2,071.4
Property, Plant & Equipment - excluding Assets Leased Out - Gross	2,149.9	2,086.6	2,071.4
Land & Buildings - Gross	460.6	453.5	453.3
Land/Improvements - Gross	23.85	23.85	23.85
Buildings - Gross	436.7	429.6	429.5
Plant, Machinery & Equipment - Gross	1,596.4	1,577.0	1,542.0
Transportation Equipment - Gross	47.64	47.08	45.29
Construction in Progress - Gross	43.02	6.12	26.58
Property, Plant & Equipment - Other - Gross	49.89	49.99	49.45
Property, Plant & Equipment - Accumulated Depreciation & Impairment - Total	1,239.8	1,169.5	1,100.7
Property, Plant & Equipment - excluding Assets Leased Out - Accumulated Depreciation & Impairment - Total	1,239.8	1,169.5	1,100.7
Land & Buildings - Accumulated Depreciation & Impairment	283.5	269.3	255.2
Land/Improvements - Accumulated Depreciation & Impairment	0	0	0
Buildings - Accumulated Depreciation & Impairment	283.5	269.3	255.2
Plant, Machinery & Equipment - Accumulated Depreciation & Impairment	909.2	855.6	803.6
Transportation Equipment - Accumulated Depreciation & Impairment	44.66	44.25	43.96
Construction in Progress - Accumulated Depreciation & Impairment	0	0	0
Property, Plant & Equipment - Other - Accumulated Depreciation & Impairment	47.05	44.66	41.98
Total Non-Current Assets	1,286.9	1,332.4	1,355.9
Total Assets
Total Assets	1,908.6	1,832.6	1,870.7
Current Liabilities
Trade Accounts Payable & Accruals - Short-Term	174.1	91.40	67.09
Trade Accounts & Trade Notes Payable - Short-Term	120.5	53.31	38.87
Accrued Expenses - Short-Term	53.60	38.09	28.22
Short-Term Debt & Current Portion of Long-Term Debt	320.5	266.0	241.8
Short-Term Debt & Notes Payable	271.5	207.3	183.1
Current Portion of Long-Term Debt including Capitalized Leases	48.94	58.76	58.76
Current Portion of Long-Term Debt excluding Capitalized Leases	48.94	58.76	58.76
Dividends/Distributions Payable	13.04	13.36	14.19
Other Current Liabilities - Total	1.10	1.64	16.21
Other Current Liabilities	1.10	1.64	16.21
Total Current Liabilities	508.8	372.4	339.3
Non-Current Liabilities
Debt - Long-Term - Total	94.93	113.9	183.3
Long-Term Debt excluding Capitalized Leases	94.93	113.9	183.3
Debt - Non-Convertible - Long-Term	94.93	113.9	183.3
Other Non-Current Liabilities - Total	31.10	27.96	27.45
Provisions - Long-Term	31.10	27.96	27.45
Provisions - Other - Long-Term	31.10	27.96	27.45
Total Non-Current Liabilities	126.0	141.8	210.8
Total Liabilities
Total Liabilities	634.8	514.3	550.1
Shareholders' Equity
Shareholders' Equity - Attributable to Parent Shareholders - Total	1,273.8	1,318.4	1,320.6
Common Equity Attributable to Parent Shareholders	1,273.8	1,318.4	1,320.6
Common Equity - Contributed	608.3	608.3	608.3
Common Stock - Issued & Paid	608.3	608.3	608.3
Equity - Non-Contributed - Reserves & Retained Earnings	665.5	710.1	712.4
Retained Earnings - Total	436.2	465.0	498.3
Comprehensive Income - Accumulated - Total	2.93	18.76	-12.31
Investments - Unrealized Gain/Loss	2.93	18.76	-12.31
Other Reserves/Equity - Total	226.4	226.4	226.4
Common Equity - Total	1,273.8	1,318.4	1,320.6
Total Shareholders' Equity
Total Shareholders' Equity - including Minority Interest & Hybrid Debt	1,273.8	1,318.4	1,320.6
Total Liabilities & Shareholders' Equity
Total Liabilities & Equity	1,908.6	1,832.6	1,870.7
Share/Per Share - Common
Common Shares - Issued - Total	608.3	608.3	608.3
Common Shares - Outstanding - Total	608.3	608.3	608.3
Common Shares - Treasury - Total	0	0	0
Common Shares - Authorized - Issue Specific	608.3	608.3	608.3
Common Shares - Issued - Issue Specific	608.3	608.3	608.3
Common Shares - Outstanding - Issue Specific	608.3	608.3	608.3
Common Shares - Treasury - Issue Specific	0	0	0
Share/Per Share - Other
Asset Allocation Factor - Issue Specific	1.00	1.00	1.00
Right of Use Liabilities
Debt including Finance and Operating Lease Liabilities	415.4	379.9	425.1
Long-Term & Short-Term
Investments - Total	406.9	449.1	407.9
Loans & Receivables - Total	223.8	173.3	177.9
Accounts & Notes Receivable - Trade - Gross - Total	227.5	174.9	178.5
Assets Held for Sale/Discontinued Operations - Long-Term & Short-Term	47.29	47.29	45.02
Dividends Payable	13.04	13.36	14.19
Payables & Accrued Expenses	174.1	91.40	67.09
Trade Account Payables - Total	120.5	53.31	38.87
Accrued Expenses	53.60	38.09	28.22
Debt Related
Net Debt	372.2	332.4	375.8
Debt - Total	415.4	379.9	425.1
Other
Accruals - Short-Term	99.85	114.0	148.8
Asset Accruals	1,895.5	1,818.8	1,844.0
Cash & Cash Equivalents - Total	13.09	13.80	26.64
Cash & Short Term Investments - Total	43.20	47.46	49.29
Debt - including Preferred Equity & Minority Interest - Total	415.4	379.9	425.1
Investments - Permanent	376.8	415.4	385.3
Net Book Capital	1,646.0	1,650.8	1,696.4
Net Operating Assets	1,646.0	1,650.8	1,696.4
Provisions - Total	31.10	27.96	27.45
Shareholders Equity - Common	1,273.8	1,318.4	1,320.6
Tangible Total Equity	1,273.8	1,318.4	1,320.6
Tangible Book Value	1,273.8	1,318.4	1,320.6
Total Book Capital	1,689.2	1,698.3	1,745.7
Total Capital	1,689.2	1,698.3	1,745.7
Total Long Term Capital	1,399.8	1,460.2	1,531.4
Total Fixed Assets - Net	1,286.9	1,332.4	1,355.9
Working Capital	112.9	127.8	175.4
Working Capital - Non-Cash	69.74	80.31	126.2
Working Capital excluding Other Current Assets & Liabilities	114.0	129.4	191.7
Book Value excluding Other Equity	1,047.4	1,092.0	1,094.2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following tax calculations have been prepared by the senior accountant and the bookkeeper. The senior accountant has correctly determined the income for tax purposes for the various sources of...

Make sure you carefully apply the theory and make reasonable choices for all the variables included in the analysis - Estimate the Cost of Equity of the Firm (CAPM approach) -Estimate the stock price...

Make sure you carefully apply the theory and make reasonable choices for all the variables included in the analysis.-calculate OCF for 3 years of the company-Please provide all calculation by exel if...

perform a DCF valuation of Sharjeh cement(SCIDC) listed in S&P 500 index by using OCF approach. Make sure you carefully apply the theory and make reasonable choices for all the variables included in...

Please solve the attached problem. (Eyemax Corp.) The First requirement answer is C. Please do the second question with step by step explanations. If you selected item c in question 1, what is the...

Hi, I need help with my audit case assignment. Detail is in the attachment. Thank you:) Case 12.1 EyeMax Corporation Evaluation of Audit Differences MARK S. BEASLEY FRANK A. BUCKLESS STEVEN M. GLOVER...

Requirement 1 ?Users of financial statements can expect that if an unqualified opinion is issued by the auditor, there will be no errors, misstatements, or misapplications of Generally Accepted...

Hello, I have assessment.. Step 1 : Calculate the following ratios for the latest five years using the O-S Checklist Approach, an Excel template . For an overview of the approach, read our article,...

A IKVA ideal single phase step-up transformer is supplied by a 24 V ac power source and is delivering power to a l10 resistive load connected to the secondary side. If the transformer is operated at...

AMAX Corporation is a mining company that focuses on extraction of molybdenum-a crucial additive in the production of steel. AMAX is considering expanding its molybdenum capacity and is deciding...

A special form must be filed with the IRS when a company intends to adopt the Blank _ _ _ _ _ _ inventory method. Multiple choice question. average cost FIFO LIFO

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...