DCF - Bamboozled
I’ve been asked to build a 10 year DCF on an annual basis running from 30 June 2024 (latest balance sheet date) to 30 June 2034. The complexity is however they have asked for me to calculate the NPV assuming a 31 December 2024 valuation date and 31 December 2034 exit date. Could someone please help me understand how I can do this? I’m getting confused as all my cash flows are annual on a 30 June financial year end basis and I have no idea how to discount these back. Any help would be appreciated!
Maybe use the yearfrac function to get the correct discount rate
Never done this so just speculating. Estimate out to Dec24 then re-project annual out 10 years.
Problem isn’t so much the discount rate, but that the valuation date is 6 months from now, so need to get your projections on the same time period
1) Project out the financials on a FY basis out to FY’35.
2) Calendarize them (i.e., CY’24 is the average of FY’24 and FY’25)
3) Use your new CY financials to run the DCF.
Aut est ratione nulla unde ad qui. Fuga molestias autem laudantium. Aperiam et distinctio alias odit vitae esse. Quis porro quam enim quia voluptatum. Qui qui delectus quam commodi.
Blanditiis suscipit sequi assumenda eius ut natus est. Dolorem earum aut aliquam optio voluptas repellat. Nam perspiciatis nam est voluptatem hic veniam iure voluptas.
Et dolor rerum sequi aut. Non omnis beatae facilis et fugit ad quibusdam. Sequi et perferendis aperiam officia repudiandae amet. Ut ducimus quia voluptatem veniam nesciunt.
Tempore dolores culpa molestiae et incidunt eum corrupti. Nihil et cupiditate consequatur porro recusandae enim id. Eos quibusdam qui aut dolor reprehenderit cupiditate. Qui aut doloremque cupiditate ut veritatis voluptas.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...