978-0133879872 Chapter 16 Excel

subject Type Homework Help
subject Pages 11
subject Words 3690
subject Authors Arthur I. Stonehill, David K. Eiteman, Michael H. Moffett

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Assumptions Values
Face amount of sale € 700,000
Maturity, days 90
Trade acceptance fee, per annum 1.000%
Discount rate on sale of acceptance, per annum 4.000%
All-in-Cost of Trade Acceptance
Face amount of the receivable € 700,000
Less trade acceptance fee (1,750)
(amount financed x acceptance fee x (days/360) )
Less discount on the sale of acceptance (7,000)
(amount financed x discount rate x (days/360))
Net proceeds € 691,250
Annualized percentage all-in-cost (AIC) 5.063%
(acceptance fee + discount) / (amount received) x (360/180)
Problem 16.1 Nikken Microsystems (A)
Assume Nikken Microsystems has sold Internet servers to Telecom España for €700,000. Payment
is due in 3 months and will be made with a trade acceptance from Telecom España Acceptance. The
acceptance fee is 1.0% per annum of the face amount of the note. This acceptance will be sold at a
4% per annum discount. What is the annualized percentage all-in-cost in euros of this method of
trade financing?
page-pf2
Assumptions Values
Face amount of sale € 700,000
Maturity, days 90
Spot exchange rate, $/1.00
Forward exchange rate, 3-months, $/1.02
Trade acceptance fee, per annum 1.000%
Discount rate on sale of acceptance, per annum 4.000%
Spot exchange rate, $/1.00
US dollar proceeds, now 698,250$
3-month forward exchange rate, $/1.02
US dollar net proceeds received in 3-months 712,215$
d. Which alternative should Nikken Microsystems choose?
If Nikken Microsystems' opportunity cost of capital is 8%, it should be indifferent financially
between the two alternatives. However, selling the acceptance at once, alternative 1, improves
Problem 16.2 Nikken Microsystems (B)
Assume that Nikken Microsystems prefers to receive U.S. dollars rather than euros for the trade
transaction described in problem 1. It is considering two alternatives:1) It can sell the acceptance for
euros at once and convert the euros immediately to U.S. dollars at the spot rate of exchange of $1.00/€; or
2) It can hold the euro acceptance until maturity but at the start sell the expected euro proceeds forward
for dollars at the 3-month forward rate of $1.02/€.
d. Which alternative should Nikken Microsystems choose?
a. What are the U.S. dollar net proceeds received at once from the discounted trade acceptance in
alternative 1?
b. What are the U.S. dollar net proceeds received in 3 months in alternative 2?
c. What is the breakeven investment rate that would equalize the net U.S. dollar proceeds from both
alternatives?
page-pf4
Assumptions Values
Value of shipment 3,000,000$
Credit terms, days 180
Bankers' acceptance fee 1.750%
Motoguzzie's WACC, per annum 10.000%
All-in-cost of Bankers' Acceptance
Face amount of bankers' acceptance 3,000,000.00$
Less acceptance fee for 6-month maturity (26,250.00)
( face amount x acceptance fee x (term/360))
Amount received by Indian 2,973,750.00$
Opportunity cost of capital @ Motoguzzie's WACC 148,687.50$
(amount received x WACC x 180/360)
Annualized percentage all-in-cost (AIC) 11.765%
(acceptance fee +opportunity cost) / (amount received) x (360/180)
Problem 16.3 Motoguzzie (A)
Motoguzzie exports large-engine motorcycles (greater than 700cc) to Australia and invoices its
customers in U.S. dollars. Sydney Wholesale Imports has purchased $3,000,000 of merchandise
from Motoguzzie, with payment due in 6 months. The payment will be made with a bankers’
acceptance issued by Charter Bank of Sydney at a fee of 1.75% per annum. Motoguzzie has a
weighted average cost of capital of 10%. If Motoguzzie holds this acceptance to maturity, what is its
annualized percentage all-in cost?
page-pf5
Assumptions Values
Value of shipment 3,000,000$
Credit terms, days 180
Bankers' acceptance fee 1.750%
Motoguzzie's WACC, per annum 10.000%
Discount rate on sale of acceptance, per annum 6.000%
All-in-Cost of Bankers' Acceptance
Face amount of bankers' acceptance 3,000,000.00$
Less acceptance fee for 6-month maturity (26,250.00)
Less discount on sale of acceptance (90,000.00)
Amount received by Motoguzzie 2,883,750.00$
Annualized percentage all-in-cost (AIC) 8.062%
(acceptance fee + discount) / (amount received) x (360/180)
Problem 16.4 Motoguzzie (B)
Assuming the facts in problem 3, Bank of America is now willing to buy Motoguzzie’s bankers’
acceptance for a discount of 6% per annum. What would be Motoguzzie’s annualized percentage all-
in-cost of financing its $3,000,000 Australian receivable?
page-pf6
Assumptions Values
Face amount of sale (first payment of 5) 200,000$
Down payment, 20% of payment 40,000$
Period for financing, days 180
Trade acceptance fee 2.000%
Discount rate on sale of acceptance, per annum 3.000%
All-in-Cost of Trade Acceptance
Face amount of sale 200,000.00$
Less cash down-payment (40,000.00)
Amount for financing 160,000.00$
Less trade acceptance fee
(amount financed x acceptance fee x (days/360) ) (1,600.00)
Less discount for the period
(amount financed x discount rate x (days/360)) (2,400.00)
Proceeds to Nakatomi Toyota 156,000.00$
a. What is the annualized percentage all-in-cost to Nakatomi Toyota?
b. What are Nakatomi’s net cash proceeds, including the cash down payment?
Problem 16.5 Nakatomi Toyota
NakatomiToyota buys its cars from Toyota Motors-USA, and sells them to U.S. customers. One of
its customers is EcoHire, a car rental firm which buys cars from Nakatomi Toyota at a wholesale
price. Final payment is due to Nakatomi Toyota in 6 months. EcoHire has bought $200,000 worth of
cars from Nakatomi, with a cash down payment of $40,000 and the balance due in 6 months without
any interest charged as a sales incentive. Nakatomi Toyota will have the EcoHire receivable
accepted by Alliance Acceptance for a 2% fee, and then sell it at a 3% per annum discount to Wells
Fargo Bank.
page-pf7
Assumptions Values
Face amount of the note due March 1, 2011 issued by Kaduna 200,000$
3-year LIBOR rate, per annum 6.000%
Basis point spread, per annum 2.000%
Total discount rate, per annum 8.000%
Bank of Zurich commitment fee, per annum 2.000%
Lagos City Bank endorsement fee, per annum 1.000%
Less discount on note at LIBOR plus spread (16,000)
Net proceeds 178,000$
Annualized all-in-cost of factoring 11.000%
b. What might motivate Umaru Oil to use this relatively expensive alternative for financing?
The promissory notes issued by Umaru Oil will be endorsed by their bank, Lagos City Bank, for
a 1% fee and delivered to Gunslinger Drilling. At this point Gunslinger Drilling will endorse the
notes without recourse and discount them with the forfaiter, Bank of Zurich, receiving the full
$200,000 principal amount. Bank of Zurich will sell the notes by re-discounting them to investors in
the international money market without recourse. At maturity the investors holding the notes will
present them for collection at Lagos City Bank. If Lagos City Bank defaults on payment, the
investors will collect on the notes from Bank of Zurich.
a. What is the annualized percentage all-in-cost to Umaru Oil of financing the first $200,000 note
due March 1, 2011?
Problem 16.6 Forfaiting at Umaru Oil (Nigeria)
Umaru Oil of Nigeria has purchased $1,000,000 of oil drilling equipment from Gunslinger Drilling
of Houston, Texas. Umaru Oil must pay for this purchase over the next 5 years at a rate of $200,000
per year due on March 1st of each year.
Bank of Zurich, a Swiss forfaiter, has agreed to buy the 5 notes of $200,000 each at a discount.
The discount rate would be approximately 8% per annum based on the expected 3-year LIBOR rate
plus 200 basis points, paid by Umaru Oil. Bank of Zurich also would charge Umaru Oil an
additional commitment fee of 2% per annum from the date of its commitment to finance until receipt
of the actual discounted notes issued in accordance with the financing contract. The $200,000
promissory notes will come due on March 1st in successive years.
page-pf8
Umaru Oil itself -- the importer, rather than by Unicorn Drilling, the exporter.
page-pf9
Problem 16.7 Sunny Coast Enterprises (A)
a. What are the annualized percentage all-in-costs of each alternative?
b. What are the advantages and disadvantages of each alternative?
c. Which alternative would you recommend?
Assumptions Values
Face amount of receivable 100,000$
Maturity, days 180
Bank prime rate 5.000%
Spread over prime rate on credit line 1.500%
Bank interest (prime + spread), per annum 6.500%
Compensating balance requirement for bank credit line 20.000%
Export credit insurance fee 1.000%
Alternative 1: Bank Credit Line
Face amount of receivable 100,000$
Less bank interest expense on receivable (3,250)
Alternative 2: Bank Credit Line + Export Credit Insurance
Face amount of receivable 100,000$
Less credit insurance fee (1,000)
Note: The reason the compensating balance is deducted from net proceeds is that
Sunny Coast Enterprises does not get that cash and does not earn interest on it.
Sunny Coast Enterprises has sold a combination of films and DVDs to Hong Kong Media
Incorporated for US$100,000, with payment due in 6 months. Sunny Coast Enterprises has the
following alternatives for financing this receivable: 1) Use its bank credit line. Interest would be at
the prime rate of 5% plus 150 basis points per annum. Sunny Coast Enterprises would need to
maintain a compensating balance of 20% of the loan’s face amount. No interest will be paid on the
compensating balance by the bank; or 2) Use its bank credit line but purchase export credit
insurance for a 1% fee. Because of the reduced risk, the bank interest rate would be reduced to 5%
per annum without any points.
page-pfa
Assumptions Values
Face amount of receivable 100,000$
Maturity, days 180
Factor discount rate, percent per annum 16.000%
Charge for non-recourse clause: "factor fee" 2.000%
a. What is the annualized all-in-cost of factoring?
Face amount of receivable 100,000$
Less cost of factoring, discount rate (8,000)
Less non-recourse clause (2,000)
Net proceeds from factoring 90,000$
Annualized all-in-cost of factoring 22.222%
Although the costs of factoring are clearly higher than using bank credit lines, factoring
removes the receivable from the balance sheet, both as an asset and the associated debt
to finance it using the bank credit line. Factoring also provides the cash at the start of
the time period compared to waiting 6 months later under the bank credit line.
b. What are the advantages and disadvantages of the factoring alternative compared to the
alternatives in Sunny Coast Enterprises (A)?
Problem 16.8 Sunny Coast Enterprises (B)
Sunny Coast Enterprises has been approached by a factor that offers to purchase the Hong Kong
Media Imports receivable at a 16% per annum discount plus a 2% charge for a non-recourse clause.
a. What is the annualized percentage all-in-cost of this factoring alternative?
page-pfb
Assumptions Values
Principal of note 100,000$
Maturity of note, days 180
Acceptance fee to be paid by Whatchamacallit 500$
Discount on sale of note, per annum 2.000%
Letter of credit fee paid by Phang 500$
Reduction in Kim's available credit-line 100,000$
All-in-cost to Whatchamacallit:
Face amount of note 100,000$
Less acceptance fee (500)
Less interest (1,000)
Net proceeds 98,500$
Annualized all-in-cost of factoring 3.046%
( total interest and fee costs / net proceeds ) x (360/maturity)
Problem 16.9 Whatchamacallit Sports (A)
Phang’s bank issues a letter of credit on behalf of Phang and agrees to accept Whatchamacallit’s
draft for $100,000 due in 6 months. The acceptance fee would cost Whatchamacallit $500, plus
reduce Phang’s available credit line by $100,000. The bankers’ acceptance note of $100,000 would
be sold at a 2% per annum discount in the money market. What is the annualized percentage all-in-
cost to Whatchamacallit of this bankers’ acceptance financing?
Whatchamacallit Sports (Whatchamacallit) is considering bidding to sell $100,000 of ski equipment
to Phang Family Enterprises of Seoul, Korea. Payment would be due in 6 months. Since
Whatchamacallit cannot find good credit information on Phang, Whatchamacallit wants to protect its
credit risk. It is considering the following financing solution.
page-pfc
Problem 16.10 Whatchamacallit Sports (B)
a. What is Whatchamacallit’s annualized percentage all-in-cost of financing?
b. What are Phang’s costs?
Assumptions Values
Principal of note 100,000$
Maturity of note, days 180
FCIA export credit insurance fee 1.500%
Interest on credit line, per annum 6.000%
a. All-in-cost to Whatchamacallit: Values
Face amount 100,000$
Less credit insurance fee (1,500)
Less interest on credit line (3,000)
Net proceeds 95,500$
Annualized all-in-cost of factoring 9.424%
( total interest and fee costs / net proceeds ) x (360/term of note)
b. What is the cost ot Phang?
c. What are the advanatges and disadvantages of this alternative?
Whatchamacallit could also buy export credit insurance from FCIA for a 1.5% premium. It finances the
$100,000 receivable from Phang from its credit line at 6% per annum interest. No compensating bank
balance would be required.
The cost of using its credit line would cost Whatchamacallit 9.42% compared to only 3.05% with the
bankers' acceptance. However, Phang would avoid the $500 cost of getting a letter of credit and reducing
c. What are the advantages and disadvantages of this alternative compared to the bankers’ acceptance
financing in Whatchamacallit (A)? Which alternative would you recommend?
page-pfd
Problem 16.11 Inca Breweries of Peru
Assumptions Values
Invoice 720,000$
Inca Breweries WACC (per annum) 20.00%
Invoice payable in full (total days) 90
Banker's acceptance discount rate (per annum) 8.00%
Commission for sale of bankers acceptance 1.20%
Alternative 1 Values
Present value of invoice (PV = Face amount x Discount rate) 685,714.29$
Alternative 2 Values
Inca Breweries can sell the banker's acceptance in today's money market at an 8% per annum discount:
Face amount of invoice 720,000.00$
Less commission (Commission rate x Face amount) (8,640.00)
Difference between alternatives (11,245.71)$
Analysis
If Inca Breweries holds the draft for 90 days after the bank accepts it, Inca
Breweries will receive the face amount of $720,000. The present value of
The current discount rate on three-month banker's acceptances is 8% per annum, and Inca Breweries
estimates its weighted average cost of capital to be 20% per annum. The commission for selling a
banker's acceptance in the discount market is 1.2% of the face amount.
Inca Breweries of Lima, Peru, has received an order for 10,000 cartons of beer from Alicante Importers
of Alicante, Spain. The beer will be exported to Spain under the terms of a letter of credit issued by a
Madrid bank on behalf of Alicante Importers. The letter of credit specifies that the face value of the
shipment, $720,000, will be paid 90 days later after the Madrid bank accepts a draft drawn by Inca
Breweries in accordance with the terms of the letter of credit.
How much cash will Inca Breweries receive from the sale if it holds the acceptance until maturity? Do
you recommend that Inca Breweries hold the acceptance until maturity or discount it at once in the U.S.
banker's acceptance market?
page-pfe
Problem 16.12 Swishing Shoe Company
b. Does Swishing Shoe Company incur any other risks in this transaction?
Assumptions Values
Face value of the shipment £400,000.00
Southampton Footware WACC (per annum) 18.00%
Letter of credit specification on payment after acceptance (days) 120
Banker's acceptance discount rate, 120-day maturity (per annum) 12.00%
Commission for sale of bankers acceptance 2.00%
Face amount of invoice £400,000.00
Discount rate at WACC for 120 days of a 360 day year 0.9434
Present value of invoice (PV = Face amount x Discount rate) £377,358.49
Alternative 2 Values
Face amount of invoice £400,000.00
Less commission (Commission rate x Face amount) (8,000.00)
Less banker's acceptance discount rate for period (90 days) (16,000.00)
Amount received now £376,000.00
today by discounting the banker's acceptance. The present value of the £400,000 to be received in 120
days, discounted at Swishing's WACC of 18%, is £377,358.49. The difference is £1,358.49. Swishing
would gain, in terms of present value cash, £1,358.49 by waiting 120 days to receive the face amount of
Swishing Shoe Company of Durham, North Carolina, has received an order for 50,000 cartons of athletic
shoes from Southampton Footware, Ltd., of England, payment to be in British pounds sterling. The shoes
will be shipped to Southampton Footware under the terms of a letter of credit issued by a London bank on
behalf of Southampton Footware. The letter of credit specifies that the face value of the shipment,
£400,000, will be paid 120 days after the London bank accepts a draft drawn by Southampton Footware
in accordance with the term of the letter of credit.
The current discount rate in London on 120-day bankers' acceptances is 12% per annum, and
Southampton Footware estimates its weighted average cost of capital to be 18% per annum. The
commission for selling a banker's acceptance in the discount market is 2.0% of the face amount.
accepted it, Swishing Footware will received the face amount of £400,000. The
present value of £400,000 received 120 days hence, discounted at Swishing's
WACC of 18% per annum (6% for 120 days) is £377,358.49.
market at a 12% per annum discount:
a. Would Swishing Shoe Company gain by holding the acceptance to maturity, as compared to
discounting the bankers' acceptance at once?
page-pff
Point 1. Swishing's gain should be calculated in present value terms. Swishing will receive £376,000
today by discounting the banker's acceptance. The present value of the £400,000 to be received in 120
days, discounted at Swishing's WACC of 18%, is £377,358.49. The difference is £1,358.49. Swishing
would gain, in terms of present value cash, £1,358.49 by waiting 120 days to receive the face amount of
Point 2. In this transaction Swishing has assumed the foreign exchange transaction risk; that is, the risk
that the pounds sterling to be received from the export will be worth fewer dollars when received. In part
this risk is a function of the time that Swisher must wait to exchange the pounds sterling for dollars. If
Swishing discounts the banker's acceptance at the time of sale, it receives dollars at once at the exchange
rate then in effect. If Swishing waits 120 days to receive the pounds sterling, Swisher assumes the added
risk that the exchange rate will deteriorate between the time of sale and the time of collection. (Of course,
Swishing might gain if the pound would buy more, rather than less, dollars in 120 days.)
page-pf10
Problem 16.13 Going Abroad
If Swishing decides to open a plant and manufacture in Ireland, the following factors must be considered:
1. Corporate income tax rates in Ireland and the United States.
page-pf11
Price / case Rate Calculation
Cases per container 968
Export to Brazil Costs & Pricing
FOB price per case (US$) 34.00$
Freight, loading, & documentation 4.32 4180 $4180 per container
CFR price 38.32$
Export insurance 0.86 2.250% % of CFR
CIF/case to distributor (US$) 39.18$
Exchange rate (R$/US$) 2.50 2.50
CIF price/case to distributor (R$) R$97.95
Brazilian Importation Costs
Import duties (ID) 1.96 2.000% % of CIF
Merchant marine renovation fee (MMRF) 2.70 25.00% % of freight
Storage cost 1.47 1.500% % of CIF * months
Cost of financing diaper inventory 6.86 7.000% % of CIF * months
DIAPER PRICES Bags of 8 Diapers per Price to Consumer
Large 24 192 R$1.28
Extra Large 22 176 R$1.39
Mini-Case: Crosswell International's Precious Ultra-Thin Diapers

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.