(Answered) Using excelnortheast baptist buys 500000 of a particular

Finance

USING Excel

Northeast Baptist buys $500,000 of a particular item (at gross prices) from its major supplier, Cardinal Health, which offers NE Baptist terms of 3/20, net 60. Currently, the hospital is paying the supplier the full amount due on Day 60, but it is considering taking the discount, paying on Day 20 and replacing the trade credit with a bank loan that has a 12 percent rate.

a. What is the amount of free trade credit that Baptist obtains from Cardinal Health? (Assume 360 days per year throughout this problem.)

b. What is the amount of costly trade credit?

c. What is the approximate annual cost of the costly trade credit?

d. Should Baptist replace its trade credit with the bank loan? Explain your answer.

e. If the bank loan is used, how much of the trade credit should be replaced?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92403398
Price:- $25

Verified Expert

Priced at $50 Now at $25, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Assignment - alternative valuation methodsyou may do this

Assignment - Alternative Valuation Methods You may do this assignment individually or with one other person. In this assignment, you use horizon value calculation methods to estimate the current market value of a private ...

This morning you purchased one share of stock for 26 the

This morning, you purchased one share of stock for $26. The stock pays $.32 per share each quarter as a dividend. What must the stock price be 1 year from now if you want to earn a total return of 16 percent for the year ...

Suppose community bank offers to lend you 10000 for one

Suppose Community Bank offers to lend you $10,000 for one year at a nominal annual rate of 8.00%, but you must make interest payments at the end of each quarter and then pay off the $10,000 principal amount at the end of ...

Discuss the core business objectives and the primary focus

Discuss the core business objectives and the primary focus of the financial business model.

Timco is considering project a project a will cost 23000 it

Timco is considering project A. Project A will cost 23000. It should provide after tax cash inflows of 5000 per year for the next 6 years. The cost of funds is 10%. Find the MIRR. Should Timco buy it?

Exerciseto hedge a short share position one can short the

Exercise To hedge a short share position, one can short the put option on the share. • What is the investor's intention in selling the put option? • What does the strike indicate when the trader has zero risk tolerance? ...

Question - the hawaiian corporation expects this years net

Question - The Hawaiian Corporation expects this year's net income to be $12 million. The firm's target debt/assets ratio is 30 percent. This year, Hawaiian has $20 million profitable investment opportunities. According ...

Your company has an opportunity to invest in a project that

Your company has an opportunity to invest in a project that is expected to result in after-tax cash flows of $16,000 the first year, $18,000 the second year, $21,000 the third year, $24,000 the fourth year, $28,000 the f ...

Timco can generate eps of 4 per year forever by maintaining

Timco can generate EPS of $4 per year forever by maintaining current operations. Tim has an investment opportunity for the firm that he expects will generate a 12% return. He would have to reinvest 25% of his earnings. S ...

Oceangate sells external hard drives for 300 each its total

OceanGate sells external hard drives for $300 each. Its total fixed costs are $30 million, and its variable costs per unit are $240. The corporate tax rate is 30%. If the economy is strong, the firm will sell 2 million d ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert