倧åŠè³éã®æºåæ¹æ³ãä¿éºã§è²¯ãããããããªãšãã®ä¿éºã®éžã³æ¹ãš3ã€ã®æ³šæç¹ã£ãŠïŒ
ä»åã¯æºåæ¹æ³ã®æåŸãã貯ããïŒéçšããïŒãæ¹æ³ã«ã€ããŠè§£èª¬ããŸãã
ç¡é§ãçããä»ã®æ¯åºãç¯çŽããã®ãæºåæ¹æ³ã®äžã€ã§ãããããã§ã¯åä¿éºååã®ç¹åŸŽãšéžã³æ¹ã«ã€ããŠç޹ä»ããŠãããŸãã
CFP(R)èªå®è ã»VBAãšãã¹ããŒã(Excel)
äž»ã«å°ãããåæ§ããæã¡ã®ãå®¶åºããã®ãäŸé Œãå€ããæè²è²»ãäœå® è²»ãéè·åŸã®ç掻è³éãªã©é·æçã«èããå®¶èšã®ã¢ããã€ã¹ãããŠããŸãããçžè«è ã¯å¹ åºããäžå ŽäŒæ¥ã ãã§ãªãäžå°äŒæ¥ã«ãå€ãã®æ¹ãèªå¶æ¥è ãå ¬åå¡ã®æ¹ãªã©ã§ã幎åã300äžåãã1,000äžåãŸã§ããã£ããããŸããäœå® ããŒã³ãä¿éºéžã³ãå°æ¥ã®è³éèšç»ãªã©ã§ãæ©ã¿ã§ããããæ°è»œã«ãåãåãããã ããã
https://fp-writers.com/
â èªåã«åã£ãååã®éžã³æ¹ïŒhttps://fp-choice.net/
ç®æ¬¡
10幎以äžã®æºåæéããããšãã®æºåæ¹æ³
倧åŠè³éã®æºåãããåºç£ãšãšãã«å§ããæ¹ãããã£ãããã§ãããã
æºåæéãé·ããã°ã³ãã³ãæºåããããšãã§ããå®¶èšãžã®è² æ
ã¯è»œããªããŸããäºå®å€ã®æ¯åºãªã©ã§äžæçã«è²¯èãã§ããªããŠããæºåæéãé·ããã°è»éä¿®æ£ããããšãã§ããŸãã
æºåæéã10幎以äžããå Žåã®æºåæ¹æ³ãšãããããã®ç¹åŸŽã¯æ¬¡ã®éãã§ãã
ïŒå€§åŠè³éã®æºåæ¹æ³ãšç¹åŸŽïŒ
ã»æ®éé éã»å®æé é
å®å šæ§ãé«ãããã€ã§ãåŒãåºãããããç·æ¥çšè³éã®æå³ãå«ãäžå®éé¡ã確ä¿ããŠããããããã 婿¯ãã»ãŒã€ããªãã ãã§ãªããç©äŸ¡äžæã«ãããéã®äŸ¡å€ãäžããå¯èœæ§ã¯ãããŸãã
ã»åŠè³ä¿éºïŒãã©ãä¿éºïŒ
äžäžã®ãšãã«ã¯ä»¥éã®ä¿éºæãå é€ãããä¿éºéãåãåãããšãã§ããããæè²è³éã®æºåæ¹æ³ãšããŠäžè¬çã§ããå¥çŽæéãé·ãã»ã©æºæã§åãåããéé¡ã¯å€ããªããŸãã®ã§ããåºç£åïŒåºç£äºå®æ¥ã®140æ¥ä»¥å ãªã©ïŒã«å å ¥ãããæ¹ãããã£ããããŸãã
ã»äœè§£çŽè¿æ»éåçµèº«ä¿éº
ä¿éºææèŸŒæºäºæ¥ã«æ¯æä¿éºæããè§£çŽè¿æ»éãäžåãç¹é·ã掻ãããæ»äº¡ä¿éãåŸã€ã€ãåŠè³ä¿éºã®ããã«æè²è³éã®æºåã«å ãŠãŸããåŠè³ä¿éºãããè§£çŽè¿æ»çã®é«ãååãå€ãã£ããããå©çšããŠããæ¹ãå€ãã§ãããã
ã»æ ªåŒã»æè³ä¿¡èš
äžå®ã®éçšç¥èãããããªã¹ã¯ãçè§£ããŠãã人ã«ãšã£ãŠã¯ãé éãä¿éºãããé åãããã§ããããéçšæçžŸã倧åŠè³éã«åœ±é¿ãããããªãªã¹ã¯ã®é«ãæè³ã¯ãå§ãã§ããŸããã
ã»å€è²šå»ºãŠé éã»å€è²šå»ºãŠçµèº«ä¿éºã»å€åœæ ªåŒãªã©
ååæ§ã¯åãã§ãããå€è²šã§éçšãããããçºæ¿å€åãªã¹ã¯ãçºçããŸããäžè¬çã«å建ãŠã®ã¿ã§éçšããããå€è²šå»ºãŠãçµã¿å
¥ããããšã§ãªã¹ã¯ã軜æžããããšãèŠèŸŒããŸãã
æ ªåŒã»æè³ä¿¡èšã¯ãããã£ã±ãªåãæ¹ã«ãªã£ãŠããŸããããæ ªåŒæè³ä¿¡èšãããJ-REITããªã©ããŸããŸãªçš®é¡ããããNISAå£åº§ã®éèª²çšæ ãå©çšãããã©ãããªã©ã§ãªã¹ã¯ãéçšæçžŸã¯ç°ãªããŸãã
æè³çµéšã®ããæ¹ã¯åºæ¬çãªããšã¯ãåãã ãšæããŸãã®ã§ãããã§ã¯ä¿éºã®éžã³æ¹ã«ã€ããŠè§£èª¬ããŠãããŸãã
æè²è³éç®çã®ä¿éºã®éžã³æ¹
å€ãã®äººã¯ãä¿éºã®çžè«ã«è¡ãåã«ãããã§æ
å ±åéããããšæããŸããæ
å ±åéããä¿éºå¥çŽãŸã§ã®æµãã«ãããŠæ³šæãã¹ãç¹ã玹ä»ããŸãã®ã§ãä¿éºéžã³ã®åèã«ããŠã¿ãŠãã ããã
ãŸããä¿éºãå©çšãã第äžã®ç®çã¯ãäžäžã®ãšãã«ã§ãæè²è³éã確ä¿ããããšïŒæ»äº¡ä¿éïŒã«ãããŸãã第äºã®ç®çã¯ãæºæä¿éºéãè§£çŽè¿æ»éïŒè§£çŽãããšãã«æ»ã£ãŠãããéïŒã§ããä¿éºãå©çšããæç¹ã§ç¬¬äžã®ç®çã¯éæã§ããŸãã®ã§ãèªç¶ã«ç¬¬äºã®ç®çã«æ³šç®ããã§ãããã
ååé¡ã¯åãååã§ããå¥çŽã®ä»æ¹ã§å€ãã£ãŠããŸããå°ãã§ãååé¡ãå¢ããããã«ã¯ã次ã®ãããªç¹ã«æ³šç®ããŸãã
(1)ãä¿éºææ¯ææéãçãããã
ãåããŸã17æ³ã®ãšãã«æºæãè¿ããåŠè³ä¿éºãã17幎åŸã«è§£çŽè¿æ»çã100ïŒ
ãè¶
ãããäœè§£çŽè¿æ»éåçµèº«ä¿éºããåºæ¬ãšããŸããããããä¿éºæã®æ¯ææéã17幎ã§ã¯ãªãã10幎ãªã©çãããã°ãããååé¡ãå¢ããããšãã§ããŸãããã æ¯åã®æ¯æé¡ã¯å¢ããŸãã®ã§ãåçŽã«çãã§ããããã§ã¯ãããŸããã
(2)ãææããã幎æã
æ¯ææ±ºããããä¿éºæãæãã®ãåºæ¬ã§ããããããå幎æãã幎æãã«ãããšãæ¯æãä¿éºæç·é¡ã¯å®ããªããŸãããŸãããã®åãè¿æ»çãäžãããŸããä¿éºæç·é¡ã100äžåãååé¡ã110äžåãªããè¿æ»çã¯110%ã§ããããããä¿éºæç·é¡ã95äžåã«ãªãã°ãååé¡ãåã110äžåã§ãè¿æ»çã¯115%çšåºŠã«ãªããŸãã幎æãã®å ŽåãïŒå¹Žåãæ¯æããŸãã®ã§ãæ¯æãã«åããŠæºåãããŠããå¿
èŠããããŸãã
ã¡ãªã¿ã«ãè¿å¹Žã®äœéå©ã®åœ±é¿ã«ãã£ãŠã以åãšæ¯ã¹ãŠè¿æ»çã¯é«ããããŸãããä¿éºæã®æ¯ææéãçããããã幎æãã«ãããããªããšè¿æ»çã«æåŸ
ã§ããªããªã£ãŠããŸãããã®ãããæåããäžèšã®2ç¹ã§ææ¡ãããããšãå€ããªããŸãã
ããããèžãŸããæ³šæç¹ã解説ããŸãã
ä¿éºãéžã¶éã®æ³šæç¹
ä¿éºäŒç€Ÿã®ããŒã ããŒãžã§ã¯ãå€ãã®å Žåãä¿éºèšèšã®ã·ãã¥ã¬ãŒã·ã§ã³ãããããšãã§ããŸããããããå
¬åŒããŒã ããŒãžã®ã·ãã¥ã¬ãŒã·ã§ã³ããèšèšã§ããã®ã¯äžéšã§ãããã®ãããã©ã®ãããªå¥çŽããããã«ã€ããŠã¯ããã¯ãçŽæ¥çžè«ããªããã°ãªããŸããã
(1)èšå®ãååãå€ããã°ãæ¯èŒããªããããš
ããçšåºŠãåžæã®ååãéžå®ããŠãããšããŠããèšèšå
容ã«ãã£ãŠååé¡ã¯ç°ãªããŸãã

