Memphis Metro just made a $75,000 purchase from a supplier, subject to the extension of suitable trade credit terms. Because of Memphis Metro’s strong balance sheet and stellar credit rating, the firm’s most recently issued line of credit is priced at 3.65 percent. Calculate the present value of this cash outflow assuming trade credit terms of 30 days; 45 days 60 days Please use Excel to explain, and show the Excel formula.

Memphis Metro just made a $75,000 purchase from a supplier, subject to the extension of suitable trade credit terms. Because of Memphis Metro’s strong balance sheet and stellar credit rating, the firm’s most recently issued line of credit is priced at 3.65 percent. Calculate the present value of this cash outflow assuming trade credit terms of 30 days; 45 days 60 days Please use Excel to explain, and show the Excel formula.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter2: The Domestic And International Financial Marketplace

Section: Chapter Questions

Problem 7P

See similar textbooks

Similar questions

The Raattama Corporation had sales of $3.5 million last year, and it earned a 5% return (after taxes) on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of purchase are net 30 days, its accounts payable represents 60 days’ purchases. The company’s treasurer is seeking to increase bank borrowing in order to become current in meeting its trade obligations (that is, to have 30 days’ payables outstanding). The company’s balance sheet is as follows (in thousands of dollars): How much bank financing is needed to eliminate the past-due accounts payable? Assume that the bank will lend the firm the amount calculated in part a. The terms of the loan offered are 8%, simple interest, and the bank uses a 360-day year for the interest calculation. What is the interest charge for 1 month? (Assume there are 30 days in a month.) Now ignore part b and assume that the bank will lend the firm the amount calculated in part a. The terms of the loan are 7.5%, add-on interest, to be repaid in 12 monthly installments. What is the total loan amount? What are the monthly installments? What is the APR of the loan? What is the effective rate of the loan? Would you, as a bank loan officer, make this loan? Why or why not?
Memphis Metro just made a $75,000 purchase from a supplier, subject to the extension of suitable trade credit terms. Using a discount rate of 7%, calculate the present value of this cash outflow assuming trade credit terms of a) 30 days b) 45 days c) 60 days d) 90 days
Paradise Retailers, Inc. (PRI) determined that $1,500,000 is needed for cash transactions made during the next year. Each time PRI deposits money in its checking account, a charge of $12.95 is assessed to cover clerical costs. If PRI can hold marketable securities that yield 4.5%, and then convert these securities to cash at a cost of only the $12.95 deposit charge, what is the optimal cash amount C* to transfer from marketable securities to the checking account according to the Baumol Model?
Buccaneer, Inc., has determined that it needs $10 million in cash per week. If Buccaneer needs additional cash, it can sell marketable securities, incurring a fee of $100 for each transaction. If Buccaneer leaves funds in its marketable securities, it expects to earn approximately 0.2% per week on their investment. 1. How much is the weekly opportunity cost of cash? (Use a number, must be in decimal form. eg. 6.3%/100, encode 0.063 , no commas, no currency, no space) * 2. How much is the total demand for cash per week? (Use a number, no decimal value, no commas, no currency, no space) *
You have recently been hired to improve the performance of Multiplex Corporation, which has been experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm’s cash conversion cycle. Using the following information and a 365-day year,(b) what is your Net Working Capital • Current inventory = $ 180,000.00 • Annual sales = $ 700,000.00 • Accounts receivable = $ 165,000.00 • Accounts payable = $ 85,000.00 • Total annual purchases = $ 567,000.00 • Purchases credit terms: net 30 days. • Receivables credit terms: net 50 days.
You have recently been hired to improve the performance of Multiplex Corporation, which has been experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm’s cash conversion cycle. Using the following information and a 365-day year,(a) what is your estimate of the firm’s current cash conversion cycle? • Current inventory = $ 180,000.00 • Annual sales = $ 700,000.00 • Accounts receivable = $ 165,000.00 • Accounts payable = $ 85,000.00 • Total annual purchases = $ 567,000.00 • Purchases credit terms: net 30 days. • Receivables credit terms: net 50 days.
Buccaneer, Inc., has determined that it needs $10 million in cash per week. If Buccaneer needs additional cash, it can sell marketable securities, incurring a fee of $100 for each transaction. If Buccaneer leaves funds in its marketable securities, it expects to earn approximately 0.2% per week on their investment. Calculate for the cash infusion of 2 million or 3 million then solve for Transaction Cost and Holding Cost.
You have recently been hired to improve the performance of Multiplex Corporation, which has been experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm’s cash conversion cycle. Using the following information and a 365-day year,(a) what is your estimate of the firm’s current cash conversion cycle? Current inventory = $241,000.00 • Annual sales = $1,200,000.00 • Accounts receivable = $300,000.00 • Accounts payable = $245,000.00 • Total annual purchases = $600,000.00 • Purchases credit terms: net 30 days. • Receivables credit terms: net 50 days.
Dome Metals has credit sales of $162,000 yearly with credit terms of net 30 days, which is also the average collection period. a. Assume the firm offers a 2 percent discount for payment in 15 days and every customer takes advantage of the discount. Also assume the firm uses the cash generated from its reduced receivables to reduce its bank loans which cost 8 percent. What will the net gain or loss be to the firm if this discount is offered? (Use a 360-day year.) Loss of: $_________
Halliday Inc. receives a $2 million payment once a year. Of this amount, $700,000 is needed for cash payments made during the next year. Each time Halliday deposits money in its account, a charge of $2.00 is assessed to cover clerical costs. If Halliday can hold marketable securities that yield 5 percent, and then convert these securities to cash at a cost of only the $2 deposit charge, what is the total cost for one year of holding the minimum cost cash balance according to the Baumol model?
DEF Corporation will be needing P1,000,000 additional cash inflow. It is looking to finance this through either Bank One or Bank Zero for a period of 6 months. Bank One offers a 10% loan but requires a P20,000 bank charge. On the other hand, Bank Zero is willing to offer an 8% loan but requires P100,000 compensating balance. Which bank should DEF approach? In the space below, provide the preferred bank's simple annual cost of loan. (format: 6.67 for 6.6666%)
Suppose that LilyMac Photography has annual sales of $233,000, cost of goods sold of $168,000, average inventories of $4,800, average accounts receivable of $25,600, and an average accounts payable balance of $7,300.Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations. Round your final answer to 2 decimal places.)