1st Midterm: Exam-Style Practice Problems
6 exam-style problems on Topic 3 (financial statements and financing), in the style of the additional exam exercises of the course. In the exam, one of them (4 points) comes with three short theory cases of 2 points each, in 90 minutes; the Exam simulator builds a timed exam from these items.
P11 — FRIGOLEV: an incomplete 2017 balance, a cooperative discount and the 2018 statements
The newly appointed financial director of LOGÍSTICA FRIGORÍFICA DEL LEVANTE S.L. (FRIGOLEV), a company located in the port area of Castellón and dedicated to the manufacturing of isothermal containers and cold-chain storage equipment for agricultural exporters, is working on the closing of its financial statements (balance sheet and Income Statement) as of 31 December 2018 (31/12/2018).
The company was originally incorporated on 1 January 2016 (01/01/2016) by four partners, with an initial contribution of each of 1.500 m.u. disbursed fully in cash at that time, and no further capital modifications took place until fiscal year 2018. Due to the sudden departure of the previous chief accountant, the financial director only has an incomplete balance of the company as of 31 December 2017 (31/12/2017), which is included below with certain missing figures marked as (?), along with the audit notes detailing the operations that have taken place during the period from 1 January 2018 (01/01/2018) to 31 December 2018 (31/12/2018):
I. On 31 December 2017 (31/12/2017), the company had as depreciable fixed assets only the industrial refrigeration chambers purchased on a certain date during 2016, which have a useful life of 10 years and are amortized linearly with a residual value of 10% of their acquisition cost. In addition, the balance sheet at 31 December 2017 (31/12/2017) reflected an industrial plot of land acquired in 2016 and financial shares of other companies acquired as a permanent investment.
II. During the year 2018, the company has sold 3.600 units of isothermal containers at a catalog price of 25 m.u. / unit (every month the same amount, 300 u.). The general payment condition agreed with the customers implies that this will occur 60 days after the sale. However, a very important agricultural cooperative (representing 25% of the physical units sold each month), which has bought an equal amount every month, has been given a discount of 8% on the catalog price of their purchases in exchange for paying strictly in cash in the same month of the sale.
III. At 31 December 2017 (31/12/2017) there was a stock (stock in stock) of 400 tons of insulating raw material valued at 2,00 m.u. / ton. On 1 April 2018 (01/04/2018), the company purchased 5.000 tons of raw material at a cost of 2,00 m.u. / ton. The payment condition agreed with the suppliers was 40% paid in cash on the date of purchase, 30% payable to 90 days, and the remaining 30% deferred until 1 February 2019 (01/02/2019). At 31 December 2018 (31/12/2018), after conducting the warehouse count, there remains a final stock (stock in stock) of 900 tons.
IV. During the first quarter of 2018, the unpaid taxes and the outstanding supplier balances from the previous year were paid in full. Regarding the customer debt outstanding from 31 December 2017 (31/12/2017), 75% was charged in cash during the first semester of 2018, except 200 m.u. from a customer who requested and was granted a deferral of payment until 15 March 2019 (15/03/2019), and 100 m.u. corresponding to a client declared definitively insolvent on 1 June 2018 (01/06/2018), which must be recorded as an unrecoverable bad debt loss for the period.
V. Fixed personnel expenses have been 2.200 m.u. / month (to which 600 m.u. / month must be added for Social Security) from 1 January 2018 (01/01/2018). To respond to seasonal peaks in container assembly, production staff also received variable wages that amounted in 2018 to 3.620 m.u. Fixed and variable wages are paid in the month in which they are produced, whereas Social Security contributions (starting from January 2018) are paid on the 15th day of the following month. General expenses and utilities (electricity, phone, insurance, etc.) amounted to 1.100 m.u. / month and are paid two months after being made.
VI. The company carried out a renting contract on 1 March 2018 (01/03/2018) (with a duration of 2 years) with a specialized company for electric warehouse forklifts, for a value of 350 m.u. monthly. The contract establishes a condition of payment to 90 days (payment at the end of each month).
VII. On 1 April 2018 (01/04/2018), the company made a capital increase by issuing 1.000 new shares of 2,00 m.u. nominal value each, fully disbursed in cash and with an issue premium of 50% over the nominal value. On the same date, 1 April 2018 (01/04/2018), it bought two refrigerated delivery vehicles that cost a total of 4.800 m.u., of which it paid 50% in cash, postponing the payment of the remainder in two equal installments: half on 1 October 2018 (01/10/2018) and the other half on 1 April 2019 (01/04/2019). These vehicles will be amortized linearly in 6 years with a total residual value of 480 m.u. Furthermore, on 1 October 2018 (01/10/2018), it bought a software license for cold-chain tracking for a value of 1.600 m.u., payable to 120 days, which is amortized linearly in 4 years with residual value zero.
VIII. The long-term bank loan appearing on the balance sheet at 31 December 2017 (31/12/2017) was granted on 1 January 2017 (01/01/2017) at an annual interest rate of 6%. Each 31 December, the company must pay the accrued annual interest calculated from the loan value at the beginning of each year, and starting on 31 December 2018 (31/12/2018) it must also return to the bank an annual principal amount of 500 m.u. until completing the repayment on 31 December 2021 (31/12/2021). Additionally, on 1 July 2018 (01/07/2018), the company obtained a new short-term bank credit of 1.500 m.u. at 8% annual interest, agreeing to return 50% of the principal each semester for the next year. Both the principal installment and the semiannual interest calculated on the amount actually due in that semester will be paid the day after the end of each semester (i.e., on 1 January 2019 (01/01/2019) and 1 July 2019 (01/07/2019)).
IX. The financial results of the company are declared at 23:59 hrs on 31 December 2018 (31/12/2018). The applicable corporation tax rate is 25% on the Profits obtained, which is settled by calendar year and will be paid to the Treasury on 20 January 2019 (20/01/2019) (counted in the balance at 31 December 2018 (31/12/2018) as "unpaid taxes"). From the net profit after taxes, the company first offsets in full the losses from previous years, and of the remaining net profit, it retains 60% as reserves and distributes the other 40% as dividends to the shareholders, which are paid in cash before carrying out the final balance at 24:00 on 31 December 2018 (31/12/2018).
BALANCE 31 December 2017 (31/12/2017)
| ASSETS | m.u. | LIABILITIES | m.u. |
|---|---|---|---|
| CURRENT ASSETS | 2.940 | CURRENT LIABILITIES | 900 |
| Cash | (?) | Unpaid taxes | 250 |
| Accounts receivable | 1.200 | Accounts payable (suppliers) | 650 |
| Inventory (stock) | 800 | NON-CURRENT LIABILITIES | 2.000 |
| NON-CURRENT ASSETS | 5.560 | Long-term bank loan | 2.000 |
| Land | 1.500 | OWNERS EQUITY | (?) |
| Refrigeration chambers (Equipment) | 4.000 | Paid-in capital | (?) |
| Accum. depreciation | (540) | Losses from previous years | (400) |
| Financial shares | 600 | ||
| Total Assets | (?) | Total Liabilities + OE | (?) |
Required:
- Determine and justify the missing figures (?) in the balance sheet as of 31 December 2017 (31/12/2017) as well as the exact date in 2016 on which the industrial refrigeration chambers were purchased, and construct the Income Statement (Profit and Loss Account) of FRIGOLEV for the period ending 31 December 2018 (31/12/2018).
- Assuming that the company has offset the prior losses and paid the dividends as indicated, construct and justify the balance sheet at 24:00 on 31 December 2018 (31/12/2018), detailing all intermediate calculations.
- Determine the values of the ROA and ROE ratios in 2018, and indicate which items of the balance sheet at 24:00 on 31 December 2018 (31/12/2018) would be affected, and the exact amount of the effect, if the decision was made before the end of 2018 to distribute the same dividend, but to pay it on 15 April 2019 (15/04/2019).
- State and explain what changes would occur on the various items of the Income Statement and the balance sheet at 31 December 2018 (31/12/2018) if the company had eliminated the 8% discount granted to the agricultural cooperative, subjecting this customer to the general 60-day payment condition at the full price of 25 m.u. / unit, which in turn would have caused the cooperative to reduce the physical units bought each month by 10%. In which case is the net profit higher, and in which case is the final cash balance higher? Discuss reasoned, why.
Setup
Hypotheses (readings of the statement that the solution depends on):
- Item IV: 75% of the 1.200 m.u. (900 m.u.) is collected; the remaining 25% (300 m.u.) is exactly the 200 m.u. deferred plus the 100 m.u. written off.
- Item IX: the 25% tax is applied to the whole profit before taxes of 2018; the losses of previous years are offset afterwards, against the net profit, as the statement orders.
- Item VI: "payable to 90 days (payment at the end of each month)" means each month's fee is paid at the end of the third month after it (March is paid at the end of June); October, November and December are unpaid at 31/12/2018.
- Requirement 4: the containers consume raw material in proportion to the units sold, and no finished containers are kept in stock.
Item VIII says that 500 m.u. of the loan are repaid on 31/12/2018, so at 31/12/2017 those 500 m.u. were due within one year and should have been a current liability (current liabilities 1.400, non-current 1.500). The totals do not change, so the solution keeps the given balance as stated and splits the loan correctly at 31/12/2018.
Timeline of the cash-relevant dates in 2018
| Date | Event |
|---|---|
| Q1 2018 | Unpaid taxes 250 and suppliers 650 of 2017 paid |
| H1 2018 | 900 of the 2017 receivables collected; 100 written off on 01/06 |
| 01/04/2018 | Raw material 10.000 (4.000 cash); capital increase 3.000; vehicles 4.800 (2.400 cash) |
| 01/07/2018 | Second 30% of raw material paid (3.000); short-term credit received 1.500 |
| 01/10/2018 | Second vehicle instalment 1.200; software 1.600 bought payable to 120 days |
| 31/12/2018 | Loan interest 120 and principal 500 paid; tax accrued; dividends paid at 24:00 |
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{Total assets}$ and $\text{ROE} = \text{Net income}/\text{Owners equity}$, both on the balance at 24:00 on 31/12/2018, as in the solved INFOPYMES exercise.
Part (a) · 1.25 points
Find the missing figures of the 2017 balance and the purchase date of the chambers, and prepare the 2018 Income Statement
Step 1. The missing figures of 31/12/2017
Check of the non-current block: $1.500 + 4.000 - 540 + 600 = 5.560$ (checked).
Step 2. Purchase date of the refrigeration chambers
Step 3. Revenue and its collection (item II)
Each month 300 units are sold: 75 to the cooperative (25%) at $25 \times 0{,}92 = 23$ m.u. and 225 to the other customers at 25 m.u.
The cooperative pays in the same month (20.700 collected); the others pay at 60 days, so November and December are pending: $2 \times 5.625 = 11.250$ m.u. receivable.
Step 4. Raw material (item III)
Payments: 40% on 01/04 (4.000) and 30% at 90 days, on 01/07 (3.000); the last 30% (3.000) is owed until 01/02/2019.
Step 5. Personnel, general expenses and renting (items V, VI)
- Social Security of December (600) is paid on 15/01/2019; 11 months paid (6.600).
- General expenses: $12 \times 1.100 = 13.200$ m.u. of expense; paid two months later, so November and December (2.200) are owed and 11.000 paid.
- Renting: March to December, $10 \times 350 = 3.500$ m.u. of expense; March to September paid ($7 \times 350 = 2.450$), October to December owed (1.050).
Step 6. Depreciation and amortization (items I, VII)
Step 7. Financial expenses (item VIII)
Step 8. Income Statement 2018
| Line | Computation | m.u. |
|---|---|---|
| Sales revenue | Step 3 | 88.200 |
| − Raw material consumed | Step 4 | 9.000 |
| − Personnel (wages and Social Security) | Step 5 | 37.220 |
| − General expenses and utilities | $12 \times 1.100$ | 13.200 |
| − Renting of forklifts | $10 \times 350$ | 3.500 |
| − Bad debt loss | item IV | 100 |
| − Depreciation and amortization | Step 6 | 1.000 |
| = Income from operations | $88.200 - 64.020$ | 24.180 |
| − Financial expenses | $120 + 60$ | 180 |
| = Profit before taxes | $24.180 - 180$ | 24.000 |
| − Corporation tax (25%) | $0{,}25 \times 24.000$ | 6.000 |
| = Net profit | $24.000 - 6.000$ | 18.000 |
- Cash 940; total 8.500; paid-in capital 6.000; owners equity 5.600 m.u.
- Chambers depreciate 360 m.u./year: bought on 1 July 2016 (01/07/2016).
- Revenue 88.200; raw material consumed 9.000; depreciation 1.000 m.u.
- Income from operations 24.180; financial expenses 180; net profit 18.000 m.u.
Part (b) · 1.25 points
Prepare the balance sheet at 24:00 on 31 December 2018
Step 1. Distribution of the profit [Slide 23]
Step 2. Capital increase (item VII)
Step 3. Cash account 2018
| Inflows | m.u. | Outflows | m.u. |
|---|---|---|---|
| Cooperative sales (cash) | 20.700 | Unpaid taxes 2017 | 250 |
| Other customers, January–October ($10 \times 5.625$) | 56.250 | Suppliers 2017 | 650 |
| Receivables of 2017 (75%) | 900 | Raw material ($4.000 + 3.000$) | 7.000 |
| Capital increase | 3.000 | Fixed wages | 26.400 |
| Short-term bank credit | 1.500 | Variable wages | 3.620 |
| Social Security (11 months) | 6.600 | ||
| General expenses (10 months) | 11.000 | ||
| Renting (7 months) | 2.450 | ||
| Vehicles ($2.400 + 1.200$) | 3.600 | ||
| Loan interest | 120 | ||
| Loan principal | 500 | ||
| Dividends | 7.040 | ||
| Total | 82.350 | Total | 69.230 |
Step 4. Balance sheet at 24:00 on 31/12/2018
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Land | 1.500 | Paid-in capital ($6.000 + 2.000$) | 8.000 |
| Refrigeration chambers ($4.000 - 900$) | 3.100 | Issue premium | 1.000 |
| Vehicles ($4.800 - 540$) | 4.260 | Reserves | 10.560 |
| Software license ($1.600 - 100$) | 1.500 | Losses from previous years (offset) | 0 |
| Financial shares | 600 | Owners equity | 19.560 |
| Non-current assets | 10.960 | Long-term bank loan (2020–2021) | 1.000 |
| Inventory (900 t × 2,00) | 1.800 | Non-current liabilities | 1.000 |
| Accounts receivable ($11.250 + 200$) | 11.450 | Bank loan, instalment 31/12/2019 | 500 |
| Cash | 14.060 | Short-term bank credit | 1.500 |
| Interest payable (credit) | 60 | ||
| Suppliers of raw material | 3.000 | ||
| Suppliers of vehicles | 1.200 | ||
| Supplier of software | 1.600 | ||
| Social Security payable | 600 | ||
| General expenses payable | 2.200 | ||
| Renting payable | 1.050 | ||
| Unpaid taxes | 6.000 | ||
| Current assets | 27.310 | Current liabilities | 17.710 |
| Total assets | 38.270 | Total liabilities and equity | 38.270 |
Accumulated depreciation of the chambers: $540 + 360 = 900$. The 200 m.u. deferred to 15/03/2019 is due within one year, so it stays current; the loan splits into the 500 due on 31/12/2019 (current) and 1.000 due in 2020–2021.
- Remaining profit 17.600; reserves 10.560; dividends 7.040 m.u.
- Cash at 24:00 on 31/12/2018: 14.060 m.u.
- Owners equity 19.560; current liabilities 17.710; total 38.270 m.u.
Part (c) · 0.75 points
Compute ROA and ROE of 2018, and the effect of paying the same dividend on 15 April 2019
Step 1. Ratios (extension)
Step 2. Dividend decided in 2018, paid on 15/04/2019
| Item | Paid at 24:00 | Paid 15/04/2019 | Change |
|---|---|---|---|
| Cash | 14.060 | 21.100 | +7.040 |
| Dividends payable (current liability) | 0 | 7.040 | +7.040 |
| Reserves and owners equity | 19.560 | 19.560 | 0 |
| Total assets = total liabilities and equity | 38.270 | 45.310 | +7.040 |
The decision already reduces the profit kept in the company, so equity does not change; only the moment the money leaves changes.
- ROA = 63,18%; ROE = 92,02% (extension).
- Paid on 15/04/2019: cash +7.040 (21.100); new current liability "dividends payable" 7.040; totals 45.310 m.u.; owners equity unchanged.
Part (d) · 0.75 points
Effect of eliminating the 8% discount to the cooperative; which case gives more profit and which more cash?
Step 1. New sales of the cooperative
Step 2. Raw material (hypothesis 4)
In the base case 4.500 tons were consumed for 3.600 units: $4.500 / 3.600 = 1{,}25$ t/unit $= 2{,}50$ m.u./unit. Selling $12 \times 7{,}5 = 90$ units fewer:
Step 3. New results
Step 4. New cash
The cooperative now pays at 60 days: January to October collected, $10 \times 1.687{,}5 = 16.875$ instead of 20.700 (−3.825). The dividend paid falls by 67,50; the tax is not paid in 2018.
Step 5. Changes in the statements
| Item | Base | Without discount | Change |
|---|---|---|---|
| Revenue | 88.200 | 87.750 | −450 |
| Raw material consumed | 9.000 | 8.775 | −225 |
| Net profit | 18.000 | 17.831,25 | −168,75 |
| Inventory | 1.800 | 2.025 | +225 |
| Accounts receivable | 11.450 | 14.825 | +3.375 |
| Cash | 14.060 | 10.302,50 | −3.757,50 |
| Total assets | 38.270 | 38.112,50 | −157,50 |
| Reserves | 10.560 | 10.458,75 | −101,25 |
| Unpaid taxes | 6.000 | 5.943,75 | −56,25 |
| Total liabilities and equity | 38.270 | 38.112,50 | −157,50 |
Discussion. The profit is higher with the discount (18.000 against 17.831,25): removing the discount gains $2$ m.u. on each of the 810 units the cooperative still buys ($810 \times 2 = 1.620$ m.u.), but the 90 units it stops buying carried a margin over raw material of $23 - 2{,}50 = 20{,}50$ m.u. each ($90 \times 20{,}50 = 1.845$ m.u.); the net effect before taxes is $1.620 - 1.845 = -225$ m.u. The cash is also higher with the discount (14.060 against 10.302,50): the cooperative pays in the same month, while under the general condition November and December stay as receivables. Keeping the discount wins on both counts.
- Cooperative: 67,5 u./month at 25 m.u. = 1.687,5 m.u./month; revenue 87.750 (−450).
- Raw material consumed −225 (90 fewer units × 2,50); net profit 17.831,25 (−168,75).
- Receivables +3.375; inventory +225; cash 10.302,50 (−3.757,50); total assets 38.112,50.
- Profit and cash are both higher with the discount.
Interpretation and checks
- Dimensional check: units × m.u./unit and tons × m.u./ton give m.u.; m.u./year × months/12 gives m.u.; ratios are dimensionless.
- Why ROA and ROE are so high: the company's annual sales (88.200 m.u.) are ten times its 2017 assets; the ratios are measured on the year-end balance, which already includes most of the year's profit.
- Accrual vs cash: net profit 18.000 m.u., but cash grew by only 13.120 m.u. because 11.250 m.u. of sales are uncollected, although many expenses (tax, software, raw material, renting) are still unpaid.
- Typical mistakes: depreciating the vehicles for 12 months, forgetting the residual values, treating the issue premium as capital, and putting the whole short-term credit or the 200 m.u. deferred receivable outside current items.
P12 — AGRODRON: the second year of a drone start-up that closed its first year with a loss
The company AGRODRON LEVANTE S.L. was incorporated on 1 January 2017 (01/01/2017) by a group of agricultural engineers with a registered paid-in capital of 4.500 m.u., having an objective of providing precision crop-monitoring services by drone and distributing organic fertilizers in the region of Murcia.
The following information applies to fiscal year 2017:
To finance the operations of the company, on 1 January 2017 (01/01/2017) a bank granted the company a loan of 1.500 m.u. at 6% annual interest, with a duration of 5 years, i.e. until 31 December 2021 (31/12/2021). Each 31 December, the company must return to the bank an equal principal amount of 300 m.u. and should also pay the due annual interest (6%) calculated from the loan value at the beginning of each year.
During 2017, the company invested in a fleet of agricultural drones worth 2.400 m.u. The useful life of the drones purchased was 8 years (amortized linearly, with no residual value) and at the end of 2017 the company recorded in accumulated depreciation an amount of 75 m.u. for those assets. Also, a further investment of 400 m.u. in mapping software licenses was made on 31 December 2017 (31/12/2017) to process aerial images. They use these licenses for 4 years (linear amortization with residual value zero). In addition, the company spent 800 m.u. to purchase a plot of rural land for its flight testing base. Most of 2017 was devoted to obtaining civil aviation permits and only the actual business work was started in the final months of the year. At 31 December 2017 (31/12/2017), its balance sheet reflected a loss of 220 m.u., there was no stock (stock in stock) nor pending customer or supplier balances, and the cash in hand and bank account was 1.955 m.u.
The following information applies to fiscal year 2018:
- For aerial crop monitoring, the average number of subscribed farms during 2018 was 400 with an average revenue of 0,45 m.u. / month per client in subscription fees. Additionally, the company billed 840 m.u. for the direct sales of organic fertilizers. At the end of 2018, AGRODRON had accounts receivable of 310 m.u. from their customers.
- The company purchased supplies of organic fertilizers during 2018 which amounted to 500 m.u. Of these purchases, 70% was paid immediately in cash and the payment of the remaining 30% was deferred to the following year. Year 2018 sales consumed 80% of the purchased goods.
- AGRODRON operates from rented hangars that have a monthly cost (from 1 January 2018 (01/01/2018)) of 25 m.u. / month, paid in cash. Fixed salaries and Social Security costs (contribution of the company to the Social Security) of the permanent employees amounted to 60 m.u. per month (from 1 January 2018 (01/01/2018)) and were paid in full in 2018. To respond to increased demand during the harvest campaign, the company hired external pilots whose variable wages amounted in 2018 to 192 m.u. (paid in cash).
- Electricity, insurance, and other administrative expenditures totaled 180 m.u. in 2018. The company postponed the payment of 40% of this amount to the following year. Furthermore, on 1 July 2018 (01/07/2018), the company acquired thermal cameras for its drones for a value of 200 m.u., paying 50% in cash on that date and leaving the remainder payable to 9 months, i.e. on 1 April 2019 (01/04/2019). This equipment has a useful life of 5 years and will be amortized linearly with a residual value of 20%.
- The financial results of the company are declared at 23:59 hrs on 31 December 2018 (31/12/2018). The applicable corporation tax rate was 25% on the Profits obtained and is payable in the first quarter of 2019. In 2018, the results were positive: after offsetting in full the loss of the previous year, the company decided to distribute 30% of the remaining net profit after taxes as dividends (paid at 24:00 on 31 December 2018 (31/12/2018)) and retain the rest in the company.
Required:
- Construct the Income Statement (Profit and Loss Account) of AGRODRON LEVANTE S.L. for the period ending 31 December 2018 (31/12/2018), and deduce the exact date in 2017 on which the fleet of agricultural drones was acquired.
- Construct and justify the balance sheet at 24:00 on 31 December 2018 (31/12/2018), detailing all intermediate cash and accrual calculations.
- Determine the values of the ROA and ROE ratios in 2018.
- Indicate which items of the balance sheet at 31 December 2018 (31/12/2018) would be affected and the exact amount of the effect if the decision was made before the end of 2018 to distribute the same dividend, but to pay it on 30 June 2019 (30/06/2019), and assuming simultaneously that the company had decided not to offset the loss of 2017 before calculating the 30% dividend payout.
Setup
Hypotheses:
- The tax of 25% is applied to the whole profit before taxes of 2018; the loss of 2017 is offset afterwards, against the net profit, as the statement orders ("after offsetting in full the loss of the previous year, ... distribute 30% of the remaining net profit after taxes").
- The software licences were bought on the last day of 2017, so their amortization starts in 2018 (a full year).
- The fertilizers not consumed (20% of the purchases) stay in stock at cost.
The balance at 31/12/2017, rebuilt from the data (needed to start 2018):
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Land | 800 | Paid-in capital | 4.500 |
| Drones ($2.400 - 75$) | 2.325 | Losses of 2017 | (220) |
| Software licences | 400 | Owners equity | 4.280 |
| Cash | 1.955 | Bank loan due 2019–2021 | 900 |
| Bank loan due 31/12/2018 | 300 | ||
| Total assets | 5.480 | Total liabilities and equity | 5.480 |
The loan was 1.500 and 300 were repaid on 31/12/2017, so 1.200 remain at the start of 2018.
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{Total assets}$ and $\text{ROE} = \text{Net income}/\text{Owners equity}$, on the balance at 24:00 on 31/12/2018.
Part (a) · 1.25 points
Prepare the 2018 Income Statement and deduce the purchase date of the drones
Step 1. Purchase date of the drones
Step 2. Revenue
Step 3. Fertilizers consumed
Step 4. Depreciation and amortization
Step 5. Interest
Step 6. Income Statement 2018
| Line | Computation | m.u. |
|---|---|---|
| Subscription fees | $400 \times 0{,}45 \times 12$ | 2.160 |
| Sales of fertilizers | 840 | |
| Revenue | 3.000 | |
| − Fertilizers consumed | Step 3 | 400 |
| − Hangar rent | $12 \times 25$ | 300 |
| − Fixed salaries and Social Security | $12 \times 60$ | 720 |
| − Variable wages of external pilots | 192 | |
| − Electricity, insurance and administration | 180 | |
| − Depreciation and amortization | Step 4 | 416 |
| = Income from operations | $3.000 - 2.208$ | 792 |
| − Financial expenses (interest) | Step 5 | 72 |
| = Profit before taxes | $792 - 72$ | 720 |
| − Corporation tax (25%) | $0{,}25 \times 720$ | 180 |
| = Net profit | $720 - 180$ | 540 |
- Drones bought on 1 October 2017 (01/10/2017).
- Revenue 3.000; fertilizers consumed 400; depreciation and amortization 416 m.u.
- Income from operations 792; interest 72; profit before taxes 720; tax 180; net profit 540 m.u.
Part (b) · 1.5 points
Prepare the balance sheet at 24:00 on 31 December 2018
Step 1. Distribution
Step 2. Collections and payments
- Customers: $3.000 - 310 = 2.690$ collected.
- Fertilizers: $0{,}70 \times 500 = 350$ paid, $150$ owed.
- Administration: $0{,}60 \times 180 = 108$ paid, $72$ owed.
- Cameras: 100 paid, 100 owed until 01/04/2019.
- Loan: interest 72 and principal 300 paid on 31/12/2018; it falls to $1.200 - 300 = 900$ (300 due on 31/12/2019, 600 later).
Step 3. Cash account 2018
| Inflows | m.u. | Outflows | m.u. |
|---|---|---|---|
| Collections from customers | 2.690 | Fertilizers | 350 |
| Hangar rent | 300 | ||
| Fixed salaries and Social Security | 720 | ||
| External pilots | 192 | ||
| Administration (60%) | 108 | ||
| Thermal cameras (50%) | 100 | ||
| Loan interest | 72 | ||
| Loan principal | 300 | ||
| Dividends | 96 | ||
| Total | 2.690 | Total | 2.238 |
Step 4. Balance sheet at 24:00 on 31/12/2018
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Land | 800 | Paid-in capital | 4.500 |
| Drones ($2.400 - 375$) | 2.025 | Losses of 2017 (offset) | 0 |
| Software licences ($400 - 100$) | 300 | Reserves | 224 |
| Thermal cameras ($200 - 16$) | 184 | Owners equity | 4.724 |
| Non-current assets | 3.309 | Bank loan due 2020–2021 | 600 |
| Stock of fertilizers | 100 | Non-current liabilities | 600 |
| Accounts receivable | 310 | Bank loan due 31/12/2019 | 300 |
| Cash | 2.407 | Suppliers of fertilizers | 150 |
| Creditors for administration expenses | 72 | ||
| Supplier of thermal cameras | 100 | ||
| Taxes payable | 180 | ||
| Current assets | 2.817 | Current liabilities | 802 |
| Total assets | 6.126 | Total liabilities and equity | 6.126 |
Accumulated depreciation of the drones: $75 + 300 = 375$.
- Remaining profit 320; dividends 96; reserves 224 m.u.
- Cash 2.407 m.u.
- Owners equity 4.724; current liabilities 802; total 6.126 m.u.
Part (c) · 0.5 points
Compute ROA and ROE of 2018
The ROE is below the ROA because interest and taxes are deducted from the numerator, while the equity base (4.724) is not much smaller than the total assets (6.126).
- ROA = 12,93%; ROE = 11,43% (extension).
Part (d) · 0.75 points
Effect of paying the dividend on 30 June 2019 and of not offsetting the 2017 loss before the 30% payout
Step 1. New distribution
Step 2. Changes in the balance sheet at 31/12/2018
| Item | Base case | New case | Change |
|---|---|---|---|
| Cash (the 96 m.u. are no longer paid) | 2.407 | 2.503 | +96 |
| Total assets | 6.126 | 6.222 | +96 |
| Losses of 2017 | 0 | (220) | −220 |
| Reserves | 224 | 378 | +154 |
| Owners equity | 4.724 | 4.658 | −66 |
| Dividends payable (current liability) | 0 | 162 | +162 |
| Total liabilities and equity | 6.126 | 6.222 | +96 |
Check: $-66 + 162 = +96$ (checked). The shareholders are promised more (162 instead of 96) because the dividend is computed before absorbing the loss; equity is lower by exactly the extra dividend ($162 - 96 = 66$), and the cash stays in the company until June.
- Dividend $0{,}30 \times 540 = 162$ m.u., recorded as "dividends payable" (current).
- Cash +96 (2.503); reserves 378; losses of 2017 (220) remain; owners equity 4.658 (−66).
- Totals 6.222 m.u. (+96).
Interpretation and checks
- Dimensional check: farms × m.u./(month·farm) × months gives m.u.; m.u./year × months/12 gives m.u.
- Accrual vs cash: net profit 540 m.u., while cash grew by 452 m.u.: $540 + 416$ (depreciation, no cash) $- 310$ (uncollected sales) $- 100$ (stock) $+ 150 + 72 + 180$ (suppliers, administration and tax still owed) $- 100$ (cameras) $- 300$ (principal) $- 96$ (dividends) $= 452$.
- Typical mistakes: expensing all 500 m.u. of fertilizers, amortizing the software in 2017, forgetting the 20% residual value of the cameras, and computing the interest on the original 1.500 m.u.
P13 — TAHSA: deducing the share of cash sales from the bank balance
The external auditor of TALLERES AERONÁUTICOS DEL HENARES S.A. (TAHSA), a company of Alcalá de Henares dedicated to the machining of titanium brackets and fittings for the aircraft structures industry, must issue the audit report on the financial statements (balance sheet and Income Statement) as of 31 December 2019 (31/12/2019). The auditor has the balance of the company as of 31 December 2018 (31/12/2018), which is included below, and the following operations that have taken place during the period from 1 January 2019 (01/01/2019) to 31 December 2019 (31/12/2019).
I. The company has sold during the year 2.400 brackets at a price of 8 m.u. / unit (every month the same amount, 200 u.). A part of the sales of each month, always the same percentage, is charged in cash in the moment of the sale; the rest is payable to 90 days. Unfortunately the commercial department has lost the contract that fixes this percentage.
II. During the first quarter of 2019, the unpaid taxes and the outstanding supplier balances of the previous year were paid. The customer debt outstanding from the previous year was charged in January, except 160 m.u. from an airline component maker declared in insolvency on 1 March 2019 (01/03/2019), which is definitively lost.
III. At 31 December 2018 (31/12/2018) there is a stock (stock in stock) of 800 kg of titanium bar valued at 1,50 m.u. / kg. On 1 February 2019 (01/02/2019) the company purchased 3.000 kg at 1,50 m.u. / kg, 50% payable to 60 days and the other 50% deferred until 1 February 2020 (01/02/2020). On 1 August 2019 (01/08/2019) it purchased 2.000 kg more at the same price, payable to 120 days. The count of 31 December 2019 (31/12/2019) shows 900 kg in the warehouse.
IV. Personnel expenses have been 400 m.u. / month (to which 120 m.u. / month must be added for Social Security); salaries are paid in the month in which they are produced and Social Security the month after. General expenses (electricity, insurance, cleaning) amount to 150 m.u. / month and are paid two months after being made.
V. The machinery of the balance of 2018 was bought on 1 January 2016 (01/01/2016) and is amortized linearly in 10 years with residual value zero. On 1 April 2019 (01/04/2019) the company bought a 5-axis CNC centre that cost 4.800 m.u., paid in full in cash that day. To finance it, the same day a bank granted a loan of 3.600 m.u. at 5% annual interest, to be returned in one single payment on 1 April 2022 (01/04/2022); the interest is paid every 1 April for the year that ends that day. The CNC centre will be amortized linearly in 8 years with a residual value of 480 m.u.
VI. The long-term loan of the balance of 2018 bears 4% annual interest. The company returns 300 m.u. of principal every 30 June and every 31 December, paying the same days the interest of the semester calculated on the debt at the beginning of the semester.
VII. On 1 October 2019 (01/10/2019) the shareholders subscribed a capital increase of 500 new shares of 2 m.u. nominal value, without issue premium, disbursing that day only 50%; the rest will be called in 2020. On 15 November 2019 (15/11/2019) the company received in cash a dividend of 80 m.u. from its financial shares in AEROPIEZAS S.A., a permanent investment.
VIII. The bank statement at 23:00 hrs on 31 December 2019 (31/12/2019), before any operation of the closing, shows a balance of 3.024 m.u. The results are declared at 23:59 hrs; the corporation tax of 30% is paid immediately, and 50% of the profit after taxes is paid as dividends before the final balance at 24:00 on 31 December 2019 (31/12/2019); the rest goes to reserves.
BALANCE 31 December 2018 (31/12/2018)
| ASSETS | m.u. | LIABILITIES | m.u. |
|---|---|---|---|
| NON-CURRENT ASSETS | 7.200 | OWNERS EQUITY | 8.100 |
| Land | 2.000 | Paid-in capital (3.500 shares × 2 m.u.) | 7.000 |
| Machinery | 6.000 | Reserves | 1.100 |
| Accum. depreciation | (1.800) | NON-CURRENT LIABILITIES | 1.200 |
| Financial shares in AEROPIEZAS S.A. | 1.000 | Long-term loan | 1.200 |
| CURRENT ASSETS | 3.700 | CURRENT LIABILITIES | 1.600 |
| Stock of titanium | 1.200 | Long-term loan, part due in 2019 | 600 |
| Accounts receivable | 1.600 | Suppliers | 700 |
| Cash | 900 | Unpaid taxes | 300 |
| Total Assets | 10.900 | Total Liabilities + OE | 10.900 |
Required:
- Deduce, justifying it from the bank statement, the percentage of the sales that is charged in cash, and construct the Income Statement (Profit and Loss Account) of TAHSA for the year 2019.
- Construct and justify the balance sheet at 24:00 on 31 December 2019 (31/12/2019), showing all the intermediate calculations.
- Determine the values of the ROA and ROE ratios in 2019.
- The commercial director proposes for 2020 that 50% of the sales be charged in cash, granting on those cash sales a discount of 4%. Indicate what changes would have occurred in the Income Statement, the cash and the balance sheet of 2019 if this policy had been applied from 1 January 2019 (01/01/2019). In which case is the profit higher, and in which case is the final cash balance higher? Discuss, reasoned, why.
Setup
Unknown of the problem: the share $p$ of each month's sales charged in cash. Every other flow of cash can be computed, so the bank statement before the closing (3.024 m.u.) gives one equation in $p$.
Collections at 90 days: a sale of January is collected in April; the sales of October, November and December are still pending at 31/12/2019.
Uncalled capital: the shareholders owe the 50% not yet disbursed; it is shown as a deduction of the subscribed capital, as in the Company X exercise of the course.
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{Total assets}$ and $\text{ROE} = \text{Net profit}/\text{Owners equity}$, on the balance at 24:00 on 31/12/2019.
Part (a) · 1.5 points
Deduce the percentage of cash sales and prepare the 2019 Income Statement
Step 1. Outflows before the closing
| Outflow | Computation | m.u. |
|---|---|---|
| Suppliers 2018 and unpaid taxes 2018 | $700 + 300$ | 1.000 |
| Titanium of 01/02, 50% at 60 days (01/04) | $0{,}50 \times 3.000 \times 1{,}50$ | 2.250 |
| Titanium of 01/08, at 120 days (29/11) | $2.000 \times 1{,}50$ | 3.000 |
| Salaries | $12 \times 400$ | 4.800 |
| Social Security, January–November | $11 \times 120$ | 1.320 |
| General expenses, January–October | $10 \times 150$ | 1.500 |
| CNC centre | 4.800 | |
| Old loan: principal | $300 + 300$ | 600 |
| Old loan: interest | $1.800 \times 0{,}04 \times \tfrac{6}{12} + 1.500 \times 0{,}04 \times \tfrac{6}{12} = 36 + 30$ | 66 |
| Total | 19.336 |
Step 2. Inflows other than the 2019 sales
Step 3. Equation for $p$
Monthly sales are $200 \times 8 = 1.600$ m.u. The cash part of every month is collected (12 months); the credit part only for January to September (9 months):
Collections from 2019 sales: $19.200 \times 0{,}30 + 9 \times 1.120 = 5.760 + 10.080 = 15.840$ m.u.; pending at 31/12: $3 \times 1.120 = 3.360$ m.u.
Step 4. Titanium consumed
Step 5. Depreciation
Step 6. Financial items
Step 7. Income Statement 2019
| Line | Computation | m.u. |
|---|---|---|
| Sales revenue | $2.400 \times 8$ | 19.200 |
| − Titanium consumed | Step 4 | 7.350 |
| − Personnel (salaries and Social Security) | $12 \times (400 + 120)$ | 6.240 |
| − General expenses | $12 \times 150$ | 1.800 |
| − Bad debt loss | item II | 160 |
| − Depreciation | Step 5 | 1.005 |
| = Income from operations | $19.200 - 16.555$ | 2.645 |
| + Financial income | dividend from AEROPIEZAS | 80 |
| − Financial expenses | Step 6 | 201 |
| = Profit before taxes | $2.645 + 80 - 201$ | 2.524 |
| − Corporation tax (30%) | $0{,}30 \times 2.524$ | 757,20 |
| = Net profit | $2.524 - 757{,}20$ | 1.766,80 |
- Outflows before closing 19.336; inflows other than 2019 sales 5.620 m.u.
- $p = 30\%$; collections from 2019 sales 15.840 m.u.
- Titanium consumed 7.350; depreciation 1.005; income from operations 2.645 m.u.
- Financial income 80, financial expenses 201; profit before taxes 2.524; tax 757,20; net profit 1.766,80 m.u.
Part (b) · 1.25 points
Prepare the balance sheet at 24:00 on 31 December 2019
Step 1. Closing operations
Step 2. Old loan after 2019
$1.800 - 600 = 1.200$ m.u.: 600 due in 2020 (current) and 600 in 2021 (non-current).
Step 3. Balance sheet at 24:00 on 31/12/2019
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Land | 2.000 | Subscribed capital (4.000 shares × 2) | 8.000 |
| Machinery ($6.000 - 2.400$) | 3.600 | − Uncalled capital | (500) |
| CNC centre ($4.800 - 405$) | 4.395 | Reserves | 1.983,40 |
| Financial shares in AEROPIEZAS S.A. | 1.000 | Owners equity | 9.483,40 |
| Non-current assets | 10.995 | Bank loan for the CNC (01/04/2022) | 3.600 |
| Stock of titanium (900 kg × 1,50) | 1.350 | Old loan, part due in 2021 | 600 |
| Accounts receivable | 3.360 | Non-current liabilities | 4.200 |
| Cash | 1.383,40 | Old loan, part due in 2020 | 600 |
| Interest payable (CNC loan) | 135 | ||
| Suppliers of titanium (01/02/2020) | 2.250 | ||
| Social Security payable | 120 | ||
| General expenses payable | 300 | ||
| Current assets | 6.093,40 | Current liabilities | 3.405 |
| Total assets | 17.088,40 | Total liabilities and equity | 17.088,40 |
- Dividends 883,40; reserves 1.983,40 m.u.; cash 1.383,40 m.u.
- Owners equity 9.483,40 (subscribed 8.000, uncalled −500).
- Non-current liabilities 4.200; current liabilities 3.405; total 17.088,40 m.u.
Part (c) · 0.5 points
Compute ROA and ROE of 2019
- ROA = 15,48%; ROE = 18,63% (extension).
Part (d) · 0.75 points
Effect of charging 50% in cash with a 4% discount; which case gives more profit and which more cash?
Step 1. New revenue and collections
Step 2. Results and closing
Step 3. Changes in the statements
| Item | Present policy | New policy | Change |
|---|---|---|---|
| Revenue | 19.200 | 18.816 | −384 |
| Corporation tax | 757,20 | 642 | −115,20 |
| Net profit | 1.766,80 | 1.498 | −268,80 |
| Accounts receivable | 3.360 | 2.400 | −960 |
| Cash at 24:00 | 1.383,40 | 2.209 | +825,60 |
| Total assets | 17.088,40 | 16.954 | −134,40 |
| Reserves | 1.983,40 | 1.849 | −134,40 |
| Total liabilities and equity | 17.088,40 | 16.954 | −134,40 |
Discussion. The profit is higher with the present policy: the discount is a real cost of 384 m.u. (269 m.u. after tax). The cash is higher with the new policy: 576 m.u. more are collected in 2019 because more of each sale is charged at once, and the lower profit also means less tax and fewer dividends paid at the closing. The discount buys liquidity at the price of profitability; it is worth it only if the company needs the cash or if the money collected earlier earns more than the discount costs.
- Revenue 18.816 (−384); net profit 1.498 (−268,80); dividends 749 (−134,40).
- Collections from 2019 sales 16.416 (+576); receivables 2.400 (−960).
- Cash at 24:00: 2.209 (+825,60). Profit higher with the present policy; cash higher with the new policy.
Interpretation and checks
- Dimensional check: units × m.u./unit, kg × m.u./kg and m.u./year × months/12 all give m.u.; $p$ and the ratios are dimensionless.
- Why the bank balance is enough: all the other flows are fixed by the terms of the contracts, so the cash balance determines the single unknown term, the share of cash sales.
- Uncalled capital: the 500 m.u. not disbursed are a debt of the shareholders to the company, not cash; showing them as a deduction keeps equity at the money actually contributed.
- Typical mistakes: paying the CNC loan interest in 2019, depreciating the CNC for 12 months, counting the dividend received as revenue from operations, and treating the bad debt as a collection.
P14 — AVIEBRO: a half-year close with a volume discount, a mortgage and prior losses
AVIÓNICA DEL EBRO S.L. (AVIEBRO), a Zaragoza workshop dedicated to the repair and calibration of avionics equipment for regional airlines and flying schools, must present to the bank that finances it the financial statements (balance sheet and Income Statement) as of 30 June 2020 (30/06/2020). The financial director has the balance of 31 December 2019 (31/12/2019), included below, and the following operations of the first semester, from 1 January 2020 (01/01/2020) to 30 June 2020 (30/06/2020):
I. The company has invoiced repairs for 1.600 m.u. every month. The payment condition agreed with the customers is payable to 60 days. A regional airline, which represents 40% of the invoicing of every month, surpassed in March the annual volume agreed in its contract, and from 1 April 2020 (01/04/2020) it receives a discount of 5% on all its invoices.
II. The customer debt outstanding at 31 December 2019 (31/12/2019) was charged in January, except 250 m.u. from a flying school that has been granted to pay it on 30 September 2020 (30/09/2020). The suppliers of the previous year were paid in February. As the company closed 2019 with losses, there were no taxes to pay.
III. At 31 December 2019 (31/12/2019) there is a stock (stock in stock) of 300 spare parts valued at 2 m.u. / unit. On 1 February 2020 (01/02/2020) the company purchased 400 parts at 2 m.u., 50% paid in cash and 50% payable to 90 days; on 1 May 2020 (01/05/2020) it purchased 300 parts more at the same price, payable to 120 days. At 30 June 2020 (30/06/2020) there remain 250 parts in the warehouse.
IV. The technicians cost 600 m.u. / month, paid in the same month, to which 180 m.u. / month of Social Security must be added, paid the month after. The overheads (electricity, telephone, cleaning) are 100 m.u. / month and are paid two months after being made. On 1 March 2020 (01/03/2020) the company carried out a renting contract for a test bench of 120 m.u. monthly, paid at the end of each month.
V. The patent of the balance (a calibration procedure) is amortized linearly in 5 years with residual value zero; the computer equipment was bought on 1 January 2019 (01/01/2019) and is amortized linearly in 3 years with residual value zero.
VI. On 1 April 2020 (01/04/2020) AVIEBRO bought a small hangar next to the airport: the building is valued at 2.000 m.u. and the land at 1.000 m.u. It paid 20% in cash and the rest with a mortgage loan at 4% annual interest, to be returned in installments of 120 m.u. every 1 October and every 1 April, the first one on 1 October 2020 (01/10/2020); the same days it pays the interest of the semester calculated on the debt at the beginning of the semester. The building is amortized linearly in 50 years with residual value zero.
VII. The long-term loan of the balance bears 5% annual interest, which is paid every 31 December, and it is returned in one single payment on 31 December 2022 (31/12/2022).
VIII. The corporation tax is 25%. The taxable base of the semester is the profit before taxes minus the losses from previous years still pending to offset, and the resulting tax will be paid on 20 July 2020 (20/07/2020) (counted in the balance as "taxes to pay"). No dividends are distributed at the half-year.
BALANCE 31 December 2019 (31/12/2019)
| ASSETS | m.u. | LIABILITIES | m.u. |
|---|---|---|---|
| NON-CURRENT ASSETS | 1.900 | OWNERS EQUITY | 2.700 |
| Patent | 1.200 | Paid-in capital | 3.200 |
| Accum. amortization of the patent | (300) | Losses from previous years | (500) |
| Computer equipment | 900 | NON-CURRENT LIABILITIES | 1.000 |
| Accum. depreciation of computer equipment | (300) | Long-term loan (31/12/2022) | 1.000 |
| Financial shares | 400 | CURRENT LIABILITIES | 500 |
| CURRENT ASSETS | 2.300 | Suppliers | 500 |
| Stock of spare parts | 600 | ||
| Accounts receivable | 1.000 | ||
| Cash | 700 | ||
| Total Assets | 4.200 | Total Liabilities + OE | 4.200 |
Required:
- Deduce the exact date on which the patent was acquired, and construct the Income Statement (Profit and Loss Account) of AVIEBRO for the first semester of 2020, explaining the intermediate calculations.
- Calculate the cash and construct the balance sheet at 30 June 2020 (30/06/2020).
- Determine the values of the ROA and ROE ratios of the semester, and indicate how the Income Statement and the balance sheet would change if the tax authority did not allow to offset the losses from previous years.
- Instead of buying the hangar, the company could have rented it from 1 April 2020 (01/04/2020) for 50 m.u. monthly, paid at the end of each month. Indicate the changes in the Income Statement, the cash and the balance sheet at 30 June 2020 (30/06/2020). In which case is the profit higher, and in which case is the final cash balance higher? Discuss, reasoned, why.
Setup
Time window: six months, 01/01/2020–30/06/2020. Depreciation and interest are prorated by months; expenses are recorded when incurred even if they are paid later [Slide 8].
Hypotheses:
- The airline's discount applies to the invoices of April, May and June only.
- "Payable to 90 days" from 1 February means payment on 1 May; "payable to 120 days" from 1 May means payment at the end of August, outside the semester.
- The losses from previous years are offset for tax purposes, but they stay in the balance sheet until the annual meeting distributes the profit of the year; the result of the semester is shown separately in equity.
- Land is not depreciated.
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{Total assets}$ and $\text{ROE} = \text{Net profit}/\text{Owners equity}$, both for the semester and on the balance at 30/06/2020.
Part (a) · 1.25 points
Deduce the purchase date of the patent and prepare the Income Statement of the semester
Step 1. Purchase date of the patent
Step 2. Revenue
Step 3. Parts consumed
Step 4. Personnel, overheads and renting
Step 5. Depreciation of the semester
Check of the computer equipment: one year at 300 m.u. gives the 300 of the 2019 balance (checked).
Step 6. Interest of the semester (accrued, nothing paid)
The mortgage is $3.000 - 0{,}20 \times 3.000 = 2.400$ m.u.
Step 7. Tax
Step 8. Income Statement 01/01/2020–30/06/2020
| Line | Computation | m.u. |
|---|---|---|
| Repair revenue | Step 2 | 9.504 |
| − Spare parts consumed | Step 3 | 1.500 |
| − Personnel (wages and Social Security) | Step 4 | 4.680 |
| − Overheads | Step 4 | 600 |
| − Renting of the test bench | Step 4 | 480 |
| − Depreciation and amortization | Step 5 | 280 |
| = Income from operations | $9.504 - 7.540$ | 1.964 |
| − Financial expenses | $24 + 25$ | 49 |
| = Profit before taxes | $1.964 - 49$ | 1.915 |
| − Corporation tax | Step 7 | 353,75 |
| = Net profit of the semester | $1.915 - 353{,}75$ | 1.561,25 |
- Patent bought on 1 October 2018 (01/10/2018).
- Revenue 9.504 (discount 96); parts consumed 1.500; depreciation 280 m.u.
- Income from operations 1.964; interest 49; profit before taxes 1.915 m.u.
- Taxable base 1.415; tax 353,75; net profit 1.561,25 m.u.
Part (b) · 1.25 points
Compute the cash and prepare the balance sheet at 30 June 2020
Step 1. Cash account of the semester
| Inflows | m.u. | Outflows | m.u. |
|---|---|---|---|
| 2019 receivables ($1.000 - 250$) | 750 | Suppliers 2019 | 500 |
| Invoices January–March ($3 \times 1.600$) | 4.800 | Parts of 01/02 ($400 + 400$) | 800 |
| Invoice of April ($1.600 - 32$) | 1.568 | Technicians' wages | 3.600 |
| Mortgage loan | 2.400 | Social Security, January–May | 900 |
| Overheads, January–April | 400 | ||
| Renting, March–June | 480 | ||
| Hangar (building and land) | 3.000 | ||
| Total | 9.518 | Total | 9.680 |
Step 2. Items still open at 30/06/2020
- Receivables: May and June invoices, $2 \times (1.600 - 32) = 3.136$, plus the 250 deferred to 30/09/2020: 3.386 m.u.
- Suppliers: the parts of 01/05 ($300 \times 2 = 600$), due at the end of August.
- Mortgage: installments of 01/10/2020 and 01/04/2021 ($2 \times 120 = 240$) are current; $2.400 - 240 = 2.160$ non-current.
Step 3. Balance sheet at 30/06/2020
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Patent ($1.200 - 420$) | 780 | Paid-in capital | 3.200 |
| Computer equipment ($900 - 450$) | 450 | Losses from previous years | (500) |
| Land | 1.000 | Profit of the semester | 1.561,25 |
| Building ($2.000 - 10$) | 1.990 | Owners equity | 4.261,25 |
| Financial shares | 400 | Long-term loan (31/12/2022) | 1.000 |
| Non-current assets | 4.620 | Mortgage loan, non-current part | 2.160 |
| Stock of spare parts (250 × 2) | 500 | Non-current liabilities | 3.160 |
| Accounts receivable | 3.386 | Mortgage loan, installments within one year | 240 |
| Cash | 538 | Interest payable ($24 + 25$) | 49 |
| Suppliers | 600 | ||
| Social Security payable | 180 | ||
| Overheads payable | 200 | ||
| Taxes to pay | 353,75 | ||
| Current assets | 4.424 | Current liabilities | 1.622,75 |
| Total assets | 9.044 | Total liabilities and equity | 9.044 |
- Cash at 30/06/2020: 538 m.u.
- Receivables 3.386; non-current assets 4.620; total 9.044 m.u.
- Owners equity 4.261,25; non-current liabilities 3.160; current liabilities 1.622,75 m.u.
Part (c) · 0.75 points
Compute ROA and ROE of the semester, and the effect of not offsetting the prior losses
Step 1. Ratios of the semester (extension)
Step 2. Without the offset of the losses
In the balance, "taxes to pay" rises by 125 m.u. and the profit of the semester (equity) falls by 125 m.u.; total assets and cash do not change, because the tax is paid only in July. The ROE falls to $1.436{,}25 / 4.136{,}25 = 34{,}72\%$. The offset is worth exactly $0{,}25 \times 500 = 125$ m.u. of tax saved.
- ROA = 21,72%; ROE = 36,64% (semester, extension).
- Without the offset: tax 478,75 (+125); net profit 1.436,25 (−125); taxes to pay +125; equity 4.136,25; totals unchanged; ROE 34,72%.
Part (d) · 0.75 points
Renting the hangar instead of buying it; which case gives more profit and which more cash?
Step 1. New results
Step 2. New cash
Step 3. Changes in the statements
| Item | Buying | Renting | Change |
|---|---|---|---|
| Depreciation | 280 | 270 | −10 |
| Rent of the hangar | 0 | 150 | +150 |
| Financial expenses | 49 | 25 | −24 |
| Net profit | 1.561,25 | 1.474,25 | −87 |
| Land and building (net) | 2.990 | 0 | −2.990 |
| Cash | 538 | 988 | +450 |
| Total assets | 9.044 | 6.504 | −2.540 |
| Owners equity | 4.261,25 | 4.174,25 | −87 |
| Mortgage loan (current and non-current) | 2.400 | 0 | −2.400 |
| Interest payable | 49 | 25 | −24 |
| Taxes to pay | 353,75 | 324,75 | −29 |
| Total liabilities and equity | 9.044 | 6.504 | −2.540 |
Discussion. The profit is higher buying the hangar: three months of rent (150) cost more than the depreciation of the building (10) and the mortgage interest (24) together, because the land is not depreciated and the mortgage is cheap. The cash is higher renting: the company keeps the 600 m.u. of down payment and pays only 150 of rent. Buying gives more profit but ties up cash and adds 2.400 m.u. of debt; renting preserves liquidity, which matters for a workshop that ends the semester with only 538 m.u. in the bank.
- Income from operations 1.824 (−140); interest 25; tax 324,75; net profit 1.474,25 (−87).
- Cash 988 (+450); total assets 6.504; no mortgage.
- Profit higher buying; cash higher renting.
Interpretation and checks
- Dimensional check: m.u./month × months gives m.u.; rates × m.u. × months/12 give m.u.; ratios dimensionless.
- Half-year ratios: ROA and ROE of a semester are not annual returns; annualising them would roughly double them.
- Profit is not cash: the company earned 1.561,25 m.u. but its cash fell from 700 to 538 m.u.: the hangar, the uncollected May–June invoices and the growth of receivables absorbed it.
- Typical mistakes: depreciating the land, applying the airline discount to the whole semester, paying the mortgage interest in the semester, and taxing the profit without offsetting the losses as the statement allows.
P15 — CAESA: financing a second autoclave with a semiannual loan or with new shares
The chief financial officer (CFO) of COMPOSITES AEROESPACIALES DE ÁLAVA S.A. (CAESA), a company of Vitoria dedicated to the manufacturing of carbon-fibre fairings for helicopters, is closing the books of the year 2021. The balance of the company at 31 December 2020 (31/12/2020) is included below; the operations of the period from 1 January 2021 (01/01/2021) to 31 December 2021 (31/12/2021) have been the following:
I. The company has sold 1.200 fairings at a price of 30 m.u. / unit (every month the same amount, 100 u.). Of the sales of every month, 20% is charged in cash and the remaining 80% is payable to 60 days. The customer debt of the previous year was charged in January, and the suppliers and the unpaid taxes of the previous year were paid in January and in April respectively.
II. At 31 December 2020 (31/12/2020) there is a stock (stock in stock) of 500 kg of epoxy resin valued at 3 m.u. / kg. On 1 March 2021 (01/03/2021) the company purchased 4.000 kg at 3 m.u. / kg, paying 30% in cash and the remaining 70% in two equal parts, on 1 September 2021 (01/09/2021) and on 1 March 2022 (01/03/2022). At 31 December 2021 (31/12/2021) there remain 700 kg in the warehouse.
III. The fixed salaries are 1.000 m.u. / month, paid in the same month, to which 300 m.u. / month of Social Security must be added, paid the month after. Variable wages of the lamination staff amounted in 2021 to 1.200 m.u. (paid in cash). The external supplies (energy for the autoclaves) are 250 m.u. / month and are paid two months after being made.
IV. The autoclave of the balance was bought on 1 January 2018 (01/01/2018) and is amortized linearly in 10 years with a residual value of 1.000 m.u. On 1 July 2021 (01/07/2021) CAESA put into service a second autoclave of 6.000 m.u. (amortized linearly in 10 years with a residual value of 600 m.u.) together with a software license for the control of the curing cycles of 1.200 m.u. (amortized linearly in 3 years with residual value zero), both paid in full in cash that day.
V. To pay the 7.200 m.u. of the expansion, the board accepted on 1 July 2021 (01/07/2021) a bank loan of 7.200 m.u. at 5% annual interest, to be returned in 8 semiannual installments of 900 m.u. every 1 January and every 1 July, the first on 1 January 2022 (01/01/2022); the same days the company pays the interest of the semester calculated on the debt at the beginning of the semester. The long-term loan of the balance bears 6% annual interest, paid every 31 December, and is returned in one single payment on 31 December 2023 (31/12/2023).
VI. The financial results are declared at 23:59 hrs on 31 December 2021 (31/12/2021). The corporation tax is 20% on the Profits and is paid immediately. Of the profit after taxes, 10% goes to the legal reserve, 30% is distributed as dividends paid in cash at 24:00 on 31 December 2021 (31/12/2021), and the rest goes to voluntary reserves.
VII. The alternative rejected by the board was a capital increase on 1 July 2021 (01/07/2021) of 4.800 new shares of 1 m.u. nominal value with an issue premium of 50% over the nominal value, fully disbursed in cash, instead of the bank loan.
BALANCE 31 December 2020 (31/12/2020)
| ASSETS | m.u. | LIABILITIES | m.u. |
|---|---|---|---|
| NON-CURRENT ASSETS | 9.600 | OWNERS EQUITY | 12.000 |
| Land | 3.000 | Paid-in capital (10.000 shares × 1 m.u.) | 10.000 |
| Autoclave | 9.000 | Reserves | 2.000 |
| Accum. depreciation | (2.400) | NON-CURRENT LIABILITIES | 1.000 |
| CURRENT ASSETS | 5.000 | Long-term loan (31/12/2023) | 1.000 |
| Stock of resin | 1.500 | CURRENT LIABILITIES | 1.600 |
| Accounts receivable | 2.000 | Suppliers | 1.200 |
| Cash | 1.500 | Unpaid taxes | 400 |
| Total Assets | 14.600 | Total Liabilities + OE | 14.600 |
Required:
- Construct the Income Statement (Profit and Loss Account) of CAESA for the year 2021, justifying the depreciation of the old autoclave from the data of the balance.
- Construct and justify the balance sheet at 24:00 on 31 December 2021 (31/12/2021), detailing the cash calculations and the classification of the new loan between current and non-current liabilities.
- Determine the ROA, the ROE and the debt-to-equity ratio of 2021.
- Indicate what changes would have occurred in the Income Statement, the cash and the balance sheet if the board had chosen the capital increase described in VII. Compare the ROE and the debt-to-equity ratio of both alternatives and explain, reasoned, the effect of the financial leverage.
Setup
Hypotheses:
- "Payable to 60 days" leaves the November and December sales uncollected at 31/12/2021.
- The interest of the new loan for July–December 2021 is accrued in 2021 and paid on 1 January 2022, the day after the closing; the installment of that day and the one of 1 July 2022 are due within one year.
- Land is not depreciated.
Financing sources involved: a long-term bank loan (external liability, [Slide 31]) against a rights issue with premium (external equity, [Slides 25-26]); the reserves are self-financing [Slide 23]. The debt-to-equity ratio is course material [Slide 36].
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{TA}$; $\text{ROE} = \text{Net profit}/E$, on the balance at 24:00.
Part (a) · 1 point
Prepare the 2021 Income Statement
Step 1. Depreciation
Step 2. Resin consumed
Step 3. Interest
Step 4. Income Statement 2021
| Line | Computation | m.u. |
|---|---|---|
| Sales revenue | $1.200 \times 30$ | 36.000 |
| − Resin consumed | Step 2 | 11.400 |
| − Fixed salaries and Social Security | $12 \times (1.000 + 300)$ | 15.600 |
| − Variable wages | 1.200 | |
| − External supplies (energy) | $12 \times 250$ | 3.000 |
| − Depreciation and amortization | Step 1 | 1.270 |
| = Income from operations | $36.000 - 32.470$ | 3.530 |
| − Financial expenses | Step 3 | 240 |
| = Profit before taxes | $3.530 - 240$ | 3.290 |
| − Corporation tax (20%) | $0{,}20 \times 3.290$ | 658 |
| = Net profit | $3.290 - 658$ | 2.632 |
- Old autoclave 800 m.u./year ($3 \times 800 = 2.400$ (checked)); new autoclave 270; software 200; total 1.270 m.u.
- Resin consumed 11.400; income from operations 3.530; interest 240 m.u.
- Profit before taxes 3.290; tax 658; net profit 2.632 m.u.
Part (b) · 1.5 points
Prepare the balance sheet at 24:00 on 31 December 2021
Step 1. Distribution
Step 2. Cash account 2021
| Inflows | m.u. | Outflows | m.u. |
|---|---|---|---|
| Cash sales ($0{,}20 \times 36.000$) | 7.200 | Suppliers 2020 | 1.200 |
| Credit sales January–October ($10 \times 2.400$) | 24.000 | Unpaid taxes 2020 | 400 |
| Receivables 2020 | 2.000 | Resin ($0{,}30 \times 12.000 + 0{,}35 \times 12.000$) | 7.800 |
| New bank loan | 7.200 | Fixed salaries | 12.000 |
| Social Security, January–November | 3.300 | ||
| Variable wages | 1.200 | ||
| External supplies, January–October | 2.500 | ||
| Second autoclave and software | 7.200 | ||
| Interest of the old loan | 60 | ||
| Corporation tax 2021 | 658 | ||
| Dividends | 789,60 | ||
| Total | 40.400 | Total | 37.107,60 |
Step 3. Classification of the new loan
Installments on 01/01/2022 and 01/07/2022: $2 \times 900 = 1.800$ m.u. current; the other six, $6 \times 900 = 5.400$ m.u., non-current.
Step 4. Balance sheet at 24:00 on 31/12/2021
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Land | 3.000 | Paid-in capital | 10.000 |
| Old autoclave ($9.000 - 3.200$) | 5.800 | Legal reserve | 263,20 |
| New autoclave ($6.000 - 270$) | 5.730 | Voluntary reserves (the 2.000 of 2020 + 1.579,20) | 3.579,20 |
| Software license ($1.200 - 200$) | 1.000 | Owners equity | 13.842,40 |
| Non-current assets | 15.530 | Long-term loan (31/12/2023) | 1.000 |
| Stock of resin (700 kg × 3) | 2.100 | New bank loan, non-current part | 5.400 |
| Accounts receivable ($2 \times 2.400$) | 4.800 | Non-current liabilities | 6.400 |
| Cash | 4.792,40 | New bank loan, installments in 2022 | 1.800 |
| Interest payable (01/01/2022) | 180 | ||
| Suppliers of resin (01/03/2022) | 4.200 | ||
| Social Security payable | 300 | ||
| External supplies payable | 500 | ||
| Current assets | 11.692,40 | Current liabilities | 6.980 |
| Total assets | 27.222,40 | Total liabilities and equity | 27.222,40 |
- Legal reserve 263,20; dividends 789,60; voluntary reserves 1.579,20 m.u.
- Cash 4.792,40 m.u.
- New loan: 1.800 current and 5.400 non-current; interest payable 180.
- Owners equity 13.842,40; total 27.222,40 m.u.
Part (c) · 0.5 points
Compute ROA, ROE and debt-to-equity of 2021
- ROA = 12,97%; ROE = 19,01% (extension); $L/E = 0{,}97$.
Part (d) · 1 point
The capital increase instead of the loan: changes, ROE, leverage and the leverage effect
Step 1. New results
Step 2. New cash
The 7.200 m.u. from the shares replace the 7.200 m.u. of the loan; only the tax (+36) and the dividend (+43,20) change:
Step 3. Changes in the balance sheet
| Item | Loan | Capital increase | Change |
|---|---|---|---|
| Cash | 4.792,40 | 4.713,20 | −79,20 |
| Total assets | 27.222,40 | 27.143,20 | −79,20 |
| Paid-in capital | 10.000 | 14.800 | +4.800 |
| Issue premium | 0 | 2.400 | +2.400 |
| Legal and voluntary reserves | 3.842,40 | 3.943,20 | +100,80 |
| Owners equity | 13.842,40 | 21.143,20 | +7.300,80 |
| New bank loan (current and non-current) | 7.200 | 0 | −7.200 |
| Interest payable | 180 | 0 | −180 |
| Total liabilities and equity | 27.222,40 | 27.143,20 | −79,20 |
Step 4. Comparison and leverage effect
| Ratio | Loan | Capital increase |
|---|---|---|
| ROA | 12,97% | $3.530 / 27.143{,}20 = 13{,}01\%$ |
| ROE | 19,01% | $2.776 / 21.143{,}20 = 13{,}13\%$ |
| $L/E$ [Slide 36] | 0,97 | $6.000 / 21.143{,}20 = 0{,}28$ |
The assets earn the same income from operations in both cases (about 13% of the assets), while the new loan costs only 5%. Each m.u. borrowed earns more than it costs, and the difference goes to the shareholders: with the loan, equity is 7.300,80 m.u. smaller while the net profit is only 144 m.u. lower, so the ROE rises from 13,13% to 19,01%. (Separately, the profit is shared among 10.000 shares instead of 14.800, which raises the earnings per share, an extension.) This is the positive financial leverage effect (the relation ROE vs ROA − cost of debt is an extension). Its price is risk: the loan raises the debt-to-equity ratio from 0,28 to 0,97 and commits the company to 1.800 m.u. of installments plus interest every year, while the new shares never have to be repaid [Slides 25, 36].
- Interest 60; profit before taxes 3.470; tax 694; net profit 2.776 m.u. (+144).
- Legal reserve 277,60; dividends 832,80; voluntary 1.665,60; cash 4.713,20 (−79,20).
- Owners equity 21.143,20; liabilities 6.000; total 27.143,20 m.u.
- ROE 13,13% vs 19,01%; $L/E$ 0,28 vs 0,97. The loan raises ROE because ROA ≈ 13% > cost of debt 5%.
Interpretation and checks
- Dimensional check: units × m.u./unit and kg × m.u./kg give m.u.; ratios dimensionless.
- Profit vs cash: the net profit of 2.632 m.u. does not explain the cash: 7.200 m.u. of new debt came in and 7.200 m.u. went into fixed assets, and 4.800 m.u. of sales are still uncollected.
- The day after the closing: the interest of the new loan is an expense of 2021 although it is paid on 01/01/2022; forgetting it overstates the profit by 180 m.u.
- Typical mistakes: putting the whole new loan in non-current liabilities, depreciating the new assets twelve months, ignoring the residual values and treating the issue premium as capital.
P16 — HESECA: the statements from a summary of ledger accounts, with prepaid insurance and a credit line
HELIPUERTOS Y SERVICIOS DEL CANTÁBRICO S.L. (HESECA) operates one helicopter from Santander for charter flights, offshore inspections and maintenance of other operators' aircraft. A trainee of the accounting firm that keeps its books has prepared, instead of the financial statements, the following summary of the ledger accounts of 2022, from 1 January 2022 (01/01/2022) to 31 December 2022 (31/12/2022). The partner of the firm asks you to prepare the balance sheet and the Income Statement as of 31 December 2022 (31/12/2022).
Opening balances at 1 January 2022 (01/01/2022): Customers 3.000; Spare parts 1.000; Bank 2.000; Helicopter (cost) 24.000; Accumulated depreciation of the helicopter 4.500; Van (cost) 1.800; Accumulated depreciation of the van 300; Paid-in capital 18.000; Reserves 1.500; Suppliers 1.200; Unpaid taxes 800; Bank loan 5.500.
Customers account: opening balance 3.000; invoiced in 2022 for flights and maintenance 34.000; collected in 2022 31.000; on 1 September 2022 (01/09/2022) a balance of 400 m.u. from an operator declared in bankruptcy was written off as definitively unrecoverable.
Spare parts and suppliers accounts: on 1 March 2022 (01/03/2022) parts were purchased for 3.000 m.u., 50% paid in cash and the rest payable to 60 days; on 1 September 2022 (01/09/2022) parts were purchased for 3.000 m.u. more, 50% payable to 30 days and the other 50% deferred until 1 March 2023 (01/03/2023). The suppliers' balance of the previous year was paid in January. The physical count of 31 December 2022 (31/12/2022) values the stock (stock in stock) of parts at 1.400 m.u.
Expense accounts (all paid by bank unless indicated): fuel 4.800; salaries of pilots and mechanics 9.600; Social Security 3.000, of which the contribution of December (250) is paid in January 2023; hangar rent 200 m.u. / month; on 1 October 2022 (01/10/2022) the annual insurance premium of the helicopter, 1.200 m.u., covering from 1 October 2022 (01/10/2022) to 30 September 2023 (30/09/2023), was paid in full. The unpaid taxes of 2021 were paid in January.
Fixed assets: the helicopter is amortized linearly in 12 years with a residual value of 10% of its cost, and was bought on a date that the trainee could not find; the van was bought on 1 January 2021 (01/01/2021) and is amortized linearly in 6 years with residual value zero.
Financing: the bank loan was granted on 1 January 2020 (01/01/2020) for 7.500 m.u. at 6% annual interest; every 31 December the company returns 1.000 m.u. and pays the interest calculated on the debt at the beginning of the year. On 1 May 2022 (01/05/2022) a bank opened a credit line with a limit of 4.000 m.u.: HESECA drew 2.000 m.u. that day and 1.000 m.u. more on 1 September 2022 (01/09/2022); it pays 9% annual interest only on the amount drawn, every 31 July, 31 October and 31 January, for the three months then ended.
Closing: the results are declared at 23:59 hrs on 31 December 2022 (31/12/2022). The corporation tax is 30% and will be paid in July 2023 ("taxes to pay"). The partners decided on 31 December 2022 (31/12/2022) a dividend of 30% of the profit after taxes, to be paid on 15 March 2023 (15/03/2023); the rest goes to reserves.
Required:
- Deduce the exact date on which the helicopter was purchased, and construct the Income Statement (Profit and Loss Account) of HESECA for the year 2022.
- Calculate the bank balance at 31 December 2022 (31/12/2022) and construct the balance sheet at that date, justifying the classification of every item.
- Determine the values of the ROA and ROE ratios in 2022, and indicate the effect on the balance sheet if the dividend had been paid at 24:00 on 31 December 2022 (31/12/2022).
- The trainee had recorded the whole insurance premium of 1.200 m.u. as an expense of 2022. Indicate what changes this error would produce in the Income Statement, the distribution of the profit and the balance sheet, and explain which statement it distorts and why.
Setup
Reading the ledger: a ledger account shows the opening balance, the increases and the decreases of the year; its closing balance is opening + increases − decreases. The balance sheet takes the closing balances of the asset, liability and equity accounts; the Income Statement takes the movements of the revenue and expense accounts.
Hypotheses:
- The rent is paid every month by bank (12 × 200).
- The insurance premium covers twelve months; only October–December 2022 are an expense of 2022, the rest is a prepaid expense, a current asset [Slide 14].
- Credit-line interest: May–July is paid on 31/07, August–October on 31/10, November–December accrue and are paid on 31/01/2023.
Extension (not defined in the course decks). $\text{ROA} = \text{Income from operations}/\text{TA}$; $\text{ROE} = \text{Net profit}/E$, on the balance at 31/12/2022.
Part (a) · 1.25 points
Deduce the purchase date of the helicopter and prepare the 2022 Income Statement
Step 1. Purchase date of the helicopter
Check of the van: one year (2021) at $1.800 / 6 = 300$ gives the 300 of the opening balance (checked).
Step 2. Parts consumed
Step 3. Insurance (accrual)
Step 4. Interest
Check of the loan: $7.500 - 2 \times 1.000 = 5.500$ at 01/01/2022 (checked).
Step 5. Income Statement 2022
| Line | Computation | m.u. |
|---|---|---|
| Revenue from flights and maintenance | Customers account | 34.000 |
| − Spare parts consumed | Step 2 | 5.600 |
| − Fuel | 4.800 | |
| − Salaries | 9.600 | |
| − Social Security | 3.000 | |
| − Hangar rent | $12 \times 200$ | 2.400 |
| − Insurance (October–December) | Step 3 | 300 |
| − Bad debt loss | Customers account | 400 |
| − Depreciation | $1.800 + 300$ | 2.100 |
| = Income from operations | $34.000 - 28.200$ | 5.800 |
| − Financial expenses | $330 + 150$ | 480 |
| = Profit before taxes | $5.800 - 480$ | 5.320 |
| − Corporation tax (30%) | $0{,}30 \times 5.320$ | 1.596 |
| = Net profit | $5.320 - 1.596$ | 3.724 |
- Helicopter: 1.800 m.u./year; bought on 1 July 2019 (01/07/2019).
- Parts consumed 5.600; insurance 300; depreciation 2.100 m.u.
- Income from operations 5.800; interest 330 + 150 = 480 m.u.
- Profit before taxes 5.320; tax 1.596; net profit 3.724 m.u.
Part (b) · 1.25 points
Compute the bank balance and prepare the balance sheet at 31 December 2022
Step 1. Closing the customers and suppliers accounts
| Supplier payment | Date | m.u. |
|---|---|---|
| Balance of 2021 | January | 1.200 |
| 50% of the March purchase | 01/03/2022 | 1.500 |
| 50% of the March purchase, at 60 days | 30/04/2022 | 1.500 |
| 50% of the September purchase, at 30 days | 01/10/2022 | 1.500 |
| Total paid | 5.700 |
Step 2. Credit-line interest paid
Step 3. Bank account 2022
| Inflows | m.u. | Outflows | m.u. |
|---|---|---|---|
| Collections from customers | 31.000 | Suppliers | 5.700 |
| Credit line drawn ($2.000 + 1.000$) | 3.000 | Fuel | 4.800 |
| Salaries | 9.600 | ||
| Social Security ($3.000 - 250$) | 2.750 | ||
| Hangar rent | 2.400 | ||
| Insurance premium | 1.200 | ||
| Credit-line interest | 105 | ||
| Loan interest | 330 | ||
| Loan principal | 1.000 | ||
| Unpaid taxes 2021 | 800 | ||
| Total | 34.000 | Total | 28.685 |
Step 4. Distribution
Step 5. Balance sheet at 31/12/2022
| Assets | m.u. | Liabilities and owners equity | m.u. |
|---|---|---|---|
| Helicopter ($24.000 - 6.300$) | 17.700 | Paid-in capital | 18.000 |
| Van ($1.800 - 600$) | 1.200 | Reserves | 4.106,80 |
| Non-current assets | 18.900 | Owners equity | 22.106,80 |
| Spare parts | 1.400 | Bank loan due 2024–2027 | 3.500 |
| Customers | 5.600 | Non-current liabilities | 3.500 |
| Prepaid insurance | 900 | Bank loan, installment 31/12/2023 | 1.000 |
| Bank | 7.315 | Credit line drawn | 3.000 |
| Interest payable (credit line) | 45 | ||
| Suppliers | 1.500 | ||
| Social Security payable | 250 | ||
| Taxes to pay | 1.596 | ||
| Dividends payable | 1.117,20 | ||
| Current assets | 15.215 | Current liabilities | 8.508,20 |
| Total assets | 34.115 | Total liabilities and equity | 34.115 |
The loan: $5.500 - 1.000 = 4.500$ m.u., of which 1.000 is due on 31/12/2023. The credit line is a short-term bank credit [Slide 31]; the prepaid insurance is a current asset because it will be consumed within the year [Slide 14].
- Customers 5.600; suppliers 1.500; payments to suppliers 5.700 m.u.
- Credit-line interest paid 105, payable 45 m.u.
- Bank balance 7.315 m.u.
- Owners equity 22.106,80; current liabilities 8.508,20; total 34.115 m.u.
Part (c) · 0.75 points
Compute ROA and ROE, and the effect of paying the dividend at 24:00 on 31 December 2022
| Item | Paid 15/03/2023 | Paid at 24:00 | Change |
|---|---|---|---|
| Bank | 7.315 | 6.197,80 | −1.117,20 |
| Dividends payable | 1.117,20 | 0 | −1.117,20 |
| Owners equity | 22.106,80 | 22.106,80 | 0 |
| Total assets = total liabilities and equity | 34.115 | 32.997,80 | −1.117,20 |
- ROA = 17,00%; ROE = 16,85% (extension).
- Paid at 24:00: bank 6.197,80; dividends payable 0; totals 32.997,80 m.u.
Part (d) · 0.75 points
The trainee's error: the whole insurance premium as an expense of 2022
Step 1. Effect on the results
Step 2. Effect on the balance sheet
| Item | Correct | With the error | Change |
|---|---|---|---|
| Prepaid insurance | 900 | 0 | −900 |
| Total assets | 34.115 | 33.215 | −900 |
| Reserves | 4.106,80 | 3.665,80 | −441 |
| Taxes to pay | 1.596 | 1.326 | −270 |
| Dividends payable | 1.117,20 | 928,20 | −189 |
| Total liabilities and equity | 34.115 | 33.215 | −900 |
Check: $441 + 270 + 189 = 900$ (checked).
Step 3. Which statement the error distorts
The bank balance is the same: the 1.200 m.u. were paid either way. The error is an accrual error: it charges to 2022 nine months of insurance that belong to 2023 [Slide 8]. The Income Statement of 2022 understates the profit by 630 m.u. (and that of 2023 will overstate it), and the balance sheet omits a resource the company still owns, the cover of January–September 2023. It also understates the tax and the dividend, so the partners receive 189 m.u. less than they should.
- Insurance expense 1.200 (+900); profit before taxes 4.420; tax 1.326 (−270); net profit 3.094 (−630).
- Dividend 928,20 (−189); reserves 3.665,80 (−441).
- Prepaid insurance disappears (−900); bank unchanged.
Interpretation and checks
- Dimensional check: m.u. × rate × months/12 gives m.u.; ratios dimensionless.
- Ledger logic: every closing balance follows from opening + increases − decreases; the customers account alone gives revenue (increase), collections and the bad debt (decreases) and the receivable (closing balance).
- Profit vs cash: net profit 3.724 m.u., while the bank rose by 5.315 m.u.: $3.724 + 2.100$ (depreciation) $+ 3.000$ (credit line) $- 1.000$ (principal) $- 900$ (prepaid insurance) $- 2.600$ (rise in customers) $- 400$ (rise in parts) $+ 300 + 250 + 796 + 45$ (more owed to suppliers, Social Security, tax and interest) $= 5.315$.
- Typical mistakes: expensing the whole insurance, charging the credit-line interest on the 4.000 m.u. limit instead of the amount drawn, treating the dividend decided as already paid, and forgetting the bad debt in the customers account.