Gift Card Program - Merchant ROI Worksheet

Gift Card Program-Merchant PROFIT Worksheet
Directions: You can change numbers in the white areas and the worksheet will calculate the profit.

Number of Cards Must be an integer.			Average Card Sales Amount Must be a dollar amount.
Total Cost Per Card Must be a dollar amount.			Total Value of Cards
Total Cost of Cards			Add Value to Existing Card Must be a dollar amount.
Transaction Cost Must be a dollar amount			Total Add Value Dollars
Number of Transactions Per Card Must be an Integer			Total Revenue
Total Cost of Transactions			Profit Margin Percentage (after cost of goods) Must be a Percentage.
Monthly Service Fee Must be a dollar amount.			Total Profit Margin
Total Service Fee			Unredeemed Card Percentage Must be a percentage.
			Unredeemed Value
Total Cost of Program			Total Gross Profit
			Total Cost of Program

			Net Profit