Darlene-P-GBS132_Lesson_4_Exercise_Template_Final (2)
docx
keyboard_arrow_up
School
Rio Salado Community College *
*We aren’t endorsed by this school
Course
132
Subject
Accounting
Date
Jun 5, 2024
Type
docx
Pages
5
Uploaded by ProfessorMink4177
GBS132 Lesson 4 Exercise Template
Name In this exercise, you will evaluate types of banking accounts and calculate interest.
Instructions:
1. Complete the assignment using the template provided. There are three parts.
2. Be sure to answer all questions
Part 1: Case Study
Jack and Lily earn $14,727 a month in combined income. After contributing to their employer 401(k) retirement plan and having their insurance and taxes deducted, they have take-home pay of $7,594 a month. After all monthly expenses are paid, they have a $1,317 surplus. Questions:
a.
How much do they need to have for an emergency fund?
b.
What type of account should they have it in, and how much interest will it earn? c.
What type of account would you tell them to invest in if they wanted to save money after filling up their emergency fund? Explain your answer. Answer:
After all monthly expenses are paid, Jack and Lilly need to have at least 6 months' worth of income
saved for their emergency fund. They need to have at least $45,564 for an emergency fund. The reason for an emergency fund is to cover expenses such as medical bills, car repairs, or any other unforeseen circumstances. The emergency fund will help pay for those monthly expenses.
They should have their emergency fund into a savings account with high interest rates. Some savings accounts that would be best for the emergency fund are CDs, money markets accounts, and high-yield savings accounts. A high-yield savings account is the best option, since they offer better interest rates and no monthly fees.
Opening another high-yield savings account can help them to save more money and earn higher interest rates. These accounts typically have lower fees, FDIC insurance, and higher annual percentage yields (APYs) than traditional savings accounts. This can help Jack and Lilly maximize their savings and help them to potentially grow their wealth over time.
Part 2: Checking Account Comparison
1.
Visit the following sites, which offer checking accounts: Page 1
GBS132 Lesson 4 Exercise Template
a.
Wells Fargo – www.wellsfargo.com
– Everyday Checking Account
b.
National Bank of Arizona – www.nbarizona.com
– Anytime Banking Account
c.
Arizona Federal Credit Union – www.arizonafederal.org
– Checking Plus Account
2.
Complete the Checking Account Comparison Chart and fill in all the required information for each account using a short phrase or sentence for each characteristic.
Checking Account Comparison Chart
Features
Wells Fargo
Everyday
Checking
National Bank
of Arizona
Anytime
Checking
Arizona
Federal Credit
Union
Checking Plus
Minimum daily balance required to waive monthly service fee
$500 $250 $0 Monthly Service Fee if not waived
$10 $10
$0
Minimum Deposit to Open Account
$25 $50 $20
Interest
No
No
0.11% Online Banking
Free Free
Free
ATM Fee at Bank Owned ATMs
0 0 0
ATM Fee at Out of Network ATMs
$2.50 $3, 1 fee is
waived per
statement
month
$2 Overdraft Protection Available
0 Yes
Yes Overdraft Fee
$35 $5 $35
Non-Sufficient Funds Fee (NSF)
0
$35
0 Online Bill Pay
Free
Free
FREE Send Money with Zelle
Free
Free
FREE Mobile Check Deposit
Free
Free FREE 3.
Answer this question: Which one would you choose to patronize? Explain your answer using details from the site. Cite all references you use in APA format using an in-text citation and reference.
Answer:
Page 2
GBS132 Lesson 4 Exercise Template
I would choose to patronize the Arizona federal credit union. It is more appealing to me and there are no monthly fees. The interest can also be used to boost my account balance. "At Arizona Financial, we truly believe in the value of free.” I believe choosing this bank would help grow my savings even further. Arizona Federal Credit Union overall seems like a smart financial decision that I can benefit from.
References
Arizona Financial Credit Union. (2024). Checking Account. https://www.arizonafinancial.org/checking-account
Part 3: Calculating Interest
1.
Answer the following questions in the provided template. 2.
Be sure to show your work for each question.
a.
If you put $6,000 into a savings account that pays interest at the rate of 4% a year, how much would you have after five years?
Answer:
FV=P(1+r)^n
FV=6,000(1+0.04)^5
FV=6,000(1.04)^5
FV=6,000(1.21)
FV=$7,260
You would have $7,260 after 5 years b.
If you put $6,000 into a savings account that pays interest at the rate of 8% a year, how much would you have after five years?
Answer: FV=P(1+r)^n
FV=6,000(1+0.08)^5
Page 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
GBS132 Lesson 4 Exercise Template
FV=6,000(1.08)^5
FV=6,000(1.469)
FV=$8,814
You would have $8,814 after 5 years
c.
If you put $6,000 into a savings account that pays interest at the rate of 12 percent a year, how much would you have after five years?
Answer:FV=P(1+r)^n
FV=6,000(1+0.12)^5
FV=6,000(1.12)^5
FV=6,000(1.76)
FV=$10,560
You would have $10,560 after 5 years
d.
How much would you earn in interest for saving in a $10,000 Certificate of Deposit that matures in 7 years and earns 5% interest?
Answer: FV=PV(1+i)^n
FV=10,000(1+0.05)^7
FV=10,000(1.05)^7
FV=10,000(1.4071)
FV=14,071
FV-PV= Interest Value
14,071-10,000= 4,071
You would earn $4,071 in interest.
e.
How much would you earn in interest for saving in a $10,000 Certificate of Deposit that matures in 5 years and earns 14% interest?
Answer: FV=PV(1+i)^n
FV=10,000(1+0.14)^5
FV=10,000(1.14)^5
FV=10,000(1.9254)
FV= 19,254
FV-PV= Interest Value
19,254-10,000= 9,254
You would earn $9,254 in interest.
f.
How long does it take your money to double if it is invested at 4%?
Answer: Use the rule of 72
72/4=18
It would take 18 years for your money to double if invested at 4%.
Page 4
GBS132 Lesson 4 Exercise Template
g.
If you put $6,000 each year into a savings account that pays interest at the rate of 4% a year, how much would you have after five years?
Answer: pmt[(1+i)^n/i-1/i]
6,000[(1+0.04)^5/0.04-1/0.04
6,000[(1.04)^5/0.04-1/0.04
6,000[(1.2167)/0.04-1/0.04]
6,000[(30.4175)-1/0.04]
6,000[(30.4175)-25]
6,000(5.4175)
= 32,505
h.
If interest is paid and compounds quarterly at 5%, what is the effective rate?
Answer: The effective rate is 5.09%
Page 5
Related Documents
Related Questions
Provide correct answer general Accounting
arrow_forward
I need answer typing
arrow_forward
Excel Skills
7. Solve the follow sections:
a.
Complete the following spreadsheet, showing how much will be in
your bank account if you deposit an initial deposit (cell B2) today
and it draws annual interest given in cell B1.
Interest
2 Initial deposit
3
4
5
6
7
A
8
9
10
Year
"
0
1
23
4
5
B
b. Graph the results of the bank account.
8%
$155
In bank
account.
arrow_forward
Overview
Plans
Resources
Follow-up and reports
360° reports
PFR Final Exam
01-10 11
Question 43
Paying the minimum amount every month on a credit card will
Your answer:
pay a large percentage of the total amount owed every month
make the final amount paid substantlally higher than the amount initlally charged
O Help the cardholder create a plan for paying off a credit card in a decent amount of time.
Allow the card holder to avoid paying any interest charges.
Clear answer
Back
Next
Play Sto
arrow_forward
Click into it and you will be able to see it clearly, please help
arrow_forward
What is the correct option ?? general Accounting
arrow_forward
Please help ?
arrow_forward
QUESTION 6
Assume you have a balance of $3200 on your credit card that you want to pay off. Calculate your monthly payment and total payment
under the given conditions. Assume you make no additional charges to the card.
The credit card APR is 18% and you want to pay off the balance in 3 years.
O $138.98; $5003.30
O $115.69; 44164.76
O $99.08; $3566.93
O $174.02; $6264.60
arrow_forward
Chapter 6
Practice Problem #4
arrow_forward
Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2%
a. What formula should be used?
b. What are you trying to find and what variable does it represent in the formula?
c. Solve the problem showing all of your work (must show all steps!!)
d. Interpet your answer using a complete sentence
You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain"
button to add pictures.
arrow_forward
CR Business Mathematics Section 2CR / Simple Interest / Lesson 63
#
7. A 180-day simple interest loan in the amount of $16, 400 will be paid in full in the amount of $16, 851. Find the interest rate of the loan. Use the banker's method, which uses 360 days in a year.
All ch
OR=5.5%
OR=6.0%
OR=4.5%
OR=5.0%
Type here to search
F4
O
2:
F5
01
F6
DELL
F7
FB
F9
F10
PREVIOUS
7 of 18
Amberly
as20157
F12
NEXT
184&
10
5/
arrow_forward
Question Help ▼
You plan to deposit $800 in a bank account now and $500 at the end of the year. If the account earns 3% interest per year, what will be the balance in the account right after you make the second
deposit?
The balance in the account right after you make the second deposit will be $
(Round to the nearest dollar.)
Enter your answer in the answer box.
arrow_forward
Part 2: Credit Cards
Another type of personal loan is a credit card. A financial institution allows you to charge a
purchase to your account, and you are required to pay the financial institution at a later time.
As with other loans, credit cards charge interest. Interest rates can range from 3% - 22%.
When you are paying for debt on a credit card, the financial institution will require a minimum
balance be paid each month. The higher the interest rate that is charged on the credit card, the
larger the minimum payment will be.
You can use credit card payoff calculators such as the one in the following link to determine
how much to pay each month and how long it will take to pay off a credit card.
credit card calculator
When using the credit card calculator, be certain that the monthly charges (new spending or
borrowing) are set to 0.
Part 2 Exercises:
Assume you have
answer the following questions.
balance of $1,800 on a credit card. Use the credit card payoff calculator to
a. If the…
arrow_forward
Answer the whole of 3.2
arrow_forward
Homework: Section 8.8
Assignment
The credit card with the
transactions described on the right
uses the average daily balance
method to calculate interest. The
monthly interest rate is 2.5% of the
average daily balance. Calculate
parts a-d using the statement on
the right.
Question 7, 8.8.1
Part 3 of 4
Help me solve this
Transaction Description
Previous balance, $6240.00
March 1 Billing date
March 5 Payment
$400.00 credit
$50.00
March 7 Charge: Restaurant
March 12 Charge: Groceries
$100.00
March 21 Charge: Car Repairs $280.00
March 31 End of billing period
Payment Due Date: April 9
a. Find the average daily balance for the billing period. Round to the nearest cent.
The average daily balance for the billing period is $ 6095.81.
(Round to the nearest cent as needed.)
View an example
Transaction
Amount
b. Find the interest to be paid on April 1, the next billing date. Round to the nearest cent.
The interest to be paid on April 1 is $152.40.
(Use the answer from part a to find this answer.…
arrow_forward
answer quickly
arrow_forward
Click and you will see it clearly, please help
arrow_forward
Chapter 7 Self Test Problem #1
arrow_forward
Math Concepts
6.
Exam 3
Name:
Assume that the following loan was paid in full before its due date.
Regular Monthly
Payments
$785
APR
6.5%
Remaining Number of Scheduled
Payments after Payoff
36
(i)
Obtain the value of h.
(ii)
Find the amount of unearned interest by the actuarial method.
arrow_forward
Goal
To use recursive sequence to determine the amount money owed on a loan after months
Role
You are a loan officer at a mortgage company.
Audience
Jim and Joan Miller are customers applying for a mortgage.
Situation
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly
payment is determined to be $758.48.
Performance Task
You need to present Jim and Joan with a report detailing the following:
• Arecursive formula for their balance after each monthly payment has been made.
• To do this, use the formula: a, = an-1 (1+r) – 758.48
A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment!
• Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment.
• Determine when the balance will be below $75,000.
• Determine when the balance will be paid off.
• Determine the interest expense when the loan is…
arrow_forward
A5
arrow_forward
2
arrow_forward
R2
arrow_forward
Score: 4/12 4/12 answered
$
You deposit $300 each month into an account earning 7% interest compounded monthly.
a) How much will you have in the account in 15 years?
Question 6
$
b) How much total money will you put into the account?
S
c) How much total interest will you earn?
Question Help: Video 1
Video 2
Search
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- Provide correct answer general Accountingarrow_forwardI need answer typingarrow_forwardExcel Skills 7. Solve the follow sections: a. Complete the following spreadsheet, showing how much will be in your bank account if you deposit an initial deposit (cell B2) today and it draws annual interest given in cell B1. Interest 2 Initial deposit 3 4 5 6 7 A 8 9 10 Year " 0 1 23 4 5 B b. Graph the results of the bank account. 8% $155 In bank account.arrow_forward
- Overview Plans Resources Follow-up and reports 360° reports PFR Final Exam 01-10 11 Question 43 Paying the minimum amount every month on a credit card will Your answer: pay a large percentage of the total amount owed every month make the final amount paid substantlally higher than the amount initlally charged O Help the cardholder create a plan for paying off a credit card in a decent amount of time. Allow the card holder to avoid paying any interest charges. Clear answer Back Next Play Stoarrow_forwardClick into it and you will be able to see it clearly, please helparrow_forwardWhat is the correct option ?? general Accountingarrow_forward
- Please help ?arrow_forwardQUESTION 6 Assume you have a balance of $3200 on your credit card that you want to pay off. Calculate your monthly payment and total payment under the given conditions. Assume you make no additional charges to the card. The credit card APR is 18% and you want to pay off the balance in 3 years. O $138.98; $5003.30 O $115.69; 44164.76 O $99.08; $3566.93 O $174.02; $6264.60arrow_forwardChapter 6 Practice Problem #4arrow_forward
- Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.arrow_forwardCR Business Mathematics Section 2CR / Simple Interest / Lesson 63 # 7. A 180-day simple interest loan in the amount of $16, 400 will be paid in full in the amount of $16, 851. Find the interest rate of the loan. Use the banker's method, which uses 360 days in a year. All ch OR=5.5% OR=6.0% OR=4.5% OR=5.0% Type here to search F4 O 2: F5 01 F6 DELL F7 FB F9 F10 PREVIOUS 7 of 18 Amberly as20157 F12 NEXT 184& 10 5/arrow_forwardQuestion Help ▼ You plan to deposit $800 in a bank account now and $500 at the end of the year. If the account earns 3% interest per year, what will be the balance in the account right after you make the second deposit? The balance in the account right after you make the second deposit will be $ (Round to the nearest dollar.) Enter your answer in the answer box.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage LearningPFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning