DCF_Model!E2:E6 | cut factor used Year-1 so Year 1 kept 1.0000 (sample) with no cut | use ^Year so Year 1 is 0.9368 (sample)
DCF_Model!F13 | terminal value cut back 4 years instead of 5 | cut back 5 years with the Year-5 factor
WACC_Check!F2:F4 | debt cost used pre-tax 4.50% (sample) giving WACC 6.90% (sample) | use after-tax 3.74% (sample) giving WACC 6.75% (sample)
DCF_Model!F12 | terminal numerator grew cash twice with (1+g)^2 | grow once with single (1+g)
DCF_Model!F16 | net debt S$200,000 (sample) added to enterprise value | subtract net debt to reach equity S$3,112,133 (sample)
Oxaide • UEN 201806463W • Research, not advice • REF SAMPLE-dcf-audit
