Skip to content
knowsia logo
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Knowsia AI
  • Community
  • Blog
  • About
  • My Account
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Knowsia AI
  • Community
  • Blog
  • About
  • My Account
knowsia logo
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Knowsia AI
  • Community
  • Blog
  • About
  • My Account
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Knowsia AI
  • Community
  • Blog
  • About
  • My Account
  • 20 Marks

ITF – APR 2023 – L3 – Q1 – Timber International Export Finance Calculation

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.

  • CIB (GHANA)
  • ASSOCIATESHIP EXAMINATION
  • INTERNATIONAL TRADE FINANCE
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).

  • Tags: Export Shipments, Forward Rates, Interest calculation, Net Profit, Overdraft Account, Payment Schedules, Receipts Schedules
  • Level: Level 3
  • Topic: Interest Calculations
  • Series: APR 2023
  • Uploader: Samuel Duah
Back to all questions
knowsia

Take control of your business data with insight and in-depth understanding by taking this course. 

Our Offerings

  • Professional Tuition
  • Question Bank
  • CPDs and Webinars
  • Corporate Trainings
  • Certificate Courses
  • Zoom Meetings

Contact Info

  • +233203701923
    +233543919232
  • info@knowsia.com

My Account

  • My Account
  • Manage Subscriptions
  • Tutors Dashboard
  • Become An Affiliate
  • Affiliate Dasboard
  • Login/Logout

Get In Touch

Follow us on our social media and get daily updates.

Facebook-f Twitter Linkedin-in Envelope

Forgot Password?

admin

Sign In

Pick a Form

Professional Tutor Application Form
Academic Tutor Application Form
Student Tutor Application Form