Your car loan requires payments of $300 a month for the first year and payments of $500 per month the second year. The annual interest rate is 6%, and payments begin in one month. What is the present value of this two-year loan?
Calculating Present Value of first year payment,
Using TVM calculation,
PV = [FV = 0, PMT = 300, N = 12, I = 0.06/12]
PV = $3,485.68
Calculating Present Value(end of Year 1) of second year payment,
Using TVM Calculation,
PV = [FV = 0, PMT = 500, N = 12, I = 0.06/12]
PV = $5,809.47
Loan Amount = 3,485.68 + 5,809.47/(1.005)12
Loan Amount = $8,957.65
Your car loan requires payments of $300 a month for the first year and payments of...
5. Brian borrowed 18,000 on a 60 month installment loan at a 6% (annual) interest rate. The loan requires payments of $347.99 per month. How much interest will be charged for the first month and for the second month? (Show your calculations.) First month = Second month =
You take out an $8,600 car loan that calls for 48 monthly payments starting after 1 month at an APR of 6%. a. What is your monthly payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) 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.) c. Now assume the payments are made in four annual year-end installments. What...
A $28,000.00 car loan is to be repaid by end-of-month payments of $480.00 (except the smaller concluding payment).The interest paid for the loan is 5.78 % compounded quarterly. a) Calculate the amortization term of the car loan. b) How much interest will be paid in the second year? c) How much will the principal be reduced in the second year? d) Calculate the balance after two years. e) What will be the final payment?
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
You are considering buying a car with an amortized loan. The car loan will be $40,000 and have an annual interest rate of 2.8%, compounded monthly. You have two options for financing the car, the first is a fully amortized loan for 72 months while the second is a partially amortized loan for 36 months with a balloon payment of $18,000 (i.e. you will still owe $18,000 on the loan at month 36). What are the payments for each option?
You take out a $7,400 car loan that calls for 36 monthly payments starting after 1 month at an APR of 9%. a. What is your monthly payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) - monthly payment? b. What is the effective annual interest rate on the loan? (Do not round intermediate calculations. Enter your answer as a percent -effective annual interest rate?? c. Now assume the payments are made in four annual year-end...
You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your monthly payment? Round your answer to 2 decimal places. 2. You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your Month 1 interest payment? Round your answer to...
A $10,000 car loan has payments of $361.52 due at the end of each month for three years. What is the annual interest rate? The Tried and True Corp had earnings of $0.20 per share in 1978. By 1995, a period of 17 years, its earnings had grown to $1.01 per share. What was the compound annual rate of growth in the company’s earnings? Please Show Work In Excel
Suppose you take out a car loan that requires you to pay $9,000 now, $3,000 at the end of year 1, and 56,000 at the end of year 2. The interest rate is 1% now and increases to 7% in the next year. What is the present value of the payments? Enter your response below rounded to 2 decimal places Number Suppose you will receive payments of $2,000, S7,000, and $8,000 in 3, 6, and 7 year(s) from now, respectively....