Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. From the Income Statement and Balance Sheet of San Miguel Corporation, compute the ROI for 2018 2. Using the IS and BS of San

image text in transcribedimage text in transcribed1. From the Income Statement and Balance Sheet of San Miguel Corporation, compute the ROI for 2018

2. Using the IS and BS of San Miguel Corporation for 2018 with these additional assumptions, compute for the EVA for 2018:

a. Market value of debt is P 1,405.147.67

b. Market value of Equity is P 2,107,720

c. Interest rate on Debt is 8.5%

d. Cost of Equity capital is 11.5%

e. Round-off the tax rate to two decimal places

f. Round-off your answer to two decimal places

3. SMC is considering an investment that is projected to produce operating profits of P 225,000 before depreciation for the next four years. At the beginning of the first year (2021), SMC will invest P 598,400 in an asset that has a 12-year life and with a salvage value of no salvage value of P 20,000. Straight-line depreciation is used. SMC calculates ROI based on end-of-year asset values.

Required:

a. Calculate the ROI using both the Gross and NetBook value by presenting a table

b. Assuming that at the end of the 9th year, an investor wants to buy the asset at a price of P 160,000. As Property Manager of SMC, are you going to sell it? Why or why not?

c. What is the Book value of the property on Dec. 31, 2026?

SAN MIGUEL CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME FOR THE PERIODS ENDED MARCH 31, 2018 AND 2017 (in Millions, Except Per Share Data) 2018 Unaudited 2017 Unaudited SALES (Note 3) P 234,347 P 195,762 COST OF SALES 183,675 151,352 GROSS PROFIT 50,672 44,410 (17,985) (16,897) SELLING AND ADMINISTRATIVE EXPENSES INTEREST EXPENSE AND OTHER FINANCING CHARGES (8,952) (8,200) INTEREST INCOME 1,373 995 46 144 8 (28) EQUITY IN NET EARNINGS OF ASSOCIATES AND JOINT VENTURES GAIN (LOSS) ON SALE OF INVESTMENTS AND PROPERTY AND EQUIPMENT OTHER CHARGES - Net (Note 4) INCOME BEFORE INCOME TAX INCOME TAX EXPENSE (4,217) (1,104) 20,945 19,320 5,336 5,492 NET INCOME 15,609 P 13,828 ANNEX "A" SAN MIGUEL CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF FINANCIAL POSITION MARCH 31, 2018 AND DECEMBER 31, 2017 (in Millions) ASSETS LIABILITIES AND EQUITY 2018 2018 Unaudited 2017 Audited Unaudited 2017 Audited P P P P P Current Assets Cash and cash equivalents (Notes 2.9 and 10) Trade and other receivables - net[Notes 2.5.9 and 10) Inventories (Note 2) Current portion of biological assets -net Prepaid expenses and other current assets/Notes 2, 9 and 10) 235,600 122,972 113,655 3,630 81,502 205,073 116,040 102,575 3,422 78 228 Current Liabilities Loans payable (Notes 2.5, 9 and 10) Accounts payable and accrued expenses/Notes 2, 5, 9 and 10) Finance lease fiabilities - current portior Notes 2, 9 and 10) Income and other taxes payable (Note 2) Dividends payable (Notes 5 and 8) Current maturities of long-term debt-net of debt issue cose Notes 2, 5, 9 and 10) Total Current Liabities 178.293 142,927 17,869 21,543 5,912 41, 256 407 800 149883 135,993 16.889 16,653 4429 36.944 361771 Total Current Assets 558 267 508,338 Noncurrent Assets Noncurrent abilities 36,341 35,537 Long-term dobt-net of current maturites and debt issue costs Notes 2, 5, 9 and 10) Deferred tax liabilities (Note 2) Finance lease abilities - net of current portion Notes 2.9 and 10) Other noncurrent abilities/Notes 2, 6, 9 and 10 Total Noncurrent Liabilities 501,314 21,626 136,617 26,608 686,065 362 548 20674 138,008 25 580 546 810 42,040 22,069 589,878 523,585 Investments and advances - net Financial assets at fair value through other comprehensive income (Notes 9 and 10) 9 Property, plant and equipment - netfNotes 2 and 6) Investment property.net Biological assets.net of current portion Goodwill - net (Note 2) Other intangible assets - net (Note 2) - Deferred tax assets 7,800 7.162 2.789 2,695 131,059 60,124 Equity Equity Attributable to Equity Holders of the Parent Company Capital stock - common Capital stock - preferred - Additional paid in capital Equity reserves Retained camninga Appropriated Unappropriated Treasury stock 16,436 10,187 177,781 (5,627) 16,435 10, 187 177,750 (4.799) 134,542 134,438 18,721 18,412 Other noncurrent assets-net(Notes 2, 5, 9 and 10) 58,355 49,282 66,690 147.822 (109, 501 303.788 183 137 486,928 66 890 143 335 (109.501) 300 297 170765 471062 Non-controlling Interests (Note 2) Total Noncurrent Assets 1,022,623 873 305 Total Equity SAN MIGUEL CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME FOR THE PERIODS ENDED MARCH 31, 2018 AND 2017 (in Millions, Except Per Share Data) 2018 Unaudited 2017 Unaudited SALES (Note 3) P 234,347 P 195,762 COST OF SALES 183,675 151,352 GROSS PROFIT 50,672 44,410 (17,985) (16,897) SELLING AND ADMINISTRATIVE EXPENSES INTEREST EXPENSE AND OTHER FINANCING CHARGES (8,952) (8,200) INTEREST INCOME 1,373 995 46 144 8 (28) EQUITY IN NET EARNINGS OF ASSOCIATES AND JOINT VENTURES GAIN (LOSS) ON SALE OF INVESTMENTS AND PROPERTY AND EQUIPMENT OTHER CHARGES - Net (Note 4) INCOME BEFORE INCOME TAX INCOME TAX EXPENSE (4,217) (1,104) 20,945 19,320 5,336 5,492 NET INCOME 15,609 P 13,828 ANNEX "A" SAN MIGUEL CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF FINANCIAL POSITION MARCH 31, 2018 AND DECEMBER 31, 2017 (in Millions) ASSETS LIABILITIES AND EQUITY 2018 2018 Unaudited 2017 Audited Unaudited 2017 Audited P P P P P Current Assets Cash and cash equivalents (Notes 2.9 and 10) Trade and other receivables - net[Notes 2.5.9 and 10) Inventories (Note 2) Current portion of biological assets -net Prepaid expenses and other current assets/Notes 2, 9 and 10) 235,600 122,972 113,655 3,630 81,502 205,073 116,040 102,575 3,422 78 228 Current Liabilities Loans payable (Notes 2.5, 9 and 10) Accounts payable and accrued expenses/Notes 2, 5, 9 and 10) Finance lease fiabilities - current portior Notes 2, 9 and 10) Income and other taxes payable (Note 2) Dividends payable (Notes 5 and 8) Current maturities of long-term debt-net of debt issue cose Notes 2, 5, 9 and 10) Total Current Liabities 178.293 142,927 17,869 21,543 5,912 41, 256 407 800 149883 135,993 16.889 16,653 4429 36.944 361771 Total Current Assets 558 267 508,338 Noncurrent Assets Noncurrent abilities 36,341 35,537 Long-term dobt-net of current maturites and debt issue costs Notes 2, 5, 9 and 10) Deferred tax liabilities (Note 2) Finance lease abilities - net of current portion Notes 2.9 and 10) Other noncurrent abilities/Notes 2, 6, 9 and 10 Total Noncurrent Liabilities 501,314 21,626 136,617 26,608 686,065 362 548 20674 138,008 25 580 546 810 42,040 22,069 589,878 523,585 Investments and advances - net Financial assets at fair value through other comprehensive income (Notes 9 and 10) 9 Property, plant and equipment - netfNotes 2 and 6) Investment property.net Biological assets.net of current portion Goodwill - net (Note 2) Other intangible assets - net (Note 2) - Deferred tax assets 7,800 7.162 2.789 2,695 131,059 60,124 Equity Equity Attributable to Equity Holders of the Parent Company Capital stock - common Capital stock - preferred - Additional paid in capital Equity reserves Retained camninga Appropriated Unappropriated Treasury stock 16,436 10,187 177,781 (5,627) 16,435 10, 187 177,750 (4.799) 134,542 134,438 18,721 18,412 Other noncurrent assets-net(Notes 2, 5, 9 and 10) 58,355 49,282 66,690 147.822 (109, 501 303.788 183 137 486,928 66 890 143 335 (109.501) 300 297 170765 471062 Non-controlling Interests (Note 2) Total Noncurrent Assets 1,022,623 873 305 Total Equity

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

M: Finance

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260772357, 9781260772357

More Books

Students also viewed these Finance questions

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago

Question

=+What kind of question would you ask to encourage their response?

Answered: 1 week ago

Question

=+Does it keep the visitor reading?

Answered: 1 week ago