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.

Problem · Topic 3 · 4 points · 60 min

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)

ASSETSm.u.LIABILITIESm.u.
CURRENT ASSETS2.940CURRENT LIABILITIES900
Cash(?)Unpaid taxes250
Accounts receivable1.200Accounts payable (suppliers)650
Inventory (stock)800NON-CURRENT LIABILITIES2.000
NON-CURRENT ASSETS5.560Long-term bank loan2.000
Land1.500OWNERS EQUITY(?)
Refrigeration chambers (Equipment)4.000Paid-in capital(?)
Accum. depreciation(540)Losses from previous years(400)
Financial shares600
Total Assets(?)Total Liabilities + OE(?)

Required:

  1. 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).
  2. 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.
  3. 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).
  4. 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):

  1. 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.
  2. 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.
  3. 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.
  4. Requirement 4: the containers consume raw material in proportion to the units sold, and no finished containers are kept in stock.
Inconsistency in the given balance

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

DateEvent
Q1 2018Unpaid taxes 250 and suppliers 650 of 2017 paid
H1 2018900 of the 2017 receivables collected; 100 written off on 01/06
01/04/2018Raw material 10.000 (4.000 cash); capital increase 3.000; vehicles 4.800 (2.400 cash)
01/07/2018Second 30% of raw material paid (3.000); short-term credit received 1.500
01/10/2018Second vehicle instalment 1.200; software 1.600 bought payable to 120 days
31/12/2018Loan 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

$$\text{Cash} = 2.940 - 1.200 - 800 = 940 \text{ m.u.}, \qquad \text{Total assets} = 2.940 + 5.560 = 8.500 \text{ m.u.}$$

Check of the non-current block: $1.500 + 4.000 - 540 + 600 = 5.560$ (checked).

$$\text{Paid-in capital} = 4 \times 1.500 = 6.000, \qquad \text{Owners equity} = 6.000 - 400 = 5.600 \text{ m.u.}$$
$$\text{Total liabilities + OE} = 900 + 2.000 + 5.600 = 8.500 \text{ m.u.} \;\checkmark$$

Step 2. Purchase date of the refrigeration chambers

$$D_{\text{year}} = \frac{4.000 - 0{,}10 \times 4.000}{10} = \frac{3.600}{10} = 360 \text{ m.u./year}$$
$$\frac{540}{360} = 1{,}5 \text{ years before } 31/12/2017 \;\Rightarrow\; \text{bought on 1 July 2016 (01/07/2016)}$$

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.

$$\text{Cooperative} = 75 \times 23 = 1.725 \text{ m.u./month}, \qquad \text{Others} = 225 \times 25 = 5.625 \text{ m.u./month}$$
$$\text{Revenue 2018} = 12 \times (1.725 + 5.625) = 12 \times 7.350 = 88.200 \text{ 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)

$$\text{Consumption} = 800 + 5.000 \times 2{,}00 - 900 \times 2{,}00 = 800 + 10.000 - 1.800 = 9.000 \text{ m.u.}$$

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)

$$\text{Personnel} = 12 \times 2.200 + 12 \times 600 + 3.620 = 26.400 + 7.200 + 3.620 = 37.220 \text{ m.u.}$$
  • 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)

$$D_{\text{chambers}} = 360, \qquad D_{\text{vehicles}} = \frac{4.800 - 480}{6} \times \frac{9}{12} = 720 \times \frac{9}{12} = 540, \qquad D_{\text{software}} = \frac{1.600}{4} \times \frac{3}{12} = 100$$
$$D_{2018} = 360 + 540 + 100 = 1.000 \text{ m.u.}$$

Step 7. Financial expenses (item VIII)

$$I_{\text{loan}} = 0{,}06 \times 2.000 = 120 \text{ m.u. (paid 31/12/2018)}, \qquad I_{\text{credit}} = 1.500 \times 0{,}08 \times \frac{6}{12} = 60 \text{ m.u. (paid 01/01/2019)}$$

Step 8. Income Statement 2018

LineComputationm.u.
Sales revenueStep 388.200
− Raw material consumedStep 49.000
− Personnel (wages and Social Security)Step 537.220
− General expenses and utilities$12 \times 1.100$13.200
− Renting of forklifts$10 \times 350$3.500
− Bad debt lossitem IV100
− Depreciation and amortizationStep 61.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
Key results
  • 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]

$$\text{Remaining profit} = 18.000 - 400 = 17.600, \qquad \text{Reserves} = 0{,}60 \times 17.600 = 10.560, \qquad \text{Dividends} = 0{,}40 \times 17.600 = 7.040 \text{ m.u.}$$

Step 2. Capital increase (item VII)

$$1.000 \times 2{,}00 = 2.000 \text{ (capital)}, \qquad 0{,}50 \times 2.000 = 1.000 \text{ (issue premium)}, \qquad \text{cash in} = 3.000 \text{ m.u.}$$

