Currently, the development of software tools and programming languages is on the increase, which allow various operations to be performed on data entered by users. For the process of developing a capital budget, the application of Software Excel is commonly used, although It is not the only usable application. There are variable data that are used in the capital budget that are obtained through official web pages, in this case from the government, in order to make the budget as accurate as possible; There are methods to obtain said data without the need to constantly consult them from the Web pages, for example the use of Web services or the application's own techniques, such as the Excel mentioned below.
Cetes management through the Office parcel application - Excel in real time
The development of a capital budget involves obtaining various data to obtain the desired result by any investor, that is, if the investment penetration is going to obtain profits in the short, long term or none of the above. Some data that the investor must analyze in detail are the fixed and variable costs of the budget for the decision making to concretize or decline a business.
Fixed costs are those that do not depend on the activity of the company or production, that is, overhead, these costs are constant and permanent for an organization to move forward; They can vary over time and the organization must pay them, whether or not it produces, for example, depreciation, amortization, salary, electricity, office or land rent, telephone and internet service, drinking water, maintenance, advertising, among others. Variable costs are those that fluctuate in proportion to the activity generated by an organization, for example commissions generated by sales of goods or services, labor, distribution costs, external suppliers to assemble and generate a product or services, some of These variable costs are regulated by the government, as is the case with cetes.
The CETES (acronym of certificates of the treasury of the federation) are titles presented in the form of credit to the bearer that are issued by the federal government in a money market in order to be invested by the government either to pay its commitments and as a result the investor gets a profit or interest as well as the government.
Éste dato es utilizado para realizar las operaciones del presupuesto de capital con la finalidad de qué sea más preciso y se tome una decisión a partir de cálculos que proporcionen datos reales. El inconveniente de este dato es que es un dato variable es decir que el gobierno lo manipula dependiendo de diversas fuentes que toma en cuenta para calcularlo. El inconveniente se presenta cuando a un inversionista se le presenta este presupuesto de capital al día siguiente puede cambiar su valor y por consiguiente afectar el resultado positivamente o negativamente en la toma de una decisión.
There are various software tools that can obtain this data without constantly consulting it on the official website of the Banco de México government, some analysts ask Software developers to implement a Software that performs the budget and with the help of Web services obtain the value in real time, another way is to use Excel applying a procedure that obtains the value in real time every time the user updates it, every period of time, or every time the Excel document where the capital budget is found is opened.
The process to obtain the value of Cetes is:
- Get the official page where you can see the value of Cetes, in this case the Banco de México page - http://www.banxico.org.mx/portal-mercado-valores/. Select the value of Cetes to use, copy and paste into an Excel cell. Next, paste options are displayed and an updateable web query is selected. A window opens where the official page of Banco de México is displayed and the value is selected by means of the symbol and it becomes a symbol, then import is selected..The value appears in the cell and it changes to gray. If you want to define the update time period:
- The Cetes value is selected, then right click, select data range properties, in the update control section select the one indicated for each case.
conclusion
The existence of tacit knowledge about the use and exploitation of the Excel Software tool facilitates the development or creation process of a capital budgeting procedure; The choice of the Software tool depends on the knowledge and needs of each user. In this case, the Office - Excel package was used and a method was presented to link the value of Cetes to the Software, making it easier for users to make capital budgets with a minimum of calculation errors.
