Scribd
Upload
48 views5 pages

Genset

The document provides financial projections for Genset Mandiri from 2022-2027. It projects total revenue of $2.7 billion with net profits of $804 million in 2023 and $1 billion in 2024. Cash flow analysis shows a net present value of $1.459 billion and payback period of 1 year. The comparable investment score is 97% based on these positive financial projections.

Uploaded by

dhkn9t8btg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
48 views5 pages

Genset

The document provides financial projections for Genset Mandiri from 2022-2027. It projects total revenue of $2.7 billion with net profits of $804 million in 2023 and $1 billion in 2024. Cash flow analysis shows a net present value of $1.459 billion and payback period of 1 year. The comparable investment score is 97% based on these positive financial projections.

Uploaded by

dhkn9t8btg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

FINANCIAL RESULTS FOR Genset Mandiri

3000000000 Accounting Impact 2022 2023 2024 2025 2026 2027 Total

Profit and Loss Statement


Total Revenue 0 1,200,000,000 1,500,000,000 0 0 0 2,700,000,000
less Expenditure 0 0 0 0 0 0 0
EBITDA 0 1,200,000,000 1,500,000,000 0 0 0 2,700,000,000

less Accounting Depreciation 0 0 0 0 0 0 0


less Goodwill Amortisation 0 0 0 0 0 0 0
EBIT 0 1,200,000,000 1,500,000,000 0 0 0 2,700,000,000

less Interest
Expense 0 0 0 0 0 0 0
less Tax
Payable 0 -396,000,000 -495,000,000 0 0 0 -891,000,000
Net Profit B4 Ab. Items 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000

add Profit
on Asset disposal 0 0 0 0 0 0 0
Net Profit 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000

Balance Sheet
Assets
Current Assets 0 804,000,000 1,005,000,000 0 0 0
Fixed Assets 0 0 0 0 0 0
Total Assets 0 804,000,000 1,005,000,000 0 0 0

Liabilities
Short-Term Liabilities 0 0 0 0 0 0
Long-term Liabilities 0 0 0 0 0 0
Total Liabilities 0 0 0 0 0 0

Equity
Share Capital 0 0 0 0 0 0
Retained Earnings 0 804,000,000 1,005,000,000 0 0 0
Total Equity 0 804,000,000 1,005,000,000 0 0 0

Total Liabilities and Equity 0 804,000,000 1,005,000,000 0 0 0

3000000000Cash Flow Analysis 2022 2023 2024 2025 2026 2027 Total PV of Capital Commitments after Year 5

Taxable Revenue 0 1,200,000,000 1,500,000,000 0 0 0 2,700,000,000

Page 1 of 5 707502382.xlsxResults 11/25/2023


less Total Expenditure 0 0 0 0 0 0 0
less Tax Payable 0 -396,000,000 -495,000,000 0 0 0 -891,000,000 0
less Interest Expense 0 0 0 0 0 0 0 0
Operating Cash Flow 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000 0

add Non Taxable Income 0 0 0 0 0 0 0


less Capital Expenditure 0 0 0 0 0 0 0
add Asset Disposal Proceeds 0 0 0 0 0 0 0 0
Net Cash Flow 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000 0

5-Yr NPV of Cash Flow 1,459,055,537 100.0%


Infinite Terminal Value 0 0.0%
Total NPV of Cash Flow 1,459,055,537

Page 2 of 5 707502382.xlsxResults 11/25/2023


3000000000Economic Value Added 2022 2023 2024 2025 2026 2027 Total PV of Capital Commitments after Year 5

Total Revenue 0 1,200,000,000 1,500,000,000 0 0 0 2,700,000,000


less Total Expenditure 0 0 0 0 0 0 0
less Tax Payable 0 -396,000,000 -495,000,000 0 0 0 -891,000,000 0
less Interest Expense 0 0 0 0 0 0 0 0
add Asset Disposal Proceeds 0 0 0 0 0 0 0 0
add Economic Adjustments 0 0 0 0 0 0 0 0
Economic Profit 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000 0

Capital Employed 0 0 0 0 0 0 0 0
less CapitalCharge 0 0 0 0 0 0 0 0
Economic Value Added 0 804,000,000 1,005,000,000 0 0 0 1,809,000,000 0

Total PV of EVA 1,459,055,537 100.0%


Infinite Terminal Value 0 0.0%

Total PV of EVA 1,459,055,537

COMPARABLE INVESTMENT SCORE ADDITIONAL ANALYSIS


Result Score Implicit Annual Growth Rates Change in Company Gearing
Return on Invested Capital (> WACC) No Capital 40.00% Total Revenues -100.00% Before (Year 0) 0.00%
Net Present Value of Cash Flows 1,459,055,537 25.00% Total Expenses After (Year 5) 0.00%
Cost/Benefit Ratio No Upfront 5.00% Operating Cash Flow -100.00% Change 0.00%
Payback Period (Year) 1 12.00% Net Cash Flow -100.00%
Free Cash Flow after 2 years 1,809,000,000 15.00% Economic Profit -100.00% Modified Internal Rate of Return
Comparable Investment Score 97.00% EVA -100.00% No solution

Page 3 of 5 707502382.xlsxResults 11/25/2023


Cash Flow Chart Analysis

Annual Cash Flow Cumulative Cash Flow


1.200.000.000 2.000.000.000
1.000.000.000 1.800.000.000
1.600.000.000
800.000.000 1.400.000.000
600.000.000 1.200.000.000
1.000.000.000
400.000.000
800.000.000
200.000.000 600.000.000
400.000.000
0
200.000.000
2022 2023 2024 2025 2026 2027
-200.000.000 0
2022 2023 2024 2025 2026 2027

Annual Cash Flow with Terminal Value


1.200.000.000

1.000.000.000

800.000.000

600.000.000

400.000.000

200.000.000

100
10

13

16

19

22

25

28

31

34

37

40

43

46

49

52

55

58

61

64

67

70

73

76

79

82

85

88

91

94

97
1

Year

Page 4 of 5 707502382.xlsxResults 11/25/2023


Economic Value Added Chart Analysis

Annual Economic Value Added Cumulative Economic Value Added


1.200.000.000 2.000.000.000
1.000.000.000 1.800.000.000
1.600.000.000
800.000.000 1.400.000.000
600.000.000 1.200.000.000
1.000.000.000
400.000.000 800.000.000
200.000.000 600.000.000
400.000.000
0
200.000.000
2022 2023 2024 2025 2026 2027
-200.000.000 0
2022 2023 2024 2025 2026 2027

Annual EVA with Terminal Value


1.200.000.000

1.000.000.000

800.000.000

600.000.000

400.000.000

200.000.000

100
10

13

16

19

22

25

28

31

34

37

40

43

46

49

52

55

58

61

64

67

70

73

76

79

82

85

88

91

94

97
1

Year

Page 5 of 5 707502382.xlsxResults 11/25/2023

You might also like