Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

interpretation of this excel sheet in bullet points Financing P&L Input --> Drivers Workings --> Revenue Opex Fixed asset roll-forward Drivers Create a capital budgeting

interpretation of this excel sheet in bullet points
image text in transcribed
image text in transcribed
Financing P&L Input --> Drivers Workings --> Revenue Opex Fixed asset roll-forward Drivers Create a capital budgeting model that uses the inputs listed below. Calculate the projects feability in terms of NPV. IRR, and perform a sensitivity analysis Selected case 2 Installed capacity (MW) second hand branded Ersthand china Arsthand branded 117000 106300 3600 Capacity factor Days in one year Hours per day 1 1 tie Expected for tempo 185 Price per MWH (KR con and branded Ersthand chine 1,100 1.000 100 11 Open af Havenue wond hand branded randa ruanded 31 Estimated to investment in PKR second hand Branded firsthandhi branded 16.000.000 20,000,000 42.600.000 10 3 Utfoy Capes after you Financing facilities Loan par Interest rate La Pepay Senior Facy in 4270.00 115 10 years 05 al 39 . 110 10 10% 10 10 0% 10% 50% 10% 10% 10% SOS Repayment schedule Repayment Tax rate Residual value of the project Comparable companies 30% 14,000,000 Lever 70 Bata 050 0.40 035 sistemi 124 Martti prema Ristret 2.15 123% Installed capacity (MW) second hand branded first hand china first hand branded 117000 105300 93600 Capacity factor Days in one year Hours per day 85% 1 Inflation Expected long-term inflation project 14% Price per MWh (PKR) second hand branded first hand china first hand branded 1,100 1,000 900 Opex as a % of Revenue second hand branded first hand china first hand branded -71% -76% -81% Estimated initial investment (in PKR) second hand Branded first hand china branded 16,000,000 20,000,000 42,608,000 Useful life (years) Capex after year 1 10 3% Financing facilities Loan (pkr) Interest rate Loan Repay Senior Facility in 42,608,000 11% 10 years

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

The Financial Crisis Implications For Research And Teaching

Authors: Ted Azarmi, Wolfgang Amann

1st Edition

3319205870, 978-3319205878

More Books

Students also viewed these Finance questions