Share
Embed
データサイエンスを活用した契約資産価値評価(LTV)とその改善 / Lifetime Value as Asset Pricing with Data Science
SAWA, Norihiko
February 25, 2022
Transcript
17 slides
-
ϓϩμΫτϚωʔδϟʔɺݚڀһ ᖒل 2 ݄ץ w ܦࡁχϡʔεͷ༗ྉߪಡαʔϏε w ສਓͷ༗ྉߪಡऀ w ֹ݄
ԁʢεϚϗ՝ۚͰ ԁʣ w ץҎདྷɺܖ৳ͼଓ͚͍ͯΔ w ͞ΒͳΔ͕ٻΊΒΕΔ ܦిࢠ൛ w ຊܦࡁ৽ฉࣾೖࣾ w ։ൃԽɺσʔλδϟʔφϦζϜ w ػցֶशʹΑΔهࣄਪનɺݟग़͠ಈըͷࣗ ಈੜɺը૾ղੳ݁ՌʹΑΔΞϓϦͷ69 ্ͳͲ w σʔλαΠΤϯεΛͬͨࣄۀઓུͷཱҊ w ܖܗଶͷݟ͠ʹΑΔࣄۀՁ্ -
"HFOEB 3 w ࣗݾհ w $-7 -57 w ܖࢿ࢈ՁධՁ w
ࣄۀՁධՁ w ײԠੳʹΑΔɺࢪࡦ͝ͱͷܦࡁޮՌͷࢼࢉ w $IVSOੳ w -57ͷվળํ๏ -
◼︎ ਓͷސ٬͔ΒಘΒΕΔকདྷ ΩϟογϡϑϩʔͷׂҾݱࡏՁ ◼︎ ӈਤ୯७ԽͷͨΊɺؒͷ ଘ$-7 $VTUPNFS-JGFUJNF 7BMVF ◼︎
ച্͚ͩͰͳ͘ɺ֫ಘඅ༻ͱҡ࣋ අ༻Λߟྀ ◼︎ ຖ݄ͷղՄೳੑʹΑΓ$BTI JOPVU fl PXచݮ͢Δ 5 ֹ݄ʹଘΛ͔͚ͨͷͷ૯͕ɺ ͦͷސ٬͔ΒকདྷಘΒΕΔΩϟογϡϑϩʔ ࢿ࢈ՁධՁ͕Մೳ αϒεΫܖ ۚ༥ࢿ࢈ͦͷͷ ࠂએඅΛ֫ಘඅ༻ɺγεςϜ։ൃඅΛҡ࣋අ༻ͱͯ͠ො՝ɻ ͰׂҾɻղʢΞϓϦ՝ۚʣΛͱͯ͠ܭࢉɻ ԁ -
αϒεΫͷ ࣄۀՁධ Ձʢ-57ʣ ܖͷ$-7ΛͤࣄۀՁʢ-57ʣʹͳΔ <>$6450.&34"4 "44&54+063/"-0' */5&3"$5*7& ."3,&5*/(70-6.& /6.#&38*/5&3
6 w ্ه؆қࣜɻղܖ͔Βͷܦա݄σϞάϥʹґଘ͢Δ w ࣮ࡍʹίϗʔτ͝ͱʹ$-7Λܭࢉ͠͠߹Θ͍ͤͯΔ ࣄۀՁ -57 = ܖ "316 ܧଓظؒ × × ԁ ສਓ ϲ݄ ղ͕ຖ݄ҰఆͰͷ࣌ ݄࣌ ฏۉސ٬୯Ձ $-7k = T ∑ t=1 $BTI'MPXk,t (1 + i)t -57 = N ∑ k=1 $-7k ίϗʔτ͝ͱͷ$-7ɺ ݄ ʹίϗʔτ ͔ΒಘΒΕΔΩϟογϡϑϩʔɺ ׂҾ $-7k $BTI'MPXk,t t k i $-7 -
◼︎ কདྷͷऩӹΛߟྀͨ͠ࢦඪ ◼︎ αϒεΫࣄۀͰղ ʢ⁶ܧଓظؒʣ૿ݮͷকདྷ ऩӹͷӨڹ͕େ͖͍ ◼︎ ख़ظʹֻ͔ࠩͬͨ͠ࣄۀ Ͱɺղվળ͕ࣄۀ ͷ伴ΛѲΔ
◼︎ ސ٬୯ՁΛࢉೖ͢Δ͜ͱ Ͱɺ୯Ձ૿ͷҙ͚ࣝΛ ߦ͏ ◼︎ কདྷͷࣄۀͷ࢟ʹ͍ͭͯͷ ༧ଌਫ਼͕ߴ·Δ 7 ࣋ଓతͳʹɺղͷվળ͕͔ܽͤͳ͍ -57Λҙࣝ͢Δ ॏཁੑ ݄ ݄ ݄ ݄ ݄ ສ ສ ສ ສ ສ ສ ສ w্هΑΓɺݶք࣌ͷܖ ͱͳΔ w࣮ࡍʹղਃࠐ݄ʹΑͬͯҟͳΔ 4VCTmax = "DR w 4VCTt+1 − 4VCTt = "DR − w ⋅ 4VCTt ݄ ͷ༗ྉܖ ݄࣍ਃࠐʢҰఆͱ͢Δʣ ݄࣍ղʢҰఆͱ͢Δʣ 4VCTt t "DR w ղͱؒਃࠐ͝ͱͷܖͷਪҠ <>-JGFUJNF7BMVFܦిࢠ൛Ͱͷࣄ ۀඪͷཧ -
$IVSOੳͷछྨ 9 ղͷਪҠɺଐੑ͝ ͱͷղͷूܭ ࢪࡦͷɺղʹ༩͑ ΔӨڹͷௐࠪ ఆٛͨ͠είΞʹجͮ ͍ͨࢪࡦͷޮՌͷਪܭ ղͷѲͷͨΊͷूܭɻ ղࢭΛاਤ࣮͠ࢪͨ͠ࢪࡦ͕
࣮ࡍʹղࢭͨ͠ྔΛଌΔɻͦ ͷࢪࡦʹͨͬͨϢʔβʔͷɺ࣮ ࢪલޙͷσʔλΛ༻͍Δɻ ࣮ࡍͷղߦಈʹݱΕΔ·Ͱɺ ϲ݄ఔͭඞཁ͕͋Δɻ "#ςετείΞੳΛߦ͏ ͷ͕ཧ͕ͩɺίετ͕͔͔Δͷ ͕ɻ ղͱ૬ؔͷ͋ΔΤϯήʔδϝ ϯτείΞΛఆٛ͠ɺࢪࡦޮՌ ɺΤϯήʔδϝϯτείΞࣗମ ͦͷมͷ૿ݮΛݟͯஅ͢ Δɻ ܦిࢠ൛ͷείΞ๚ස Ӿཡهࣄຊ͕มɻ ࠓճ͓͢͠Δ͜ͱ -
1SPEVDU5FDIͷࢪࡦɺࣄۀߩݙΛධՁ͠ʹ͍͘ എܠײԠੳͱࢪࡦධՁ 10 ࣄۀՁ (LTV) ܧଓ݄ F V ๚ස ফඅهࣄຊ
ඇࣗൃత ղࢭ Net ARPPU ηοτߪೖ ൢചखྉ ܦIDܾࡁൺ ిࢠ൛ϓϥϯൺ ՝ۚऀ ৽نདྷ๚ऀ ࠶དྷ๚ऀ ແྉମݧਃࠐ ՝ۚ ίϯςϯπϚʔέ ϓϩϞʔγϣϯ ϓϩμΫτ نͷ֦େ ސ٬֫ಘ ղࢭ ൺֱత༰қ ൺֱత༰қ ࠔ ࣄۀߩݙͷ ධՁ త νʔϜ ^ ^ ^ ܦిࢠ൛αϒεΫࣄۀʢݸਓʣͷ,1*πϦʔ ॳճ՝ۚ ηοτ୯Ձ MAU -
◼︎ සൟʹདྷ๚͠ଟ͘ͷهࣄΛ ಡΉϢʔβʔͷղ ͍ ◼︎ ΤϯήʔδϝϯτείΞΛ ఆΊɺΤϯήʔδ֊ڃ͝ͱ ʹϢʔβʔΛྨ͠Ѳ ◼︎ -JHIUϢʔβʔʹΤϯήʔ
δ͍ͨͩ͘͜ͱ͕ඞཁ 11 είΞʹج͍ͮͨϢʔβʔྨΛߦ͍ɺ.JEEMFҎ্ͷϢʔβʔͷׂ ߹Λ,1*ͷҰͭʹઃఆɻ w ΤϯήʔδϝϯτείΞ Λఆٛ w ''SFRVFODZʢ๚සʣ w 77PMVNFʢফඅهࣄຊʣ w ͝ͱͷΛجʹϢʔβʔΛྨ F V log2 (F V + 1) ײԠੳͱࢪࡦධՁ $IVSOੳͱ Τϯήʔδϝϯτ είΞ 0 30,000 60,000 90,000 120,000 g0 g1 g2 g3 g4 g5 g6 g7 g8 g09 g10 g11 g12 g13 ֊ڃ͝ͱͷਓͱղ log2 (F V + 1) -JHIU .JEEMF -PZBM 4VQFS-PZBM <>ܦిࢠ൛Λʹಋ͍ͨσʔλ׆ ༻ज़ɻ%9Λ્ΉͭͷนͱΓӽ͑ํ -
ํ๏ײԠੳͱࢪࡦධՁ w ΤϯήʔδϝϯτείΞ ͷଟՉ͕ղ͢͠ ͞Λද͢ w ֊ڃͷ͕Ұ༷ͩͱԾఆ͢Δͱɺ' 7͕૿ݮ ͨ࣌͠ʹ ͷ͕εϥΠυ͢ΔྔΛ
ܭࢉͰ͖Δ F V log2 (F V + 1) ࢪࡦͷ' 7վળྔΛݟࠐΉ͜ͱͰ $IVSOվળɺച্ߩݙΛਪఆ͢Δ 12 ༷ʑͳಛྔͷ͏ͪɺղͷӨ ڹ͕େ͖͍ͷ'ͱ7 w ֊ڃ͝ͱͷղɺ֓Ͷ୯ௐݮগͱ ͳΔ w ͕૿͑ΔͱɺҰఆ͕࣍ͷ֊ڃʹεϥΠυ͢Δ log2 (F V + 1) F V ࠜڌײԠੳ 10% ར༻ਓͷׂ߹ ๚ස × 1.2 ফඅهࣄຊ × 1.1 0 30,000 60,000 90,000 120,000 g0 g1 g2 g3 g4 g5 g6 g7 g8 g09 g10 g11 g12 g13 ֊ڃ͝ͱͷਓʢݱࡏͱ26.9%վળʣͱղ log2 (F V + 1) 1ؒͷച্૿ 0.15ԯԁ -
◼︎ ػೳར༻͝ͱʹɺސ٬ͷΤϯ ήʔδϝϯτ͕ҟͳΔ ◼︎ ͞ΒʹΤϯήʔδ͞ΕΔΑ͏ ʹɺػೳΛਪનදࣔ͢Δ Έ ◼︎ ᶃػೳ͝ͱͷΤϯήʔδଟՉ ᶄϢʔβʔ͕ػೳΛ͍࢝Ί
Δ֬ͦΕͧΕΛਪఆ͢ΔϞ σϧΛ࡞ ◼︎ %BUBCSJDLT্ͰϞσϧΛߏங த 14 ʢࣄྫհʣ'JOBODJBM5JNFTͰػೳͷಡऀΤϯήʔδϝ ϯτʹ༩͑ΔӨڹͱɺͦͷػೳͷར༻։࢝֬Λܭࢉ͠ػೳ ͷਪનදࣔΛߦͬͨ <>)PXXFDBMDVMBUFUIF/FYU#FTU "DUJPOGPS'5SFBEFST ͞ΒͳΔΤϯήʔδͷͨΊ ͷػೳͷਪન /FYU#FTU "DUJPOʢ/#"ʣ -
·ͱΊ 15 -57ܭࢉ ܖͷࢿ࢈ՁධՁ $IVSOੳΛͬͨ ࢪࡦධՁ -57վળʹ ػցֶशΛ -57Λ͏͜ͱͰɺࡒձܭʴܖ
Ͱݟ͑ͮΒ͍ظతͳ ੑධՁઓུΛཱͯ͘͢ͳ Δɻ ղʹ૬ؔͷߴ͍Τϯήʔδϝ ϯτείΞΛఆٛͨ͠ɻ ͦͷมͰ͋Δ๚සফඅه ࣄຊΛ,1*ʹ͍ͯ͠Δɻ ײԠੳʹΑΔࣄۀߩݙͷఆྔ ධՁߦ͍ͬͯΔɻ վળ͖͢υϥΠόʔ͕ಛఆ ͞Ε͍ͯΕσʔλαΠΤϯε XFCΤϯδχΞϦιʔεΛ ߟ͑͘͢ͳΔɻ -
ࢀߟจݙ 17 w <>4VOJM(VQUB%POBME3-FINBOO $6450.&34"4"44&54 +063/"-0'*/5&3"$5*7&."3,&5*/(70-6.&/6.#&3 8*/5&3IUUQTXXXHTCDPMVNCJBFEVNZHTCGBDVMUZSFTFBSDI QVC fi
MFTHVQUB@DVTUPNFSTQEG BDDFTTFE'FCSVBSZ w <>ᖒل -JGFUJNF7BMVFܦిࢠ൛ͰͷࣄۀඪͷཧIUUQT IBDLOJLLFJDPNCMPHBEWFOU@MUW BDDFTTFE'FCSVBSZ w <>8FC୲ऀϑΥʔϥϜ ܦిࢠ൛Λʹಋ͍ͨσʔλ׆༻ज़ɻ%9 Λ્ΉͭͷนͱΓӽ͑ํIUUQTXFCUBOJNQSFTTDPKQF BDDFTTFE'FCSVBSZ w <>(FPSHF,BTUSJOBLJT )PXXFDBMDVMBUFUIF/FYU#FTU"DUJPOGPS '5SFBEFSTIUUQTNFEJVNDPNGUQSPEVDUUFDIOPMPHZIPXXF DBMDVMBUFUIFOFYUCFTUBDUJPOGPSGUSFBEFSTFEBCB BDDFTTFE 'FCSVBSZ