9. Company A is a trading company. This question deals with the financial statements for year 5. Many parts of the financial statements are complete, but some data is missing. Your task is to complete the financial statements. Balance sheet from the financial statements per 31/12 year 4 can be found besides year 5 below. Year 5: Sales revenues $15,300,000 Operating expenses, excluding cost of goods sold for good X and depreciation of $12,400,000 Accounts receivable as of 31/12 year 5 amount to a nominal value of $1,490,000 A review of the accounts receivable shows that a claim of $30,000 on Customer Lucy has not been paid in eight months. Company A decides to write down this claim by 100%. Please note that this write-down is not tax deductible. Inventory All inventory except the stock of good X are valued according to laws and regulations. These other inventories amount to $1,600,000 on 31/12. The opening inventory of good X on 1/1 year 5 was valued at $70,000. According to the purchasing record, during the year Company A bought good X as follows: Purchase date Quantity $/ pc 4/2 1000 320 20/6 1500 300 7/11 280 1500 At the inventory as of 31/12 year 5, 1,400 of good X were in inventory. Ignore obsolescence deductions when valuing. The net sales value for a good X amounts to $340 /pc. Machines and inventory At the beginning of year 5, a machine is sold for $550,000 This machine had been used for sale for three years and had a purchase price of $1,200,000 and, like all other machines and equipment, had an estimated useful life of 6 years. 6 At the financial statements as of 31/12 year 4, the total acquisition value for machinery and equipment was $5,400,000. During the year 5, no machines and equipment have exceeded the limit for the useful life. Assume that the realization result that may arise is taxable / deductible. Appropriations and dividends According to directives from company management, the appropriation of the year must be adjusted so that the tax cost for the year is minimized. An investigation into the rules of tax legislation shows that the untaxed reserves can amount to a maximum of $1,380,000. The dividend that is paid during year 5 amounts to $500,000. Tax cost Use the tax rate of 25% when calculating tax expense. Tax payment is assumed to coincide with tax expense. Calculate and answer below (grey boxes): Liabilities As of 31/12 year 5, Company A's debts to suppliers amount to $2,550,000. Other current liabilities at the same time amount to $270,000. At the end of December year 5, Company A repays a long-term loan of $850,000 This loan has run without amortization and this amortization was not planned at the previous financial statements. The existing long-term loans are also amortization-free and redemption does not begin until year 7. The company's total interest costs for year 5 amount to $230,000 Remember to put out a minus sign for costs and other negative values. Please calculate and fill in the grey boxes below: 15300 Income statement for year 5 Sales revenue Operating expenses Depreciation Realization result Impairment of accounts receivable Interest expenses Results before year-end appropriations Year-end appropriations Result before tax Tax Result of the year 31/12 Year 5 31/12 Year 4 Balance sheet Machines and inventory Inventory Accounts receivable Cash and bank balances Total assets Equity Untaxed reserve Long-term liabilities Other current liabilities Accounts payable Total liabilities and equity 4120 2700 1380 900 8800 2550 1000 2290 710 2250 8800 Cash flow analysis for year 5 From the day-to-day operations From the investment business From the financing business The year's cash flow 9. Company A is a trading company. This question deals with the financial statements for year 5. Many parts of the financial statements are complete, but some data is missing. Your task is to complete the financial statements. Balance sheet from the financial statements per 31/12 year 4 can be found besides year 5 below. Year 5: Sales revenues $15,300,000 Operating expenses, excluding cost of goods sold for good X and depreciation of $12,400,000 Accounts receivable as of 31/12 year 5 amount to a nominal value of $1,490,000 A review of the accounts receivable shows that a claim of $30,000 on Customer Lucy has not been paid in eight months. Company A decides to write down this claim by 100%. Please note that this write-down is not tax deductible. Inventory All inventory except the stock of good X are valued according to laws and regulations. These other inventories amount to $1,600,000 on 31/12. The opening inventory of good X on 1/1 year 5 was valued at $70,000. According to the purchasing record, during the year Company A bought good X as follows: Purchase date Quantity $/ pc 4/2 1000 320 20/6 1500 300 7/11 280 1500 At the inventory as of 31/12 year 5, 1,400 of good X were in inventory. Ignore obsolescence deductions when valuing. The net sales value for a good X amounts to $340 /pc. Machines and inventory At the beginning of year 5, a machine is sold for $550,000 This machine had been used for sale for three years and had a purchase price of $1,200,000 and, like all other machines and equipment, had an estimated useful life of 6 years. 6 At the financial statements as of 31/12 year 4, the total acquisition value for machinery and equipment was $5,400,000. During the year 5, no machines and equipment have exceeded the limit for the useful life. Assume that the realization result that may arise is taxable / deductible. Appropriations and dividends According to directives from company management, the appropriation of the year must be adjusted so that the tax cost for the year is minimized. An investigation into the rules of tax legislation shows that the untaxed reserves can amount to a maximum of $1,380,000. The dividend that is paid during year 5 amounts to $500,000. Tax cost Use the tax rate of 25% when calculating tax expense. Tax payment is assumed to coincide with tax expense. Calculate and answer below (grey boxes): Liabilities As of 31/12 year 5, Company A's debts to suppliers amount to $2,550,000. Other current liabilities at the same time amount to $270,000. At the end of December year 5, Company A repays a long-term loan of $850,000 This loan has run without amortization and this amortization was not planned at the previous financial statements. The existing long-term loans are also amortization-free and redemption does not begin until year 7. The company's total interest costs for year 5 amount to $230,000 Remember to put out a minus sign for costs and other negative values. Please calculate and fill in the grey boxes below: 15300 Income statement for year 5 Sales revenue Operating expenses Depreciation Realization result Impairment of accounts receivable Interest expenses Results before year-end appropriations Year-end appropriations Result before tax Tax Result of the year 31/12 Year 5 31/12 Year 4 Balance sheet Machines and inventory Inventory Accounts receivable Cash and bank balances Total assets Equity Untaxed reserve Long-term liabilities Other current liabilities Accounts payable Total liabilities and equity 4120 2700 1380 900 8800 2550 1000 2290 710 2250 8800 Cash flow analysis for year 5 From the day-to-day operations From the investment business From the financing business The year's cash flow