Step 3. Cash account 2018

Inflowsm.u.Outflowsm.u.
Cooperative sales (cash)20.700Unpaid taxes 2017250
Other customers, January–October ($10 \times 5.625$)56.250Suppliers 2017650
Receivables of 2017 (75%)900Raw material ($4.000 + 3.000$)7.000
Capital increase3.000Fixed wages26.400
Short-term bank credit1.500Variable wages3.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 interest120
Loan principal500
Dividends7.040
Total82.350Total69.230
$$\text{Cash}_{24:00,\,31/12/2018} = 940 + 82.350 - 69.230 = 14.060 \text{ m.u.}$$

Step 4. Balance sheet at 24:00 on 31/12/2018

Assetsm.u.Liabilities and owners equitym.u.
Land1.500Paid-in capital ($6.000 + 2.000$)8.000
Refrigeration chambers ($4.000 - 900$)3.100Issue premium1.000
Vehicles ($4.800 - 540$)4.260Reserves10.560
Software license ($1.600 - 100$)1.500Losses from previous years (offset)0
Financial shares600Owners equity19.560
Non-current assets10.960Long-term bank loan (2020–2021)1.000
Inventory (900 t × 2,00)1.800Non-current liabilities1.000
Accounts receivable ($11.250 + 200$)11.450Bank loan, instalment 31/12/2019500
Cash14.060Short-term bank credit1.500
Interest payable (credit)60
Suppliers of raw material3.000
Suppliers of vehicles1.200
Supplier of software1.600
Social Security payable600
General expenses payable2.200
Renting payable1.050
Unpaid taxes6.000
Current assets27.310Current liabilities17.710
Total assets38.270Total liabilities and equity38.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.

Key results
  • 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)

$$\text{ROA} = \frac{24.180}{38.270} = 63{,}18\%, \qquad \text{ROE} = \frac{18.000}{19.560} = 92{,}02\%$$

Step 2. Dividend decided in 2018, paid on 15/04/2019

ItemPaid at 24:00Paid 15/04/2019Change
Cash14.06021.100+7.040
Dividends payable (current liability)07.040+7.040
Reserves and owners equity19.56019.5600
Total assets = total liabilities and equity38.27045.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.

Key results
  • 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

$$75 \times 0{,}90 = 67{,}5 \text{ u./month}, \qquad 67{,}5 \times 25 = 1.687{,}5 \text{ m.u./month}, \qquad 12 \times 1.687{,}5 = 20.250 \text{ m.u.}$$
$$\Delta\text{Revenue} = 20.250 - 20.700 = -450 \text{ m.u.} \;\Rightarrow\; \text{Revenue} = 87.750 \text{ m.u.}$$

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:

$$\Delta\text{Consumption} = -90 \times 2{,}50 = -225 \text{ m.u.} \;\Rightarrow\; \text{final stock} = 1.800 + 225 = 2.025 \text{ m.u.}$$

Step 3. New results

$$\text{Profit before taxes} = 24.000 - 450 + 225 = 23.775, \qquad \text{Tax} = 0{,}25 \times 23.775 = 5.943{,}75$$
$$\text{Net profit} = 23.775 - 5.943{,}75 = 17.831{,}25, \qquad \text{Remaining} = 17.431{,}25$$
$$\text{Reserves} = 0{,}60 \times 17.431{,}25 = 10.458{,}75, \qquad \text{Dividends} = 0{,}40 \times 17.431{,}25 = 6.972{,}50$$

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.

$$\text{Cash} = 14.060 - 3.825 + 67{,}50 = 10.302{,}50 \text{ m.u.}$$

Step 5. Changes in the statements

ItemBaseWithout discountChange
Revenue88.20087.750−450
Raw material consumed9.0008.775−225
Net profit18.00017.831,25−168,75
Inventory1.8002.025+225
Accounts receivable11.45014.825+3.375
Cash14.06010.302,50−3.757,50
Total assets38.27038.112,50−157,50
Reserves10.56010.458,75−101,25
Unpaid taxes6.0005.943,75−56,25
Total liabilities and equity38.27038.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.

Key results
  • 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.
Problem · Topic 3 · 4 points · 50 min

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:

  1. 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.
  2. Construct and justify the balance sheet at 24:00 on 31 December 2018 (31/12/2018), detailing all intermediate cash and accrual calculations.
  3. Determine the values of the ROA and ROE ratios in 2018.
  4. 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:

  1. 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").
  2. The software licences were bought on the last day of 2017, so their amortization starts in 2018 (a full year).
  3. 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):

Assetsm.u.Liabilities and owners equitym.u.
Land800Paid-in capital4.500
Drones ($2.400 - 75$)2.325Losses of 2017(220)
Software licences400Owners equity4.280
Cash1.955Bank loan due 2019–2021900
Bank loan due 31/12/2018300
Total assets5.480Total liabilities and equity5.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

