
Open
Posted
•
Ends in 3 hours
I have a set of revenue projections already organised in Excel and I need them transformed into a complete Discounted Cash Flow model. The end goal is to arrive at a defensible enterprise valuation and then present the key drivers—free cash flow, terminal value, sensitivities, and valuation range—in an interactive Power BI report. Here is how I picture the flow of work: • Build a flexible, fully-linked DCF in Excel starting from the provided revenue projections. You will add the missing schedules (operating costs, capex, working capital, depreciation, tax, WACC) with clear, editable assumptions so that I can tweak scenarios later. • Include standard valuation outputs—NPV, IRR, sensitivity tables for WACC and growth, and a concise summary dashboard inside the workbook. • Once the model balances and all checks pass, connect it to Power BI and create a sleek report. I want slicers for scenario selection and visuals such as waterfall charts, contribution analyses, and a high-level valuation funnel that makes the story easy to grasp for non-finance stakeholders. Deliverables 1. Excel file with the dynamic DCF model, clearly separated input, calculation and output tabs. 2. Power BI (.pbix) file pulling directly from the model and reflecting the visuals described above. 3. A brief walkthrough (recorded video or call) so I am comfortable updating assumptions on my own. Acceptance criteria: model flows correctly with zero circular errors, cash flows tie to financial statements, sensitivity results update instantly, and the Power BI report refreshes without manual intervention. If you have recent experience building DCFs and visualising them in Power BI, I’d love to see a sample. Let’s create a valuation tool that looks as good as it calculates.
Project ID: 40467284
40 proposals
Open for bidding
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $22 USD/hour for this job

As a seasoned financial analyst with a formidable background in Excel-based financial modeling and impressive experience with Power BI, I am confident that my skillset equips me extraordinarily well to execute your project. I have built dynamic DCF models that cater to their unique requirements, and I'm prepared to create an elegant and interconnected spreadsheet while ensuring every valuation feature you desire is integrated perfectly. My use of clear assumptions allows me to provide the flexibility you need for future scenario testing, an important aspect that doesn't receive enough attention. More than just constructing the model to generate a detailed cash flow statement, I am equipped with the ability to present the story your figures tell convincingly. Thanks to my expertise in Power BI, I am fully capable of transforming this intricate DCF model into an interactive dashboard comprising your requested visualizations—waterfall charts, contribution analyses, and even a valuation funnel—so that non-finance stakeholders can effortlessly apprehend the data. What sets me apart is not just my proficiency with Power BI and Excel, but my passion for delivering beyond expectations. My assignments go beyond completion; they become meaningful relationships where I continuously offer support even after the contract has ended.
$15 USD in 5 days
7.9
7.9

Warm greetings! As a seasoned financial modeling and Power BI specialist with over 9 years of experience, I specialize in building dynamic DCF valuation models that are audit-friendly, fully linked, and designed for scenario analysis. I can transform your revenue projections into a complete enterprise valuation tool with an executive-level Power BI dashboard. Here’s how I can help: * Build a flexible Excel DCF with WACC, capex, depreciation, tax, and working capital schedules * Create linked NPV, IRR, terminal value, and sensitivity analysis outputs * Develop interactive Power BI visuals including waterfall charts, valuation funnels, and scenario slicers * Ensure zero circular-reference errors and fully balanced cash flow logic * Provide a walkthrough session so your team can confidently update assumptions I’ve recently delivered valuation and forecasting models for startups and investment analysis projects with automated Power BI reporting and live-refresh functionality. Do you already have historical financial statements available, or should I also structure baseline assumptions from scratch?
$20 USD in 40 days
7.3
7.3

With nearly a decade of experience as a Chartered Accountant and ACA qualified professional, I have built numerous end-to-end financial models like the DCF model you need for your revenue projections. My skills and expertise lie not only in creating accurate models, but also in connecting those models into powerful visualization tools - like Power BI - that relay complex financial data in a digestible way for non-finance stakeholders. My prior work showcases an ability to build fully-linked and flexible models with clear, editable assumptions, which is essential for your goal of tweaking scenarios later on. With added expertise in independent business valuation, I have strong familiarity with the NPV, IRR, and sensitivity tables that you require for your DCF model.
$20 USD in 40 days
6.2
6.2

