Great Gator Gifts (GGG) launched a Touchdown Club, where Gator fans can create a “wish list” of Gator items. Every year, at the beginning of football season, GGG sends a link to the spouse of each member of the Touchdown Club with a reminder to kick the season off with a special Gator gift. GGG attracted new customers at a cost of $25.00 each and tracked their purchases over a 4-year period. The average annual purchase was $500.00, with a gross margin of 60% and annual per capita marketing expense of $50.00. GGG uses a discount rate of 8%, and the observed annual retention rate of Touchdown Club members was 50%. What was GGG’s 4-year CLV?
https://warrington.video.ufl.edu/Mediasite/Play/0823104c2dc74f8cac525e9872a3bfea1d
https://warrington.video.ufl.edu/Mediasite/Play/ad0ded7acb0e456aa6d1f07e846a27bb1d
Please complete and correct if necessary the Excel file.