Original financial management tool for one year

It was an occasional opportunity to go into the door of financial management, but it also became a turning point in my life!

Our financial services were managed by our wife before last June. However, my wife is not very sensitive to finance. I occasionally asked her how much money we have saved now? She always said, probably ...... Maybe ...... Yes ....... Later, I asked her to study financial management because most families had financial management services. Although there is not much money, it should be well managed. I didn't expect her to dislike financial management, fund management, and don't want to do it. Let me learn it myself. I don't want to, but I still know that it is very important, so I can't do it myself! Unexpectedly, after studying financial management, my view of money and success has undergone significant changes.

I learned the poor father and rich father recommended on the Internet, and the money view was slowly changed. I did my work seriously. After reading it, I did not put it down. Instead, I found the author's foreign website and started playing the cash flow online game he created: CA $ hflow the web game .). Every time I play this game, I feel like I am growing and learning a lot of new financial things. Last year, I wrote an article titled "start investment and financial management-poor dad and rich dad". If you are interested, you can take a look.

I have been playing for a year now, and I have created many tools in the process. Some tools are very important and require monthly maintenance or even maintenance at any time, such as the monthly balance sheet and cash flow control table. Some tools will affect my investment behavior, such as the purchase planning table. I will list them one by one:

Balance Sheet

Cash flow control table

Future asset planning table

Bank Loan Planning

Credit card analysis table

Equal cost Calculator

House Purchase Plan

Changes in house buying assets and liabilities

Monthly Income Statement

 

 

Balance Sheet

The most important financial statement, when the number of balance sheet. This table is informative and describes your current assets (cash assets, real estate), liabilities, cash flow (active income, passive income, expenditure, consumption, and important traffic ). This table shows the financial status at that time. Below is the table:

You can see that the information is rich. Of course, this is the latest version. The first version is much simpler than this one. It was done by a completely simulated cashflow game:

I will make a financial statistics at the end of each month and take a snapshot of this table:

In this way, I can review the financial status of each month.

 

Cash flow control table

Cash flow control is critical! Once a company's cash flow breaks, it is basically not far from bankruptcy. The break of personal and family cash flows will affect your life, and even affect your bank's credit history and others' trust in you!

Therefore, I made a simple estimation of future cash inflows and made statistics in the table, which makes it easy to predict what actions should be taken for a certain amount of money, to complete cash flow control.

 

Future asset planning table

This table is a very interesting table. You can use it to calculate how many assets you will have in the next ten or two years. It can also reflect the effect of compound interest.

For example, if you earn 0.1 million yuan a year for your work and you have a deposit of 0.1 million yuan now, you have made an additional business, with a yield of 30% yuan a year (that is, 0.1 million yuan can earn 30 thousand yuan a year, there are too many such businesses.) How much do you have in 10 years? What about 20 years later?

Let's first look at a simple schematic table:

We can see that you have 5.64 million in 10 years and 82.02 million in 20 years. Compound interest is amazing!

Let's take a look at a more complete schedule, or the example above:

Assume that this person is 25 years old and initially has 0.1 million credit loans at the bank, and his business can earn 0.3 million yuan a year, his job income is 30% yuan, and his annual expenditure is currently 0.1 million, more and more in the future. We can see that when he was 35 years old, he could have 15.5 million yuan, with an annual income of 4 million. When he was 45 years old, he had 0.2 billion million yuan, with an annual income of 50 million!

What do you think?

Why do I need to borrow money from a bank? Loan Interest is lower than the rate of return, so financing is used to make money. In principle, the more you get, the more you earn! The higher the risk!

 

Bank Loan Planning

To raise funds, the first idea is to borrow money from a bank. Banks have many types of loans, including mortgage loans and credit loans. If we borrow 0.3 million yuan from a bank, borrow for four years, and the interest rate is 12%, and the business rate is 30%, what is the difference between loans and non-loans? See the following table:

Conclusion: The monthly net income increases by 4330 yuan. In the end, the monthly net income increases by 6226 yuan. This is still a credit loan. If you use a real estate mortgage loan, the bank's interest will be lower.

Therefore, the richer the person needs to borrow money from the bank, and the poorer the person needs to deposit money in the bank!

 

Credit card analysis table

In addition to direct loans, we can also use credit cards for bank money. It is illegal to cash in, but everyone has their own solutions. Therefore, when you have a channel, all you need to do is to apply for a credit card with more. The following is my current credit card. It took less than a year to use it, and the credit limit is already 50 thousand. Two more applications are in process. However, I did not apply for much trouble.

Among them, the amount of interest owed is the amount of installment money in the credit card. Regular installments make it a high-quality customer of a bank. Now that you have to know what the cost is. The following is my analysis on credit cards of different banks:

On the right is the installment fee for each credit card, and on the left is the actual annual interest rate after conversion. How to convert? I have dedicated tools later! As you can see, the cost of credit card financing is about 10-15% in annualization.

In addition, there are more real data to measure the actual rate of return:

Here, we enter the number of months in installments and the rate, list the number of money in and out of each date, and then use the xirr function to calculateInternal Rate of Return.

 

Equal cost Calculator

Whether it is a bank loan or credit card installment business, it is actually based on the same amount of principal and interest. As a financial administrator, it is necessary to have a deep understanding of this repayment method. In the market, although some loan contracts do not cover the same amount of principal and interest, they are basically in this way. For example, the credit card installment payment service shown in the figure above is divided into three phases, and the bank says the rate for each period is 0.72%, and the fee for each period is 3405.33 yuan. Isn't it the same as the same amount of principal and interest repayment? This is just a change in the concept of a bank.

The point is, how is the interest rate calculated? In addition to the EXCEL function used to calculate the internal rate of return, because I am engaged in it, I also specially compiled a program to calculate the interest rate of the same amount of interest, that is, the actual interest rate is calculated based on the loan, month, and monthly repayment amount. This type of calculator cannot be found in the sky. It can only be written by yourself! The second item:

The webpage program can be opened on the mobile phone and computed at any time.

House Purchase Plan

Purchasing a house is a highly leveraged investment. You use a 30% down payment to trigger a 70% mortgage (6% interest rate. (In fact, the 30% down payment can also be used as a credit to lend a part to the bank .) So, how can I buy a house? :

Result:

You can also calculate the rate of return on your assets for different house price increases:

Changes in house buying assets and liabilities

After analyzing how to buy a house is the most cost-effective, what is my financial status after a large operation like purchasing a house? I made another new balance sheet to evaluate my assets, cash flows, and expenses after purchasing a house. This not only adjusts the expectation of purchasing a house price, but also predicts the future economic situation.

 

 

Monthly Income Statement

When I got home at the beginning of the year, I asked a relative to save the money to me and deposit it to me every month. I gave him two times the bank's interest. To help him better understand his benefits, I have compiled a 1000-based income table. You can calculate the amount of RMB 10% per year, 1000 yuan per month, 30 years, and 1000*360 = 0.36 million yuan per month?

For the answer, see:

......

1.7 million.

After I gave it to him, I found that I did what the insurance company did? Khan ......

 

Now, this blog is here. Tools that can be made public have been shared here, but some business-related tools are not made public. This article is all dry! In this way, you can record the forms you have designed and the financial knowledge behind the tools you have learned over the past year.

Original financial management tool for one year