$$D_{\text{drones}} = \frac{2.400 - 0}{8} = 300 \text{ m.u./year}, \qquad \frac{75}{300} \times 12 = 3 \text{ months} \;\Rightarrow\; \text{bought on 1 October 2017 (01/10/2017)}$$

Step 2. Revenue

$$\text{Subscriptions} = 400 \times 0{,}45 \times 12 = 2.160, \qquad \text{Revenue} = 2.160 + 840 = 3.000 \text{ m.u.}$$

Step 3. Fertilizers consumed

$$\text{Consumed} = 0{,}80 \times 500 = 400, \qquad \text{Stock at } 31/12/2018 = 500 - 400 = 100 \text{ m.u.}$$

Step 4. Depreciation and amortization

$$D_{\text{drones}} = 300, \qquad D_{\text{software}} = \frac{400}{4} = 100, \qquad D_{\text{cameras}} = \frac{200 - 0{,}20 \times 200}{5} \times \frac{6}{12} = 32 \times \frac{6}{12} = 16$$
$$D_{2018} = 300 + 100 + 16 = 416 \text{ m.u.}$$

Step 5. Interest

$$I_{2018} = 0{,}06 \times 1.200 = 72 \text{ m.u.} \quad \text{(loan value at the beginning of 2018)}$$

Step 6. Income Statement 2018

LineComputationm.u.
Subscription fees$400 \times 0{,}45 \times 12$2.160
Sales of fertilizers840
Revenue3.000
− Fertilizers consumedStep 3400
− Hangar rent$12 \times 25$300
− Fixed salaries and Social Security$12 \times 60$720
− Variable wages of external pilots192
− Electricity, insurance and administration180
− Depreciation and amortizationStep 4416
= Income from operations$3.000 - 2.208$792
− Financial expenses (interest)Step 572
= Profit before taxes$792 - 72$720
− Corporation tax (25%)$0{,}25 \times 720$180
= Net profit$720 - 180$540
Key results
  • 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

$$\text{Remaining profit} = 540 - 220 = 320, \qquad \text{Dividends} = 0{,}30 \times 320 = 96, \qquad \text{Reserves} = 320 - 96 = 224 \text{ m.u.}$$

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

Inflowsm.u.Outflowsm.u.
Collections from customers2.690Fertilizers350
Hangar rent300
Fixed salaries and Social Security720
External pilots192
Administration (60%)108
Thermal cameras (50%)100
Loan interest72
Loan principal300
Dividends96
Total2.690Total2.238
$$\text{Cash}_{24:00,\,31/12/2018} = 1.955 + 2.690 - 2.238 = 2.407 \text{ m.u.}$$

Step 4. Balance sheet at 24:00 on 31/12/2018

Assetsm.u.Liabilities and owners equitym.u.
Land800Paid-in capital4.500
Drones ($2.400 - 375$)2.025Losses of 2017 (offset)0
Software licences ($400 - 100$)300Reserves224
Thermal cameras ($200 - 16$)184Owners equity4.724
Non-current assets3.309Bank loan due 2020–2021600
Stock of fertilizers100Non-current liabilities600
Accounts receivable310Bank loan due 31/12/2019300
Cash2.407Suppliers of fertilizers150
Creditors for administration expenses72
Supplier of thermal cameras100
Taxes payable180
Current assets2.817Current liabilities802
Total assets6.126Total liabilities and equity6.126

Accumulated depreciation of the drones: $75 + 300 = 375$.

Key results
  • 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

$$\text{ROA} = \frac{792}{6.126} = 12{,}93\%, \qquad \text{ROE} = \frac{540}{4.724} = 11{,}43\%$$

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).

Key results
  • 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

$$\text{Dividend} = 0{,}30 \times 540 = 162, \qquad \text{Reserves} = 540 - 162 = 378 \text{ m.u.}, \qquad \text{the loss of 2017 } (-220) \text{ is not offset}$$

Step 2. Changes in the balance sheet at 31/12/2018

ItemBase caseNew caseChange
Cash (the 96 m.u. are no longer paid)2.4072.503+96
Total assets6.1266.222+96
Losses of 20170(220)−220
Reserves224378+154
Owners equity4.7244.658−66
Dividends payable (current liability)0162+162
Total liabilities and equity6.1266.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.

Key results
  • 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.
Problem · Topic 3 · 4 points · 60 min

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)

ASSETSm.u.LIABILITIESm.u.
NON-CURRENT ASSETS7.200OWNERS EQUITY8.100
Land2.000Paid-in capital (3.500 shares × 2 m.u.)7.000
Machinery6.000Reserves1.100
Accum. depreciation(1.800)NON-CURRENT LIABILITIES1.200
Financial shares in AEROPIEZAS S.A.1.000Long-term loan1.200
CURRENT ASSETS3.700CURRENT LIABILITIES1.600
Stock of titanium1.200Long-term loan, part due in 2019600
Accounts receivable1.600Suppliers700
Cash900Unpaid taxes300
Total Assets10.900Total Liabilities + OE10.900