Hi, This looks like the type of work I usually handle. I’ve worked with Data Visualization, Business Analysis, Excel, Financial Analysis, Finance, Power BI, Financial Modeling and Statistics and similar projects before. Let me know if you'd like to discuss your project.
$15 USD in 24 days
5.3
5.3

Hi, With over seven years of experience in financial modeling and data visualization, I am well-equipped to transform your revenue projections into a comprehensive Discounted Cash Flow (DCF) model. I will meticulously build a flexible and fully-linked DCF in Excel, incorporating essential schedules while ensuring clarity and editability of assumptions for future scenario analyses. My strong attention to detail will guarantee that all calculations balance, cash flows align with financial statements, and sensitivity analyses are accurate and instantly updated. Your deliverables will be organized in distinct tabs, making it easy to navigate through inputs, calculations, and outputs. I prioritize clear communication and will maintain a consistent flow of information throughout the project to ensure alignment with your vision. As I connect the DCF model to Power BI, I will create an interactive report that highlights key drivers and visualizes the story effectively for all stakeholders. I am committed to meeting the agreed timeline and will provide a brief walkthrough to empower you to adapt the model confidently. Let’s collaborate to create a standout valuation tool that balances aesthetics with robust calculations.
$20 USD in 7 days
5.2
5.2

With over 15 years of experience as a Finance & Accounting Expert and a CFO, I'm adept at building powerful financial models. I specialize in crafting Discounted Cash Flow models just like what you're looking for, and have created a number of them that are already functioning seamlessly, producing defensible enterprise valuations and presenting key insights. Being a QuickBooks ProAdvisor adds an extra layer of versatility to my portfolio. I'm comfortable working extensively with Excel, which makes converting your existing revenue projections into a comprehensive DCF model second nature to me. By hiring me, not only are you assured of an accurately balanced model and dynamic cash flows but also an appealing Power BI report that tells the valuation story like never before. Finally -- and perhaps most essentially, I'm passionate about enabling my clients to utilize my work independently. When I deliver your project, I'll ensure you're comfortable with every aspect of the newly set-up system from assumptions to updating scenarios in Power BI. I assure you that not only will your expectations be met but exceeded. Together let's create something beautiful that looks as good as it calculates – a valuation tool that's effective for non-finance stakeholders but powerful enough for financial analysts. Looking forward to discussing details further with you! I HAVE SAMPLES TO SHOW راسلني أخى الكريم و سنصل لاتفاق أن شاء الله
$20 USD in 40 days
4.8
4.8

Hi, Thank you for sharing the detailed requirements. I understand you need a dynamic DCF valuation model built in Excel and connected to a professional Power BI dashboard for interactive valuation analysis and executive-level reporting. I can help with: • Building a fully linked DCF model from your revenue projections • Creating operating cost, capex, working capital, depreciation, tax, and WACC schedules • Developing valuation outputs including NPV, IRR, terminal value, and sensitivity analysis • Structuring clean input, calculation, and output tabs for easy scenario management • Designing an interactive Power BI dashboard with slicers, waterfall charts, valuation funnels, and contribution analysis visuals ### Deliverables • Dynamic Excel DCF model with editable assumptions • Interactive Power BI `.pbix` report • Sensitivity and scenario analysis dashboards • Walkthrough session/video for future updates and maintenance The final solution will be designed for accuracy, scalability, and easy interpretation by both finance and non-finance stakeholders, with automated Power BI refresh support and clean reporting structure. I focus on reliable financial modeling, business-focused reporting, and interactive Power BI solutions that help simplify complex valuation insights. Looking forward to discussing your project further. Best regards, Nidhi
$20 USD in 40 days
4.6
4.6

