Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USE EXCEL! EXHIBIT 18.5 Semen Indonesia Capital Budget: Project Viewpoint (millions of rupiah) 25,376 32,028 5 1,219,029 2,739,0674,744,982 6,053,589 7,592,941 (365,709) (821,720) 1,423,495 1,816,077) (2,277,882)

image text in transcribed

image text in transcribed

USE EXCEL!

EXHIBIT 18.5 Semen Indonesia Capital Budget: Project Viewpoint (millions of rupiah) 25,376 32,028 5 1,219,029 2,739,0674,744,982 6,053,589 7,592,941 (365,709) (821,720) 1,423,495 1,816,077) (2,277,882) 1,760,000 2,613,320 3,677,347 5,081,487 5,997,512 7,075,059 (240,670) (139,028) 195,379) 150,748) (190,265) 10,000 12,621 15,930 20,106 Exchange rate (Rp/USS) Project Year EBIT Less recalculated taxes @ 30% Add back depreciation Net operating cash flow Less changes to NWC Initial investment Terminal value Free cash flow (FCF) NPV @ 33.257% IRR NwO net working capital NPV-net present value. Discount rate is Semen Indonesia's WACC of 3325790 IRR-internal rate of return, the rate of discount yielding an NPV of exactly zero. Values in exhibit are exact and are rounded to the nearest million. 4 1,760,000 1,760,000 1,760,000 1,760,000 (22,000,000) 21,274.102 (22,000,000) 2,372,650 3,538,319 4,886,09 5,846,764 28,158.896 (7,606,313) 19.1% This highlights the distinction between an income statement and a capital budget. The project's income statement shows losses the first two years of operations as a result of interest expenses and forecast foreign exchange losses, so it is not expected to pay taxes. But the capital budget, constructed on the basis of EBIT, before these financing and foreign exchange expenses,calculates a positive tax payment

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

Contemporary Financial Management Fundamentals

Authors: R. Charles Moyer, James R. McGuigan, Ramesh P. Rao

1st Edition

0324015771, 9780324015775

More Books

Students also viewed these Finance questions

Question

2. Providing time for questions.

Answered: 1 week ago