Excel 4 Ur Business

Net worth is one of those phrases that you hear now and then, but what does it mean? Simply put, it is the sum of all your assets (things you own) minus the sum of all your liabilities (things you owe). Take what you own and subtract what you owe to get your net worth.

Net worth is a way to track your financial progress or to get a snapshot of your financial status at a given time. In a way, net worth can be thought of as a measure of your financial health. The greater your net worth, the greater your ability to achieve major financial goals and to withstand unexpected financial stresses, such as being laid off or having a serious illness.

(more…)

In the calculations that have been presented so far in this chapter, the interest rate was a variable that you either know or had to estimate. But what if you know the other parameters of a loan or other transaction but not the interest rate? Then you can calculate it using the RATE function.

(more…)

Present value is similar to future value in that it represents the value of an investment. However, it calculates the value of money you will receive in the future from the perspective of right now. A dollar today is always worth more than a dollar tomorrow because of the interest you can earn on today’s dollar. This might not make sense right off, so let’s look at a couple of examples.

(more…)

The concept of future value is quite simple and is based on the fact that a given amount of money received today will be worth more at some time in the future. It’s easy to understand why this is true-money you have now can be invested and earn interest, hence its value increases.

(more…)

When you make a payment on a loan, each payment is divided into two parts:

• Part of the payment is for that month’s interest charge.
• The remainder of the payment goes toward paying down the principal.

Each month you pay down the loan balance, or principal, by some amount. This means that the next month the interest charge will be less because the charge is calculated as the interest rate multiplied by the balance. The total payment amount is fixed, which means that each succeeding month less of your payment goes toward interest and more toward the principal. To calculate the amount that goes toward principal for a specific payment, use the function.

(more…)

If you ask people what they do not have enough of, the most common answer is likely to be “money.” No matter how hard you work, no matter how good your job is, it can be a struggle to make ends meet while maintaining the standard of living you want. Can you do anything about this situation? Yes, you can! One approach is to bring in more money, but that’s not something I can help you with. The other is to take control of your finances, and that’s something I definitely can help you with!

Facing the Problem

Before getting down to details, it is a good idea to look at the problems facing many people today when it comes to their finances. The majority of Americans are financially illiterate. If you fall into this category, don’t blame yourself-after all, personal finance classes are not offered in most high schools or colleges and, even when they are, they are usually a low priority for most students. People are expected to somehow absorb all the intricacies of personal finance on their own, and, in my opinion, that’s asking a lot.

Some people are hesitant to admit they do not know much about personal finance. In our society, competence is valued and you might feel embarrassed to admit you don’t know much about the topic. That’s exactly the wrong attitude! Competence comes from learning, and the first step in learning is admitting you need to learn. Getting this book was a good first step.

Another source of problems is that some people equate finances with investing. There is undoubtedly something very alluring about the stock market and the chance to see your investments grow over the months and years. Investing is, in fact, important, and several chapters of this book are devoted to it. But investing is only part of the personal finance picture.

Excel is Microsoft’s spreadsheet program. It is not a home finance program, so why am I using it in this website? Excel is a very flexible program that has applications in many different areas, and one of them is finance. Excel might not be designed specifically for personal finance, but it certainly has the tools you need. Let’s take a look at the fundamentals of Excel. If you already have some familiarity with Excel, you might want to skim or skip this post.

(more…)

Few people can make it though life without taking out one or more loans. By extending payments over a period of time, a loan enables you to buy something now that otherwise you would have to save for over a long time. Big ticket items, such as a car or house, are perhaps the most common uses of loans.

(more…)