The company decided to borrow a one-time loan of $100,000 in Jan 2023 to launch a marketing campaign to expand the business. The $100,000 is taken from the bank and use in the marketing campaign directly and as such no additional $ is plough back into the cash flow. Given the bank charges 4% interest rate and the company wishes to borrow for 5-year term, add another row for Annual Payment to the bank (SAFELOCK LTD chooses to pay monthly payment, calculate the total 12 monthly payments using the appropriate built-in functions and formula.) Also calculate the Total Bank term payment for the loan assuming the monthly payment scheme, Total Interest for the loan tak

The company decided to borrow a one-time loan of $100,000 in Jan 2023 to launch a marketing campaign to expand the business. The $100,000 is taken from the bank and use in the marketing campaign directly and as such no additional $ is plough back into the cash flow. Given the bank charges 4% interest rate and the company wishes to borrow for 5-year term, add another row for Annual Payment to the bank (SAFELOCK LTD chooses to pay monthly payment, calculate the total 12 monthly payments using the appropriate built-in functions and formula.) Also calculate the Total Bank term payment for the loan assuming the monthly payment scheme, Total Interest for the loan tak

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Mama Inc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000. Bank of Tigers charges Mama P15 for every transaction with the bank. The bank grants 5% annual interest. Mama is contemplation if it will still need to have the cash buffer. How much is the annual savings in annual holding cost of cash for Mamaif it will not have a cash buffer?
National Co. needs to borrow P300,000 for the next 6 months. The company has a line of credit with a bank that allows the company to borrow funds with a 10% interest rate subject to a 20% of loan compensating balance. Currently, National Co. has no funds on deposit with the bank and will need the loan to cover the compensating balance as well as their other financing needs. How much will National Co. need to borrow?
NTA Co. needs to borrow P300,000 for the next 6 months. The company has a line of credit with a bank that allows the company to borrow funds with a 10% interest rate subject to a 20% of loan compensating balance. Currently, NTA Co. has no funds on deposit with the bank and will need the loan to cover the compensating balance as well as their other financing needs. How much will NTA Co. need to borrow?
Happy Hollow, LLC plans to extend their line of Wind in the Willow Wind Chimes. In order to increase their inventory they need additional cash. On January 1, 20X1, Grumpy Bank loans $50,000 to Happy Hollow in order to spread some cheer. Happy Hollow must pay 20% interest and make quarterly payments for 5 years. If the loan payment amount is $4,012, create the loan amortization schedule (table) for а. the first year, showing the breakdown of each payment b/w interest expense and principle. b. Record the first three journal entries. С. In terms of cash outflow, is Happy Hollow better off or worse off if it had issued bonds (see question B above). Why?
Bridgette Inc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000. Bank of Wildcats charges Bridgette P15 for every transaction with the bank. The bank grants 5% annual interest. Bridgette is contemplation if it will still need to have the cash buffer. 1.How much is the annual savings in annual holding cost of cash for Bridgette if it will not have a cash buffer?
Pool-N-Patio World needs to borrow $55,000 to increase its inventory for the upcoming summer season. The owner is confident that he will sell most, if not all, of the new inventory during the summer, so he wishes to borrow the money for only four months. His bank has offered him a simple interest amortized loan at 7.75% interest. (Round your answers to the nearest cent.) (a) Find the size of the monthly bank payment.$ (b) Prepare an amortization schedule for all four months of the loan. PaymentNumber PrincipalPortion InterestPortion TotalPayment BalanceDue 0 $ 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $
Pool-N-Patio World needs to borrow $50,000 to increase its inventory for the upcoming summer season. The owner is confident that he will sell most, if not all, of the new inventory during the summer, so he wishes to borrow the money for only four months. His bank has offered him a simple interest amortized loan at 73% interest. (Round your answers to the nearest 4 cent.) (a) Find the size of the monthly bank payment. Interest Portion Total Payment Balance Due (b) Prepare an amortization schedule for all four months of the loan. Principal Portion A A A Payment Number 0 1 2 3 4 A $ A LA +A $ A A A A A $ +A $ +A
Company A is contemplating on borrowing $500,000 to start a business. Credit union 1 has offered to loan the company the money at an interest rate of 10% compounded monthly. Credit union 2 has offered the money with the stipulation that the company repays it by making monthly payments of $100,000 for 8 years. From which credit union should the company borrow the money? MANUAL CALCULATIONS AND CASH FLOW DIAGRAM!
The Patel Company has several financial issues to solve. As the company’s Financial Analyst you have been asked to answer the following 2 questions: Their bank will lend them $100,000 for 90 days at a cost of $1,200 interest. What is the company’s effective annual rate? A major supplier has granted credit terms of 1/10 N120. Assuming the company can borrow any amount of money at the rate you have calculated above (in part 1), should the company take the discount? (Your answer must be supported with a calculation of the cost of not taking the discount – using either simple or effective annual rate)
(Related to Checkpoint 18.2) (Estimating the cost of bank credit) Paymaster Enterprises has arranged to finance its seasonal working-capital needs with a short-term bank loan. The loan will carry a rate of 16 percent per annum with interest paid in advance (discounted). In addition, Paymaster must maintain a minimum demand deposit with the bank of 7 percent of the loan balance throughout the term of the loan. If Paymaster plans to borrow $110,000 for a period of 6 months, what is the annualized cost of the bank loan?
Zara Corporation borrowed RM100,000 from their bank for one year. The bank required the company to pay RM9,500 in interest at the end of the year plus maintain a minimum balance of RM10,000 with the bank in a chequing account throughout the year. What is the effective interest rate on this loan?
On December 31, 2021, Oregon Bank recorded an investment of P5,000,000 in a loan granted to a client. The loan has a 10% effective interest rate payable annually every December 31. The principal is due in full at maturity on December 31, 2024.Unfortunately, the borrower is experiencing significant financial difficulty and will have difficult time in making full payment. The bank projected that the entire principal will be paid at maturity and 4% interest or P200,000 will be paid annually on December 31 of the next three years. There is no accrued interest on December 31, 2021.The present value of 1 at 10% for three periods is 0.75, and the present value of an ordinary annuity of 1 at 10% for three periods is 2.49. What is the carrying amount of the loan receivable on December 31, 2022? a. 5,000,000 O b. 3,750,000 O c. 4,472,800 O d. 4,672,800