ADE Andalucía 2018 Past Paper PDF

## CUERPO: PROFESORES DE ENSEÑANZA SECUNDARIA (590) ## ESPECIALIDAD: ADMINISTRACIÓN DE EMPRESAS (101) ### INSTRUCCIONES: - The test will consist of the completion of three practical exercises from among six proposed by the Board. - The exercises will be distributed in three sections, with the appl...

## CUERPO: PROFESORES DE ENSEÑANZA SECUNDARIA (590) ## ESPECIALIDAD: ADMINISTRACIÓN DE EMPRESAS (101) ### INSTRUCCIONES: - The test will consist of the completion of three practical exercises from among six proposed by the Board. - The exercises will be distributed in three sections, with the applicant having to choose one from among the two proposed in each section. - These exercises will require the application of accounting, financial, tax or any other techniques related to the current syllabus. ## ESPECIALIDAD: ADMINISTRACIÓN DE EMPRESAS (101) ### APARTADO A #### EJERCICIO A.1 - A company is considering an investment project that requires an initial outlay of 1,000,000 euros. - The project will last for 10 years, after which time it will be dismantled, resulting in payments of 60,000 euros for demolition and receipts of 100,000 euros for the sale of the used machinery. - The first two years will be dedicated to the assembly of the facilities so there will be no receipts or payments (only the initial outlay mentioned). - The revenue from sales in the first year of operation is estimated at 20,000 euros per month, increasing annually by 4% (geometric progression). - All sales are collected at the end of the month. - The planned outlays are constant and payable in arrears: 60,000 euros every six months for the first four years of operation and 40,000 euros every three months for the last four years. - *The project is valued at a 10% effective annual interest rate.* - **It is requested:** - Calculate the discounted revenue of the project. - Calculate the discounted outlays of the project. - Calculate the net present value of the investment. #### EJERCICIO A.2 - Settle the following credit account using the Hamburg method. - **CONDITIONS:** - Opening date: 1 April. - Credit limit: 10,000 euros. - Opening commission 3%. Minimum 50 euros. - Other opening expenses: 150 euros. - Commission on the highest balance exceeding: 0.5%. - Availability commission: 0.18%. - Interest on credit used: 16%. - Interest on excess of credit: 22%. - Interest on creditor balances: 0.10% - IRPF withholding: 19%. - Civil year. - Settlement date: 30 June. - **MOVEMENTS:** | DATE | CONCEPT | CAPITAL | VALUE | |:---|:---|:---|:---| | 3-April | Payment of wages | 6,120.- |3-April| |13-April | Your remittance of effects | 19,700.- | 20-April | | 15-April | Public Treasury. Mod. 303 | 5,100.- |15-April| |15-April | Public Treasury. Mod. 111| 2,830.- | 15-April | | 25-April | Letter to your charge | 3,875.- | 26-April | | 20-May | Transfer to your favor | 1,685.- |20-May| | 25-May | Charge system RED Soc. Sec. | 1,980.- |30-May| | 3-June | Your order of transfer | 15,390.- | 3-June | | 8-June | Effect returned | 935.- | 20-April | | 14-June | Effect returned | 1,600.- | 20-April | | 18-June | Transfer to your favor | 8,250.- | 18-June | | 25-June | Payment of taxes | 3,500.- | 25-June | ## ESPECIALIDAD: ADMINISTRATION OF COMPANIES (101) ### APARTADO B #### EXERCISE B.1 - Consulting & Training is a company that provides business consulting services and professional training and retraining (activity exempt from VAT). - Both activities are carried out in the same building, so they share electricity, water and telecommunication costs. - In the 2016 financial year, Consulting & Training invoiced 130,000 euros for business consulting services and 90,000 for professional training and retraining services. - During the first quarter of 2017, it has carried out the following operations: - It purchases a photocopier for use in both activities for 6,000 euros. - It purchases computers for the professional training and retraining activity for 12,000 euros. - It purchases IT applications for the business consulting service for 3,000 euros. - The electricity invoices amount to 1,540 euros. - The telecommunications invoice amount to 900 euros. - The invoices for the supply of water amount to 280 euros. - It sells computers purchased in 2016 for the professional training and retraining activity for 2,000 euros. The purchase price was 5,000 euros. - It purchases various office supplies for the business consulting service for 1,200 euros. - It purchases various stationery for the professional training and retraining activity for 3,00 euros. - The cost of maintaining the IT applications for the business consulting service is 600 euros. - It invoices 20,000 euros for business consulting services and 30,000 for training services. - During the second quarter of 2017, it has carried out the following operations: - It sells printers purchased in 2010 for the professional training and retraining activity for 1,000 euros. The purchase price was 3,000 euros. - It purchases various furniture for use in both activities for 9,000 euros. - It purchases various office supplies for the business consulting service for 2,500 euros. - The electricity invoices amount to 1, 600 euros. - The telecommunications invoice amount to 900 euros. - The invoices for the supply of water amount to 290 euros. - The cost of maintaining the IT applications for the business consulting service is 600 euros. - It purchases various stationery for the professional training and retraining activity for 4, 000 euros. - It invoices 25,000 euros for business consulting services and 30,000 for training services. - During the third quarter of 2017, it has carried out the following operations: - It receives an invoice from a printer for the printing of posters for the professional training and retraining activity for 3, 500 euros. - It purchases various office supplies for the business consulting service for 2,000 euros. - The electricity invoices amount to 1, 000 euros. - The telecommunications invoice amount to 900 euros. - The invoices for the supply of water amount to 260 euros. - It purchases various stationery for the professional training and retraining activity for 800 euros. - The cost of maintaining the IT applications for the business consulting service is 600 euros. - It invoices 22,000 euros for business consulting services and 10,000 for training services. - During the fourth quarter of 2017, it has carried out the following operations: - It purchases various office supplies for the business consulting service for 1,800 euros. - The electricity invoices amount to 1,300 euros. - The telecommunications invoice amount to 900 euros. - The invoices for the supply of water amount to 275 euros. - It purchases various office supplies for the professional training and retraining activity for 1,500 euros. - The cost of maintaining the IT applications for the business consulting service is 600 euros. - It invoices 23,000 euros for business consulting services and 30,000 for training services. - **IT IS REQUESTED:** - To prepare the VAT self-assessments corresponding to the four quarters of 2017, applying the special pro-rata regime. - **NOTE FOR CLARIFICATION:** The VAT is not included in any of the amounts of the exercise. #### EXERCISE B.2 - An employee in the professional category of technical engineer (contribution group 2), employed on an indefinite contract and on a full-time basis for the past 10 years, goes off sick due to a non-work-related accident on 10 April and remains so until 20 May. - His monthly remuneration is as follows: - Base salary: 2,500 euros. - Seniority: 300 euros. - Agreement bonus: 90 euros. - Productivity bonus: 50 euros. - In addition, he receives two annual extra payments (June and December) each equivalent to one month's base salary and seniority, and a profit bonus of 2, 400 euros per year in November. - During April, he earned 50 euros for overtime worked. - For the year immediately prior to the month of the leave, he paid 900 euros in overtime. - The IRPF withholding is 20%. - **With the above data and the data in ANNEX I:** - Calculate the social security contributions payable by the company, payable by the employee, and the total amount to be paid for the month of April. - Calculate the net amount to be received by the employee for the month of April. |Contribution Group|Categories of Professionals| Minimum bases euros/month|Maximum bases euros/month| |:---|:---|:---|:---| |1|Engineers and Graduates. Senior management staff not included in Article 1.3.c of the Workers' Statute|1,199.10| 3.751.20| |2|Technical Engineers, Experts and Qualified Assistants |994.20| 3.751.20| |3|Administrative and Workshop Managers|864.90|3.751.20| |4|Non-Qualified Assistants|858.60|3.751.20| |5|Administrative Officials |858.60|3.751.20| |6|Subordinates|858.60| 3.751.20| |7|Administrative Assistants|858.60|3.751.20| |8|First and Second Level Officials|Minimum bases euros/day|Maximum bases euros/day| |9|Third-Level Officials and Specialists|28.62|125.04| |10|Street Workers|28.62|125.04| |11|Employees under 18 years of age, whatever their professional category|28.62|125.04| |CONTINGENCIES | COMPANY | WORKERS | TOTAL | |---|---|---|---| |Common|23.60| 4.70| 28.30| |Overtime due to Force Majeure|12.00|2.00|14.00| |Rest Overtime |23.60|4.70|28.30| |UNEMPLOYMENT | COMPANY | WORKERS | TOTAL | |---|---|---|---| |General Type| 5.50|1.55|7.05| |Contract of definite duration, Full Time |6.70|1.60|8.30| |Contract of definite duration, Part Time|6.70|1.60|8.30| |FOGASA | COMPANY | WORKERS | TOTAL | |---|---|---|---| | 0.20|0.10|0.20|0.70| |TRAINING | COMPANY | WORKERS | TOTAL | |---|---|---|---| |0.60|0.10|0.70| |MINIMUM | MAXIMUM| |---|---| |858.60|3.751.20| |IT Contribution Rate|IMS Contribution Rate| TOTAL Contribution Rate| |---|---|---| |0.85|0.80|1.65| ## ESPECIALIDAD: ADMINISTRATION OF COMPANIES (101) ### APARTADO C #### EXERCISE C.1 - Make the accounting entries corresponding to the following cases, in accordance with the provisions of Royal Decree 1514/2007, of 16 November, approving the General Accounting Plan, taking into account that: - None of the amounts in the cases includes VAT (if in doubt, apply the general rate). - The activities of the companies that appear in the different cases are subject to and not exempt from VAT. - Each entry must include the explanation or concept of the entry. - **CASE 1.1** - OPOSITA4 received, on 2 January of year xx1, a deposit in its current bank account of 25 million euros, corresponding to a loan to finance the construction of a factory on a plot of land it owns. - The effective interest rate of the loan is 5% and it will be repaid over three years. - The construction of the factory is estimated to take two years. - During year xx1, OPOSITA14 paid 15 million euros to the construction company, 1.25 million euros in interest and amortized 12.5 million euros of the loan. - During year xx2, it paid 7 million euros to the construction company, 625,000 euros in interest and amortized 7.5 million euros of the loan. - On 1 January xx3, the factory is ready to start operating. - During year xx3, OPISITA14 amortizes the entire loan and pays 250,000 euros in interest. - All payments were made by bank transfer. - **CASE 1.2** - OPOSITA7 purchases a folding machine on 1 January of year xx1 for 3,900 euros, paying by bank transfer. - The useful life of the machine is estimated at 5 years, with the company using the straight-line depreciation method. - At the end of year xx1, the value in use of the machine is 2,600 euros, the fair value 2,700 euros and the cost of sale 130 euros. - During year xx2 the value in use of the machine is 1,900 euros, the fair value 2,200 euros and the cost of sale 100 euros. - At the end of year xx3 the value in use of the machine is 1,475 euros, the fair value 1,560 euros and the cost of sale 100 euros. - **CASE 1.3** - OPOSITA15 purchases on 1 September of year xx1 shares admitted to trading on the stock market for 1,330,000 euros. The shares were acquired for the long term and classified as available for sale. The expenses of the transaction amounted to 3,800 euros. The nominal value of the shares is 1,000,000 euros. - At the end of year xx1, the market value of the shares is set at 1,235,000 euros. - At the end of year xx2, the market value of the shares is set at 1,310,000 euros. - On 15 January of year xx3, OPOSITA15 sells the shares for 1,340,000 euros. - All payments and receipts were made by bank transfer. #### EXERCISE C.2 - Make the accounting entries corresponding to the following cases, in accordance with the provisions of Royal Decree 1514/2007, of 16 November, approving the General Accounting Plan, taking into account that: - None of the amounts in the cases includes VAT (if in doubt, apply the general rate). - The activities of the companies that appear in the different cases are subject to and not exempt from VAT. - Each entry must include the explanation or concept of the entry. - **CASE 2.1** - OPOSITA8 has been developing a software application during year xx1. During this year, the company has paid the following expenses by bank transfer: - Leases: 500,000 euros. - Supplies: 300,000 euros. - Other services: 200,000 euros. - Personnel expenses: 3, 000,000 euros. - Social Security payable by the company: 750,000 euros. - Of the above expenses, 15% correspond to research and the rest to development. - At the end of year xx1, there are reasons to believe that the application will be a success. - At the end of year xx2, the software application is complete and has been successfully launched, with the relevant intellectual property rights. - The company will amortize research costs over five years. - **CASE 2.2** - OPOSITA18 sells on credit for one year machinery for 4,000 euros. The machinery is recorded in the balance sheet for 10,000 euros, with accumulated depreciation of 7,500 euros, and is invested in bonds classified as held-to-maturity. - The balance sheet shows an impairment of the bonds of 900 euros. - OPOSITA18 sells the bonds for 6,100 euros, which are deposited in a current account. - Subsequently, it purchases new machinery for 15,000 euros, using the liquidity obtained from the sale of the bonds and accepting two bills of exchange of the same amount for the outstanding balance, due in 6 and 18 months, respectively. - All transactions are carried out in the same financial year. - **CASE 2.3** - OPOSITA19 acquires IT equipment under a financial lease agreement on 1 January of year xx1, the fair value of which coincides with the present value of the minimum payments agreed over the lease term, including the purchase option. - The lease term is three years and the effective interest rate is 6%. - The annual payments will be 20,000 euros and will be paid on 31 December of each year. - The lessee will exercise the purchase option at the end of the contract for a price of 5, 000 euros. - The equipment will be depreciated using the straight-line method over 5 years. - The installation expenses of the equipment, paid on 1 January of year xx1 by bank transfer, amounted to 2,340 euros.