å æ¥ãç±³åœéå®å£«åäŒ(ASA)ã§ããŒãã£ã«ã»ãããŒME182 - Utilizing Excel To Build Market Based Depreciation Curves ãéå¬ãããŸããã å ·äœçã«èšããšEXCELã®ã°ã©ãæ©èœã§æ£åžå³ãäœããè¿äŒŒæ²ç·ãè¿œå ããè¿äŒŒæ²ç·ã®æ°åŒãè¿œå ããã ãã®äœæ¥ã§ãããŒã¿ãæã£ãŠããããã°ããããªæéã§åºæ¥ãŠããŸãäœæ¥ã§ãã å°ãé£ããã®ã¯è¿äŒŒæ²ç·ã®æ°åŒããå®æ°ãæ±ããäœæ¥ã§ãããe ãåºãšããæ°å€ã«ãªã£ãå Žåã§ãEXPé¢æ°ã䜿ãã°æ¯èŒçç°¡åã«å®æ°ãæ±ããããšãå¯èœã§ãã
ãšã¯ããããã®æ¹æ³ã¯å®éã®è©äŸ¡ã«äœ¿ããšãªããšãªããªãããŒãã«ãé«ãéšåãããããšã¯ç¢ºãã§ãã
ããŒã¿ãã©ãã§åã£ãŠããã
ååŒããŒã¿ã¯å€æ°ããã°åŸãããæžäŸ¡æ²ç·ã®ç²ŸåºŠãåäžãããšèããããŸãããåé¡ã¯ãå€æ°ã®ããŒã¿ãã©ãããåã£ãŠããããšã§ãã
ååŒããŒã¿ã¯å®éã®å£²è²·ããŒã¿ïŒæçŽäŸ¡æ ŒïŒã ãã§ãªããASAã®è©äŸ¡åè«(POV)ãªã©ã§ã¯åžå Žã§ã®å£²åºäŸ¡æ Œã䜿ãããšãå¯èœãšãããŠããŸããèªåè»ïŒä¹çšè»ããã©ãã¯ããã¬ãŒã©ãŒããã¹ïŒã建èšæ©æ¢°ããã©ãŒã¯ãªãããªã©åããã®ã¯æ¯èŒçäŸ¡æ ŒããªãŒãã³ã«ãªã£ãŠããŠããŒã¿ãåããããã§ããããã以å€ã®æ©æ¢°ã¯å£²åºäŸ¡æ Œãç§å¿ã«ãªã£ãŠããããšãå€ããæ å ±åéã«èª²é¡ããããŸãã
æçŽäŸ¡æ Œã売åºäŸ¡æ Œã
äžèšã§ãå°ã觊ããããã«å®éã«å£²è²·ãããæçŽäŸ¡æ Œãããããã¯å£²åºäŸ¡æ Œã§ãè¯ãã®ããšããåé¡ããããŸããæ å ±å ¥æã®å¯èœæ§ãšããŠã¯å£²åºäŸ¡æ ŒãããæçŽäŸ¡æ Œã®æ¹ãæ Œæ®µã«äœããæçŽäŸ¡æ Œã®ã¿ã«ãã ããã°ãå€æ°ã®ããŒã¿åéã¯è³é£ã®æ¥ãšèšããããåŸãŸããã
説ææ§ã®åé¡
è¿äŒŒæ²ç·ã¯EXCELã®æ©èœã§ç°¡åã«æ±ããããŸãããå°åºã®éçšã®èª¬ææ§ãéåžžã«é£ãããšããåé¡ããããŸããè¿äŒŒæ²ç·ã«ãããã€ãçš®é¡ãååšããå€é åŒã§ããã°æ¬¡æ°ãããã€ã«ããããšèšãåé¡ããããŸããå€é åŒãããã¿ã«æ¬¡æ°ãå¢ãããŠãããšæ³¢æã€ãããªåœ¢ç¶ã®æ²ç·ã«ãªã£ãŠããŸããŸããäžè¬ã«ååŽè³ç£ã®äŸ¡å€ã¯çµé幎æ°ãå¢ããã䜿çšæéãå¢ããããšã§æžå°ããŠããããšãéåžžã§ãããããã»ã©ã®çç±ããªãéãæ³¢æã€ãããªç·åœ¢ã®è¿äŒŒåŒãå°å ¥ããããšã¯èª€ããšèããããŸãã
çžé¢ä¿æ°ã®æãæ¹
EXCELã®è¿äŒŒæ²ç·å°åºæ©èœã§ã¯ãæ°åŒãšå ±ã«R-2ä¹å€ãæ±ããããšãåºæ¥ãŸãã R-2ä¹å€ã¯çžé¢ä¿æ°ãšãåŒã°ããŠããŠãã®æ°å€ã1.0ã«è¿ãã»ã©åæããäºã€ã®èŠå ã®çžé¢é¢ä¿ãé«ããšèããããŠããŸãã以åãããã»ãããŒã®æŒç¿ã®éã«ã¯R-2ä¹å€ã0.8ã0.9ã§ããã°çžé¢é¢ä¿ãé«ãïŒïŒèª¬åŸåãé«ãïŒãšãã£ãæ±ãããããŠããŸããããME182ã§ã¯ãããã®èª¬æã¯ãªããåè¬åŸã«R-2ä¹å€ãç¬èªã«æ±ãããšãã0.44ã§ããã äžæŠã«éŸå€ãèšå®ããã®ã¯äžå¯èœã§ãããã©ã®çšåºŠãŸã§ä¿¡é Œæ§ããããã®ãšèããã¹ãããé£ããå€æãæ±ããããŸãã
ããŒã±ããã¢ãããŒãã¯ãªãã¹ãåºãé©çšãããã§ããããæ å ±ãéãããäžã§ãããªãã¹ãåºç¯ã«åéããåæããå¿ èŠããããŸãã ãããåºæ¥ãããã«ãªãã°ãç¹ã«æ©æ¢°èšåã®ä»äºã®ããæ¹ãå€§å¹ ã«å€ãã£ãŠãããšèããããŸãã
ãªããäžåç£ã®éå®è©äŸ¡ã«ã€ããŠã¯äžåç£éå®è©äŸ¡åºæºã§è©äŸ¡ã®æ¹æ³ãå®ããããŠããããã®æ¹æ³ããå€ããäžèšã®åææ¹æ³ã¯å°ãªããšãéå®è©äŸ¡æžäœæã«ãããŠã¯çšããããäœå°ããªãã®ãçŸç¶ã§ãããšèããããŸãã