Large semitrailer trucks cost $75,000 each. A trucking company buys such a truck and agrees to pay for it by a loan that will be amortized with 8 semiannual payments at 18% compounded semiannually. Complete an amortization schedule for the first four payments of the loan. ..... Fill out the amortization schedule below. (Round to the nearest cent as needed. Do not include the $ symbol in your answers.) Principal at Payment Amount of Interest for Payment Portion to End of Number Period Principal Period $75,000 1

Large semitrailer trucks cost $75,000 each. A trucking company buys such a truck and agrees to pay for it by a loan that will be amortized with 8 semiannual payments at 18% compounded semiannually. Complete an amortization schedule for the first four payments of the loan. ..... Fill out the amortization schedule below. (Round to the nearest cent as needed. Do not include the $ symbol in your answers.) Principal at Payment Amount of Interest for Payment Portion to End of Number Period Principal Period $75,000 1

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

Consider a 4-year amortizing loan. You borrow $2,400 initially and repay it in four equal annual year-end payments. a. If the interest rate is 10%, what is the annual payment? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Annual payment $ ✓Answer is complete and correct. Time b. Prepare an amortization schedule. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required. 1 2 3 4 Loan Balance (S) 2,400.00 2,400.00 757.13 1,882.87 x 1,314.03 688 Answer is complete but not entirely correct. Year-End Interest Due on Loan Balance (5) 240.00 188.29 131.40 68.83 Total Year- End Payment ($) 10 757.13 757.13 757.13 757.13 Amortization of Loan (S) 0 517.13 568.84 625.73 688.30
A bank loan requires you to pay $88,000 at the end of each of the next eight years. The interest rate is 10%. a. What is the present value of these payments? b. Complete the following amortization table. Complete this question by entering your answers in the tabs below. Required A Required B Complete the following amortization table. Note: Negative amounts should be indicated by a minus sign. Round intermediate calculations and final answers to the nearest whole dollar amount. Year 1 2 3 4 5 6 7 8 Beginning Balance Payment Interest (10%) Loan Reduction Ending Balance Required A Required B
prepare an amortization schedule showing the first four payments for each loan. Large semitrailer trucks cost $110,000 each. Ace Trucking buys such a truck and agrees to pay for it by a loan that will be amortized with 9 semiannual payments at 8% compounded semiannually.
Construct an amortization schedule (monthly) with the followings: House Price: 700,000 Down Payment: 20% of House Price Loan Period: 30 years Interest rate: 5.78% To get full credit, you must use Excel functions with relative cells to change the amortization schedule with variables such as price, interest, and load period. Please submit your Excel spreadsheet. (No other files are accepted)
We will use Excel PMT function to calculate the payment Rand then create an amortization schedule for the problem below: The Turners have purchased a house for $250,000. They made an initial down payment of $50,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance . Interest computations are made at the end of each month . Assume that the loan is amortized over 15 years . Determine the size of each installment such that the loan is amortized at the end of the term Type the raw data of P, r, m, t into cells Calculate i by its definition Calculate n by its definition Calculate R by Excel function PMT. Note : please reference in PMT What will be their total interest payment ?
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 fully amortizing CAM loan is made for $132,000 at 6 percent interest for 20 years. Required: a. What will be the payments and balances for the first six months? b. What would payments be for a CPM loan? c. If both loans were repaid at the end of year 5, would the lender earn a higher rate of interest on either loan? Complete this question by entering your answers in the tabs below. Required A Required B Required C What will be the payments and balances for the first six months? (Round your intermediate calculations and final answers to the 2 decimal places.) Month 1 Month 2 Month 3 Total Payment End Balance
Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan agreement calls for a principal reduction of $19,000 every year. How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. Leave no cells blank. You must enter '0' for the answer to grade correctly.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $57,000 $4,560 2 3 0 Total Interest
You plan to borrow $25,000 at a 3.4% annual interest rate compounded annually. The terms require you to amortize the loan with 5 equal payments each made at the end of each year. You would like to construct an amortization schedule showing details of the payments. Answer the following questions, and choose the closest answer from the possible choices following each question: 1.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P2 = 2.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P1 = 3.How much total interest is repaid in periods 1 to 2?
Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Principal Payment Ending Balance Total Beginning Balance Interest Year Payment Payment 1 3. 4 How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Total interest paid < Prev 10 of 10 Next
Develop an amortization schedule for the loan described. (All answers should be entered in dollars. Round your answers to the nearest cent.) $90,000 for 2.5 years at 10% compounded semiannually
A design studio received a loan of $6,800 at 4.10% 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? Round to the nearest cent c. What was the balance of the loan at end of the first year? Round to the nearest cent d. What was the size of the interest portion on the last payment? Round to the nearest cent