LEW Company purchased a machine at a price of $100,000 by signing a note payable, which requires a single payment of $123,210 in two years. a. Assuming annual compounding of interest, what rate of interest is being paid on the loan? Use Excel function Rate to calculate the rate. b. What would be the purchase price of the machine had LEW negotiated a single payment of $120,000 in two years, using the same effective rate? Use excel only..

LEW Company purchased a machine at a price of $100,000 by signing a note payable, which requires a single payment of $123,210 in two years. a. Assuming annual compounding of interest, what rate of interest is being paid on the loan? Use Excel function Rate to calculate the rate. b. What would be the purchase price of the machine had LEW negotiated a single payment of $120,000 in two years, using the same effective rate? Use excel only..

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 14P

See similar textbooks

Similar questions

LEW Company purchased a machine at a price of $100,000 by signing a note payable, which requires a single payment of $123,210 in 2 years. Assuming annual compounding of interest, what rate of interest is being paid on the loan?
Use the following information to answer the question: Loan amount: $245,000 Loan term: 30 years Contract interest rate: 6.00% Monthly payment: $1,468.8988 Total up-front financing costs paid to lender: $9,100 Up-front financing costs paid to third party service providers: $2.900 Calculate the lender's expected yield/IRR if the lender expects the borrower to keep the loan outstanding for the entire loan term. O None of the selections is correct 6.36% 6.00% 6.48% O 6.54%
Data Back-Up Systems has obtained a $29,000, 90-day bank loan at an annual interest rate of 15%, payable at maturity. (Note: Assume a 365-day year.) a. How much interest (in dollars) will the firm pay on the 90-day loan? b. Find the 90-day rate on the loan. c. Annualize your result in part b to find the effective annual rate for this loan, assuming that it is rolled over every 90 days throughout the year under the same terms and circumstances. Answers a. The amount of interest on the loan is $___. (Round to the nearest cent.) b. The effective 90-day rate is___%. (Round to two decimal places.) c. The effective annual rate is___%. (Round to two decimal places.)
Cerise Company would record a note payable of_____, if the terms of the loan with a bank are as follows: Cersie Company would have to make one $102,000 payment in two years. Assume the market interest rate is 10% per year and the company rounds to the nearest dollar. (The present value of $1 for two periods at 10% is 0.82645). a.) $94,498 b.) $84,298 c.) $10,200 d.) $74,098
Cloud Venture has a line of credit with a local bank of $75,000. The loan agreement calls for interest of 6 percent with a compensating balance requirement of 3 percent that is based on the total amount borrowed. What is the effective interest rate if the firm needs $58,000 for one year to finance a fixed asset purchase?
It is important to know how to build an amortization schedule when firms (or individuals) take out bank loans. It all start with calculating the monthly payment using the formula below.using the formula provided, do calculations to confirm the monthly payment for that loan based on the following information Loan amount (P): $60,000 Number of periods (n): 3 years = 36 months Interest (i): 12% per year = 1% per month (should be expressed as 0.01)
Let's say you are a credit analyst in the asset management department of a large bank or insurance company. The credit department is researching an investment in a syndicated loan made to a large firm. The loan is an “amortized loan” with a 7% interest rate payable semi-annually. The original term was 10 years. For analytical purposes, assume the loan trades in $1000 increments. What are the semi-annual payments on the loan? * PLEASE USE EXCEL AND SHOW WHAT FUNCTIONS/FORMULAS YOU USED*
A design studio received a loan of $8,950 at 5.60% compounded semi-annually to purchase a camera. If they settled the loan in 2 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? Round to the nearest cent b. What was the size of the interest portion on the first payment? ← a acer SUBMIT QUESTION SAVE PROGRESS V SUBMIT ASSIC
A machine can be leased for four years at $1000 per month payable at the beginning of each month. Alternatively, it can be purchased for $45,000 and sold for $5000 after four years. Should the machine be purchased or leased if the firm's cost of borrowing is: a. 6.6% compounded monthly? b. 9% compounded monthly? *
Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000 for the transaction. The loan will be amortized over 5 years and the nominal interest rate will be 8% payable monthly. Calculate the monthly payment and the annual percentage rate (EAR) of the loan to be amortized.
Data Back-Up Systems has obtained a $10,000, 90-day bank loan at an annual interest rate of 15%, payable at maturity. (Note: Assume a 365-day year.) 1.How much interest (in dollars) will the firm pay on the 90-day loan? Format: 111.11 2.Find the 90-day rate on the loan. Format: 1.11% 3.Annualize your result in part b to find the effective annual rate for this loan, assuming that it is rolled over every 90 days throughout the year under the same terms and circumstances. Format: 11.11%
Assume you take out a car loan of $8,600 that calls for 48 monthly payments of $300 each. a. What is the APR of the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Use a financial calculator or Excel.) b. What is the effective annual interest rate on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)