ãåã©ããæ¥ã«å€§åŠã«é²åŠããããšèšãå§ããããè³éæºåãååã§ãªãããæ³å®å€ã®è³éäžè¶³ã«å¯Ÿå¿ããçºã®å¥šåŠéãäžæã«æŽ»çšããæ¹æ³
ä»åããæ¥ãªåºè²»ã«ã察å¿ã§ãããåãããæ¹æ³ã«ã€ããŠç޹ä»ããŠãããŸãã
ãåãããæ¹æ³ã¯ãäž»ã«ãæ¥æ¬åŠçæ¯æŽæ©æ§ã®å¥šåŠéããšãæ¥æ¬æ¿çéèå ¬åº«ã®åœã®æè²ããŒã³ãããããŠãæ°éã®éèæ©é¢ã®æè²ããŒã³ãããããŸããä»åã¯ãæ¥æ¬åŠçæ¯æŽæ©æ§ã®å¥šåŠéãã«ã€ããŠè§£èª¬ããŠãããŸãã
CFP(R)èªå®è ã»VBAãšãã¹ããŒã(Excel)
äž»ã«å°ãããåæ§ããæã¡ã®ãå®¶åºããã®ãäŸé Œãå€ããæè²è²»ãäœå® è²»ãéè·åŸã®ç掻è³éãªã©é·æçã«èããå®¶èšã®ã¢ããã€ã¹ãããŠããŸãããçžè«è ã¯å¹ åºããäžå ŽäŒæ¥ã ãã§ãªãäžå°äŒæ¥ã«ãå€ãã®æ¹ãèªå¶æ¥è ãå ¬åå¡ã®æ¹ãªã©ã§ã幎åã300äžåãã1,000äžåãŸã§ããã£ããããŸããäœå® ããŒã³ãä¿éºéžã³ãå°æ¥ã®è³éèšç»ãªã©ã§ãæ©ã¿ã§ããããæ°è»œã«ãåãåãããã ããã
https://fp-writers.com/
â èªåã«åã£ãååã®éžã³æ¹ïŒhttps://fp-choice.net/
ç®æ¬¡
倧åŠã«è¡ããã人ã®ããã®JASSO奚åŠé
ãæ©ãã«æºåããŠããããã©ãåŠè²»ãè¶³ããªãããåã©ããæ¥ã«å€§åŠã«é²åŠããããšèšãå§ããããè³éæºåãååã§ãªãããšãã£ãäºå®å€ã®è³éäžè¶³ã«å¯Ÿå¿ã§ããã®ãã奚åŠéãåœã®æè²ããŒã³ãæ°éã®éèæ©é¢ã®æè²ããŒã³ãªã©ã§ãã
ä»åã¯ãã奚åŠéãã«ã€ããŠè§£èª¬ããŠãããŸãïŒå¥šåŠé絊ä»åã¯ãããããã«åé¡ãããŸããã解説ã®éœåäžãããã§æ±ã£ãŠããŸãïŒã
æ¥æ¬åŠçæ¯æŽæ©æ§ïŒJASSOïŒã®å¥šåŠéã«ã¯ãã絊ä»åããšã貞äžåãããããŸãã察象ãšãªãåŠæ ¡ãéåŠæ¹æ³ãªã©ã«ããæ¡ä»¶ãç°ãªããŸãã®ã§ãããã§ã¯ãç§ç«å€§åŠãžèªå®
ããéåŠããå Žåãã§ç¢ºèªããŸãã
ïŒJASSOã®å¥šåŠéãç§ç«å€§åŠïŒèªå® éåŠïŒïŒ
ã貞äžåãã«ã¯ã第äžçš®ããšã第äºçš®ãããå
¥åŠæç¹å¥å¢é¡è²žäžå¥šåŠéãããããŸããã第äžçš®ãã¯ç¡å©æ¯ãã第äºçš®ããšãå
¥åŠæç¹å¥å¢é¡è²žäžå¥šåŠéãã¯å©æ¯ä»ãšãªããŸãã

ã絊ä»åãã¯è¿æžäžèŠã®å¥šåŠéãã貞äžåãã¯åæ¥åŸã«è¿æžããŠãã奚åŠéã§ããã第äžçš®ãã¯ç¡å©æ¯ã§ãããã第äºçš®ãããåºæºãé«ããªã£ãŠããŸãã
JASSOãå
¬è¡šããŠããå¹³æ29å¹ŽåºŠã®æ¡çšåè£è
æ°ãèŠãŸããšã第äžçš®ã¯åºæºãæºããã17äž2027人ã®ãã¡æ¡çšåè£è
æ°ã¯13äž2003人ã第äºçš®ã¯åºæºãæºãããŠããã°æ¡çšåè£è
ã«ãªã£ãŠããã23äž1154人ãšãªã£ãŠããŸãã
åšåŠäžã«å¿
èŠãªè²»çšãšåæ¥åŸã®è¿æžé¡ãã·ãã¥ã¬ãŒã·ã§ã³ãã貞äžé¡ã決å®ããããšã«ãªããŸãã
奚åŠéã®ã·ãã¥ã¬ãŒã·ã§ã³ã§è³éèšç»ãç«ãŠã
倧åŠè³éãæºåãã第2åã§ãäžäŸãšããŠç޹ä»ããè³éæºåãã©ã³ãããšã«å¥šåŠéã®ã·ãã¥ã¬ãŒã·ã§ã³ïŒè²žäžå第äºçš®ïŒãããŠã¿ãŸãã
ãã®äŸã§ã¯ããšãã倧åŠã®æåç³»åŠéšã®åŠè²»ãåèã«ããŠããŸãããã®å€§åŠã§ã¯å€§åŠïŒå¹ŽçåŸæãã倧åŠïŒå¹ŽçåŸæãŸã§ã¯èšïŒåã®çŽå
¥éãå¿
èŠãšãªããäžååã¯50äžåã§ããçŽå
¥éäžååã®ååã«ããã25äžåãäºåã«çšæããè³éããåºããããã«ããæ®ãã®25äžåã¯æ¯æã®åå
¥ããæ¯åºãããšæ³å®ããŸããå
¥åŠé75äžå+çŽå
¥é1ååã®ååã§25äžåÃ7åå=250äžåãã§ãã®ã§ãå
¥åŠãŸã§ã«250äžåãçšæããŠãããã©ã³ãšãªã£ãŠããŸãã

ã·ãã¥ã¬ãŒã·ã§ã³çµæïŒè²žäžå第äºçš®ïŒïŒœ
äºå®å€ã®æ¯åºãªã©ã§ãå
¥åŠæç¶ãæçŽä»éã¯è¶³ãããã®ã®ãåšåŠäžã®åŠè²»ãæããªããªãããšãèããããŸããäžèšã®äŸã§ããšãåæããã³åŸæçŽå
¥éå25äžåïŒçŽå
¥éã®ååã§ãã25äžåãçšæããŠãããã©ã³ã§ãã®ã§ãæ®ãã®ååïŒã®äžè¶³ãæ³å®ãããšãçŽå
¥é7ååãªã®ã§åèšã§175äžåãšãªããŸããããã§ã¯è²žäžç·é¡100äžåãš200äžåã§ã·ãã¥ã¬ãŒã·ã§ã³ããŸããã®ã§ãç®å®ãšããŠã芧ãã ããã

貞äžé¡ã決å®ããããã«ã¯ãè¿æžé¡ã®ã·ãã¥ã¬ãŒã·ã§ã³ã«å ããåšåŠäžãšåæ¥åŸã®è³éèšç»ãç«ãŠãŠãããšå®å¿ã§ãã
ã»åšåŠäžã®è³éèšç»ïŒåšåŠäžã«å¿ èŠãªè²»çšãèãã
âã貞äžé¡ã®æ±ºå®
ã»åæ¥åŸã®è¿æžèšç»ïŒåæ¥åŸã®åå ¥ãšæ¯åºã倧äœã§ããã®ã§äºæ³ããè¿æžæéäžã®åæ¯ã確èªãã
ãâãè¿æžå¯èœãã©ããã®å€æææ
奚åŠéã¯è²žäžå©çãããªãäœãã婿¯è² æ
é¡ã軜ããšãã倧ããªã¡ãªããããããŸãããåéã§ããããšã«ã¯å€ãããããŸããã忥åŸã®è¿æžèšç»ãç«ãŠãäœè£ããã£ãŠè¿æžã§ãããã©ãã確èªããŠãããŸãããããæ¬äººãšäžç·ã«ããšã¯ã»ã«ãªã©ãå©çšãããã©ã³äœãããå§ãããŸãã
ãªããé²åŠåŸãåŠæ ¡ã«ãé²åŠå±ããæåºãããªã©ãæå®ã®æç¶ããçµãŠåããŠã奚åŠçããšãªããŸãããããŸã§ã¯ãæ¡çšåè£çã«éããŸãããçµæçã«äžèŠã§ããã°ãé²åŠå±ããåºããªããã°ãã£ã³ã»ã«æ±ããšãªããŸãã
貞äžå奚åŠéã®å Žåãå
¥åŠåã«ç³ã蟌ããäºçŽæ¡çšããšãåšåŠäžã«ç³ã蟌ããåšåŠæ¡çšãããããŸãããåšåŠæ¡çšãã®å ŽåãæçžŸãçµæžç¶æ³ã®å¯©æ»ã«å ããåŠæ ¡ããšã«æ¡çšæ ããããŸãããã®ãããå©çšã§ããªãããšãèããŠããäºçŽæ¡çšãããç³ã蟌ãã§ãããæ¹ãããã§ãããã
次åã¯åœã®æè²ããŒã³ã«ã€ããŠè§£èª¬ããŸãã
åºå
žïŒæ¥æ¬åŠçæ¯æŽæ©æ§
â»è¡š1ã¯æ¥æ¬åŠçæ¯æŽæ©æ§ã®ã奚åŠéãã®éšåãåèã«äœæãããŸããã
â»è¡š2ã¯æ¥æ¬åŠçæ¯æŽæ©æ§ã®ã奚åŠé貞äžã»è¿éã·ãã¥ã¬ãŒã·ã§ã³ããåèã«äœæãããŸããã
TextïŒè€ åæ²ïŒãšã ããã®ãïŒ
CFPRèªå®è
ã»VBAãšãã¹ããŒã(Excel)