Required:

  1. 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.
  2. Construct and justify the balance sheet at 24:00 on 31 December 2019 (31/12/2019), showing all the intermediate calculations.
  3. Determine the values of the ROA and ROE ratios in 2019.
  4. 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

OutflowComputationm.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 centre4.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
Total19.336

Step 2. Inflows other than the 2019 sales

$$\underbrace{1.600 - 160}_{\text{2018 receivables}} + \underbrace{3.600}_{\text{new loan}} + \underbrace{0{,}50 \times 1.000}_{\text{capital disbursed}} + \underbrace{80}_{\text{dividend received}} = 1.440 + 3.600 + 500 + 80 = 5.620 \text{ m.u.}$$

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):

$$900 + 5.620 + 12 \times 1.600\,p + 9 \times 1.600\,(1 - p) - 19.336 = 3.024$$
$$19.200\,p + 14.400 - 14.400\,p = 3.024 + 19.336 - 900 - 5.620 = 15.840$$
$$4.800\,p = 15.840 - 14.400 = 1.440 \;\Rightarrow\; p = \frac{1.440}{4.800} = 0{,}30 = 30\%$$

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

$$\text{Consumption} = 1.200 + 3.000 \times 1{,}50 + 2.000 \times 1{,}50 - 900 \times 1{,}50 = 1.200 + 4.500 + 3.000 - 1.350 = 7.350 \text{ m.u.}$$

Step 5. Depreciation

$$D_{\text{machinery}} = \frac{6.000}{10} = 600 \quad \left(\text{check: } 3 \text{ years} \times 600 = 1.800 \text{ at } 31/12/2018 \;\checkmark\right)$$
$$D_{\text{CNC}} = \frac{4.800 - 480}{8} \times \frac{9}{12} = 540 \times \frac{9}{12} = 405, \qquad D_{2019} = 600 + 405 = 1.005 \text{ m.u.}$$

Step 6. Financial items

$$I_{\text{old loan}} = 66 \text{ (Step 1)}, \qquad I_{\text{CNC loan}} = 3.600 \times 0{,}05 \times \frac{9}{12} = 135 \text{ (accrued, paid 01/04/2020)}$$
$$\text{Financial expenses} = 66 + 135 = 201, \qquad \text{Financial income (dividend received)} = 80 \text{ m.u.}$$

Step 7. Income Statement 2019

LineComputationm.u.
Sales revenue$2.400 \times 8$19.200
− Titanium consumedStep 47.350
− Personnel (salaries and Social Security)$12 \times (400 + 120)$6.240
− General expenses$12 \times 150$1.800
− Bad debt lossitem II160
− DepreciationStep 51.005
= Income from operations$19.200 - 16.555$2.645
+ Financial incomedividend from AEROPIEZAS80
− Financial expensesStep 6201
= 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
Key results
  • 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

$$\text{Dividends} = 0{,}50 \times 1.766{,}80 = 883{,}40, \qquad \text{to reserves} = 883{,}40 \;\Rightarrow\; \text{Reserves} = 1.100 + 883{,}40 = 1.983{,}40$$
$$\text{Cash}_{24:00} = 3.024 - 757{,}20 - 883{,}40 = 1.383{,}40 \text{ m.u.}$$

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

Assetsm.u.Liabilities and owners equitym.u.
Land2.000Subscribed capital (4.000 shares × 2)8.000
Machinery ($6.000 - 2.400$)3.600− Uncalled capital(500)
CNC centre ($4.800 - 405$)4.395Reserves1.983,40
Financial shares in AEROPIEZAS S.A.1.000Owners equity9.483,40
Non-current assets10.995Bank loan for the CNC (01/04/2022)3.600
Stock of titanium (900 kg × 1,50)1.350Old loan, part due in 2021600
Accounts receivable3.360Non-current liabilities4.200
Cash1.383,40Old loan, part due in 2020600
Interest payable (CNC loan)135
Suppliers of titanium (01/02/2020)2.250
Social Security payable120
General expenses payable300
Current assets6.093,40Current liabilities3.405
Total assets17.088,40Total liabilities and equity17.088,40
Key results
  • 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

$$\text{ROA} = \frac{2.645}{17.088{,}40} = 15{,}48\%, \qquad \text{ROE} = \frac{1.766{,}80}{9.483{,}40} = 18{,}63\%$$
Key results
  • 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

$$\text{Revenue} = 0{,}50 \times 19.200 \times 0{,}96 + 0{,}50 \times 19.200 = 9.216 + 9.600 = 18.816 \text{ m.u.} \;(-384)$$
$$\text{Collections} = 9.216 + 9 \times 800 = 16.416 \;(+576), \qquad \text{Receivables} = 3 \times 800 = 2.400 \;(-960)$$

