Semen Indonesia Project

profilecybacatx
fin.docx
Home>Business & Finance homework help>Semen Indonesia Project

the third HW problem set you will not be doing EOC. Instead you will replicate the Cemex case from the chapter. That means you should know exactly how each number in Exhibits 2 thru 6 are calculated. You will redo those exhibits showing formula in excel. You will submit the excel file for this assignment. 

Your excel file should have one sheet only. Do not do different sheet for each exhibit. Do them one below the other in order. Format well.

Exhibit 2. Investment and Financing of the Semen Indonesia Project (all values in 000s unless otherwise noted)

ex19_02

Exhibit 3 Semen Indonesia’s Debt Service Schedules and Foreign Exchange Gains/Losses

ex19_03

Exhibit 4 Semen Indonesia’s Pro Forma Income Statement (millions of rupiah)

ex19_04

Exhibit 5 Semen Indonesia’s Capital Budget: Project Viewpoint (millions of rupiah)

ex19_05

Exhibit 6 Semen Indonesia’s Remittance and Capital Budget: Parent Viewpoint (millions of rupiah and U.S. dollars)

ex19_06