WuExp19ExcelCh06CapDirectMarketing

Taylor Wu Direct Marketing 1430deefeb65651e678529cab31ae2ccbd035d1f.xlsx Direct Marketing Inputs Gross Profit Net Profit Net Profit Number of Ads 10000 2.00% $ 2,500.00 $ 50.00 2.00% Click Rate 6.83% 2.50% $ 3,125.00 $ 562.50 2.50% 3.00% $ 3,750.00 $ 1,075.00 3.00% Parameters 3.50% $ 4,375.00 $ 1,587.50 3.50% Design Fee $ 2,000.00 4.00% $ 5,000.00 $ 2,100.00 4.00% Cost Per Ad $ 2.25 4.50% $ 5,625.00 $ 2,612.50 4.50% Total Clicks 682.92682927 5.00% $ 6,250.00 $ 3,125.00 5.00% Profit Per Click $ 12.50 5.50% $ 6,875.00 $ 3,637.50 5.50% Gross Profit $ 8,536.59 6.00% $ 7,500.00 $ 4,150.00 6.00% Net Profit $ 5,000.00 6.50% $ 8,125.00 $ 4,662.50 6.50%

Taylor Wu Direct Marketing 1430deefeb65651e678529cab31ae2ccbd035d1f.xlsx 10000 15000 20000 25000 30000 35000 40000 $ 50.00 $ 1,075.00 $ 2,100.00 $ 3,125.00 $ 4,150.00 $ 5,175.00 $ 6,200.00 $ 562.50 $ 1,843.75 $ 3,125.00 $ 4,406.25 $ 5,687.50 $ 6,968.75 $ 8,250.00 $ 1,075.00 $ 2,612.50 $ 4,150.00 $ 5,687.50 $ 7,225.00 $ 8,762.50 $ 10,300.00 $ 1,587.50 $ 3,381.25 $ 5,175.00 $ 6,968.75 $ 8,762.50 $ 10,556.25 $ 12,350.00 $ 2,100.00 $ 4,150.00 $ 6,200.00 $ 8,250.00 $ 10,300.00 $ 12,350.00 $ 14,400.00 $ 2,612.50 $ 4,918.75 $ 7,225.00 $ 9,531.25 $ 11,837.50 $ 14,143.75 $ 16,450.00 $ 3,125.00 $ 5,687.50 $ 8,250.00 $ 10,812.50 $ 13,375.00 $ 15,937.50 $ 18,500.00 $ 3,637.50 $ 6,456.25 $ 9,275.00 $ 12,093.75 $ 14,912.50 $ 17,731.25 $ 20,550.00 $ 4,150.00 $ 7,225.00 $ 10,300.00 $ 13,375.00 $ 16,450.00 $ 19,525.00 $ 22,600.00 $ 4,662.50 $ 7,993.75 $ 11,325.00 $ 14,656.25 $ 17,987.50 $ 21,318.75 $ 24,650.00