Step 2. Results and closing

$$\text{Profit before taxes} = 2.524 - 384 = 2.140, \qquad \text{Tax} = 0{,}30 \times 2.140 = 642, \qquad \text{Net profit} = 1.498$$
$$\text{Dividends} = 0{,}50 \times 1.498 = 749, \qquad \text{Reserves} = 1.100 + 749 = 1.849$$
$$\text{Cash}_{24:00} = (3.024 + 576) - 642 - 749 = 2.209 \text{ m.u.}$$

Step 3. Changes in the statements

ItemPresent policyNew policyChange
Revenue19.20018.816−384
Corporation tax757,20642−115,20
Net profit1.766,801.498−268,80
Accounts receivable3.3602.400−960
Cash at 24:001.383,402.209+825,60
Total assets17.088,4016.954−134,40
Reserves1.983,401.849−134,40
Total liabilities and equity17.088,4016.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.

Key results
  • 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.
Problem · Topic 3 · 4 points · 60 min

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)

ASSETSm.u.LIABILITIESm.u.
NON-CURRENT ASSETS1.900OWNERS EQUITY2.700
Patent1.200Paid-in capital3.200
Accum. amortization of the patent(300)Losses from previous years(500)
Computer equipment900NON-CURRENT LIABILITIES1.000
Accum. depreciation of computer equipment(300)Long-term loan (31/12/2022)1.000
Financial shares400CURRENT LIABILITIES500
CURRENT ASSETS2.300Suppliers500
Stock of spare parts600
Accounts receivable1.000
Cash700
Total Assets4.200Total Liabilities + OE4.200

Required:

  1. 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.
  2. Calculate the cash and construct the balance sheet at 30 June 2020 (30/06/2020).
  3. 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.
  4. 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:

  1. The airline's discount applies to the invoices of April, May and June only.
  2. "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.
  3. 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.
  4. 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

$$D_{\text{patent}} = \frac{1.200}{5} = 240 \text{ m.u./year}, \qquad \frac{300}{240} = 1{,}25 \text{ years} = 15 \text{ months before } 31/12/2019 \;\Rightarrow\; \text{1 October 2018 (01/10/2018)}$$

Step 2. Revenue

$$\text{Discount per month} = 0{,}05 \times 0{,}40 \times 1.600 = 32 \text{ m.u.}, \qquad \text{Revenue} = 6 \times 1.600 - 3 \times 32 = 9.600 - 96 = 9.504 \text{ m.u.}$$

Step 3. Parts consumed

$$\text{Consumption} = 600 + 400 \times 2 + 300 \times 2 - 250 \times 2 = 600 + 800 + 600 - 500 = 1.500 \text{ m.u.}$$

Step 4. Personnel, overheads and renting

$$\text{Personnel} = 6 \times (600 + 180) = 4.680, \qquad \text{Overheads} = 6 \times 100 = 600, \qquad \text{Renting} = 4 \times 120 = 480 \text{ m.u.}$$

Step 5. Depreciation of the semester

$$D_{\text{patent}} = 240 \times \frac{6}{12} = 120, \qquad D_{\text{computer}} = \frac{900}{3} \times \frac{6}{12} = 150, \qquad D_{\text{building}} = \frac{2.000}{50} \times \frac{3}{12} = 10$$
$$D = 120 + 150 + 10 = 280 \text{ m.u.}$$

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)

$$I_{\text{mortgage}} = 2.400 \times 0{,}04 \times \frac{3}{12} = 24, \qquad I_{\text{loan}} = 1.000 \times 0{,}05 \times \frac{6}{12} = 25 \text{ m.u.}$$

The mortgage is $3.000 - 0{,}20 \times 3.000 = 2.400$ m.u.

Step 7. Tax

$$\text{Taxable base} = 1.915 - 500 = 1.415, \qquad \text{Tax} = 0{,}25 \times 1.415 = 353{,}75 \text{ m.u.}$$

Step 8. Income Statement 01/01/2020–30/06/2020

LineComputationm.u.
Repair revenueStep 29.504
− Spare parts consumedStep 31.500
− Personnel (wages and Social Security)Step 44.680
− OverheadsStep 4600
− Renting of the test benchStep 4480
− Depreciation and amortizationStep 5280
= Income from operations$9.504 - 7.540$1.964
− Financial expenses$24 + 25$49
= Profit before taxes$1.964 - 49$1.915
− Corporation taxStep 7353,75
= Net profit of the semester$1.915 - 353{,}75$1.561,25
Key results
  • 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

Inflowsm.u.Outflowsm.u.
2019 receivables ($1.000 - 250$)750Suppliers 2019500
Invoices January–March ($3 \times 1.600$)4.800Parts of 01/02 ($400 + 400$)800
Invoice of April ($1.600 - 32$)1.568Technicians' wages3.600
Mortgage loan2.400Social Security, January–May900
Overheads, January–April400
Renting, March–June480
Hangar (building and land)3.000
Total9.518Total9.680
$$\text{Cash}_{30/06/2020} = 700 + 9.518 - 9.680 = 538 \text{ m.u.}$$

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

