How to solve financial calculation problems with excel

Method: Fill in the unit price in A1, fill in the quantity in B1, fill in the book **Total**A2 B2 C2 is the specific number, and the formula for C2 is: =A2*B2 in the third line to assume the condition, and calculate other necessary expenses in the fourth line:

Formula: =c2*

Then calculate the actual **total**:=c2+b4 of the fifth row, and the algorithm for another hypothetical condition is the same, and two results are obtained, when **price = selling price, there is no loss or profit.

Let's assume that the commission is; Stamp duty is levied unilaterally; If the transfer fee is not so high, 1 yuan will be charged.

**Expenditure: Sale Income:

Selling price * 1000 * (

The ask price at which ** is sold:

Fill in ** in the A1 box, write the quantity in B1, fill in the commission percentage in C1, and fill in the amount of stamp duty in D1 as "=A1*B1*."

Fill in the e1 box with transfer fee "=if(a1*b1=<1000,1,ceiling((a1*b1-1000) 1000, fill in the grid with commission "=a1*b1*c1".

Finally, find the answer in g1, the formula is "=(a1*b1+d1+e1+f1) 1000".

To put it simply, it is the sum of all expenses, divided by the number of shares, which is the flat amount sold**. If you also need to charge a commission for selling, then you can add a commission for selling.

The yield to maturity is the yield to maturity = (principal and interest to maturity and -**price) **price * year, enter this formula to you.

It is also necessary to use the formulas in financial calculations, and then they are all automatic calculations, which are very convenient and practical.

Need to know what you mean by financial literacy?

As long as there is a logical relationship between the data, it can be calculated in whole or in part using Excel.

Loan excel calculator, including equal principal and interest, equal principal and two kinds, and early repayment calculation, forget to apply!!

Let's talk about the operation first, there are common skills in the past.

1. For the grouping of different columns and columns, many excels occupy a place but the content does not want to see it for the time being, you can consider folding the group, and the shortcut key under win is alt shift ->

2. Use macros to keep the format of different tabs in excel uniform (in addition, it should be noted that the magnification ratio of different cells may be different, resulting in problems in the display of font size).

3. Remember to check the excel** at the end of the selection of the cell in the upper left corner (that is, click the mouse on the A1 cell in the upper left corner, so that the next person starts from the first column of the first row when opening it, so as to avoid the problem of reading from the bottom, saving others is a virtue ......）

4. If you need to set different fonts of Chinese and English in Excel, remember to set Chinese first and then set English, otherwise set English first and then set Chinese, the English font will be overwritten by the English font that comes with the Chinese font.

5. It is recommended to open the dotted line of the printed page when making excel, at least know how much length your excel** is, you can choose to print it on a page when printing, and excel will automatically compress it into a page.

6. The excel rows and columns that you don't use should be hidden, so as not to let others misoperate and move the cursor to a place outside 5000 rows, which is very unpleasant ......

7. Personally, I don't like the default ** line of excel, if you do it seriously, set the background to white, and the borders of those ** will disappear, and then set the borders yourself, I think this will look very refreshing (personal opinion). About analytics.

How much does the financial industry pay attention to Excel analysis? This is not much use, now as long as it is a financial college finance-related lectures are not recommended excel to do analysis, matlab data calculation is simple and practical, the operation is not complicated, the street is full of tutorials, it has really entered thousands of households, counting on the use of excel to do analysis I am exposed to the analysis of various financial data, in accounting side of the use of more:

1. Regarding the trend chart, the actual number and the growth rate should be drawn in a **, the coordinates on the left are the actual values, and the coordinates on the right are the growth percentages, which are clear and concise.

2. To calculate various financial figures, it is recommended that you prepare a template, and then you only need to paste the financial statements into the desired ratio according to that format. (Remember the negative number of the red table).

3. Office2010 has a trend chart, which directly draws the trend of the past few years in a cell, which is very practical.

4. Another commonly used is pivot table, but it is not limited to the financial industry, and the requirements for readers are also a bit high, and they are often used in year-end summaries.

Generally think of so much first, everyone in the financial industry looks at excel for a long time, so that the people who look at the excel sheets you do feel relaxed, convenient, is the best result, communicate with the people who read your excel sheets, the customer is God.

If you use the bond function key, you don't have a specific date, what is the face value? According to your meaning, there is a number of 855, and the face value may be 1000, which is lacking.

Send out the original question and take a look. The full meaning of the title is out.

Well, you have to learn financial excel and be familiar with those finance-related formulas.

There are many functions related to calculating the present value of annuities in Excel, and it is necessary to choose different functions according to the known conditions.