You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? 3. Prepare a monthly payment schedule for each loan above using Excel, and submit it.

You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? 3. Prepare a monthly payment schedule for each loan above using Excel, and submit it.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate: What would the monthly payment be? What would the amount of interest be? Prepare a monthly payment schedule for each loan above using Excel, and submit it. Suppose that you are only allowed to make a balloon payment to the principal of the compound interest loan. You have $1,000 to put down at the beginning of year three. How many payments will you save?
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
Use the Loan Payoff Table to determine both the finance charge and the payment required to amortize a loan of $4100 at an annual interest rate of 11% with a term of 36 monthly payments. What is the amount of each payment? What is the finance charge?
The formula below finds the monthly payment for a loan (car, mortgage, student): P=I (r/1-(1+r)-n ) P = monthly payment I = initial loan amount borrowed r = monthly interest rate n = number of months to pay off the loan 5. Assume you decide to take a 5-year car loan, with a 3.25% APR paid monthly. Insert the numbers you have so far into the formula above and simplify as much as possible. Show any in-between steps you do. (Note: simplify means to calculate the parts of the equation that you can so far.) 6. Use your simplified formula from above to answer: What is the largest amount you can borrow for the car if you can afford a $350/month payment? Show work.
You are preparing a loan amortization table for a 1-year loan of $1000 with a monthly interest rate of 1%. What is your principal payment in month 3 of the amortization schedule?
Suppose that you decide to borrow $15,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 5.9% Installment Loan B: five-year loan at 4.8% P Use PMT = to complete parts (a) through (c) below. - nt 1- 1+ a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.)
Suppose that you decide to borrow $13,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 6.3% Installment Loan B: five-year loan at 4.8% P. Use PMT = to complete parts (a) through (c) below. - nt 1- a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan A is $. (Round to the nearest cent as needed.) b. Find the monthly payments and the total interest for Loan B. The monthly payment for Loan B is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan B is $. (Round to the nearest cent as needed.) MacBook Air
Suppose that you decide to borrow $35,000 for a new car. You can select one of the following loans, each requiring regular monthly payments: Installment Loan A: three-year loan at 6% Installment Loan B: five-year loan at 9%. Find the monthly payments and the total interest for Loan A. Find the monthly payments and the total interest for Loan B. Compare the monthly payments and total interest for the two loans. Use this formula to find the monthly payments:
If you borrow $8,637 and are required to pay back the loan in five equal annual installments of $2,700, what is the interest rate associated with the loan? Use Appendix D or a financial calculator to solve this problem. (Round your answer to the nearest whole percent.) Interest rate %
A customer of your bank comes for a car loan 10000 OMR. He is charged with an interest rate of 5% per year. The customer expects a monthly repayment schedule from you, to plan his repayment. Provide a loan amortization schedule for monthly repayment of I year.
Suppose that you decide to borrow 13000 for a new car. You can select one of the following loans each requiring regular monthly payments. Installment loan A three-year loan at 5.9% Installment loan B five -year loan at 5.8% What would be the monthly payments for each loan and total interest for them also?
If you borrow $9,983 and are required to pay back the loan in five equal annual installments of $2,500, what is the interest rate associated with the loan? Use Appendix D or a financial calculator to solve this problem. (Round your answer to the nearest whole percent.