AM READY TO START ASAP: DCF VALUATION MODEL + POWER BI DASHBOARD – REVENUE PROJECTIONS, FCF, WACC, SENSITIVITY, NPV, IRR Hello, I am John K., MSc Econ & Statistician, 15+ years, 1,000+ projects, 4.9⭐. My expertise includes DCF modeling, financial analysis, WACC, sensitivity tables (NPV/IRR), and Power BI visualization. My understanding is: You have revenue projections in Excel. You need a complete DCF model (operating costs, capex, working capital, depreciation, tax, WACC) leading to enterprise valuation. Outputs: NPV, IRR, sensitivity tables for WACC/growth. Then connect to Power BI for an interactive report with slicers, waterfall charts, contribution analyses, and valuation funnel. Deliverables: Excel DCF model (.xlsx), Power BI report (.pbix), and brief walkthrough video/call. I will deliver: ✅ A fully dynamic, flexible DCF model with zero circular errors. ✅ Sensitivity tables updating instantly. ✅ A Power BI report refreshing without manual intervention. I am ready to begin. Let's connect via chat to receive your Excel revenue projections and discuss any existing assumptions. Respectfully, John K.
$15 USD in 40 days
4.6
4.6

I can transform your Excel revenue projections into a robust DCF model and an interactive Power BI dashboard, mirroring the analytical depth seen in successful valuation projects. My approach will focus on building a defensible valuation by clearly articulating key drivers and sensitivities. My technical plan involves developing a dynamic Excel DCF model, incorporating all necessary schedules (OpEx, CapEx, Working Capital, Depreciation, Tax, WACC) with explicit, editable assumptions. I will then integrate this model with Power BI, leveraging DAX for calculations and creating interactive visuals to showcase FCF, Terminal Value, WACC, sensitivity analyses (e.g., growth rate, discount rate), and a clear valuation range. To ensure alignment, could you clarify the desired level of detail for the WACC calculation (e.g., specific CAPM inputs)? Also, are there any particular industry benchmarks you'd like to incorporate into the sensitivity analysis? I'm eager to discuss how I can deliver this valuation and visualization efficiently.
$25 USD in 7 days
4.0
4.0

I understand you need a Discounted Cash Flow model built in Excel from your existing revenue projections, culminating in a defensible enterprise valuation presented through an interactive Power BI report highlighting free cash flow, terminal value, sensitivities, and valuation range. I recently completed a similar project where I developed a dynamic DCF model in Excel that accurately projected a company's valuation, which was then integrated into a Power BI dashboard for executive review. My approach will involve creating a fully linked Excel DCF model, starting with your revenue projections and incorporating essential schedules for operating costs, capex, working capital, depreciation, tax, and WACC. I will use standard Excel formulas and functions, ensuring all assumptions are clearly labeled and editable. The generated valuation output will then be imported into Power BI, where I will build interactive visuals using DAX to display key drivers, sensitivities, and the valuation range. What is the specific methodology you prefer for calculating the terminal value? Ready to start as soon as you confirm scope.
$25 USD in 7 days
3.7
3.7

In a project as important as yours, accuracy, versatility and the ability to add value are key. As an actuarial graduate specialized in financial modelling, I bring that rare trifecta to the table alongside my experience with Power BI and Excel. Through my training and internship experience, I've developed an inherent understanding across various financial components. This means not only constructing an accurate DCF model, but also recognizing the underlying uncertainty and interpreting its impact on your valuation. Of course, a great model is useless if it can't be navigated easily or understood by non-finance stakeholders. That’s where my proficiency in data visualization and dashboard building shines — I'll ensure your stakeholders not only grasp your valuation story but can tweak different scenarios effortlessly using slicers in Power BI. Beyond the technical frontend, I take pride in delivering clean outputs backed by solid assumptions - a direct benefit of combining my quantitative training with a practical business sense. Furthermore, with me on board you can rely on attention to detail that will keep everything from cash flow statements to sensitivity tables in sync. In short, I’ll produce work that flows cleanly and paints a picture that resonates with clarity and confidence.
$20 USD in 40 days
3.7
3.7

This is a strong fit for my background. I’ve built investor-grade DCF models and connected them into Power BI dashboards for founders, PE teams, and finance stakeholders who needed both analytical rigor and presentation clarity. I’d structure the Excel model with clean assumption drivers, fully linked schedules, audit checks, dynamic sensitivity tables, and scenario toggles so it remains usable long after delivery. Then I’d build a Power BI layer with valuation waterfalls, WACC/growth sensitivities, terminal value contribution, and executive-friendly visuals that refresh directly from the workbook. Most DCF models fail because they’re technically “correct” but impossible to maintain — I focus heavily on transparency and usability. Estimated timeline: 4–7 days Estimated cost: USD 600–1,500 depending on model depth and reporting sophistication.
$25 USD in 40 days
3.7
3.7

Hi, I’d be excited to help you turn your existing revenue projections into a fully dynamic DCF valuation and Power BI decision tool. We have experience building institutional-style financial models in Excel, including integrated 3-statement forecasting, free cash flow modelling, WACC calculation, terminal valuation, scenario analysis, and sensitivity matrices. My approach focuses on transparency, auditability, and flexibility—cleanly separating Inputs, Calculations, and Outputs so assumptions can be updated easily without breaking the model. For your project, I will: • Build a fully linked DCF with operating cost, capex, working capital, depreciation, tax, and financing schedules • Include valuation outputs such as NPV, IRR, terminal value, and sensitivity tables for WACC/growth assumptions • Add model integrity checks to ensure zero circular references and fully balanced cash flows • Develop an interactive Power BI dashboard with slicers, valuation waterfalls, scenario comparisons, contribution analysis, and executive-friendly visuals • Ensure Power BI refreshes directly from the Excel model with minimal manual intervention I can also provide a walkthrough session and documentation so your team can comfortably maintain and extend the model independently. I’d be happy to share relevant examples of DCF structures and Power BI finance dashboards during discussion. Looking forward to collaborating on this valuation tool. Best regards
$20 USD in 40 days
3.0
3.0

A Warm Hello! I carefully reviewed your requirement, and this is exactly the kind of finance + analytics project where a strong modeling structure and clean visualization layer make a huge difference. The goal is not only to calculate a defensible valuation, but to create a flexible decision-making tool that remains easy to update and present to stakeholders later. I can help you build: A fully dynamic and audit-friendly DCF model in Excel Separate input, calculation, assumption, and output tabs Revenue, opex, capex, depreciation, working capital, tax, and WACC schedules NPV, IRR, terminal value, and sensitivity analysis modules Validation/error-checking structure to eliminate circular issues Interactive Power BI dashboards connected directly to the Excel model Scenario slicers, valuation waterfalls, contribution visuals, and executive-level reporting views The Power BI layer can include: Enterprise valuation funnel Sensitivity heatmaps Free cash flow trend analysis WACC vs growth valuation matrix Scenario comparison dashboards KPI cards for valuation drivers I particularly understand the importance of: Clean financial modeling standards Transparent assumptions and traceability Fast-refresh Power BI integration Stakeholder-friendly storytelling through visuals Building models that remain maintainable long-term Best Regards, Jemin Sagar
$20 USD in 40 days
3.5
3.5

Hi, I specialize in Excel financial modeling and Power BI dashboards. I can build the full DCF model in Excel with NPV/IRR/sensitivity outputs and connect it to an interactive Power BI report with waterfall charts, scenario slicers, and valuation funnel visuals. Deliverables will be clean, well-documented, and easy for you to update. Available to start immediately - happy to discuss the scope in detail.
$20 USD in 40 days
2.5
2.5

Hello! I’m Cora May, and I can help you turn your existing Excel revenue projections into a fully linked, audit-ready Discounted Cash Flow model with defensible enterprise valuation. I’ll build the missing schedules in Excel, operating costs, capex, working capital, depreciation, tax, and WACC, with clear, editable assumptions and built-in checks to ensure the model balances with zero circular errors. You’ll get standard outputs like NPV and IRR, plus sensitivity tables for both WACC and terminal growth that update instantly as you change scenarios. Next, I’ll connect the workbook to Power BI to deliver an interactive valuation story for non-finance stakeholders, including slicers for scenario selection, free-cash-flow and terminal-value visuals, waterfall charts, contribution analyses, and a valuation funnel. In your current Excel, are revenues already broken out by forecast year and scenario, and do you have any target assumptions for WACC/terminal growth or should I propose a starting set? Also, do you want the model aligned to a specific tax rate and depreciation convention (e.g., straight-line, % of capex)?
$20 USD in 23 days
0.0
0.0

