Personal Financial Planning Spreadsheet

Looking for a spreadsheet to help you with your budget?

We at Maestri Investment Group Ltd. have made a spreadsheet that is simple but should help you, or at least guide you on how to do your financial planning, not just for a month but for the whole year!

 No more guessing how much you'll have in three months' time. Know and consolidate!

Download Now your Personal Financial  Planning Worksheet!

• This spreadsheet may be just an example, but here are some tips:
  
  1. Put the entries (salary, loans, interest received, etc.) as positive values ​​and at the top of the spreadsheet in the “Entries” box.
  
  2. Put the outputs (water, electricity, telephone bills, etc.) as negative values ​​in the “Outputs” box.
  
  3. Always try to place the outputs in the following order:
  

• The first outings should be those that vary less from month to month (payments on loans, investments, monthly fees, etc.).

• The departures that occur once a year (such as IPVA, IPTU, Taxes, etc.) are more organized if placed in the order of the month in which they are paid, that is;

• From the annual payments, put the first that comes in the first month, under that put what goes in the following month, and so on. This makes your spreadsheet more organized and gives you a better idea of ​​what's going on with your money.
  
  4. Finally, there are the outputs that vary the most (such as credit cards, everyday expenses and other discretionary expenses).
  

  BONUS TIP!

• Put the average amount of expenses that vary (such as water, electricity, telephone bills, etc.) already in the 'cells' for the coming months! It helps you with planning and cuts down on those nasty surprises. 

• The same goes for purchases in installments! Adding the value of the card's installments in the cells for the next few months helps prevent you from accidentally spending more than you expected. If your card is NuBank, you can find the open amount of future invoices by accessing the app itself.  

(Edit Feb, 10th 2020)

FAQ

       After the release of our spreadsheet, several people started to have some doubts about how much of the budget to allocate to each part. So here are some general tips that are advisable to help you when budgeting:

From your salary:

• Housing costs - 25% up to 30% 

  (Rent, Water, Electricity…)

• Retirement - 10% - 15%
  If you can, more.

• Emergency reserve - 3 to 6 months of expenses

• Check your bank account at least 3 times a week

  One tip is the SMS notification service!

• If you can't save these levels, remember:

  "Habit is more important than amount!"

          So if you can't get 5% each month to build your emergency reserve, start with 3% or even 1%. In the beginning, the important thing is to create the habit!

Want to learn more?

Check out our course on Personal Finances for Beginners on Skillshare! https://skl.sh/2VbhNIu