Assetsm.u.Liabilities and owners equitym.u.
Patent ($1.200 - 420$)780Paid-in capital3.200
Computer equipment ($900 - 450$)450Losses from previous years(500)
Land1.000Profit of the semester1.561,25
Building ($2.000 - 10$)1.990Owners equity4.261,25
Financial shares400Long-term loan (31/12/2022)1.000
Non-current assets4.620Mortgage loan, non-current part2.160
Stock of spare parts (250 × 2)500Non-current liabilities3.160
Accounts receivable3.386Mortgage loan, installments within one year240
Cash538Interest payable ($24 + 25$)49
Suppliers600
Social Security payable180
Overheads payable200
Taxes to pay353,75
Current assets4.424Current liabilities1.622,75
Total assets9.044Total liabilities and equity9.044
Key results
  • 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)

$$\text{ROA} = \frac{1.964}{9.044} = 21{,}72\%, \qquad \text{ROE} = \frac{1.561{,}25}{4.261{,}25} = 36{,}64\%$$

Step 2. Without the offset of the losses

$$\text{Tax} = 0{,}25 \times 1.915 = 478{,}75 \;(+125), \qquad \text{Net profit} = 1.915 - 478{,}75 = 1.436{,}25 \;(-125)$$

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.

Key results
  • 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

$$\text{Income from operations} = 1.964 + 10 - 3 \times 50 = 1.824, \qquad \text{Profit before taxes} = 1.824 - 25 = 1.799$$
$$\text{Tax} = 0{,}25 \times (1.799 - 500) = 324{,}75, \qquad \text{Net profit} = 1.799 - 324{,}75 = 1.474{,}25$$

Step 2. New cash

$$\text{Cash} = 538 + 600 - 3 \times 50 = 988 \text{ m.u.}$$

Step 3. Changes in the statements

ItemBuyingRentingChange
Depreciation280270−10
Rent of the hangar0150+150
Financial expenses4925−24
Net profit1.561,251.474,25−87
Land and building (net)2.9900−2.990
Cash538988+450
Total assets9.0446.504−2.540
Owners equity4.261,254.174,25−87
Mortgage loan (current and non-current)2.4000−2.400
Interest payable4925−24
Taxes to pay353,75324,75−29
Total liabilities and equity9.0446.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.

Key results
  • 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.
Problem · Topic 3 · 4 points · 60 min

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)

ASSETSm.u.LIABILITIESm.u.
NON-CURRENT ASSETS9.600OWNERS EQUITY12.000
Land3.000Paid-in capital (10.000 shares × 1 m.u.)10.000
Autoclave9.000Reserves2.000
Accum. depreciation(2.400)NON-CURRENT LIABILITIES1.000
CURRENT ASSETS5.000Long-term loan (31/12/2023)1.000
Stock of resin1.500CURRENT LIABILITIES1.600
Accounts receivable2.000Suppliers1.200
Cash1.500Unpaid taxes400
Total Assets14.600Total Liabilities + OE14.600

Required:

  1. 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.
  2. 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.
  3. Determine the ROA, the ROE and the debt-to-equity ratio of 2021.
  4. 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:

  1. "Payable to 60 days" leaves the November and December sales uncollected at 31/12/2021.
  2. 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.
  3. 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

$$D_{\text{old}} = \frac{9.000 - 1.000}{10} = 800 \quad \left(\text{2018–2020: } 3 \times 800 = 2.400 \;\checkmark\right)$$
$$D_{\text{new}} = \frac{6.000 - 600}{10} \times \frac{6}{12} = 540 \times \frac{6}{12} = 270, \qquad D_{\text{software}} = \frac{1.200}{3} \times \frac{6}{12} = 200$$
$$D_{2021} = 800 + 270 + 200 = 1.270 \text{ m.u.}$$

Step 2. Resin consumed

$$\text{Consumption} = 1.500 + 4.000 \times 3 - 700 \times 3 = 1.500 + 12.000 - 2.100 = 11.400 \text{ m.u.}$$

Step 3. Interest

$$I_{\text{old loan}} = 0{,}06 \times 1.000 = 60, \qquad I_{\text{new loan}} = 7.200 \times 0{,}05 \times \frac{6}{12} = 180, \qquad I = 240 \text{ m.u.}$$

Step 4. Income Statement 2021

LineComputationm.u.
Sales revenue$1.200 \times 30$36.000
− Resin consumedStep 211.400
− Fixed salaries and Social Security$12 \times (1.000 + 300)$15.600
− Variable wages1.200
− External supplies (energy)$12 \times 250$3.000
− Depreciation and amortizationStep 11.270
= Income from operations$36.000 - 32.470$3.530
− Financial expensesStep 3240
= Profit before taxes$3.530 - 240$3.290
− Corporation tax (20%)$0{,}20 \times 3.290$658
= Net profit$3.290 - 658$2.632
Key results
  • 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

