I'm starting to learn corporate finance on my own and have read about this question:
You sell the rights to screen a film on TV once every two years for €0.8m. The film has just been screened. You make the assumption that screenings will be possible for 30 years or in perpetuity. The discount rate is 6%. What is the value of your asset?
The answers to this questions are: €5.34m for the 30-year period €6.47m if it's a perpetuity
For the 30-year period, I have used an excel sheet to discount each cashflow to find 5.34m. I would like to know if there's a formula that I could have used for both situations.