Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to calculate EPS, ROCE, PE Ratio, Current Ratio, Debt to Equity Ratio based on the image? c BALANCE SHEET Cash & CE Accounts Receivables

image text in transcribed
How to calculate EPS, ROCE, PE Ratio, Current Ratio, Debt to Equity Ratio based on the image?
image text in transcribed

c BALANCE SHEET Cash & CE Accounts Receivables Inventory Prepaid Expenses Current Assets PPE (cost) Acc. Depreciation Goodwil I Other Assets Total Assets Accounts Payable Accrued Expenses (net) 66, 353 73, 957 82, 346 91, 517 101, 480 198, 054 208, 054 218, 054 228, 054 238, 054 (102, 746) (126, 052) 206, 249 230, 229 238, 684 65 218 66 572 67 967 69 392 70 848 118, 036 120, 900 126, 873 129, 973 109, 401 80, 546 89, 951 94, 963 100, 192 83, 611 93, 016 98, 028 103, 257 199, 581 213 916 221, 877 230, 130 188, 054 198, 054 208, 054 218, 054 228, 054 10, ooo 10, ooo 188, 054 198, 054 208, 054 218, 054 228, 054 238, 054 (71, 538) (91, 843) (102, 746) (10, 403) (10, 903) (71, 538) (91, 843) (102, 746) (126, 052) 116, 613 116, 613 116,211 115, 308 113, 905 112, 002 188, 054 10, 403 10, 903 11, 403 11, 903 491, 773 501, 608 511, 640 368, 829 376, 206 383, 730 122, 943 127, 910 130, 468 133, 078 100, 322 102, 328 25, 080 22, 720 15 449 D 2016 8, 705 5, 624 60, 239 188, 054 -71, 538 16, 695 6, 131 199, 581 38, 487 19, 607 2, 708 3, 296 521 64 619 44, 030 7, 321 115, 970 2, 122 90, 021 -11, 597 Year +1 13, 675 5, 736 45, 472 1, 470 (81, 441 ) 17, 029 6, 254 38, 503 19, 999 2, 789 3, 395 531 45, 351 7, 467 2, 186 94, 560 Year +2 20, 225 5, 851 46, 382 1, 499 (91, 843) 17, 369 6, 379 213, 916 39, 261 20, 399 2, 873 3, 497 542 46, 711 7, 617 2, 251 99, 297 Year +3 27, 539 5, 968 47, 309 1, 529 17, 717 6, 506 221, 877 20, 807 2, 959 3, 602 553 48, 113 7, 769 123, 849 2, 319 Year +4 35 614 6, 088 48, 255 1, 560 049 ) 18, 071 6, 636 40, 847 21, 223 3, 048 3, 710 564 49, 556 7, 924 2, 388 Year +5 44, 459 6, 209 49, 220 1, 591 18, 433 6, 769 664 648 3, 139 3, 821 575 043 8, 083 Notes Payable/ ST Debt LT Debt Current IT Payable Current Liabilities LT Debt LongTerm Deferred Taxes LT Redeemable NCI Total Liabilities Common Stock & APIC Retained Earnings Acc. Other Comprehensive Income Total Shareholder' s Equity Noncontrolling Interests Total Equity Total Liabilities and Equity 3, 065 -11, 597 85, 149 3, 065 88, 214 206, 250 -11, 597 3, 065 G -11, 597 3, 065 -11, 597 3, 065 -11, 597 105, 647 3, 065 108, 712 238 685 B c Forecast Developm nt: Capital Expendi tures, Property, Plant and Equipment, and Depreciation Property, Plant and Equipment and Depreciation PP&E at cost: Beg. balance at cost: Add: CAPEX forecasts: End balance at cost: Accumulated Depreciation: Beg. Balance: Subtract: Depreciation expense forecasts from below: Property, Plant and Equipment and Depreciation Forecasts: 2016 Year +1 (9, 903) (81, 441 ) Year +2 10, ooo (81, 441 ) (9, 836) Year 10, ooo (9, 903) Year End Balance: Existing PP&E at cost: Depreciation expense forecast 9, 403 9, 403 9, 403 Depreciation expense forecasts on on Capex Capex Capex Capex Capex Total Year +1 Year +2 Year +3 Year +5 Depreciation 149) existing 9, 403 PP&E: new 500 500 500 500 Year +5 10, ooo (114, 149) PP&E: 9, 403 500 500 500 500 500 Expense 500 9, 903 c D COMPREHENSIVE INCOME STATEMENT Year +2 125, 402 254 (2, 615) 7, 270 (386) 15, 063 15, 063 500 500 Year +3 25, 582 358 (2, 694) 23, 246 7, 439 15, 807 (386) 15, 421 15, 421 500 500 500 Year Revenues COGS Gross Profit SG&A Expense Operating Income Interest Income Interest Expense Income Before Tax Income Tax Expense Net Income NI Attributable to NCI NI Attributable to CS Comprehensive Income 2016 482, 130 -360, 984 121, 146 (97, 041) 24, 105 81 -2, 548 21, 638 (6, 558) 15, 080 (386) 14, 694 (4, 429) 10, 265 Year +1 98, 355 24, 589 168 (2, 539) 22, 217 7, 110 15, 108 (386) 14, 722 14, 722 +4 521, 873 391, 405 375 26, 094 474 (2, 775) 23, 792 16, 179 (386) 15, 793 15, 793 Year +5 532, 310 399, 233 106, 462 26, 616 601 (2, 858) 24, 358 7, 795 16, 563 (386) 16, 177 16, 177

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_2

Step: 3

blur-text-image_3

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 Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine

6th Canadian edition

1118644948, 978-1118805084, 1118805089, 978-1118644942

More Books

Students also viewed these Accounting questions

Question

Describe the parts of the self, according to William James.

Answered: 1 week ago