how to do a simple calculation of your net worth in microsoft excel using formulas

8/10/2019 How to Do a Simple Calculation of Your Net Worth in Microsoft Excel Using Formulas

1/64

HOW TO DO A SIMPLE

CALCULATION OF YOUR NET

WORTH IN MICROSOFT EXCELUSING FORMULAS

1

2015 Roanne Joy- thegreatva.wordpress.com (Your VAProfessional)


2/64

2

WHAT IS NETWORTH?



3/64

3

THE AMOUNT BY WHICH

ASSETS EXCEED LIABILITIES.



4/64

WHATAREASSETS?

1



5/64

THEVALUEOFALLTHE

THINGSYOUOWN

1



6/64

6



7/64

WHATISLIABILITIES?

1



8/64

8

THE VALUE OF YOUR DEBTS

OR OBLIGATION THAT

ARISES



9/64

9


LETS START TO KNOW

YOUR NET WORTH


10/64

10

GO TO START BUTTON



11/64


12/64

12

HIGHLIGHT IT FROM A to K THEN

CLICK MERGE and CENTER



13/64

13

HIGHLIGHT AND CLICK THE

BOLD THEN CHANGE THE

FONT AND FONT SIZE



14/64

JUST COPY THE FORMAT1



15/64

15



16/64

16



17/64

HIGHLIGHT AND CLICKTHE COMMA STYLE TO

COMMA

ALL THE NUMBERS1



18/64

18



19/64

19



20/64

CLICK THE AUTO SUM TO

TOTAL ALL THE TOTALS1



21/64

21



22/64

OR USE THE INSERT

FUNCTION1



23/64

23



24/64

24



25/64

25


OR USE THE FORMULA


26/64

26

OR USE THE FORMULA



27/64

JUST COPY THE

FORMULA THEN PRESS

ENTER AND TOTAL IT ALL.1



28/64


29/64

29



30/64

30



31/64


32/64

BECAUSE OF THEFORMULA IT WILL

CHANGE

AUTOMATICALLY.1



33/64

33



34/64

THESTOCKSIS50,000 ANDEARNSACAPITALGAINOF

50,000. THETOTALEARNINGS

NOWIS100,0001



35/64

35



36/64

MORE EXAMPLES

1



37/64

THEBUSINESS EARNS20,000 THIS MONTH SO

THE EARNINGS BECAME

100,0001



38/64

38



39/64


40/64

DID YOU NOTICE THETOTAL ASSETS? IT

CHANGE

AUTOMATICALLY.1



41/64

SUBTRACT THE TOTALASSETS AND TOTAL

LIABILITIES TO TOTAL

THE NET WORTH1



42/64

42



43/64

43

2015 Roanne Joy- thegreatva.wordpress.com (Your VA

Professional)


44/64


45/64

JUST USE THE FORMULA,

=D31-DJ22 THEN PRESS

ENTER.1


Professional)


46/64

46


Professional)


47/64


48/64

HIGHLIGHTFIRSTTHE

SELECTEDCELLSTOAPPLY

BORDERS1


Professional)


49/64

49


Professional)


50/64


51/64


52/64

IFYOUWANTTOMAKEITMORE

COLORFUL, USETHEME

COLORS1


Professional)


53/64

HIGHLIGHT THE

SELECTED CELLS TO

APPLY THEME COLORS.1


Professional)


54/64

54


Professional)


55/64

55


Professional)


56/64

SAVE THE DOCUMENT1


Professional)


57/64


58/64

58


Professional)

TYPE YOUR FILE NAME


59/64

59

TYPE YOUR FILE NAME

THEN CLICK SAVE


Professional)


60/64

YOUARENOWAWAREOF

YOURNETWORTH!1


Professional)


61/64

YOUR NET WORTH IS A

WAY TO MONITOR YOUR

FINANCIAL PROGRESS1


Professional)


62/64

EVERY GOOD FINANCIAL

DECISION YOU MAKE

RAISES YOUR NET

WORTH1


Professional)


63/64

EVERY POOR FINANCIAL

DECISION YOU MAKE

DROPS YOUR NET WORTH1


Professional)


64/64

64

YOUR NET WORTH TO THE

WORLD IS USUALLYDETERMINED BY WHAT REMAINS

AFTER YOUR BAD HABITS ARE

SUBTRACTED FROM YOUR GOODONES.

-BENJAMIN FRANKLIN

how to do a simple calculation of your net worth in microsoft excel using formulas

Documents