Prepare the Retained Income Note for the year ended 28 February 2023 - NSC Accounting - Question 2 - 2023 - Paper 1
Question 2
Prepare the Retained Income Note for the year ended 28 February 2023.
Calculate the following figures for the 2023 Cash Flow Statement:
1. Change in loan
2. Procee... show full transcript
Worked Solution & Example Answer:Prepare the Retained Income Note for the year ended 28 February 2023 - NSC Accounting - Question 2 - 2023 - Paper 1
Step 1
Prepare the Retained Income Note
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To prepare the Retained Income Note for the year ended 28 February 2023, we must start with the balance at the beginning of the year:
Balance at beginning of year: R237,400
Net profit after tax: R1,526,000
Less: Shares repurchased (180,000 shares at R1.20): R216,000
Ordinary share dividends: R(191,800) which includes interim dividends of R342,400 and final dividends
Thus, the balance at the end of the year can be calculated:
Calculate the retained income:
Retained income = Starting balance + Net profit - Shares repurchased - Ordinary share dividends
The final balance will be R629,600.
Step 2
Calculate the following figures for the 2023 Cash Flow Statement:
Change in loan
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The change in loan is determined by:
Current loan: R7,200,000
Previous loan: R6,348,000
Change in loan: R7,200,000 - R6,348,000 = R852,000
Step 3
Calculate the following figures for the 2023 Cash Flow Statement:
Proceeds from shares issued
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The proceeds from shares issued can be calculated as follows:
Shares repurchased: 1,370,000 shares.
This does not qualify for shares issued, therefore we focus solely on the initial share capital:
The amount generated from shares = R3,420,000.
Step 4
Complete the Cash Effects of Operating Activities section of the Cash Flow Statement.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
This section includes:
Cash generated from operations: R2,340,000
Interest paid: R648,000
Tax paid: R723,600
Dividends paid: R(817,400)
Summarizing, total cash flow from operations would then aggregate these figures.
Step 5
Calculate the following financial indicators on 28 February 2023:
Current ratio
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The current ratio is computed using:
Current assets: R1,479,600
Current liabilities: R822,000
Current ratio = Current assets / Current liabilities = R1,479,600 / R822,000 = 1.8.
Step 6
Calculate the following financial indicators on 28 February 2023:
Net asset value
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Net asset value is calculated as:
Total assets: R13,959,500
Total liabilities: R629,600
Therefore:
Net asset value = (Total assets - Total liabilities) / Total shares = (R13,959,500 - R629,600) / 1,370,000 = 1,064.9 cents.
Step 7
Calculate the following financial indicators on 28 February 2023:
% return on total capital employed (ROTEC)
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
ROTEC is computed via:
Net profit after tax: R1,526,000
Average capital employed: R20,343,500
Formula:
ROTEC = (Net profit / Average capital employed) * 100 = (R1,526,000 / R20,343,500) * 100 = 7.5%.