Planilha de Controle de Carteira de Investimentos em Excel 6.0
Investment Portfolio Management in Excel Tutorial
Introduction to the Investment Spreadsheet
- The video tutorial introduces version 6.0 of an investment portfolio management spreadsheet designed for use in both personal and business contexts.
- This spreadsheet is compatible with Microsoft Office Excel 2013 and later, as well as Google Sheets, allowing for easy sharing and collaboration.
- Users will receive a blank template to input their data, with instructions applicable to both Excel and Google Sheets.
Getting Started with the Spreadsheet
- Upon receiving the spreadsheet, users should review the help page for necessary instructions on how to utilize the tool effectively.
- It is recommended that users watch the tutorial while having their own spreadsheet open for better understanding of its functionalities.
Initial Setup: Capital and Asset Registration
- The first step involves entering the initial capital available for investments into the designated field within the spreadsheet.
- Users can register up to 10 different types of assets they plan to invest in, which helps categorize their investments effectively.
- The financial institution section allows registration of up to 10 institutions where investments are held, facilitating tracking across multiple platforms.
Investment Duration and Tracking
- Users can specify from which year they began investing; the spreadsheet accommodates a timeline spanning up to 20 years.
Making Investments: Inputting Data
- When making an investment entry, users must select their financial institution from a dropdown menu populated by previously registered institutions.
- Essential details such as asset type, expected return rate, investment date, duration until maturity (in days), and invested amount need to be filled out accurately.
Withdrawal Process and Calculations
- A withdrawal section allows users to input dates and amounts when withdrawing funds; this automatically calculates gross returns after taxes and net earnings based on withdrawals made.
Monitoring Performance: Reports Section
- The reports feature provides an overview of investments by year, detailing monthly values including total invested amounts, withdrawals made, gross returns earned, fees incurred, net earnings achieved, and overall profitability.
Investment Tracking and Reporting Features
Overview of the Spreadsheet Functionality
- The spreadsheet automatically compiles investment data based on the year of investment or withdrawal, allowing for a comprehensive overview over a span of 20 years.
- A summary report is available that condenses information into five-year intervals, enabling users to select specific years (e.g., from 2012 to 2016) for analysis.
- Users can analyze assets by selecting specific types, providing a more focused view compared to general reports that encompass all assets.
- Reports are generated automatically without user edits, reflecting real-time updates based on ongoing entries in the spreadsheet.
Dashboard Insights
- Dashboards present graphical representations of key metrics such as invested amounts, withdrawals, gross returns, and fees associated with investments.
- Users can visualize their financial data through various charts detailing investments by financial institution and net returns per asset type.
- The spreadsheet enhances control over investments by organizing data effectively and facilitating tracking of contributions and withdrawals.
Customization Options
- The spreadsheet is fully editable, allowing users to modify colors, fonts, and add new tabs or functionalities according to their preferences.