$$\text{Legal reserve} = 0{,}10 \times 2.632 = 263{,}20, \qquad \text{Dividends} = 0{,}30 \times 2.632 = 789{,}60, \qquad \text{Voluntary reserves} = 0{,}60 \times 2.632 = 1.579{,}20$$

Step 2. Cash account 2021

Inflowsm.u.Outflowsm.u.
Cash sales ($0{,}20 \times 36.000$)7.200Suppliers 20201.200
Credit sales January–October ($10 \times 2.400$)24.000Unpaid taxes 2020400
Receivables 20202.000Resin ($0{,}30 \times 12.000 + 0{,}35 \times 12.000$)7.800
New bank loan7.200Fixed salaries12.000
Social Security, January–November3.300
Variable wages1.200
External supplies, January–October2.500
Second autoclave and software7.200
Interest of the old loan60
Corporation tax 2021658
Dividends789,60
Total40.400Total37.107,60
$$\text{Cash}_{24:00,\,31/12/2021} = 1.500 + 40.400 - 37.107{,}60 = 4.792{,}40 \text{ m.u.}$$

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

Assetsm.u.Liabilities and owners equitym.u.
Land3.000Paid-in capital10.000
Old autoclave ($9.000 - 3.200$)5.800Legal reserve263,20
New autoclave ($6.000 - 270$)5.730Voluntary reserves (the 2.000 of 2020 + 1.579,20)3.579,20
Software license ($1.200 - 200$)1.000Owners equity13.842,40
Non-current assets15.530Long-term loan (31/12/2023)1.000
Stock of resin (700 kg × 3)2.100New bank loan, non-current part5.400
Accounts receivable ($2 \times 2.400$)4.800Non-current liabilities6.400
Cash4.792,40New bank loan, installments in 20221.800
Interest payable (01/01/2022)180
Suppliers of resin (01/03/2022)4.200
Social Security payable300
External supplies payable500
Current assets11.692,40Current liabilities6.980
Total assets27.222,40Total liabilities and equity27.222,40
Key results
  • 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

$$\text{ROA} = \frac{3.530}{27.222{,}40} = 12{,}97\%, \qquad \text{ROE} = \frac{2.632}{13.842{,}40} = 19{,}01\%, \qquad \frac{L}{E} = \frac{13.380}{13.842{,}40} = 0{,}97$$
Key results
  • 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

$$\text{Profit before taxes} = 3.530 - 60 = 3.470, \qquad \text{Tax} = 0{,}20 \times 3.470 = 694, \qquad \text{Net profit} = 3.470 - 694 = 2.776$$
$$\text{Legal reserve} = 277{,}60, \qquad \text{Dividends} = 832{,}80, \qquad \text{Voluntary reserves} = 1.665{,}60$$

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:

$$\text{Cash} = 4.792{,}40 - 36 - 43{,}20 = 4.713{,}20 \text{ m.u.}$$

Step 3. Changes in the balance sheet

ItemLoanCapital increaseChange
Cash4.792,404.713,20−79,20
Total assets27.222,4027.143,20−79,20
Paid-in capital10.00014.800+4.800
Issue premium02.400+2.400
Legal and voluntary reserves3.842,403.943,20+100,80
Owners equity13.842,4021.143,20+7.300,80
New bank loan (current and non-current)7.2000−7.200
Interest payable1800−180
Total liabilities and equity27.222,4027.143,20−79,20

Step 4. Comparison and leverage effect

RatioLoanCapital increase
ROA12,97%$3.530 / 27.143{,}20 = 13{,}01\%$
ROE19,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].

Key results
  • 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.
Problem · Topic 3 · 4 points · 55 min

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:

  1. 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.
  2. 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.
  3. 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).
  4. 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:

  1. The rent is paid every month by bank (12 × 200).
  2. 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].
  3. 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

$$D_{\text{helicopter}} = \frac{24.000 - 0{,}10 \times 24.000}{12} = \frac{21.600}{12} = 1.800 \text{ m.u./year}$$
$$\frac{4.500}{1.800} = 2{,}5 \text{ years before } 01/01/2022 \;\Rightarrow\; \text{bought on 1 July 2019 (01/07/2019)}$$

Check of the van: one year (2021) at $1.800 / 6 = 300$ gives the 300 of the opening balance (checked).

Step 2. Parts consumed

$$\text{Consumption} = 1.000 + 3.000 + 3.000 - 1.400 = 5.600 \text{ m.u.}$$

Step 3. Insurance (accrual)

$$\text{Expense 2022} = 1.200 \times \frac{3}{12} = 300, \qquad \text{Prepaid at } 31/12/2022 = 1.200 - 300 = 900 \text{ m.u.}$$

Step 4. Interest

$$I_{\text{loan}} = 0{,}06 \times 5.500 = 330 \text{ m.u.}$$
$$I_{\text{credit}} = 2.000 \times 0{,}09 \times \frac{8}{12} + 1.000 \times 0{,}09 \times \frac{4}{12} = 120 + 30 = 150 \text{ m.u.}$$

Check of the loan: $7.500 - 2 \times 1.000 = 5.500$ at 01/01/2022 (checked).

Step 5. Income Statement 2022

LineComputationm.u.
Revenue from flights and maintenanceCustomers account34.000
− Spare parts consumedStep 25.600
− Fuel4.800
− Salaries9.600
− Social Security3.000
− Hangar rent$12 \times 200$2.400
− Insurance (October–December)Step 3300
− Bad debt lossCustomers account400
− 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
Key results
  • 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

$$\text{Customers}_{31/12} = 3.000 + 34.000 - 31.000 - 400 = 5.600 \text{ m.u.}$$
Supplier paymentDatem.u.
Balance of 2021January1.200
50% of the March purchase01/03/20221.500
50% of the March purchase, at 60 days30/04/20221.500
50% of the September purchase, at 30 days01/10/20221.500
Total paid5.700
$$\text{Suppliers}_{31/12} = 1.200 + 6.000 - 5.700 = 1.500 \text{ m.u. (due 01/03/2023)}$$

Step 2. Credit-line interest paid

$$31/07: \; 2.000 \times 0{,}09 \times \frac{3}{12} = 45; \qquad 31/10: \; 2.000 \times 0{,}09 \times \frac{1}{12} + 3.000 \times 0{,}09 \times \frac{2}{12} = 15 + 45 = 60$$
$$\text{Paid} = 45 + 60 = 105, \qquad \text{Payable (November–December)} = 3.000 \times 0{,}09 \times \frac{2}{12} = 45 \text{ m.u.} \quad (105 + 45 = 150 \;\checkmark)$$

Step 3. Bank account 2022

Inflowsm.u.Outflowsm.u.
Collections from customers31.000Suppliers5.700
Credit line drawn ($2.000 + 1.000$)3.000Fuel4.800
Salaries9.600
Social Security ($3.000 - 250$)2.750
Hangar rent2.400
Insurance premium1.200
Credit-line interest105
Loan interest330
Loan principal1.000
Unpaid taxes 2021800
Total34.000Total28.685
$$\text{Bank}_{31/12/2022} = 2.000 + 34.000 - 28.685 = 7.315 \text{ m.u.}$$

Step 4. Distribution

$$\text{Dividend} = 0{,}30 \times 3.724 = 1.117{,}20 \text{ (payable 15/03/2023)}, \qquad \text{Reserves} = 1.500 + 3.724 - 1.117{,}20 = 4.106{,}80$$

Step 5. Balance sheet at 31/12/2022

Assetsm.u.Liabilities and owners equitym.u.
Helicopter ($24.000 - 6.300$)17.700Paid-in capital18.000
Van ($1.800 - 600$)1.200Reserves4.106,80
Non-current assets18.900Owners equity22.106,80
Spare parts1.400Bank loan due 2024–20273.500
Customers5.600Non-current liabilities3.500
Prepaid insurance900Bank loan, installment 31/12/20231.000
Bank7.315Credit line drawn3.000
Interest payable (credit line)45
Suppliers1.500
Social Security payable250
Taxes to pay1.596
Dividends payable1.117,20
Current assets15.215Current liabilities8.508,20
Total assets34.115Total liabilities and equity34.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].

Key results
  • 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

$$\text{ROA} = \frac{5.800}{34.115} = 17{,}00\%, \qquad \text{ROE} = \frac{3.724}{22.106{,}80} = 16{,}85\%$$
ItemPaid 15/03/2023Paid at 24:00Change
Bank7.3156.197,80−1.117,20
Dividends payable1.117,200−1.117,20
Owners equity22.106,8022.106,800
Total assets = total liabilities and equity34.11532.997,80−1.117,20
Key results
  • 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

$$\text{Profit before taxes} = 5.320 - 900 = 4.420, \qquad \text{Tax} = 0{,}30 \times 4.420 = 1.326, \qquad \text{Net profit} = 4.420 - 1.326 = 3.094$$
$$\text{Dividend} = 0{,}30 \times 3.094 = 928{,}20, \qquad \text{Reserves} = 1.500 + 3.094 - 928{,}20 = 3.665{,}80$$

Step 2. Effect on the balance sheet

ItemCorrectWith the errorChange
Prepaid insurance9000−900
Total assets34.11533.215−900
Reserves4.106,803.665,80−441
Taxes to pay1.5961.326−270
Dividends payable1.117,20928,20−189
Total liabilities and equity34.11533.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.

Key results
  • 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.