Question

Homework: Homework 4D - Loan Payments, Credit Cards, Mortga Save Score: 0 of 1 pt 7 of 10 (7 complete) HW Score: 55%, 5.5 of

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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

AutoSave Off book 1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help O Search Share Comments X CAutoSave Off book 1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help O Search Share Comments X C

Add a comment
Know the answer?
Add Answer to:
Homework: Homework 4D - Loan Payments, Credit Cards, Mortga Save Score: 0 of 1 pt 7...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT