
Closed
Posted
Project Title Correct FCFF & FCFE Calculations in Existing Excel DCF Model Project Description I have an existing Excel DCF valuation model that is nearly complete. However, the Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity (FCFE) calculations have been flagged as incorrect during a financial modelling assessment. I'm looking for an experienced financial modelling professional to: Review the existing workbook. Trace every precedent and dependent related to the FCFF and FCFE schedules. Verify all upstream calculations (EBIT, taxes, depreciation, CapEx, working capital, debt movements, etc.). Identify any formula, sign convention, or methodology errors. Correct the FCFF and FCFE calculations according to standard valuation practices. Ensure all formulas remain fully linked (no hard-coded values). Explain every correction made. Deliverables Corrected Excel workbook. Summary of all changes made. Explanation of why the previous calculations were incorrect. Confirmation that the FCFF and FCFE schedules follow accepted DCF methodology. Requirements Applicants should have experience with: Investment Banking financial modelling DCF Valuation FCFF & FCFE Three-statement financial models Working Capital schedules WACC and Enterprise Value calculations Please mention your experience with correcting valuation models or financial modelling test assignments.
Project ID: 40614111
8 proposals
Remote project
Active 2 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
8 freelancers are bidding on average ₹280 INR/hour for this job

With my extensive background in business valuation, financial modeling, and data analysis, I am confident I can provide exceptional value to your current project. My years of experience in Investment Banking have sharpened my skills in precisely the areas you require, specifically DCF valuation, FCFF and FCFE calculations, three-statement financial models, WACC and Enterprise Value calculations. I have a knack for identifying formula errors and ensuring all formulas remain fully linked, which is a critical aspect of your project. For each error found, I assure you I will not only correct it but also deliver a concise summary explaining why the previous calculation was incorrect. This level of transparency is what sets me apart in my field. Moreover, my fluency with Excel's advanced functions and formulas combined with my commitment to timely delivery will ensure an overall smooth transition in the project as we move towards its completion. Partner with me and rest assured that every effort will be exerted to produce an excellent deliverable that adheres strictly to accepted DCF methodology while exceeding your expectations.
₹250 INR in 40 days
6.3
6.3

Thank you for considering my proposal. I have gone through the requirements in detail and understand that your DCF model is largely complete, with the primary issue being the FCFF and FCFE calculations. My focus will be to identify the root cause, correct the methodology, and preserve the integrity of the existing model. I am a Chartered Accountant (ICAI) with 7+ years of experience in financial modelling, valuation, FP&A, and Excel. I have worked extensively with DCF models, three-statement models, FCFF/FCFE, WACC, Enterprise Value, working capital schedules, and investment appraisal. I can trace every formula, verify all linked calculations, eliminate sign or methodology errors, and ensure there are no hard-coded values. You’ll receive the corrected Excel model, a summary of all changes made, and a clear explanation of why the original calculations were incorrect, ensuring the model follows accepted DCF valuation practices. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Timely delivery ✅ 100% commitment to project completion Profile: https://www.freelancer.com/u/caajoys?sb=t I’m ready to review your model immediately and deliver a robust, assessment-ready solution. Best regards.
₹200 INR in 40 days
3.1
3.1

As a chartered accountant finalist, I have spent four years honing my skills in financial modeling and analysis, and your project aligns perfectly with my area of expertise. Not only am I well-versed in DCF valuation, FCFF & FCFE calculations, but I even possess the ability to quickly identify formula or methodology errors and rectify them according to standard practices. My proficiency in Excel is incomparable which is reflected in my work of preparing final statements and scrutinizing client accounts. Apart from this, I also have massive experience in creating adjusted journals, maintaining payroll, and generating various financial reports as required. All these skills combined will aid me significantly in the task at hand. To add to my credibility, I'm frequently engaged with property management tasks requiring attention to detail making sure everything adheres to standard practices - a skillset that will benefit me equally while reviewing your existing workbook. Choose me and be assured of quality work that meets all your requirements on time.
₹300 INR in 40 days
2.1
2.1

Hello, I can review your Excel DCF model, trace the FCFF and FCFE calculations, identify formula or methodology errors, and correct them while keeping all formulas fully linked. I have strong Excel and financial analysis skills and pay close attention to accuracy and detail. I'll provide the corrected workbook along with a clear summary of the changes made and explain each correction. I'm ready to start immediately and can deliver within your timeline. Thank you!
₹250 INR in 40 days
0.1
0.1

Worked with one of the big4s in core valuation domain. I come with experience of being a valuation auditor as well. Happy to serve you.
₹500 INR in 40 days
0.0
0.0

A DCF model is only as reliable as its cash flow calculations. Incorrect FCFF or FCFE formulas can significantly impact enterprise value and equity valuation. As a Chartered Accountant with 10+ years' experience, I have extensive experience in financial modelling, business valuation, FP&A, and investment analysis. 1. Model Review • Trace all precedents and dependents impacting the FCFF and FCFE schedules. • Verify EBIT, taxes, depreciation, CapEx, working capital, debt movements, and other upstream calculations. 2. DCF Validation • Correct methodology, formula logic, sign conventions, and cash flow calculations in line with accepted DCF practices. • Validate the linkage between the three financial statements, FCFF/FCFE, WACC, Enterprise Value, and Equity Value without introducing hard-coded values. 3. Deliverables • Corrected Excel valuation model with fully linked formulas. • Summary of all changes and detailed explanation of each correction. • Confirmation that the FCFF and FCFE schedules follow accepted DCF valuation methodology. • Relevant financial modelling samples have been uploaded to my profile for your review. I have worked extensively on financial models, business valuations, CMA/DPR reports, and investment analysis, including reviewing and correcting valuation models for accuracy and consistency. Let's review the workbook first, after which I'll confirm the timeline and professional fee in chat.
₹240 INR in 40 days
0.0
0.0

Hi there, I read your project description, and I can help you correct the FCFF (Free Cash Flow to Firm) and FCFE (Free Cash Flow to Equity) calculations in your DCF model right away. Since your model is nearly complete, the error is likely in the cash flow buildup—usually, it happens in adjusting Non-Cash Charges, Changes in Net Working Capital, CapEx, or Net Borrowing linkages. With over 6 years of experience in financial modeling and a strong focus on Cash Flow Quality auditing, tracing precedents and dependents to find such errors is my core expertise. I will meticulously review your existing workbook, audit the formula linkages, and fix the calculations so your DCF valuation becomes 100% accurate for your assessment. Could you please share the Excel file? I can take a quick look right now and tell you exactly where the issue is. Best regards, Vikrant Gharde
₹250 INR in 40 days
0.0
0.0

Mumbai, India
Member since Jan 11, 2023
₹750-1250 INR / hour
₹12500-37500 INR
£5000-10000 GBP
$10-30 USD
min $50 USD / hour
₹600-1500 INR
$30-250 USD
$30-250 USD
₹600-1500 INR
$10-30 USD
₹12500-37500 INR
$100-200 AUD
$30-250 USD
£10000-20000 GBP
€6-12 EUR / hour
$250-750 AUD
₹12500-37500 INR
€6-12 EUR / hour
€250-750 EUR
$10-30 AUD