财务论文小资料（Small papers on financial papers）.docVIP

财务论文小资料（Small papers on financial papers） - - Abstract: investment decision-making often involves calculating a large number of complex and long-term, a lot of financial workers for this part calculation feel more difficult, but if we can combine EXCEL with this part of the content, you can solve good long-term investment decisions involved in the calculation of net cash flow and evaluation index etc.. Keywords: EXCEL, long-term investment, cash flow, evaluation index With the characteristics of large amount of investment and long-term investment, long payback period of investment, investment risk is big, therefore any enterprise in the long-term investment should be very cautious, before making long-term investments must be on the project feasibility analysis. It is because of the long-term investment decision involves a relatively long time, so the project feasibility analysis, usually must consider the time value of money, and calculate the time value of money has the theory of abstract and complex computation, especially high computing power requirements. If the financial personnel can correctly and flexibly use Excel to calculate the financial function, it can make the calculation of the original complex very simple, and greatly reduce the amount of work related to the calculation of the daily work. In most of the current financial evaluation theory was based on the net cash flow generated by the project, so the following will be application and EXCEL from EXCEL in the net cash flow calculation in the calculation of the long-term investment in the evaluation of two aspects of the relevant issues for further discussion. The application of EXCEL in net cash flow calculation In the long term investment, the focus is the study of net cash flow and the profit research in the secondary position, mainly in the following several reasons: first, because the entire investment duration, total profit and net cash flow is equal to the total net amount of cash, so can replac