Homework Answers
| Option 1 | Monthly payment of option 1 =Using PMT function in MS excel | PMT(rate,nper,pv,fv,type) rate = 7/12= .5833% nper =12*3 =36 pv =11000 fv 0 type =0 | PMT(0.5833%,36,11000,0,0) | ($339.65) |
| Option 2 | Monthly payment of option 1 =Using PMT function in MS excel | PMT(rate,nper,pv,fv,type) rate = 7.5/12= .625% nper =12*4 =48 pv =11000 fv 0 type =0 | PMT(0.625%,48,11000,0,0) | ($265.97) |
| Option 3 | Monthly payment of option 1 =Using PMT function in MS excel | PMT(rate,nper,pv,fv,type) rate = 8/12= .666% nper =12*5 =60 pv =11000 fv 0 type =0 | PMT(0.666%,60,11000,0,0) | ($223.00) |
| Option is A | The third loan best meets the person's need because the monthly payment of 223 is less than the maximum budgeted amount of 250 per month |
Add Answer to:
Homework: Homework 4D - Loan Payments, Credit Cards, Mortga Save Score: 0 of 1 pt 7...
Homework: Unit 7 Lab Assignment Save HW Score: 0%, 0 of 40 pts Score: 0 of...
Homework: Unit 7 Lab Assignment Save HW Score: 0%, 0 of 40 pts Score: 0 of 4 pts 2 of 10 (0 complete) Question Help Problem 4.LO4.14 You are considering the purchase of a BMW MS. You will borrow the money from BMW Financial Services. The terms of the deal are outlined below: BMW MS RWD, 500hp, 0-100 in 4.7s MSRP $110,000 Term 48 months APR 8% Down Payment-So Monthly Payments $2,685.42 The amortized loan payments are a blend of...
Someone needs to borrow $12,000 to buy a car and the person has determined that monthly...
Someone needs to borrow $12,000 to buy a car and the person has determined that monthly payments of $275 are affordable. The bank offers a 3-year loan at 6% APR, a 4-year loan at 6.5%, or a 5-year loan at 7% APR. Which loan best meets the person's needs?
Score: 0 of 1 pt 6 of 9 (3 complete) HW Score: 22.22 % , 2...
Score: 0 of 1 pt 6 of 9 (3 complete) HW Score: 22.22 % , 2 of 9 pts P 5-26 (similar to) Question Help You have an outstanding student loan with required payments of $600 per month for the next four years The interest rate on the loan is 8 % APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking...
Homework: Chapter 4. Learning Objective 4. Topic Homework 1 Save 4 of 4 (4 complete) Score:...
Homework: Chapter 4. Learning Objective 4. Topic Homework 1 Save 4 of 4 (4 complete) Score: 0 of 1 pt HW Score: 50%, 2 of 4 pts X Problem 4.LO4.16 (similar to) Question Help A Hummer H3 sells for $94,000 tax included. GMAC lends money at the rate of 9.8% APR. If you buy the car and borrow through GMAC, then what are the unonthly (end-of-month) payments for a 9-year term? What is the amount of the monthly payment? (Round...
Homework: Section 7-3 Homework Save Score: 0 of 1 pt 6 of 19 (11 complete) HW...
Homework: Section 7-3 Homework Save Score: 0 of 1 pt 6 of 19 (11 complete) HW Score: 56%, 14 of 25 pts 7.3.16 Assigned Media Question Help In a sample of seven cars, each car was tested for nitrogen-oxide emissions (in grams per mile) and the following results were obtained: 0.16, 0.06, 0.19,0.12, 0.06, 0.15, 0.06. Assuming that this sample is representative of the cars in use, construct a 98% confidence interval estimate of the mean amount of nitrogen-oxide emissions...
You have an outstanding student loan with required payments of $550 per month for the next...
You have an outstanding student loan with required payments of $550 per month for the next four years. The interest rate on the loan is 10% APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking at your budget, you can afford to pay an extra $250 a month in addition to your required monthly payments of $550, or $800 in total...
1-determine how much of the loan will be paid off by the final ballon payment 2-how...
1-determine how much of the loan will be paid off by the final
ballon payment
2-how much loan must be paid off by the monthly payment
3-the monthly payments needed to pay off the portion of the
loan that is not paid off by the final balloon payment
(Complex stream of cash flows) Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller financing that is, a loan from the current owners...
You have an outstanding student loan with required payments of $600 per month for the next...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 9% APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month Looking at your budget, you can afford to pay an extra $250 a month in addition to your required monthly payments of $600, or $850 in total...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a $50,000 loan. Option 1: a 30-year loan at an APR of 7.65%. Option 2: a 15-year loan at an APR of 7.25%. Find the monthly payment for each option. The monthly payment for option 1 is $ The monthly payment for option 2 is $ (Do not round until...
A buyer can afford no more than $1,200 per month in payments. The most favorable loan...
A buyer can afford no more than $1,200 per month in payments. The most favorable loan available in the market is a 30-year loan at 5%. What is the maximum affordable house with a 20% down payment? please show using financial calc.
Homework: Unit 7 Lab Assignment Save HW Score: 0%, 0 of 40 pts Score: 0 of 4 pts 2 of 10 (0 complete) Question Help Problem 4.LO4.14 You are considering the purchase of a BMW MS. You will borrow the money from BMW Financial Services. The terms of the deal are outlined below: BMW MS RWD, 500hp, 0-100 in 4.7s MSRP $110,000 Term 48 months APR 8% Down Payment-So Monthly Payments $2,685.42 The amortized loan payments are a blend of...
Score: 0 of 1 pt 6 of 9 (3 complete) HW Score: 22.22 % , 2 of 9 pts P 5-26 (similar to) Question Help You have an outstanding student loan with required payments of $600 per month for the next four years The interest rate on the loan is 8 % APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking...
Homework: Chapter 4. Learning Objective 4. Topic Homework 1 Save 4 of 4 (4 complete) Score: 0 of 1 pt HW Score: 50%, 2 of 4 pts X Problem 4.LO4.16 (similar to) Question Help A Hummer H3 sells for $94,000 tax included. GMAC lends money at the rate of 9.8% APR. If you buy the car and borrow through GMAC, then what are the unonthly (end-of-month) payments for a 9-year term? What is the amount of the monthly payment? (Round...
Homework: Section 7-3 Homework Save Score: 0 of 1 pt 6 of 19 (11 complete) HW Score: 56%, 14 of 25 pts 7.3.16 Assigned Media Question Help In a sample of seven cars, each car was tested for nitrogen-oxide emissions (in grams per mile) and the following results were obtained: 0.16, 0.06, 0.19,0.12, 0.06, 0.15, 0.06. Assuming that this sample is representative of the cars in use, construct a 98% confidence interval estimate of the mean amount of nitrogen-oxide emissions...
You have an outstanding student loan with required payments of $550 per month for the next four years. The interest rate on the loan is 10% APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking at your budget, you can afford to pay an extra $250 a month in addition to your required monthly payments of $550, or $800 in total...
1-determine how much of the loan will be paid off by the final
ballon payment
2-how much loan must be paid off by the monthly payment
3-the monthly payments needed to pay off the portion of the
loan that is not paid off by the final balloon payment
(Complex stream of cash flows) Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller financing that is, a loan from the current owners...
You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 9% APR (compounded monthly). Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month Looking at your budget, you can afford to pay an extra $250 a month in addition to your required monthly payments of $600, or $850 in total...
Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a $50,000 loan. Option 1: a 30-year loan at an APR of 7.65%. Option 2: a 15-year loan at an APR of 7.25%. Find the monthly payment for each option. The monthly payment for option 1 is $ The monthly payment for option 2 is $ (Do not round until...
Most questions answered within 3 hours.
-
A shot-putter throws the shot with a horizontal velocity of 10
m/s and a
vertical velocity...
asked 13 minutes ago -
Mildred sells industrial-sized refrigeration units. Her
prospective buyer's face looks tense, and his forehead is wrinkled....
asked 14 minutes ago -
Clark Heter is an industrial engineer at Lyons Products. He
would like to determine whether there...
asked 1 hour ago -
3. Use a text editor to create a comma-delimited file of user
IDs and passwords. Revise...
asked 57 minutes ago -
Jensen and Associates has a projected balance
sheet that includes the following accounts. What is the...
asked 30 minutes ago -
implement a doubly-linked list in C. Each node in the linked list should contain a string,...
asked 53 minutes ago -
What are some best practices and things to avoid when developing
a PowerPoint presentation or file
asked 55 minutes ago -
Consider the ways that the government can get involved in
economic issues. What role do you...
asked 31 minutes ago -
Sodium carbonate is added to the tea mixture, in part, to form
the sodium salt of...
asked 54 minutes ago -
he plant started to purify its wastewater before discharging it
into the lake. How long will...
asked 1 hour ago -
Thiazyl fluoride, F3NS is a colourless gas. Using concepts of
electronegativity, formal charge etc. determine the...
asked 1 hour ago -
1. Why is an explicit inflation target a bad policy?
2. MV=PQ If M grows, then...
asked 48 minutes ago