äžåŠçã®åäŸãæã€å®¶åºã®çåãåŠç¿å¡Ÿè²»çšã¯å¹Žéã§ããããé©åãªã®ãïŒïŒ
ããã¯ãåã©ãäžäººã«ã€ã1000äžåãããããšèšãããæè²è²»ã«å«ãŸããŠããéé¡ã§ããããããåŠç¿å¡Ÿãå®¶åºæåž«ãå©çšããªããå®¶åºããããŸãããå©çšããã«ããŠããã®éé¡ã¯ååãªã®ã§ããããã
ä»åã¯ãåŠç¿è²»ãæ¬åœã«çŸå®çãªæ°å€ã«ãªã£ãŠããã®ããäžåŠçã®å®¶åºæåž«è²»çšã»åŠç¿å¡Ÿã«æ³šç®ããŠèããŠãããããšæããŸãã
CFP(R)èªå®è ã»VBAãšãã¹ããŒã(Excel)
äž»ã«å°ãããåæ§ããæã¡ã®ãå®¶åºããã®ãäŸé Œãå€ããæè²è²»ãäœå® è²»ãéè·åŸã®ç掻è³éãªã©é·æçã«èããå®¶èšã®ã¢ããã€ã¹ãããŠããŸãããçžè«è ã¯å¹ åºããäžå ŽäŒæ¥ã ãã§ãªãäžå°äŒæ¥ã«ãå€ãã®æ¹ãèªå¶æ¥è ãå ¬åå¡ã®æ¹ãªã©ã§ã幎åã300äžåãã1,000äžåãŸã§ããã£ããããŸããäœå® ããŒã³ãä¿éºéžã³ãå°æ¥ã®è³éèšç»ãªã©ã§ãæ©ã¿ã§ããããæ°è»œã«ãåãåãããã ããã
https://fp-writers.com/
â èªåã«åã£ãååã®éžã³æ¹ïŒhttps://fp-choice.net/
ç®æ¬¡
å®¶åºæåž«è²»çšã¯å¹Žé2äžåïŒ
次ã®ããŒã¿ã¯ãæéšç§åŠçãå¹³æ28幎床åäŸã®åŠç¿è²»èª¿æ»ãããã®æç²ã§ããäŸãã°å
¬ç«äžåŠæ ¡ã®å®¶åºæåž«è²»çšçã¯å¹Žé1äž7868åãåŠç¿å¡Ÿè²»ã¯å¹Žé20äž2498åã§ããããšãããããŸãã
æéšç§åŠçãå¹³æ28幎床åäŸã®åŠç¿è²»èª¿æ»ãããæç²
ãã£ãã·ã¥ãããŒïŒè³éèšç»ïŒãäœãå ŽåãåŠç¿è²»ç·é¡ã§ã¯ãªã詳现ãªããŒã¿ãèŠãŠå€æããŸãããã
ç§ãåããŠãã®å®¶åºæåž«è²»çšçãèŠããšããéé¡ãå°ãªãããšã«çåãæãæç§çã«åãåãããããŸããã
ãããšããã®éé¡ã¯ãå®¶åºæåž«ãå©çšããŠããªãå®¶åºãå«ããå¹³åé¡ãã§ããšã¯ã»ã«ã®å¥ã·ãŒããèŠããšè©³çްãåãããšã®ããšã§ããã
å®¶åºæåž«è²»çšçãšåŠç¿å¡Ÿè²»çšãããã詳现ããŒã¿ãèŠãŠãããŸãããã
äžåŠçã®çŽ2å²ãå®¶åºæåž«ãå©çšããå¹³åé¡ã¯å¹Žé7äž9000å
æéšç§åŠçãå¹³æ28幎床åäŸã®åŠç¿è²»èª¿æ»ãããæç²
ãã®è¡šã¯ããå®¶åºæåž«ãå©çšããŠããå®¶åºã®æ¯åºé¡ãããããããŒã¿ã§ãã
å
¬ç«äžåŠæ ¡ã®ãå¹Žéæ¯åºé¡0åããèŠãŸããšã77.4%ãšãããŸããã€ãŸããçŽ8å²ãå®¶åºæåž«ãå©çšããŠããªãããšãããããŸãã
å®¶åºæåž«ãå©çšããŠããæ®ã2å²ã®å®¶åºã§ã¯ã幎éã§ã©ãããããéãè²»ãããŠããã®ã§ããããã
è¡šã®æäžéšã«ããæ¯åºè
å¹³åé¡ããšãããŸããå
¬ç«äžåŠæ ¡ã®é
ç®ããäžã«ãã©ããŸããšã79ïŒååïŒãšãããŸãã
ããªãã¡ãå®¶åºæåž«ãå©çšããŠããå®¶åºã®å¹Žéå¹³åé¡ã¯7äž9000åãšããããšã§ããå
šäœå¹³åã®1äž7868åãšã¯å€§ããé¢ããŠãããããå®¶åºæåž«è²»çšçã®å¹³åé¡ãç¥ãããå Žåã¯ãã¡ãã®éé¡ã®æ¹ãçŸå®çã§ãã
åŠç¿å¡Ÿè²»çšå¹³åã¯ãçŽ20äžåã§ã¯ãªãçŽ30äžå
æéšç§åŠçãå¹³æ28幎床åäŸã®åŠç¿è²»èª¿æ»ãããæç²
次ã«åŠç¿å¡Ÿã®ããŒã¿ãèŠãŠã¿ãŸãããã衚ã®èŠæ¹ã¯ãå®¶åºæåž«ã®å Žåãšåãã§ããå
¬ç«äžåŠæ ¡ã¯çŽ7å²ãç§ç«äžåŠæ ¡ã¯5.5å²ã®ãå®¶åºãåŠç¿å¡Ÿãå©çšããŠããããšã«ãªããŸãã
æ¯åºè
å¹³åé¡ãèŠãŸããšã幎é30äžå匱ãæéã§2äžåïœ2.5äžåã»ã©ã®æ¯åºãšãªããŸãã
ãŸããåŠç¿å¡Ÿè²»çšãå®¶åºæåž«è²»çšãšåæ§ãæ¯åºè
å¹³åé¡ã¯å
šäœå¹³åããé«ãã10äžåã»ã©ã®å·®ããããŸãã
ãåŠç¿å¡Ÿã«ã©ã®ããããããã®ïŒããšããçåã¯ãæ¯åºè
å¹³åé¡ãåæãšãªã£ãŠããã®ã§ã¯ãªãã§ããããã
ãããã®ããŒã¿ãã©ã®ããã«èšç»ã«çã蟌ãã
ãåããŸãããããäžåŠçã§ãåŠç¿å¡Ÿãå®¶åºæåž«ããå©çšãããã©ãããªã©ã®æè²æ¹éãæ±ºãŸã£ãŠããã°ãå
·äœçãªéé¡ãèšç»ã«çã蟌ãããšãã§ããŸãã
åºç£åãåºç£çŽåŸã«æè²è³éã®æºåãèãããå®¶åºãå€ããšæããŸããããã®ææã«ã¯äœã決ãŸã£ãŠããªãããšãå€ããããã©ã®ããã«ããŒã¿ãçã蟌ããè¿·ããããããŸããã
ä»åã®èšäºã§ãã®ããŒã¿ã玹ä»ããçç±ã«ã¯æ¬¡ã®ãããªèæ¯ããããŸãã
ã»å€§åŠïŒå€§åŠé¢ã»é«æ ¡çïŒåæ¥ãŸã§ã®æè²è²»ãå®¶èšã«åãããŠæºåãããã
ã»æè²æ¹éïŒé²è·¯ïŒã¯æªå®ã§ããã§ããéããå°æ¥å¿
èŠãªéé¡ããé¢ããªããããªéé¡ãæºåãããã
ã»çµ±èšããŒã¿ã¯æ¥æ¬å
šäœã®æè²è²»ãèŠãããã®ãã®ã§ãå人ã«äœ¿çšãããšéé¡ã«ãºã¬ãçããã
ã»æè²è²»ã«ã¯å®¶èšã®ç¶æ³ã«åãããŠã³ã³ãããŒã«ã§ããæ¯åºãããã
ä»å玹ä»ããåŠç¿å¡Ÿè²»çšã»å®¶åºæåž«è²»çšã®ããã«ãå
šäœå¹³åé¡ã§ã¯ãªãæ¯åºè
å¹³åé¡ãèšç»ã«çã蟌ãããšãäžã€ã§ãããå¹³åé¡èªäœã宿
ãšããé¢ããŠããå¯èœæ§ããããŸãã
ãã£ãã·ã¥ãããŒïŒè³éèšç»ïŒã®éé¡ã¯ãæè²è²»ã«éãããã»ãšãã©ãäºæ³ã®äžã«æãç«ã£ãŠããŸããè³éäžè¶³ã«ãªãããšãå¿é
ãªäººã¯ãæ¯åºé
ç®ã«è²¯èãšã¯å¥ã«ãäºåè²»çšããå ãããšããã§ãããã
ãã®äºåè²»çšã«å ããéé¡ã誀差ãã«ããŒããŠãããŸãã
TextïŒè€ åæ²ïŒãšã ããã®ãïŒ
CFPRèªå®è
ã»VBAãšãã¹ããŒã(Excel)



