Tips on using the vehicle purchase tax return form
Vehicle purchase tax return formHow to fill it out?
The calculation formula for tax payable is: tax payable = taxable price × tax rate.
Calculation of tax rate for self-use vehicles: extra-price expenses × 10%, in which extra-price expenses do not include value-added tax;
Calculation of imported car tax rate: taxable price = (duty paid price + tariff) ÷ (1-consumption tax rate);
The purchase tax is 10% of the car’s selling price (excluding tax). The formula is:
New car purchase tax = car purchase price (tax included)/1.13*10%.
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, and then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the misalignment of the range of the second SUM function, otherwise an error will be reported.
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park
Vehicle Purchase Tax ReturnIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need a vehicle purchase tax return form, download it quickly. In addition,Increased salary schedule for promoted personnel,Tourism receptionist communication formIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful