Welcome to Money Mata’s Blog

UAE focussed financial blog, provides actionable tools and ideas for Wealth Accumulation, Insurance and Financial Independence.

close

Categories

See More

Subscribe to Email Updates

Popular Stories

List of Medical Insurance companies in Dubai - Financial Planning in Dubai
How to invest in UAE, using 3 Bucket Investment Approach?
Top 5 Reasons Why I Use Zurich Futura Life Insurance...
Metlife Future Protect Review - Financial Planning in Dubai
Medical Insurance for Parents in Dubai - Financial Planning in Dubai
Written by Money Mata - aka - Damodhar Mata
on February 02, 2016

What is a Personal Balance Sheet?

It is a statement which helps you clearly see, where you stand financially on a particular date?

It shows how much you own and how much you owe...

It is an organised statement of your assets and liabilities; helping you understand your net-worth at a given point.

Hence it is also known as Net-Worth Statement.

Free Download

Download and use this unique but very handy Personal Balance Sheet Template to give you a snapshot of your financial affairs for a given period.

When you hear the word Balance sheet, don't be perturbed by the accounting jargon. This template makes the process very easy; needing no prior accounting knowledge or background.


Personal Balance Sheet Template.jpg


What is unique about this Personal Balance Sheet Template?

This template has a unique feature for the expats in UAE. 

While it allows you to record assets and liabilities, and see your net worth in dirhams, it also has a provision to enter the latest exchange rate of your home currency and see the figures both in AED and your home currency, like INR, GBP, EURO etc...

Balancesheet Header

All you have to do is enter the latest currency rate in the space provided and the template picks it up wherever necessary and shows you the figures in both currencies. 


How to use the Personal Balance Sheet Template?

The template consists of 2 sheets.

The first sheet summary of your assets and liabilities classified under various heads.

It also enables you to record the income from the asset or expense/charges on the asset or liability.

The Sheet 2 is where most of the entries and editing happen, it enables you to record your assets and liabilities in detail; for e.g.

You can record multiple details of an asset( Property in this case) like address, type of property, purchase price, year of purchase, mortgage repayments, current mortgage outstanding and the current market value...

Personal Balance Sheet

You can also record various aspects of your liabilities; like the name of the creditor/bank, Type of loan, the collateral for the loan, starting balance, maturity date of the loan, monthly repayment and the balance due.

liabilities

When you have entered the details of the assets and liabilities under particular heads on the sheet 2, the data is automatically captured on sheet one, which calculates your net-worth.

Positive or Negative Networth

If your assets are more than your liabilities, then your net worth is positive if your liabilities are more than your assets, then your net worth is negative.

In addition to the net worth, this template also enables you to calculate the following;

  1. Number of months you can survive on your liquid assets without an income
  2. Debts to assets ratio
  3. Investment assets to net worth ratio
  4. Liquid assets

financial ratios

All in all, it is a very useful template, providing vital insights into your financial situation on a single page.

Go ahead; fill the following form and download this template to take control of your financial future..

Let Us Know What You Thought about this Post.

Put your Comment Below.

You may also like:

Financial Planning CashFlow & Budgeting

Free Budget Planner - 2018 - Exclusive for UAE Residents.

A Budget Planner that actually works! It is December, and 2017 is coming to an end. Time to draw your family budget for ...

CashFlow & Budgeting

Are you spending it or keeping it - How to Save more in UAE? - Financial Planning in Dubai

What brings you to UAE? I usually ask this question to every expat I meet, and I meet as many as 5 - 10 every week.

Financial Planning CashFlow & Budgeting

How to keep your budget on track? - Financial Planning in Dubai

Now that you've created your budget, how do you keep it on track? The key is in diligently recording and tracking your e...