Use the Excel template VLC to estimate the value of a loyal customer for a loyal Craftsman tool buyer.

Assume the contribution margin is 0.25, the purchase price is $300 for a certain set of tools, and the repurchase frequency is every five years, and the customer defection rate is 10 percent. If the target market segment for this tool set is one million customers and this firm has a 27 percent market share, what is the VLC for this firm’s target market?