- Arts & Culture 5941
- Business & Economics 689
- Computers 319
- Dictionaries & Encyclopedias 81
- Education & Science 75925
- Abstracts 252
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 2256
- Coursework 15546
- Culture 9
- Diplomas 411
- Drawings 574
- Ecology 6
- Economy 83
- English 75
- Ethics, Aesthetics 3
- For Education Students 17613
- Foreign Languages 11
- Geography 3
- Geology 1
- History 89
- Maps & Atlases 5
- Mathematics 13856
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 14865
- Political Science 5
- Practical Work 101
- Psychology 60
- Religion 4
- Russian and culture of speech 8
- School Textbooks 7
- Sexology 42
- Sociology 9
- Summaries, Cribs 87
- Test Answers 150
- Tests 9243
- Textbooks for Colleges and Universities 32
- Theses 24
- To Help Graduate Students 14
- To Help the Entrant 37
- Vetting 364
- Works 13
- Информатика 10
- Engineering 3063
- Fiction 696
- House, Family & Entertainment 107
- Law 132
- Website Promotion 71
TSU Computer Products Option 3 for TSU
Refunds: 0
Uploaded: 13.10.2010
Content: 01013125202940.rar 29,9 kB
Seller will give you a gift certificate in the amount of
Product description
Tyumen State University
Computer control products for TSU Option 3
Topic: "Using the table editor MS Excel and VBA in economic calculations
Situation: In this paper, we consider the following simple model: The state is seeking to increase the amount of tax revenues; the value of tax deductions depends on the tax rates (TXRT - tax rate) and on the size of the profits of enterprises (PRF - profit); the profit margin, in turn, depends on the profitability of the enterprise (Rn). The question arises, as in such complex relationships to establish the value of the tax rate to get the maximum payments to the budget.
Task: investigate the dependence of revenues from the tax rates and on profitability. To take study period of 10 years. Find the optimal value and justify the tax. Search not lead programmatically and visually - by plotting.
The order of performance
1. Get the original data.
As can be seen from the above, the value of revenues influenced by the following parameters:
- Income tax rate (TXRT - tax rate),%;
- The initial capital of the company (CPo), rubles
- Profitability of the company (RN),%.
In this study, all options for jobs performed for payment TXRT values \u200b\u200bfrom 10% to 80% in increments of 10%. The values \u200b\u200bof the original data points are shown in Table 1.
Values \u200b\u200bof margins to select from a specified range in increments of 5% (all variants).
Version number the last digit of the record-book CPo Range Rn
1 1.2 100 10% ... 30%
2 3.4 200 30% ... 50%
3 5.6 300 50% ... 70%
4 7.8 400 70% ... 90%
5 9.0 500 90% ... 110%
2. Create a user-defined function to calculate revenue.
The algorithm of calculations carried out by this function:
For each year of the study period (ie, 10 times), follow these steps.
Step 1. Calculate the value of pre-tax profits by the formula:
PRF = CP • RN
Where the CP - the value of the company's capital in the previous year (in the first year it is SRO)
STEP 2. Calculate the value of tax deductions:
BD = PRF - BD
STEP 3: Calculate the value of the company's capital in the current year:
CP = CP + PRF - BD
Step 4. Increase the total amount of payments to the budget by the amount BDt deductions for the year (UDF already crowded). Function name BDt (category: a user-defined).
With this function, and it will be calculated filled table (will be sent to you in the load).
3. Perform the necessary calculations payments to the budget, filling in the table, using the established function BDt.
4. The data obtained to construct a diagram total range.
5. Analyze the results on the resulting graph. Respond to the following questions: the effect on payments to the budget increase profitability? Which company (with high or low profitability) Suitable heavily taxed?
7. Using the search for a solution, to find different values \u200b\u200bof profitability optimum value of the tax rate.
On a new sheet of the workbook to build the table depending revenues at the optimal tax rate, which implies a maximum value of profitability BDt Table 2
The dependence of revenue on profitability
(At the optimum tax rate)
SRO Rn TXRT,% BDt (Rn)
100 30%
100 60%
100 90%
100 120%
The initial capital of the company considered to be 100 rubles. Search optimal tax rates lead using Excel Solver. As the target cells to select a cell in the column BDt (Rn); changing cells - from the column values \u200b\u200bwill be obtained TXRT optimal tax rate.
Making report
The report is submitted on paper and must include title, purpose, printing raw data, tables, diagrams and texts created in the VBA functions.
Evaluation criteria
- Finish work: perform all the tasks, built all the necessary charts and tables
Additional information
Tyumen State University
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
TSU Computer Products Option 3 for TSU
Feedback
0Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |