Question
Based on this information, could you build the closing balance sheet of 2020? Remember to distinguish between current assets and fixed assets (and its categories)
Based on this information, could you build the closing balance sheet of 2020? Remember to distinguish between current assets and fixed assets (and its categories) on the asset side of the balance sheet. And between short term debt, long term debt and equity in the liabilities side.
1.- There were some debts with the tax authority due to unpaid taxes (basically VAT) of 128.300 euros, that would have to be paid during the first trimester of 2021.
2.- The different inventories of the company had a value of 287.400 euros.
3.- A short term credit line had been used to finance the acquisition of inventory and the maximum limit of the line was being used: 241.000 euros.
4.- Sporting Apparel Inc. was founded more than 20 years ago with a capital of 200.000 euros.
5.- The company owned two buildings that were bought 10 years ago. The actual book value of them was of 9,6 million euros.
6.- There were also some vehicles (cars and vans basically) that had an actual value of 162.000 euros.
7.- The acquisition of the buildings that the company had bought ten years ago had been financed with a 15- year mortgage. The outstanding amount left at the end of the year was of 5,75 million euros.
8.- Unpaid salaries reached 120.000 euros and they would have to be paid in the following months.
9.- The software licenses of the company had a book value of 28.400 euros.
10.- There was an amount of accounts receivables of 478.000 euros at the end of the year, and account payables of 349.000 euros.
11.- The yearly net income of 2020 reached 104.237 euros and the company was thinking of retaining all of it, against the common practice of the previous owners of paying out at least the 50% of it in the form of dividends.
12.- The company had some registered trademarks for an actual value of 60.000 euros. They were halfway their expected life.
13.- The computer systems and other technological equipment like printers, projectors, mobile phones, tablets, etc. had a book value of 46.000 euros.
14.- In cash the company had 24.765 euros and in two bank accounts you found 184.738 euros.
15.- There was also a 2-year bank deposit of 42.145 euros and a 6-month treasury bills for an amount of 142.004 euros.
16:- Retained earnings showed an amount of 4.162.915 euros.
Now that the balance sheet was in place, you had to try to finish the net income statement using the information you already had and new information you were able to collect, related with the operations of the company.
1.- The yearly depreciation and amortization of the company reached 635.330 euros.
2.- The different bank accounts and deposits had generated 3.458 euros in interests earned.
3.- On the other side, the mortgage and the credit line generated interest expenses of 134.345 euros.
4.- The yearly revenues of Sporting Apparel Inc. had fallen from 9,2 million euros of the previous year to 7,87 million euros of this year. This amount did not include 124.000 euros of products that were returned due to some problems with them.
5.- The salaries of the sales and warehouse employees, including social costs reached 0,91 million euros.
6.- The rest of salaries of the company reached an amount of 0,53 million euros.
7.- The company had bought products during the year for a value of 4,05 million euros and was able to sell 3,85 million euros of them (which generated an increase in the value of the inventory of the company). This amount included the net effect of the products returned because they were faulty.
8.- The yearly overheads of the company (fixed costs and structural expenses) were estimated in 645.000 euros. And the expenses related with different service suppliers (water, electricity, cleaning, etc...) reached 128.000 euros.
9.- The company was actually paying a 25% tax rate over its EBT (earnings before taxes).
10.- The company had sold some used vehicles during 2020 generating a profit of 28.000 euros.
11.- The company was paying for external professional services like marketing, advertising, communication, etc. 880.000 euros per year.
12.- During the last year, the company had rented part of the office space to another company that paid a yearly rent of 74.200 euros. With all this information, could you build the detailed net income statement of Sporting Apparel Inc. for the ending year of 2020?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started