Nadia needs to borrow $5000 to pay for ocean cruise tickets for her family. She can borrow from a finance company (at 2.77% add-on interest for 4 years) or she can borrow from a credit union (48 monthly payments of $114.58 each). Find the APR (to the nearest 0.01%) for each loan, and decide which one is Nadia's better choice. The APR for the finance company loan is (Type an integer or decimal rounded to the nearest hundredth as needed.)

Nadia needs to borrow $5000 to pay for ocean cruise tickets for her family. She can borrow from a finance company (at 2.77% add-on interest for 4 years) or she can borrow from a credit union (48 monthly payments of $114.58 each). Find the APR (to the nearest 0.01%) for each loan, and decide which one is Nadia's better choice. The APR for the finance company loan is (Type an integer or decimal rounded to the nearest hundredth as needed.)

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

不 Claire needs to borrow $5000 to pay for NHL season tickets for her family. She can borrow from a finance company (at 2.78% add on interest for 5 years) or she can borrow from credit union (60 monthly payments of $03 78 each). Find the APR for each loan using a TVM solver, and decide which one is Claire's better choice The APR for the finance company loan is (Type an integer or decimal rounded to the nearest hundredth as needed)
Diane is deciding between two personal loans. For each loan, the loan amount is $7500. Use the ALEKS loan calculator for the following. Also use the regular ALEKS calculator, as necessary. Write your answers to the nearest cent. ALEKS Loan Calculator Loan amount: $ Loan term: Interest rate: Calculate years % Monthly payment: (a) For Loan A, the interest rate is 6.15% per year and the loan term is 7 years. Find the total amount to repay Loan A. S (b) For Loan B, the interest rate is 6.15% per year and the loan term is 5 years. Find the total amount to repay Loan B. (c) For which loan would she pay less, and by how much? Loan A The total amount paid is $ less. Loan B The total amount paid is $less. X Ľ
Yuli plans to purchase a vehicle, and she is working with two bank offers. . Bank One Loan Offer: $73,800, 6% annual interest, 60 months. . Bank Two Loan Offer: $73,800, 3% annual interest, 84 months. Yuli's ultimate financial goal is to select the loan with the lowest monthly payment regardless of duration. Based on her financial goal, which loan will Yuli choose? O A. Bank One: Loan Offer O B. Bank Two: Loan Offer OC. Both monthly payments are the same. O D. Not enough information given to answer the question.
Claire needs to borrow $5000 to pay for NHL season tickets for her family. She can borrow from the credit union (36 monthly payments of $151.54 each). Find the APR for each loan. The APR for the finance company loan is? The APR for the credit union is?
Terri is looking to purchase a used car for $15,000 and received the following auto loan offers. Her goal is to find the option with the lowest monthly payment. Which option should Terri choose to meet her goal? Note you may need to use a financial calculator to answer this question. Select answer from the options below There is not enough information to answer this question. A 60-month loan with a fixed 3.65% interest rate. A 48-month loan with a fixed 2.76% interest rate. A 36-month loan with a fixed 2.72% interest rate.
Your friend is currently paying $734 in rent monthly in Fort Wayne and would rather apply the payment toward purchasing a home. If she can get a 30 year mortgage at 4.67% APR using her current payment amount, how much could she borrow? What could you type into Excel to calculate this value?
Rayleene is getting a loan to buy a used car from a seller. The price of the car is $8200.00. She has a down payment of $500.00 and is able to negotiate an interest rate of 5% from her bank. Rayleene is trying to decide whether to get her loan for 3 or 4 years. What is the Amount of Principal.What is the Monthly Payment for a 3 year loan & a 4 year loan.What are the Total Payments.What is the Total Cost of the Loan.Should Rayleene take her car loan out for 3 or 4 years? Why?Gary is buying a used car from a dealership for $15,499.00 so he needs to pay both GST and PST. His down payment is $3000.00, and he is approved for a 4.75% loan.What is the GST.What is the PST.What is the Amount of Principal.What is the Monthly Payment for a 3 year loan & a 5 year loan.What are the Total Payments.What is the Total Cost of the Loan.Should Gary take his car loan out for 3 or 5 years? Why?
Can Olivia and Anthony Afford This Home Using the Monthly Income Loan Criterion? Next week, your friends Olivia and Anthony want to apply to the Fourth Global Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $125,000. Given your knowledge of personal finance, they’ve asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To assist in the preparation of the worksheet, Olivia and Anthony also collected the following information: • Their financial records report a combined gross before-tax annual income of $125,000 and current (premortgage) installment loan, credit card, and car loan debt of $1,823 per month. • Their property taxes and homeowner’s insurance policy are expected to cost $3,125 per year. • Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan.…
Tayah is considering buying a new car for which she will need to borrow $23,900. But first, as she learned in FI 3300, Tayah wants to know how much she will have to pay per month on the dealership loan. The loan that Tayah is being offered has a five-year term, requires monthly payments, and has an interest rate of 4.4% p.a. What is the required monthly payment on this loan, assuming that the first payment will be made exactly one month from today? $439.22 $438.69 $444.48 $451.87 $442.74
Ursula wants to buy a $21,000 used car. She has savings of $2,000 plus an $800 trade-in. She wants her monthly payments to be about $302. Which of the following loans offers monthly payments closest to $302? A. 6% APR for 60 months B. 6% APR for 72 months C. 6% APR for 36 months D. 6% APR for 48 months Please use BA II where applicable.
Andie needs to borrow $6,000 to buy a car. One dealer offers her a monthly payment of $193.60 on a 3-year loan with an APR of 10 percent while another dealer offers her a monthly payment of $158.00 on a 4-year loan with an APR of 12 percent. If she can afford to make either payment, which loan costs less overall?
Erika is weighing her options for transportation. She’s narrowed them down to the following: Option A: buying a new car, requiring a loan to finance $18,000 at 1.9% interest compounded monthly over 60 months. Option B: buying a 6-year old, used car, requiring a loan to finance $6,000 at 3.6% interest compounded monthly over 48 months. The formula for calculating the value of a loan payment is: Calculate Erika’s monthly payment for both options. If you were advising Erika on her options, name at least 3 things other than the monthly payment that she should take into consideration in making her decision.