This assignment aligns perfectly with my background, and I’ve delivered similar financial modelling and Power BI integration projects for clients focused on valuation and scenario analysis. Your need for a clean, professional, user-friendly DCF model with seamless integration to an automated Power BI dashboard shows you want clarity and flexibility in presenting your enterprise valuation — exactly where my skills come in. I’m proficient in building dynamic Excel models with editable assumptions, complete schedules, and error-free flows, plus creating interactive Power BI reports featuring slicers, waterfall charts, and sensitivity visuals. While new to freelancer, I bring extensive off-site experience and will offer this at a discounted rate to establish my reputation through your positive review. I would like to talk more about your project and discuss the points in which I think this should be handled. Regards, Louis Brink
$15 USD in 40 days
0.0
0.0

⭐⭐⭐⭐⭐ ✅Hi there, hope you are doing well! I recently completed a financial project where I built a dynamic DCF model in Excel linked to Power BI, enabling real-time scenario analysis and executive-friendly visualizations. The key to successfully completing this project is ensuring a fully flexible, error-free linkage between Excel calculations and Power BI visuals for seamless updates. Approach: ⭕ Build a linked DCF model in Excel incorporating all necessary schedules: operating costs, capex, working capital, depreciation, tax, and WACC with clear, editable assumptions. ⭕ Design NPV, IRR, and sensitivity tables with instant update capabilities. ⭕ Prepare separated tabs for inputs, calculations, and outputs ensuring clear navigation. ⭕ Connect Excel to Power BI to create interactive reports with slicers, waterfall charts, contribution analyses, and valuation funnels. ⭕ Provide a walkthrough session for comfortable model updates. Questions: ❓ Would you prefer the walkthrough as a recorded video or a live call? ❓ Are there specific WACC or growth scenarios you want pre-built in sensitivities? I am confident in delivering a robust, user-friendly valuation tool that not only calculates accurately but also tells a compelling story visually. Best regards, Nam
$25 USD in 20 days
0.0
0.0

Hey there, I'm Vishal Maharaj, a Data Visualization expert with 25 years of experience in Power BI and Statistics, based in Perth, Australia. I understand your need to transform revenue projections into a DCF model and visualize it in Power BI. I would approach the project by building a fully-linked DCF in Excel with editable assumptions, incorporating standard valuation outputs, and creating an interactive Power BI report with slicers and insightful visuals. Let's discuss further and bring your valuation tool to life. Cheers, Vishal Maharaj
$20 USD in 40 days
0.0
0.0

Your revenue projections need a complete DCF model behind them and a Power BI report in front. I'll build both end-to-end with clean assumptions you can tweak yourself anytime. I build advanced Excel financial models and Power BI dashboards structured input/calculation/output tabs, dynamic assumptions, and interactive visualizations. I'll add all missing schedules (operating costs, CapEx, working capital, depreciation, tax, WACC), calculate NPV, IRR, and sensitivity tables for WACC and growth scenarios, then connect directly to Power BI for waterfall charts, contribution analysis, and valuation funnel scenario slicers included. What you'll receive: Excel DCF — three clean tabs (Input/Calculation/Output), zero circular errors All schedules built — WACC, FCF, terminal value, NPV, IRR, sensitivity tables Sensitivity tables — instant update on WACC + growth assumption changes Power BI .pbix — direct Excel connection, waterfall + contribution + valuation funnel visuals Scenario slicers — non-finance stakeholders understand the story immediately Auto-refresh — no manual intervention needed Walkthrough video — update assumptions independently after handover What WACC range and terminal growth rate are you working with, and is this a startup projection or an established business with historical financials? I'll build a sample DCF structure with dummy revenue data and share it before you award verify model logic and Power BI visual quality first.
$15 USD in 40 days
0.0
0.0

Dubai, United Arab Emirates
Member since May 25, 2026
₹12500-37500 INR
$10-50 USD
€10000-20000 EUR
$8-15 USD / hour
$2-8 USD / hour
$15-25 USD / hour
₹400-750 INR / hour
£10-15 GBP / hour
₹12500-37500 INR
$15-25 USD / hour
₹750-1250 INR / hour
$30-250 USD
$800-900 USD
$2-8 USD / hour
€8-30 EUR
$250-750 USD
₹750-1250 INR / hour
£250-750 GBP
$250-750 USD
$1000-10000 USD