Excel을 이용한 공학적 투자사업의 손익분기점분석

A Breakeven Analysis Using the Excel for an Engineering Project

  • Kim, Jin-Wook (Department of Industrial and System Engineering, Changwon National University) ;
  • Lee, Hyun-Ju (SHINSUNG ENG) ;
  • Kim, Jin (Changwon Cycle Racing Corporation)
  • 투고 : 20020300
  • 심사 : 20020600
  • 발행 : 2002.09.30

초록

A break-even analysis is a method used widely for profit planning or decisions in most companies. It is useful tool in financial studies because it is simple and offers useful insights from a modest amount of data. Although it is widely used, it has some weaknesses. It is limited in particular to the analysis for a short term time horizon or one period. We suggest a new break-even procedure to analyze projects with a long term time horizon as keeping the simplicity of a conventional break-even analysis. We will make efforts doing to include actual data for a cost or an income as much as possible rather than developing a mathematical model to improve unreality of a traditional break-even analysis. Also, we will use the spreadsheet software to solve problems.

키워드

참고문헌

  1. Brealey, Richard and Myers. Stewart (1984). Principle of Corporate Finance. 2nd ed., 198-202. McGraw-Hill
  2. Kim,J.S. and Kim. J.W. (1996). A Breakeven Procedure for a Multi-Period Project. The Engineering Economics, 41(2), 95-104
  3. Kim, J. W. (1992), Multi-period Breakeven Analysis for Long Term Profit Planning and Decisions, A Thesis for a Ph.D., Korea Advanced Institute of Science and Technology, Daejenn, Korea
  4. Kim, J. W.. et aI. (2000). Contemporary Engineering Economics, Kyung Moon Publisher, Seoul. Korea. 559-561
  5. Lee, K. H. (1999). Managerial Analysis, Hakmun Publishing, Seoul, Korea, 293-334
  6. Park, C. S.(1997), Contemporary Engineering Economics. 2nd ed., 620-623. Addison-Wesley
  7. Reinhardt, V. E.(1973). Break-even Analysis for Lockheed's Tristar: An Application of Financial Theory, Journal of Finance. 28. 821-838
  8. Thuesen. G. J. and Fabrycky, W. J.(1993). Engineering Economics, 8th ed.. 192-199. Prentice Hall
  9. Yoon, S. C. and Kim, B. K.(1998), Managerial Analysis, Hakmun Publishing, Seoul. Korea, 211-223