Excel DCF Valuation Model
Budget: $30 – $250 USD
I need a detailed Excel DCF valuation model for HumanSoft Holding, covering both FCFF and FCFE. The model should include:
- Historical data for the past 3 years
- Cash flow projections for the next 5 years
- Specific industry benchmarks I will provide
Ideal skills and experience:
- Expertise in DCF valuation, FCFF, and FCFE
- Proficiency in Excel, especially financial modeling
- Experience with industry-specific benchmarks
Please provide samples of similar work done.
Project Description:
We are a group of MBA students working on a discounted cash flow (DCF) valuation assignment for HumanSoft Holding Co. (Kuwait-listed company). We need support to complete two specific parts of the project:
Scope of Work:
1. Build Forecasted FCFF & FCFE Cash Flows:
• Use financial data from HumanSoft Holding’s recent financials (last 3–5 years).
• Forecast 3 years of cash flows, then add 1 extra year (Year 6).
• Calculate the Terminal Value using the Gordon Growth Model for both FCFF and FCFE.
• Apply and justify the choice of WACC (for FCFF) and Cost of Equity (for FCFE).
• Choose and justify a realistic terminal growth rate (g) based on company performance, industry data, or academic references.
2. Valuation & Target Share Price:
• Use NPV to calculate:
• Enterprise Value via FCFF → Equity Value → Target Share Price
• Equity Value via FCFE → Target Share Price
• Compare the calculated prices to the current market price of HumanSoft on Boursa Kuwait.
• Give a short investment recommendation (Buy, Hold, Sell) based on the valuation gap and company performance.
⸻
Deliverables:
• Fully functional Excel file, structured clearly:
• Input section for assumptions (WACC, g, etc.)
• Cash flow forecasts for FCFF and FCFE
• Terminal value calculations
• NPV and share price output
• Brief explanation (1 page max) of:
• Inputs and justifications
• Valuation summary
• Final share price comparison and recommendation
⸻
Requirements:
• Strong background in DCF modeling, WACC, and FCFE/FCFF valuation
• Must use HumanSoft’s actual financials (available via Boursa Kuwait or financial sites like Zawya, MarketScreener)
• Must cite sources (APA or simple URLs) for all variables
• Deadline: within 4–5 days
- Historical data for the past 3 years
- Cash flow projections for the next 5 years
- Specific industry benchmarks I will provide
Ideal skills and experience:
- Expertise in DCF valuation, FCFF, and FCFE
- Proficiency in Excel, especially financial modeling
- Experience with industry-specific benchmarks
Please provide samples of similar work done.
Project Description:
We are a group of MBA students working on a discounted cash flow (DCF) valuation assignment for HumanSoft Holding Co. (Kuwait-listed company). We need support to complete two specific parts of the project:
Scope of Work:
1. Build Forecasted FCFF & FCFE Cash Flows:
• Use financial data from HumanSoft Holding’s recent financials (last 3–5 years).
• Forecast 3 years of cash flows, then add 1 extra year (Year 6).
• Calculate the Terminal Value using the Gordon Growth Model for both FCFF and FCFE.
• Apply and justify the choice of WACC (for FCFF) and Cost of Equity (for FCFE).
• Choose and justify a realistic terminal growth rate (g) based on company performance, industry data, or academic references.
2. Valuation & Target Share Price:
• Use NPV to calculate:
• Enterprise Value via FCFF → Equity Value → Target Share Price
• Equity Value via FCFE → Target Share Price
• Compare the calculated prices to the current market price of HumanSoft on Boursa Kuwait.
• Give a short investment recommendation (Buy, Hold, Sell) based on the valuation gap and company performance.
⸻
Deliverables:
• Fully functional Excel file, structured clearly:
• Input section for assumptions (WACC, g, etc.)
• Cash flow forecasts for FCFF and FCFE
• Terminal value calculations
• NPV and share price output
• Brief explanation (1 page max) of:
• Inputs and justifications
• Valuation summary
• Final share price comparison and recommendation
⸻
Requirements:
• Strong background in DCF modeling, WACC, and FCFE/FCFF valuation
• Must use HumanSoft’s actual financials (available via Boursa Kuwait or financial sites like Zawya, MarketScreener)
• Must cite sources (APA or simple URLs) for all variables
• Deadline: within 4–5 days