Question
The company's financial year is the calendar year. Certain costs (incl. wages, rents, and taxes) of 65000 total are paid out in the middle of
The company's financial year is the calendar year. Certain costs (incl. wages, rents, and taxes) of 65000 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 first financial year, the company has taken out a loan of 2400000 total that has not been amortized. However, an interest of 5 % p.a. has been paid at the end of the financial year. The company has made an initial investment of 3600000 . Half of the investment has been paid during the previous financial 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 100 per unit. The variable costs consist of purchasing the materials and are expected to be 58 per unit. At the end of the second financial year, 1200000 of the debt must be amortized and interest must be paid.
The company then specifies the plan for the second financial year. 28 % of the annual volumes are delivered during the first half of the year and 72 % during the second. Monthly volumes are constant during both phases and the customers are given one 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 monthly information of incoming and outgoing payments allocated to the three cash flows, changes in cash and equivalents, and total cash and equivalents.
1) Calculate the cash flow from operating activities of the first financial year.
2) Calculate the cash flow from investment activities of the entire first financial year.
3) Calculate the payments received from the customers during the first half of the second financial year (1.1.-30.6.).
4) Calculate the payments made to the company's suppliers 1.1.-30.6.
5) Calculate the company's cash flow from operating activities during the first half of the second financial year (1.1.-30.6.).
6) Calculate the company's cash flow from investment activities during the first half of the second financial year(1.1.-30.6.).
7) Calculate the change in cash and equivalents during the first half of the second financial year (1.1.-30.6.).
8) Let's consider the company's monthly liquidity: The company would become insolvent if its cash and equivalents would be less than 0,00 at the end of any month. How much at least must the company have had shareholder's capital, i.e. the money that the owners have invested to the company at the beginning, so that it will not become insolvent during the first half of the second financial year (1.1.-30.6.)?
9) Calculate the company's cash flow from operating activities of the entire second financial year (1.1.-31.12).
10) Calculate the company's cash flow from financing activities of the entire second financial year (1.1.-31.12.).
11) Let's consider the company's monthly liquidity again: The company would become insolvent if it's cash and equivalents would be less than 0,00 at the end of any month. How much, at least, must the company have had shareholder's capital, i.e. the money that the owners have invested to the company at the beginning, so that it will not become insolvent during the entire second accounting period (1.1.-31.12.)?
12) Let's consider the company's monthly liquidity in more detail: The company would become insolvent if it's cash and equivalents would be less than 0,00 at the end of any month. How much does the company have to take new debt at the beginning of the third financial year in order not to become insolvent in January of the third year? Let's assume that the company had just enough shareholder's capital at the end of the second year.
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