长期投资决策是管理会计工作的一项重要内容。通常管理会计教科书只针对确定性投资问题进行决策分析,即投资决策分析都是在给定时期、给定经营业绩数据资料、给定现金流量、给定折现率的条件下进行的。然而,现实投资决策具有时期长、风险大、随机性强等特征,基本的确定性投资决策模型很大程度上不具有决策相关性和操作可行性,难以满足现实决策的需要。本文运用Excel的高级计算功能,针 Long-term investment decision-making is an important part of management accounting. Management accounting textbooks usually only for deterministic investment decision-making analysis, that is, investment decision analysis are given period, given operating performance data, given cash flow, under the conditions of a given discount rate. However, the real investment decision-making has the characteristics of long period, high risk and strong randomness. The basic deterministic investment decision-making model largely does not have the decision-making relevance and operational feasibility, which makes it difficult to meet the needs of realistic decision-making. This article uses Excel’s advanced computational capabilities to pin