50 Ways to use Chat GPT-3 in Finance, FP&A and Investing. Part 3

If you haven’t read part 1 or 2, these are the links:

• 50 Ways to use Chat GPT-3 for Finance. Part 1 | by Christian Martinez Founder of The Financial Fox | Mar, 2023 | Medium
• 50 Ways to use Chat GPT-3 for Finance. Part 2 | by Christian Martinez Founder of The Financial Fox | Mar, 2023 | Medium

Finance professionals must adapt to the fast-paced changes in the industry to remain successful. Recently, an advanced artificial intelligence tool called Chat GPT-3 has emerged and is revolutionizing the way finance professionals work.

In this series, we’ll delve into the world of Chat GPT-3 and highlight 50 ways that finance professionals can use this technology to enhance productivity and achieve better results.

11) Generate a financial model in Python to analyze stocks

Adding on point 10 from the previous article , Chat GPT3 can also gene an example of how to use Python to create a financial model.

The assumptions, revenue and expense inputs, and other factors can be customized based on the investment opportunity.

The model can then be used to analyze the investment opportunity and make informed decisions.

Chat GPT-3 Prompt: Can you generate a financial model for a new investment opportunity with some code in Python

12) Give advices for venture capital investing

Venture capital (VC) investing is a form of private equity financing that involves investing in high-growth, early-stage companies with high potential for success. Venture capital firms typically invest in companies that have innovative technologies, business models, or products, with the goal of helping these companies grow and succeed.

Venture capital investing involves a significant amount of risk, as many early-stage companies fail. However, successful venture capital investments can generate significant returns for investors. Venture capital firms typically take an equity stake in the companies they invest in, and they may also provide strategic guidance and operational support to help these companies grow.

Chat GPT-3 Prompt: I am a new venture capital investor. What should I consider when deciding where to invest?

13) Automate PowerPoint Slides Generation from Excel models

One of the tasks that finance analysts perform the most is creating slides with different inputs from Excel models. It can take hours every month but with the help of Chat GPT3 and some basic Python code, this can be automated!

Say good-bye to spending your time copy and pasting things into PowerPoint from Excel and instead use that time to analyze the financials and provide meaningful commentary.

Chat GPT-3 Prompt: I need to get a code to automate slides generation from Excel Tables and into PowerPoint. can you give me some Python code that does that?

In this code, replace “path/to/excel/file.xlsx” with the actual file path of your Excel file, and replace “worksheet_name” with the name of the worksheet containing your table. You can also modify the position and dimensions of the table by adjusting the “left”, “top”, “width”, and “height” variables. Finally, replace “path/to/powerpoint/file.pptx” with the desired file path and name for your PowerPoint file.

14) Automate Google Slides Generation from Google Spreadsheets models

For some of you that use Google Slides and Google Spreadsheets instead of PC (yes, there are some people out there), then you can use Chat GPT3 to get you started to use Python for this use case!

Chat GPT-3 Prompt: I need to get a code to automate slides generation from Google Spreadsheet Tables and into Google Slides. can you give me some Python code that does that?

Here the full code:

import os
import google.auth
import google.auth.transport.requests
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.errors import HttpError

# Authenticate and build the Sheets API and Slides API services
creds = Credentials.from_authorized_user_file(os.environ['GOOGLE_APPLICATION_CREDENTIALS'])
sheets_service = build('sheets', 'v4', credentials=creds)
slides_service = build('slides', 'v1', credentials=creds)

# Define the spreadsheet ID and range of the table
spreadsheet_id = 'your-spreadsheet-id'
range_name = 'Sheet1!A1:C4'

# Get the data from the spreadsheet
result = sheets_service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id,
    range=range_name
).execute()

# Create a new Google Slides presentation
presentation = slides_service.presentations().create(
    body={
        'title': 'Presentation Title'
    }
).execute()

# Get the ID of the new presentation
presentation_id = presentation['presentationId']

