1] Assume one wants a monthly car payment of $200.00. Assume the interest rate on 60-month car loans is 5.5%. Assume one has $2,750 to put down on the car. Given these assumptions, what is the most this person should pay for a car?
2] If one finances $257,000 for a home at 4.9% interest for 30 years, what would be the monthly payment for principal and interest?
1.
Monthly payment = $200
Monthly rate R = 5.5%/12
down payment = $2750
Time = 60 months
So,
Price of the car = 2750 + 200*(1- 1/(1+ 5.5%/12)^60)/(5.5%/12)
Price of the car = $13220.57 or $13221
Hence, maximum amount to be paid for the car is $13220.57 or $13221.
------
2.
Loan amount = $257000
Monthly rate R = 4.9%/12
Time = 360 months (30 years)
Let, monthly payment = P
Then,
P = 257000 / ((1-1/(1+4.9%/12)^360)/(4.9%/12))
P = $1363.97 or $1364
So, monthly payment will be $1363.97 or $1364.
1] Assume one wants a monthly car payment of $200.00. Assume the interest rate on 60-month...
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...
You buy a car for $38,000. You agree to a 60-month loan with a monthly interest rate of 0.573 percent. What is your required monthly payment? $750.2 $760.2 $780.2 $800 $825.3 $850 $867 $900.2
Debt Interest Rate Current Balance Minimum Payment MasterCard 19.9% $600 $22 Visa 23.95% $2,545 $60 Car 4.8% $16,800 $465 Student Loan 6.8% $18,400 $220 Electronics Store 22.65% $1,015 $29 Loan from Dad 0% $3,000 $20 Knee Surgery 6.2% $5,000 $100 The above are debts you owe, the annual interest rate for those debts and the monthly payment. If you only make a debt payment of $1,200 each month, how much total interest will you pay over the life of your...
Determine Car Lease Payments: The term of the lease is 5 years, for 60 monthly payments. The current value of the car is $100,000, and the residual value at the end of year 5 is $42,000. 1.) The annual interest rate (APR) on the lease is 3.0%. Assuming you do not put down any money upfront, what is the monthly lease payment? Please list the formula. 2.) If there is an upfront sales tax of $4,640 you have to pay,...
3. What is Paul's monthly payment if he wants to repay his student loans completely within 10 years? Assume Paul pays a 5 percent annual interest rate (compounded monthly) on his student loan. Construct the amortization schedule of Paul's student loan for the first three months. Jinhee Ju. 27. has an annual salary of $37,000. Jinhee wants to buy a new car in 3 years, and she wants to save enough money to make a $7,000 down payment on the...
You consider buying a car for a price of $34,000. The car is to be bought on credit with an annual interest rate of 4.25%. The credit will be repaid in monthly constant total payments spread over 60 months. The dealer makes a "special" offer to you: a one-year grace period, which means that the first payment will be made only one year after the car is bought (however this period is subject to interest!!!). 1. What is the nominal...
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...
plz help LESSON 84 The Monthly Payment Most mortgage loans are repaid in equal payments. Each payment includes an amount for payment of interest and an amount for payment of the principal of the loan. The amount of interest is calculated using the simple interest formula. Each payment you make decreases the amount of the principal you owe. PRINCIPAL PAYMENT - MONTHLY PAYMENT - INTEREST PAYMENT NEW PRINCIPAL - PREVIOUS PRINCIPAL PRINCIPAL PAYMENT Complete the table below. Mortgage Amount Interest...
(1 point) Recall that the formula for a simple interest amortized loan, with initial loan value Vo, monthly payments of size m, with interest compounded n times per year for t years at annual interest rate r is rtn.t rt Ben buys his $230,000 home and, after the $40,000 down payment, finances the remainder with a simple interest amortized loan. Ben can pay at most $1,200 per month for the loan, on which the lender has set an annual rate...
Janet buys a $20,000 car. Prevailing market rates are nominal 8% annual, convertible monthly. The dealership offers her the choice of a rebate upon purchase of the car for cash, or alternatively, Janet can make no down payment and 60 monthly payments based on a nominal 2.5% annual interest, convertible monthly. The first payment would be due one month after the purchase of the car. The amount of the rebate is set so that the dealership is indifferent as to...