Comprehensive Financial Analysis for Data Center Capex

Job ID: 38603171

Budget: $30 – $250 USD

Overview
Our company is seeking an experienced finance professional to conduct a comprehensive financial analysis for a $4.5 million capital expenditure (capex) project involving the setup of data centers as a brownfield development. The selected freelancer will be responsible for evaluating the financial viability of the project using key financial metrics such as Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period. The analysis will help guide our investment decisions and ensure that the project meets our financial goals.

Project Scope
The financial analysis will focus on the following key components:

Net Present Value (NPV): Calculation of the project’s NPV to assess the value it will generate over time, discounted to present-day terms.
Internal Rate of Return (IRR): Analysis of the IRR to understand the project’s profitability and compare it with our required rate of return.
Payback Period: Determination of the time it will take to recover the initial $4.5 million investment.
Sensitivity & Scenario Analysis: Evaluating the impact of varying assumptions (such as changes in revenue, costs, and external factors) on the project's profitability.
Responsibilities of the Freelancer:

Conduct detailed financial analysis using provided and gathered data, including operational costs, revenue projections, and capital requirements.
Develop a financial model in Excel that accurately reflects the project's cash inflows and outflows.
Perform scenario and sensitivity analysis to assess the project's resilience under different conditions.
Prepare a clear, concise report summarizing the NPV, IRR, Payback Period, and key financial risks associated with the project.
Provide insights and recommendations based on the analysis to guide our decision-making process.
Expected Deliverables:

Financial Model: A dynamic Excel model, including all relevant calculations (NPV, IRR, Payback, etc.) with the ability to adjust variables as needed.
Comprehensive Financial Report: A report detailing the analysis, assumptions used, results, and actionable recommendations.
Risk Assessment: A brief risk analysis, outlining potential financial risks and mitigation strategies.
Presentation of Findings: A summary presentation of the key financial metrics and overall project assessment.
Requirements:

Proven experience in financial analysis, capital budgeting, and investment appraisal, particularly for large-scale projects.
Advanced Excel proficiency, including experience in developing complex financial models with NPV, IRR, and Payback calculations.
Strong analytical skills and attention to detail, ensuring accuracy in financial projections and recommendations.
Ability to clearly communicate findings and provide actionable insights.
Proposal Submission Requirements:

A brief summary of relevant experience, particularly in analyzing capex projects or data center investments.
Examples of similar financial models or projects completed.
Proposed timeline for project completion.
Fee structure, including any potential milestones or payment schedules.
Timeline:
We are looking to engage a freelancer as soon as possible, with the final deliverables expected within 7 days - 9/31/2024.

Submission Deadline:
Please submit your proposal to the submission portal on freelancer.

Please submit your proposal soon by 9/25/2024.