# Create a new slide in the presentation
requests = [
    {
        'createSlide': {
            'insertionIndex': '0'
        }
    }
]
response = slides_service.presentations().batchUpdate(
    presentationId=presentation_id,
    body={
        'requests': requests
    }
).execute()

# Add a new table to the slide
table_id = response['replies'][0]['createSlide']['objectId']
table_size = len(result['values'])
table = slides_service.presentations().pages().pageElements().create(
    presentationId=presentation_id,
    pageObjectId=table_id,
    body={
        'table': {
            'rowCount': table_size,
            'columnCount': len(result['values'][0])
        },
        'elementProperties': {
            'pageObjectId': table_id,
            'size': {
                'height': {
                    'magnitude': 300,
                    'unit': 'PT'
                },
                'width': {
                    'magnitude': 400,
                    'unit': 'PT'
                }
            },
            'transform': {
                'scaleX': 1,
                'scaleY': 1,
                'translateX': 0,
                'translateY': 0,
                'unit': 'PT'
            }
        }
    }
).execute()

# Fill the table with data from the spreadsheet
for i, row in enumerate(result['values']):
    for j, value in enumerate(row):
        cell_text = value
        cell_id = table['objectId'] + '/cell/{0}:{1}'.format(i+1, j+1)
        cell_request = {
            'insertText': {
                'objectId': cell_id,
                'insertionIndex': 0,
                'text': cell_text
            }
        }
        slides_service.presentations().batchUpdate(
            presentationId=presentation_id,
            body={
                'requests': [cell_request]
            }
        ).execute()

# Save the changes to the presentation
slides_service.presentations().batchUpdate(
    presentationId=presentation_id,
    body={
        'requests': requests
    }
).execute()

15) Look for ideas to improve your working capital

Let’s start my explaining what is working capital.

Working capital is the measure of a company’s short-term liquidity, and it represents the amount of money that is available to finance day-to-day operations. It is calculated as the difference between a company’s current assets (e.g. cash, accounts receivable, inventory) and its current liabilities (e.g. accounts payable, short-term loans, and other obligations due within one year).

Working capital management is critical for the financial health of a company because it impacts its ability to pay its bills, invest in growth opportunities, and generate profits. A positive working capital means that a company has more current assets than current liabilities, which provides a cushion to cover short-term cash needs. In contrast, a negative working capital means that a company has more current liabilities than current assets, which may indicate liquidity problems and difficulties in meeting short-term obligations.

Working capital and EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) are closely related because they both measure a company’s financial performance. EBITDA is a measure of a company’s operating profitability, calculated as revenue minus operating expenses. EBITDA is often used by investors and analysts as an indicator of a company’s ability to generate cash flow from its operations.

Working capital affects EBITDA because it impacts a company’s ability to invest in growth opportunities and generate revenue. For example, if a company has a negative working capital, it may have difficulty purchasing inventory or raw materials needed to fulfill orders, resulting in lost sales and lower revenue. Conversely, if a company has a positive working capital, it may have the flexibility to invest in growth opportunities or negotiate better payment terms with suppliers, which could improve profitability and EBITDA.

In summary, working capital and EBITDA are both important measures of a company’s financial health and performance, and they are closely related because working capital impacts a company’s ability to generate revenue and profitability.

Chat GPT-3 Prompt: I am a finance analyst and I need to identify opportunities for improving our Working Capital. Where can I start looking?

By focusing on these areas, you can identify opportunities for improving working capital and help the company achieve better financial performance. It is important to work closely with other departments and stakeholders to implement any changes and ensure that they are sustainable over the long term.

This is the end of part 3.

If you want to read part four and continue to learn how to leverage Chat GPT-3, come back next week to my profile.

Click here to read every story from Christian Martinez Founder of The Financial Fox (and thousands of other writers on Medium).

Join Medium with my referral link — Christian Martinez Founder of The Financial Fox