build an onshore wind farm over 20 years

Suljettu Julkaistu 3 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

Please prepare the following:

1. Financial Model (see the excel file)

2. PowerPoint presentation; please include:

One page presentation on the sensitivities of key drivers (e.g., 10% increase in capex will lead to a 3% decrease in IRR)

3. Please list the top 5 key drivers by impact

The client is hoping to build an onshore wind farm in BC. The client has sent over their assumptions and has requested you to build out a financial model to help them make an investment decision. The details of the model can be found in the excel file attached. The client is hoping to achieve a specific level of return, and needs help setting the price of their output.

Additionally, they are also interested in the sensitivities of the model, i.e., they want to know how a change to any assumption within the model will affect their decisions. The client wants to know the top 5 key drivers behind the model by impact.

Please prepare the financial model and a PowerPoint presentation to share your analysis with the client.

Additional Details

Capacity is expressed in Megawatts (MW)

Capacity factor is the utilization of the turbines (ie. how often the wind blows)

Total Generation Output is expressed in Megawatthours (MWh), it is the volume of power produced in a year. To get from MW to MWh, you need to multiple by 24 and 365 (hours a day, number of days in a year). Then to get to output you need to multiply with the Capacity (utilization).

Levelized cost of energy (LCOE) is the unit price of power produced. Multiplying output with LCOE gives you the revenues.

The debt schedule is based on equal debt service (interest + principal) payments over 20 years. PMT is a standard function in excel that that will give you levelized debt service. Inputs are number of periods, interest rates and present value of debt (ie. initial balance). Try to see if you can calculate based on the Key Assumptions Table on the right.

Capital expenses will need to be calculated based on Key Assumptions: EPC Costs ($/kW) x CAPACITY (MW) will give you the required amount (capital cost of the facility build-out). You will need to convert MW to kW to calculate the correct $ amount.

MACRS depreciation is an accelerated depreciation method for tax purposes. Here the full CAPEX will be depreciated over 5 years.

Powerpoint Excel Financial Modeling

Projektin tunnus: #37474209

Tietoa projektista

16 ehdotusta Etäprojekti Aktiivinen 2 kuukautta sitten

16 freelanceria on tarjonnut keskimäärin $190 tähän työhön

topacademics

I will provide you quality powerpoint presentation design and writing. I am a PhD writer with 10 years of experience. I have worked on several similar projects of presentation writing, and can deliver professional pres Lisää

$120 HKD 1 päivässä
(39 arvostelua)
5.8
syedomairali

Dear Sir, How are you? I am a business & financial Advisor providing services of writing business plans, feasibility studies, financial models & business valuation reports. I am CA finalist from Institute of Chartered Lisää

$650 HKD 7 päivässä
(16 arvostelua)
4.8
mwikalicarolyne2

Hello Kenny L., Good morning I have read the project description, and I am convinced that I am the best person to help you. I have skills in Excel, Financial Modeling and Powerpoint. I have worked in many projects Lisää

$194 HKD 1 päivässä
(3 arvostelua)
4.2
Zakwan555

Hi, I am an experienced certified Cost And Management Accountant and i have more than 7+ years' experience in professional domain. I have gone through your project with interest and it seems a perfect match with my ski Lisää

$300 HKD 1 päivässä
(12 arvostelua)
4.0
zafarfarooq612

Hello, I am eager to take on the task of preparing the financial model and PowerPoint presentation for your proposed onshore wind farm project in BC. Leveraging my extensive expertise in financial modeling and renewab Lisää

$240 HKD 7 päivässä
(35 arvostelua)
4.3
QualityHub

build an onshore wind farm over 20 years I have more than 5 years of experience as a professional writer, I have crafted various types of content such as articles, blogs, research papers, reports, business plans, and Lisää

$100 HKD 1 päivässä
(6 arvostelua)
3.0
amarkumar434936

Hello Kenny L., I went through your project description and it seems like I am a great fit for this job. I am an expert having many years of experience on Infographic and Powerpoint Slide Designing Hi there I am in Lisää

$240 HKD 1 päivässä
(2 arvostelua)
2.3
raojawadahmedna2

Hello, My skillset includesPowerpointdesign, logo design, illustration, vector art, Photoshop and website design which makes me well-suited to tackle this project. Additionally, I am experienced in calculating capita Lisää

$80 HKD 1 päivässä
(1 arvostelu)
1.8
qualityxenter

Affordable, Early Delivery. ★★★★★★★★★★★★★★I hold a Masters degree which gives me the requisite background to handle writing from various subjects. I am a highly committed person towards my work. You can rely on Qualit Lisää

$80 HKD 1 päivässä
(1 arvostelu)
1.5
saurabhforphp

HI, I HAVE CHECKED YOUR REQUIREMENTS AND HAVE UNDERSTOOD. I HAVE 3 YEARS+ OF EXPERIENCE IN WEB DEVELOPMENT. FOR FURTHER DISCUSSIONS CAN WE CHAT?

$150 HKD 10 päivässä
(0 arvostelua)
0.0
Asadjutt111

Hello, my name is Asad, and I am a data wonderland expert with over a decade of experience in the freelancing industry. I understand that you are looking to build an onshore wind farm in BC, and have sent over their as Lisää

$160 HKD 1 päivässä
(0 arvostelua)
0.0
hanifnurrochman8

hello I'm HANIF NURROCHMAN I graduated from vocational high school majoring in IT and am currently working at an internet service company as a Network Operating Center and also as a CS during the night shift and I a Lisää

$160 HKD 7 päivässä
(0 arvostelua)
0.0
amanvishwakarm01

Hello Freelancers!! Congrats for taking this bold step to start a fantastic journey in this jungle of freelancing. With all the awsome skills that you developed and ready to impart and assist clients with their projec Lisää

$160 HKD 7 päivässä
(0 arvostelua)
0.0
Naveedfrl

Hello, I am a business & financial Advisor with 18+ years of experience and provide services of creating Business valuations, Financial Forecasts, business plans & feasibility studies. I am MBA finance from National Lisää

$165 HKD 7 päivässä
(0 arvostelua)
0.0
AsadCopywriter

Hi! It seems that you are looking for financial models. Having a Doctorate and being a business writer for the last 9+ years, I can completely assist you with your financial models. Your financial model will be creat Lisää

$80 HKD 1 päivässä
(0 arvostelua)
0.0