Please send send in excel

can be print excel screen

Exercise 7: With the data provided below, prepare the statement of financial position of the company Aurera S.A as of December 31, 2017. The existing money in cash is L. 10,000.00, in stock of cash for minor expenses amounts to L. 2,500.00; the cash in bank accounts amounts to L. 400,000.00; of which they are depositing the amount of L. 150,000.00 for 15 months and L. 50,000.00 for 2 months. There are 200 bonds with a value of L. 1,000.00 each, of which 60 mature within 8 months and the difference in 5 years. The inventories of merchandise for the period are 1.400,000.00; of which our clients owe us 30% and L.120,000.00 are owed. The company has furniture and equipment valued at L. 200,000.00. 15 monthly installments of L. 3,000.00 each are owed for the furniture; there are tools worth L. 35,000.00; there is a building valued at L. 670,000.00; built on land valued at L. 200,000.00; a mortgage falls on the building from which 20 monthly payments of L. 5,000.00 will be made; the machinery has a value of L. 300,000.00 of which 20 bills of exchange are owed monthly with a value of L. 8,000.00 each; the stock of cleaning supplies is L. 4,000.00 and that of office supplies is L. 4,000.00. Provisions to cover customer guarantees are estimated at a value of L. 40,000.00 with a maturity of one year. The rents collected in advance corresponding to 15 months have a total value of L. 80,000.00, the subscriptions to various magazines amount to L. 4,200.00; the services charged in advance are L. 60,000.00; goodwill is L. 95,000.00. The profit of the company amounts to L. 600,000.00 of which the income tax of L. 150,000.00 is owed to the government of Colombia. Exercise 7: With the data provided below, prepare the statement of financial position of the company Aurera S.A as of December 31, 2017. The existing money in cash is L. 10,000.00, in stock of cash for minor expenses amounts to L. 2,500.00; the cash in bank accounts amounts to L. 400,000.00; of which they are depositing the amount of L. 150,000.00 for 15 months and L. 50,000.00 for 2 months. There are 200 bonds with a value of L. 1,000.00 each, of which 60 mature within 8 months and the difference in 5 years. The inventories of merchandise for the period are 1.400,000.00; of which our clients owe us 30% and L.120,000.00 are owed. The company has furniture and equipment valued at L. 200,000.00. 15 monthly installments of L. 3,000.00 each are owed for the furniture; there are tools worth L. 35,000.00; there is a building valued at L. 670,000.00; built on land valued at L. 200,000.00; a mortgage falls on the building from which 20 monthly payments of L. 5,000.00 will be made; the machinery has a value of L. 300,000.00 of which 20 bills of exchange are owed monthly with a value of L. 8,000.00 each; the stock of cleaning supplies is L. 4,000.00 and that of office supplies is L. 4,000.00. Provisions to cover customer guarantees are estimated at a value of L. 40,000.00 with a maturity of one year. The rents collected in advance corresponding to 15 months have a total value of L. 80,000.00, the subscriptions to various magazines amount to L. 4,200.00; the services charged in advance are L. 60,000.00; goodwill is L. 95,000.00. The profit of the company amounts to L. 600,000.00 of which the income tax of L. 150,000.00 is owed to the government of Colombia