Answered step by step
Verified Expert Solution
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)
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 paymentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started