Reference no: EM133128145
Question - The company's financial year is the calendar year. Certain costs (incl. wages, rents and taxes) of 145000 € total are paid out in the middle of each month.
The company's first financial year is, exceptionally, only six months of length (1.7.-31.12.). At the beginning of the financial year, the company has taken out a loan of 4800000 € that has not been amortized. However, an interest of 5 % p.a. has been paid at the end of the year. The company has made an initial investment of 7200000 €. Half of the investment has been paid during the previous year and the rest must be paid at the beginning of the second financial year. Nothing has been sold yet during the first financial year.
The revenues of the second financial year are estimated according to shipped (billed) quantities of 30000 units at a unit price of 200 € per unit. The variable costs consist of purchasing the materials and are expected to be 110 € per unit. At the end of the second financial year, 2400000 € of the debt must be amortized and an interest of 5 % p.a. must be paid.
The company then specifies the plan for the second financial year. 40 % of the annual volumes are delivered during the first half of the year and 60 % during the second. Monthly volumes are constant during both phases and the customers are given a month for payments. The company purchases the materials for the second financial year in three equal installments. The first batch has arrived at the end of December, but the bill is not due until at the end of January. The next batches arrive at the beginning of May and September. In order for the business to run smoothly during the next year as well, the company purchases an additional batch of materials for 7500 units towards the end of December (20.12). Each batch is payable in 14 days.
It is recommended to make a table of months having the containing information of incoming and outgoing payments, incoming and outgoing shipments, total value of the inventories calculated by buy-in-price and of other items necessary in this quiz.
Required -
a. How much the customers owe to the company (accounts receivable) in the middle of the second financial year (30.6.)? Give your answer as an absolute value (no minus sign).
b. How much does the company owe to its suppliers (accounts payable) in the middle of the second financial year (30.6.)? Give your answer as an absolute value (no minus sign).
c. How much have the company's inventories increased (+) or decreased (-) during the first half of the second financial year (1.1.-30.6.)?
d. What is the company's working capital in the middle of the second financial year (30.6.)?
e. How much do the accounts receivable increase (+) or decrease (-) during the second half of the second financial year?
f. How much do the accounts payable increase (+) or decrease (-) during the second half of the second financial year?
g. What is the value of the company's inventories at the end of the second financial year (31.12.)?
h. What is the company's working capital at the end of the second financial year (31.12.)?
i. How much has the company's working capital increased (+) or decreased (-) during the second financial year (1.1.-31.12.)?