European green public procurement policy Finance Assignment Help With Solution

European green public procurement policy Finance Assignment Help With Solution

 
European green public procurement policy, the traffic and use of traditional incandescent lamps is gradually prohibited, in order for energy-saving lamps to be exclusively used.
 
The Municipality of “Athecheias” spends € 1.053.010 per year on electricity, for the lighting of roads, parks and other outdoor spaces. According to studies by the same municipality, the replacement of the existing lighting technology with energy-saving lamps, in accordance with that European policy will result in reduced lighting costs by 70%. The municipality wants to carry out the above investment, without having the required funds.
 
Consequently, the municipal authorities aimed at a private investor, through public-private contracts (also known as Public-Private Partnership or PPP).
The private investor has to pay the entire amount of the capital required (See Table 1), at the beginning of a certain 12-year contract, during which they annually receive the benefit resulting from the use of economical light bulbs. At the end of these 12 years, the total investment including the equipment becomes the exclusive property of the municipality.
 
Also, it is given, that the start-up costs are € 225,000 (See Table 2), the operating costs are also given and percent change per year (See Tables 3,4). Also the profits tax rate is 26%, while depreciation is calculated linearly in the 12 years (straight-line depreciation method). Finally, the required return on this investment is estimated at 12% per annum.

 

 
As a junior analyst of this private investment company, you are required, based on the data given, to evaluate this investment using the method of the Net Present Value (NPV).
 
The documentation of your judgment (decision) should be presented in PowerPoint, the presentation including the spreadsheets you used to capture the following tables:
 
1. Income Table
2. Costs Table
3. Depreciation Table
4. Income Statement (given)
5. Statement of Cash Flows
 
Translation of the Table:
 
Title: Capital Expenditure (Table 1)
Line 1: Lighting of Roads -> €1,325,000
Line 2: Lighting of Parks -> €340,600
Line 3: Repairs -> €211,000
Line 4: Control System -> €23,400
TOTAL: €1,900,000
 
Translation of the Table:
Title: Start-up Costs (Table 2)
Line 1: Independent Technical Auditor -> €30,000
Line 2: Technical Advisor -> €30,000
Line 3: Public Tender -> €55,000
Line 4: Installation Expenses -> €50,000
TOTAL: €165,000
 
Translation of the Table:
Title: Operating Costs (Table 3)
Line 1: Administrative Costs -> €60,000
Line 2: Operation and Maintenance Costs (years 1-5) -> €0
Line 3: Operation and Maintenance Costs (years 5-12) -> €48,123
Line 4: Insurance Cost -> €10,000
TOTAL: €118,123
 
Translation of the Table:
Title: Price Growth Rates (Rates in which the prices increase) (Table 4)
Line 1: In the Electricity Company Cost -> 3,00%
Line 2: In the Insurance Cost -> 3,00%
Line 3: In the Administrative Costs -> 2,00%
Line 4: In the General Costs -> 1,00%
 
Translation of the Table:
 
Title: Income Statement (pattern to be used)
The numbers on top of the Table from 1 to 12 are the years of the investment (The investment lasts for 12 years)
The numbers from 2015 to 2026 are the date (obviously :P)
 
The rest of the financials that need to be calculated are:
 
1. Comprehensive Ιncome (Total Income)
2. Total Operating Costs
3. Earnings Before Interest, Taxes, Depreciation, Amortization and Exceptional Items (EBITDAE)
4. Depreciation
5. Earnings Before Taxes
6. Taxes
7. Net Profit
 
 

Product Code :Fin118

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.