- 20 Marks
Question
==========
Question Title: [ITF – APR 2023 – L3 – Q1 – Timber International Export Finance Calculation] Level: LEVEL III Professional Bodies: CIBG Programs: ASSOCIATESHIP EXAMINATION Subjects: INTERNATIONAL TRADE FINANCE Topics: International Trade Finance, Export Finance, Letters of Credit, Forward Exchange Contracts, Overdraft Facilities, Interest Calculations Series: APRIL 2023 Total Marks: 20 Question Tags: Export Shipments, Payment Schedules, Receipts Schedules, Overdraft Account, Forward Rates, Interest Calculation, Net Profit Question Short Summary: Calculate net profit for Timber International’s timber exports to Libya, Tunisia, and Saudi Arabia, including schedules for supplier payments and buyer receipts, and the overdraft account with interest. ——————————————————————— Question: Question One
Timber International are global exporters of first class sawn timber. Though they have their large buyers in Europe, they have taken advantage of the AICFTA for further expansion. As your customers, they have come to discuss the finance of contracts to supply “Odum” kiln dried sawn timber to their new buyers in North Africa and the Gulf – Libya, Tunisia and Saudi Arabia. Timber International had agreed with these buyers under confirmed irrevocable letters of credit under the following details:
Shipments: 10 May 40 cubic meters to Libya at Libyan Dinar – LYD 5, 386.50 per cubic meter 14 June 50 cubic meters to Tunisia at Tunisia Dinar – TND 3, 517.50 per cubic meter 8 July 45 cubic meters to Saudi Arabia at Saudi Riyal – SAR 4, 168.50 per cubic meter
Payments: Ten days after shipment date, Timber International will issue a one-month bill of exchange on their new buyers. Proceeds of these drafts will be wired by SWIFT payment platform to your bank on due dates. To minimize risks, the company has completed a one-month forward exchange contracts with your bank on the dates drafts were drawn by Timber International on these buyers.
Timber International decided to buy the processed Odum timber from local suppliers at an agreed price of Euro 832 per cubic meter FOB to any of the three ports of destination Benghazi, Tunis and Jeddah Islamic ports respectively.
It is further agreed that payment to the local suppliers will be made exactly seven days after shipment date and within which period your bank would have already received the necessary export documents from the ultimate suppliers. To meet timely and uninterrupted payment to suppliers, Timber International applied for an overdraft facility in local currency to finance this business. In each case, payment under the credit was made to the local suppliers in euros on the agreed dates as appropriate, and debited to the cedi overdraft account accordingly.
Please note the following additional information:
- Ghana Reference Rate is 33.25% p.a.
- Your bank takes a spread of 2% p.a. on facilities.
- Day basis for overdraft interest calculation is 360 days for a year with each month also taken as 30 days. Kindly round-up all interest calculations amount and post as a single figure after all postings have been made.
Required On the basis of the following additional information, calculate the net profit in Ghana Cedis for your customer, showing: a. Schedule of Payments to Suppliers (3 marks) b. Schedule of Receipts from Buyers (6 marks) c. Overdraft account of your customers showing all postings (11 marks)
Rates for the transactions are detailed below:
| Spot | One month | |||
|---|---|---|---|---|
| 17 May | EUR/GHS | 13.5200 | 13.5250 | 0.0010-0.0015 cedis discount |
| 21 June | EUR/GHS | 13.5305 | 13.5350 | 0.0025-0.0030 cedis discount |
| 15 July | EUR/GHS | 13.5525 | 13.5575 | 0.0040-0.0045 cedis discount |
| Spot | One month | |||
| 20 May | LYD/GHS | 2.6000 | 2.6100 | 0.0150-0.0200 cedis discount |
| 24 June | TND/GHS | 4.0500 | 4.1500 | 0.0050-0.0100 cedis discount |
| 18 July | SAR/GHS | 3.4000 | 3.4105 | 0.0030-0.0450 cedis discount |
| [Total Marks 20] |
Answer
| a. Schedule of Payments to Suppliers |
The payments to suppliers are made in Euros, converted to Ghana Cedis at the bank’s selling rate (ask rate) on the payment dates, and debited to the overdraft account.
| Date | Destination | Quantity (cubic meters) | EUR Amount (Quantity x 832) | EUR/GHS Ask Rate | GHS Amount Debited |
|---|---|---|---|---|---|
| 17 May | Libya | 40 | 33,280 | 13.5250 | 450,112.00 |
| 21 June | Tunisia | 50 | 41,600 | 13.5350 | 563,056.00 |
| 15 July | Saudi Arabia | 45 | 37,440 | 13.5575 | 507,592.80 |
Total Payments in GHS: 1,520,760.80
b. Schedule of Receipts from Buyers
The receipts are in foreign currencies, converted to Ghana Cedis at the forward bid rate (spot bid minus higher discount) on the draft dates, credited on the due dates (one month after draft).
| Draft Date | Due Date | Destination | Quantity (cubic meters) | Foreign Amount | Forward Bid Rate | GHS Amount Credited |
|---|---|---|---|---|---|---|
| 20 May | 20 June | Libya | 40 | LYD 215,460.00 | 2.5800 | 555,886.80 |
| 24 June | 24 July | Tunisia | 50 | TND 175,875.00 | 4.0400 | 710,535.00 |
| 18 July | 18 August | Saudi Arabia | 45 | SAR 187,582.50 | 3.3550 | 629,339.29 |
Total Receipts in GHS: 1,895,761.09
c. Overdraft Account of Customers Showing All Postings
The overdraft interest rate is 33.25% + 2% = 35.25% p.a. Interest is calculated on negative balances using the 30/360 day convention and rounded up to the nearest cedi after all postings. The account starts at zero.
| Date | Description | Debit (GHS) | Credit (GHS) | Balance (GHS) | Days Held | Interest Calculation (on negative balances) |
|---|---|---|---|---|---|---|
| 17 May | Payment to supplier (Libya) | 450,112.00 | -450,112.00 | 33 | 450,112.00 x 35.25% x 33/360 = 14,542.58 | |
| 20 June | Receipt from buyer (Libya) | 555,886.80 | 105,774.80 | 1 | Positive balance – no interest | |
| 21 June | Payment to supplier (Tunisia) | 563,056.00 | -457,281.20 | 24 | 457,281.20 x 35.25% x 24/360 = 10,746.11 | |
| 15 July | Payment to supplier (Saudi Arabia) | 507,592.80 | -964,874.00 | 9 | 964,874.00 x 35.25% x 9/360 = 8,502.95 | |
| 24 July | Receipt from buyer (Tunisia) | 710,535.00 | -254,339.00 | 24 | 254,339.00 x 35.25% x 24/360 = 5,976.97 | |
| 18 August | Receipt from buyer (Saudi Arabia) | 629,339.29 | 375,000.29 | Positive balance – no interest | ||
| Final | Interest posting (total rounded up) | 39,769.00 | 335,231.29 |
Total interest = 14,542.58 + 10,746.11 + 8,502.95 + 5,976.97 = 39,768.61, rounded up to 39,769.00.
Net Profit in Ghana Cedis: 335,231.29 (final balance after interest).
- Topic: Interest Calculations
- Series: APR 2023
- Uploader: Samuel Duah