TSU Computer Products Option 3 for TSU

The sale of this product is temporarily suspended.

Sold: 2
Refunds: 0

Uploaded: 13.10.2010
Content: 01013125202940.rar (29,9 kB)

Seller

Letodream information about the seller and his items
offlineAsk a question

Seller will give you a gift certificate in the amount of 27,12 RUB for a positive review of the product purchased..

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

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
Seller will give you a gift certificate in the amount of 27,12 RUB for a positive review of the product purchased..
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)