ä»®ã«çžè«åã«ã¯ä¿éºäŒç€ŸA瀟ã®ååã®è¿æ»çãå¥ã®ä¿éºäŒç€ŸB瀟ã®ååãããé«ããçžè«ã§ããã®ããšã確èªã§ãããšããŸãããããçžè«ã§A瀟ã®ä»ã®ååã§ããè¿æ»çã®é«ãååã玹ä»ãããå Žåãäºå®ããŠããååããè¯ãååã玹ä»ããããšæããæ¹ããŠB瀟ã®ååãšæ¯èŒããªããããšãå¿ããŠããŸããã¡ã§ãã
ããããA瀟ã®ååãå€ãã£ãæç¹ã§èšèšå
容ããããšåæ¡ä»¶ã®B瀟ã®ååãå€ãããããæ¬æ¥ãªãæ¯èŒããªããå¿
èŠããããŸãããªããªããå®ã¯åãæ¡ä»¶ã§æ¯ã¹ããšä¿éºäŒç€ŸB瀟ã®ååã®æ¹ãåªããŠãããšãã£ãã±ãŒã¹ãããããã§ãã
(2)äºå®å€ã®ååãææ¡ãããå Žåã¯ä¿çããããš
äžèšã®äŸã®ããã«ãå¥çŽåŸãä¿éºäŒç€ŸA瀟ã®ååãæãè¿æ»çãé«ããšæã£ãŠãããæ°ã¥ããªãããšããããŸãã䌌ããããªååã§ããã°ããã®ã§ãããå建ãŠããå€è²šå»ºãŠã«å€åãããªã©ã倧ããå€ããå Žåã«ã¯ãããªã泚æãå¿
èŠã§ãã
å€è²šå»ºãŠãå§ããããå¯èœæ§ãé«ãçç±ã®äžã€ã¯ãå建ãŠååã®è¿æ»çã«é
åããªããªã£ãŠããããšã§ããè¿æ»çã®é«ãå€è²šå»ºãŠååãèŠãŠããŸããšãå建ãŠååãéžã³ã«ãããªããã®ã§ãã
ããããååéžã³ãããæ¹ã¯ãäºåã«çºæ¿å€åãªã¹ã¯ãçºæ¿çžå Žã®åºæ¬ã«ã€ããŠèª¿ã¹ãŠããããšã倧åã§ããçžè«ããåã«ãå€è²šå»ºãŠååã®ç¹åŸŽã«ã€ããŠåŠã³ãå©çšãããã©ããæ±ºããŠãããŸããããå
ã«èª¬æãèããŠããŸããšãé©åãªå€æãã§ããªããªãå¯èœæ§ããããŸãããã®å Žåã¯ããã£ããæã¡åž°ããååæéããããŠæ€èšããŠãã ããã
(3)販売ã«ãŒãã«ããéã
ä¿éºã®çžè«ã¯ãåä¿éºäŒç€Ÿã®çŽå¶åºã®ã»ãã«ããä¹å代çåºãããããŸããçŽå¶åºã¯ãã®äŒç€Ÿã®ååããåãæ±ã£ãŠããŸããããä¹å代çåºã¯æ°å瀟ã®ååãæ±ã£ãŠããŸãã®ã§ãæ¯èŒãããããšããã¡ãªããããããŸãã
以åããã®ä¿éºå°éã®äŒæ¥ïŒä»¥äžã代çåºïŒããéèæ©é¢ãä¹å代çåºã§ãããã芳å¯ãããšåãããŸãããéèæ©é¢ã§åãæ±ãä¿éºäŒç€Ÿã¯ã代çåºãšåæ§ã«è€æ°ã®ä¿éºäŒç€Ÿãåãæ±ã£ãŠããŸãããååæ°ã¯ä»£çåºããå°ãªããªã£ãŠããŸããéèæ©é¢ã®è¡å¡ã«ãã¹ãŠã®ååç ä¿®ãããã®ãé£ãããäŸãã°å»çä¿éºã¯A瀟ãB瀟ãC瀟ãçµèº«ä¿éºã¯A瀟ãD瀟ãE瀟ã®ããã«ã人æ°ã®ããïŒé
åã®ããïŒååã«çµã£ãŠããããã§ãã
ãŸããç¹å®ã®è²©å£²ã«ãŒãã§ãã販売ããŠããªãååããããŸããåãåååã§ã販売ã«ãŒãã«ãã£ãŠè¿æ»çãç°ãªãå¯èœæ§ããããŸãã®ã§ãä¿éºéžã³ãé£ããããŠããŸãã
ãã®ããã«æ³šæç¹ãæããŸããšãã©ã®ããã«ä¿éºãéžãã ããããåãããªããªããããããŸããã
å¹³æ28å¹ŽïŒæ29æ¥ã«ä¿éºæ¥æ³ãæ¹æ£ãããŸããã顧客ã®ããŒãºã«åã£ãååãææ¡ãããããå
·äœçãªçžè«ã«å
¥ãåã«ãã¢ã³ã±ãŒãã§æå確èªãè¡ããªã©ã®å¥çŽã®æµãã«å€æŽãããŠããŸããä¿éºä»£çåºãžã®ãã¢ãªã³ã°èª¿æ»ãèŠãŸããšãææ¡æ¹æ³ã匷åãããªã©ããŠããŸãã®ã§ãååã ãã§ãªãã代çåºãæ¯èŒãããæ¬åœã«ããããã®ãå®¶åºã®ç«å Žã§ææ¡ãããŠãããèŠæ¥µããŸãããã
ããã§å€§åŠè³éã®æºåãããŒãã«ããäžé£ã®èšäºã¯çµããã§ãã
TextïŒè€ åæ²ïŒãšã ããã®ãïŒ
CFPRèªå®è
ã»VBAãšãã¹ããŒã(Excel)