Free cookie consent management tool by TermsFeed Policy Generator
  • Azure SQL Video
  •    13 page views
  •   1048 video views
  • 2024, June 19, Wednesday

#131 How to calculate fixed income profitability in Azure SQL Server

How to calculate the profitability of investments using compound interest using Azure SQL Server to perform financial calculations

Topics covered

:

Compound Interest: 🔹Understand the concept of compound interest and how to calculate the final amounts of your investments over time;
🔹Conversion from Annual to Monthly Profitability: Learn how to convert the annual rate of return into a monthly rate for more frequent calculations;
🔹Hierarchy of Records (CTE): Explore how to create a hierarchy of records by using a Common Table Expression (CTE) to calculate amounts over years or months;
🔹Investment Comparison: Compare different financial products, such as savings, CDB with 99% of the CDI and Treasury Direct, to make informed decisions.

This content contains
  • Content Video
  • Language Portuguese
  • Duration 19m 12s
  • Subtitles Não

  • Reading time 0 min 27 seg

avatar
Fabio Santos

Data Scientist and Consultant for Digital and Analytics Solutions


  • Share

Youtube Channel

@fabioms

Subscribe now