Which streaming plan is worth the ad budget?

A streaming service in Toronto sells several plans. Finance wants the customer lifetime value over a fixed horizon, with churn and discounting, and the month in which each plan pays back its acquisition cost.

Task: line 1 is the horizon H in months. Line 2 is the monthly discount rate d in percent (decimal). Line 3 is the number of plans n. Then n lines name price margin churn cac: monthly price, gross margin in percent, monthly churn in percent, and acquisition cost per customer (all numbers, name has no spaces). For months t = 1..H the discounted contribution of one acquired customer is price * margin/100 * (1 - churn/100)^(t-1) / (1 + d/100)^t. The clv is the sum over the horizon, and net = clv - cac. The payback month is the first t where the running sum of contributions reaches cac or more, or never if that does not happen within the horizon. Print one line per plan, sorted by net descending (ties by name ascending), as name clv=A net=B payback=P with A and B to 2 decimals.