Answered Spreadsheet Use the Excel template VIC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $0 per veit, the frequency of repurchase is seven times per year, the contribution margin is 20 percent, and the average customer defection rate is 20 percent? Round your answer to the nearest dollar 5