[提示词] 25 Prompt Templates for Financial Tasks in the Finance Industry

In the finance industry, using ChatGPT has achieved remarkable results. ChatGPT can quickly and accurately understand and respond to finance-related queries, greatly reducing the time spent searching for financial rules and policies. At the same time, ChatGPT has demonstrated outstanding capabilities in helping finance personnel complete tasks such as report writing, data analysis, and forecasting.

When using ChatGPT for financial forecasting, it can provide relevant prompts such as industry trends and historical data analysis, greatly improving forecasting accuracy. The necessity and benefits of using ChatGPT in the finance industry are obvious. First, by automating the processing of a large number of repetitive financial tasks, it significantly improves the efficiency of financial work. Second, the data analysis and forecasting suggestions provided by ChatGPT can help finance personnel make more precise decisions and enhance corporate competitiveness. In addition, when handling complex financial transactions and tax planning, ChatGPT can provide compliance suggestions to help enterprises effectively avoid risks.


Demonstration of 25 Financial Prompt Templates
Contents: Calculation, analysis, modeling, document creation, plan development, strategy development
Notes: Replace the fields in the templates with relevant content. If you find it useful, you can bookmark this page for future use.

Task: Calculate the present value of an investment given expected cash flows and a discount rate.
Template: =PV(rate, nper, pmt, [fv], [type])
Example: =PV(5%, 10, -1000, 0, 0) returns 613.91 yuan, representing the present value of a 10-year investment with annual payments of 1,000 yuan and a discount rate of 5%.

Task: Perform financial due diligence
Template: "I need to perform financial due diligence for my _________. Can you provide me with a checklist and recommend any relevant tools?"
Example: "I need to perform financial due diligence for a potential acquisition. Can you provide me with a checklist and recommend any relevant tools?"

Task: Develop a financial strategy
Template: "I need to develop a financial strategy for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to develop a financial strategy for the company's expansion plan. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Calculate the internal rate of return (IRR) for a series of cash flows.
Template: =IRR(values, [guess])
Example: =IRR({-1000, 500, 400, 300, 200}) returns 14.98%, which represents the IRR of a 5-year investment with an upfront cost of 1,000 yuan and positive subsequent annual cash flows of 500 yuan, 400 yuan, 300 yuan, and 200 yuan, respectively.

Task: Develop a financial risk management plan
Template: "I need to develop a financial risk management plan for my _________. Can you provide me with a template and recommend some relevant tools?"
Example: "I need to develop a financial risk management plan for the company's foreign currency risk. Can you provide me with a template and recommend some relevant tools?"

Task: Develop an investment strategy
Template: "I need to develop an investment strategy for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to develop an investment strategy for my high-net-worth client. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Calculate the net present value (NPV) of a series of cash flows given a discount rate.
Template: =NPV(rate,values)
Example: =NPV(10%, {-1000, 500, 400, 300, 200}) returns 30.88 yuan, representing the NPV of a 5-year investment with an upfront cost of 1,000 yuan and positive subsequent annual cash flows of 500 yuan, 400 yuan, 300 yuan, and 200 yuan, respectively, at a discount rate of 10%.

Task: Use the Bloomberg Terminal to analyze financial statements and ratios.
Template: Enter the company ticker symbol, then select "Financial Analysis" or "Financials" from the main menu.
Example: Enter ticker "AAPL" and select "Financial Analysis" to provide an overview of Apple Inc.'s financial performance, including the income statement, balance sheet, and key financial ratios.

Task: Create a financial analysis report
Template: "I need to create a financial analysis report for my _________. Can you provide me with a template and recommend some relevant tools?"
Example: "I need to create a financial analysis report for the company's board of directors. Can you provide me with a template and recommend some relevant tools?"

Task: Develop a financial performance measurement system
Template: "I need to develop a financial performance measurement system for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to develop a financial performance measurement system for my client's investment portfolio. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Create a financial model
Template: "I need to create a financial model for my _________. Can you provide me with a template and recommend some relevant tools?"
Example: "I need to create a financial model for a client's new product launch. Can you provide me with a template and recommend some relevant tools?"

Task: Use Tableau to analyze financial data and create reports
Template: Use Tableau to analyze [financial data/sales data/inventory data] to [identify trends/find insights/track performance] and create reports for [management/stakeholders/clients].
Example: Use Tableau to analyze last quarter's sales data to identify customer behavior trends and create a report for the marketing team.

Task: Use Google Sheets to create and share financial documents
Template: Use Google Sheets to create [a budget/a forecast/an expense report/a balance sheet] and share it with [team members/stakeholders/clients].
Example: Use Google Sheets to create a monthly budget and share it with the finance team to track expenses.

Task: Use regression analysis to analyze the relationship between two variables.
Template: =LINEST(known_y's, [known_x's], [const], [stats])
Example: =LINEST(B2:B6, A2:A6, TRUE, TRUE) returns a set of regression statistics for a dataset where column A contains the independent variable data and column B contains the dependent variable.

Task: Develop a financial forecasting model
Template: "I need to develop a financial forecasting model for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to develop a financial forecasting model for the company's budget planning. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Create a financial dashboard
Template: "I need to create a financial dashboard for my _________. Can you provide me with a template and recommend some relevant tools?"
Example: "I need to create a financial dashboard for a client's investment portfolio performance. Can you provide me with a template and recommend some relevant tools?"

Task: Perform valuation analysis
Template: "I need to perform a valuation analysis on my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to perform a valuation analysis on a client's private equity investments. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Use Xero to manage invoices and expenses
Template: Use Xero to [create invoices/track expenses/manage accounts payable and accounts receivable] for [clients/suppliers/company].
Example: Use Xero to manage the company's accounts payable and accounts receivable by creating invoices and tracking payments.

Task: Use ADP to process payroll
Template: Use ADP to process payroll for [employees/contractors/company] by [calculating wages/withholding taxes/generating pay stubs].
Example: Use ADP to process employee payroll by calculating wages, withholding taxes, and generating pay stubs.

Task: Create a dynamic chart that updates based on criteria selected by the user.
Template: =OFFSET(reference, rows, cols, [height], [width])
Example: =OFFSET(Sheet1!$B$1, 0, 0, COUNTA(Sheet1!$B:$B), 1) returns a dynamic chart range that updates when new data is added to column B of Sheet1.

Task: Perform credit analysis
Template: "I need to perform credit analysis on my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to perform credit analysis on a potential borrower. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Develop a project portfolio management strategy
Template: "I need to develop a project portfolio management strategy for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to develop a portfolio management strategy for a client's investment portfolio. Can you provide me with a step-by-step guide and recommend any relevant tools?"

Task: Use SAP for financial analysis
Template: Use SAP to perform [financial analysis/budget analysis/variance analysis] by [generating reports/analyzing data/creating charts].
Example: Use SAP to perform budget analysis by generating reports and analyzing data to identify areas where costs can be saved.

Task: Use Microsoft Power BI to create detailed financial models.
Template: Import data from multiple sources, create calculated fields and measures, and build interactive reports and dashboards.
Example: Use Power BI to analyze a retail company's sales data and create reports

Task: Perform a cost-benefit analysis
Template: "I need to perform a cost-benefit analysis for my _________. Can you provide me with a step-by-step guide and recommend any relevant tools?"
Example: "I need to perform a cost-benefit analysis on a client's investment in new technology. Can you provide me with a step-by-step guide and recommend any relevant tools?"