A certain newspaper has an annual subscription price of $338, and annual variable costs per subscriber...

A certain newspaper has an annual subscription price of $338, and annual variable costs per subscriber are $300. Current retention spending is $8 a year per customer resulting in an attrition rate of 23% per year. The marketing department estimates that if the newspaper were to increase its retention spending to $12 a year, the attrition rate would be reduced to 15%. What would be the difference in the CLV if the spending is increased and a discount rate of 13% is used?

Please post the Excel formula

Expert Solution

Sl.No	Descriptions	Existing	Proposal
i	Annual subscription price (Given in question)	338.00	338.00
ii	Annual variable costs (Given in question)	300.00	300.00
iii	Gross profit contribution (i-ii)	38.00	38.00
iv	Retention Cost (Given in question)	8.00	12.00
v	Net profit contribution (iii-iv)	30.00	26.00
vi	Percentage of total customers retained (Given in question)	77%	85%
vii	Net profit contribution of retained customers only (v*vi)	23.10	22.10
viii	Discount rate (Given in question)	13%	13%
ix	Discounted Net profit contribution per retained customer [vii/(1+viii)]	20.44	19.56

The difference in the CLV if the spending is increased is $0.88 per customer

jeff jeffy answered 1 year ago

New Berlin Corporation has annual fixed costs of $800,000, variable costs of $48 per unit, and...

New Berlin Corporation has annual fixed costs of $800,000, variable costs of $48 per unit, and a contribution margin ratio of 40 percent. a. Compute the unit sales price and unit contribution margin for the above product. b. Compute the sales volume in units required for New Berlin Corporation to earn an operating income of $600,000. c. Compute the dollar sales volume required for New Berlin Corporation to earn an operating income of $600,000.

A major daily newspaper charges $460 (paid in advance) for an annual subscription, or $47 per month payable at the end of each month to the carrier.

A major daily newspaper charges $460 (paid in advance) for an annual subscription, or $47 per month payable at the end of each month to the carrier. What is the effective interest rate being charged to the monthly payment subscribers? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Effective interest rate %

Sells price per unit=$200 variable manufacturing costs per unit= $50 variable S&A costs per unit= $10...

Sells price per unit=$200 variable manufacturing costs per unit= $50 variable S&A costs per unit= $10 Fixed MOH= $50,000 Fixed S&A costs=$10,000 Units produced=5000 Units sold= 4000 Produce a full absorption income statement, what is the operating income produce a variable costing income statement, what is the operating income if units produced exceeds untis sold, does full absorption accounting or varible cost account result in a higher operating income

The annual subscription to a magazine costs $50 and this cost is expected to increase by...

The annual subscription to a magazine costs $50 and this cost is expected to increase by 10 percent per year. A life subscription, on the other hand, costs $500. The relevant discount rate for analyzing this situation is 12 percent. In order to justify taking out a life subscription, what is your minimum life expectancy (approximately)

The selling price, variable costs, annual fixed costs, annual depreciation charges, and marginal tax rate for...

The selling price, variable costs, annual fixed costs, annual depreciation charges, and marginal tax rate for the project are shown below. If sales are equal to 14,000 units, what is the after-tax profit? Sales Price $3.00 Variable Costs $1.40 Fixed Costs $15,000.00 Depreciation $6,000.00 Tax Rate 35% A mesquite farmer wants you to invest in his mesquite harvesting business. He sells mesquite wood to several "Texas-style" steakhouses that serve authentic "Mesquite-smoked" steaks. He promises to give you all profits for 5 years after...

A project has a projected sales price of $99 a unit, variable costs per unit of...

A project has a projected sales price of $99 a unit, variable costs per unit of $58, annual fixed costs of $238,000, and annual depreciation of $139,000. The tax rate is 22 percent. What is the contribution margin for an analysis using sales units of 12,800? Multiple Choice $27.06 $38.97 $22.41 $41.00 $42.64

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $135

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $135. Customers prepay their subscriptions and receive 260 issues over the year. To attract more subscribers, the company offered new subscribers the ability to pay $130 for an annual subscription that also would include a coupon to receive a 40% discount on a one-hour ride through Central Park in a horse-drawn carriage. The list price of a carriage ride is $125 per hour. The company estimates that approximately 30%...

A New York City daily newspaper called "Manhattan Today" charges an annual subscription fee of $108....

A New York City daily newspaper called "Manhattan Today" charges an annual subscription fee of $108. Customers prepay their subscriptions and receive 270 issues over the year. To attract more subscribers, the company offered new subscribers the ability to pay $110 for an annual subscription that also would include a coupon to receive a 40% discount on a one-hour ride through Central Park in a horse-drawn carriage. The list price of a carriage ride is $100 per hour. The company...

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $594....

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $594. Customers prepay their subscriptions and receive 290 issues over the year. To attract more subscribers, the company offered new subscribers the ability to pay $560 for an annual subscription that also would include a coupon to receive a 40% discount on a one-hour ride through Central Park in a horse-drawn carriage. The list price of a carriage ride is $550 per hour. The company...

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $216....

A New York City daily newspaper called “Manhattan Today” charges an annual subscription fee of $216. Customers prepay their subscriptions and receive 260 issues over the year. To attract more subscribers, the company offered new subscribers the ability to pay $210 for an annual subscription that also would include a coupon to receive a 40% discount on a one-hour ride through Central Park in a horse-drawn carriage. The list price of a carriage ride is $200 per hour. The company...

Question