Spreadsheet Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $70 per visit, the frequency of repurchase is eight times per year, the contribution margin is 20 percent, and the average customer defection rate is 50 percent? Round your answer to the nearest dollar. $ Value of a Loyal Customer Enter data only in yellow cells. Cengage Learning Not for commercial use. Revenue per unit Percent contribution margin to profit and overhead Repurchase frequency (purchases/year) Defection rate $100.00 50.0% 0.25 0.4 Buyer's life cycle VLC 2.50 $31.25