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
Subject: acounting
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
Part 1: Data Tables
You have decided to start saving for retirement. You plan to work for 35 years and then retire.
Requirements: Complete each requirement on a separate worksheet.
1. Calculate the amount of money that will be in your Roth IRA account when you retire if
you:
a. Save $3,500 at the end of each year.
b.
Earn 7% interest each year.
c. The answer to requirement I must be calculated using a single formula.
2. Create a one-input Data Table that calculates the value of your Roth IRA when you retire
if the annual savings amount is different than $3,500 per year.
a. Use the following annual end of the year annual savings amounts as the column
data in the Data Table: $500, $1,000, $2,000, $3,000, $3,500, $4,000, and $5,000.
b. The annual interest rate is still 7% each year.
3. Create a two-input Data Table that calculates the value of your Roth IRA when you retire
for different annual interest rates and different annual savings amounts.
a. Use the following annual interest rates…
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
Problem Set for Credit Card Debt
MATH 113: Section 9.4a
Page 2 of 2
3. Rachel is purchasing a new camera that costs $3800 for her photography business. Rachel
uses a credit card that has an APR of 16.99%.
a. How long will it take her to pay off the camera if she makes monthly payments of
$75?
b. How much will she pay in the long run for the camera if she makes monthly
payments of$75?
arrow_forward
Chapter 6
Practice Problem #4
arrow_forward
COSTS & FEATURES OF A CHECKING ACCOUNT
Read each situation below, then circle the choice that you think is the best banking solution.
In the last column, describe why you believe it was the best banking solution.
1 DR = 2%
2
SITUATION
102
7.50
1. Monica typically has about
$750 in her checking account.
She also uses a debit card
wand online banking regularly.
750
Xby
2
7:03
The Vasquez family keeps
a balance of $3,000 in their
checking account. They use
checks to pay their household
bills and use their debit card
sparingly.
CHOICES
a. Bank of Texas charges a
$10 monthly fee for online
banking.
b. Bank of the South charges
2% of the checking account
balance.
a. Texas First charges 1% of
the checking account balance.
b. State Bank charges a $3
fee for each written check
and a $5 per month debit
card fee.
EXPLANATION
7.50
Y
02-
$15.00
Skyld
Skylar has a part-time job
and makes about $200 per
week. She would like to be
able to access her bank
account online.
a. First State Bank charges a…
arrow_forward
Cy loans Mookie The Beagle™ Concierge $2,000 at 6% annual interest. Record the transaction as a loan payable as follows.
Complete a Deposit.
Select Create (+) icon > Bank Deposit
Select Account: Checking
Select Date: 01/12/2022
In Add Funds to This Deposit section, select Account: + Add New > Loan Payable > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable, then select Save and close
Select Payment Method: Check
Enter Ref No.: 5002
Enter Amount: 2000.00
Select Save and close
What is the Amount of the Loan Payable? (Answer this question in the table shown below. Round your answer 2 decimal places.)
View the Transaction Journal for the Deposit.
From the Navigation Bar, select Accounting
From the Chart of Accounts, select Loan Payable > View Register
From the Register, select the transaction just recorded > Edit
From the bottom of the Loan Payable transaction, select More > Transaction Journal
What are the…
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
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
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
- Subject: acountingarrow_forwardOverview 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_forwardPart 1: Data Tables You have decided to start saving for retirement. You plan to work for 35 years and then retire. Requirements: Complete each requirement on a separate worksheet. 1. Calculate the amount of money that will be in your Roth IRA account when you retire if you: a. Save $3,500 at the end of each year. b. Earn 7% interest each year. c. The answer to requirement I must be calculated using a single formula. 2. Create a one-input Data Table that calculates the value of your Roth IRA when you retire if the annual savings amount is different than $3,500 per year. a. Use the following annual end of the year annual savings amounts as the column data in the Data Table: $500, $1,000, $2,000, $3,000, $3,500, $4,000, and $5,000. b. The annual interest rate is still 7% each year. 3. Create a two-input Data Table that calculates the value of your Roth IRA when you retire for different annual interest rates and different annual savings amounts. a. Use the following annual interest rates…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.60arrow_forwardProblem Set for Credit Card Debt MATH 113: Section 9.4a Page 2 of 2 3. Rachel is purchasing a new camera that costs $3800 for her photography business. Rachel uses a credit card that has an APR of 16.99%. a. How long will it take her to pay off the camera if she makes monthly payments of $75? b. How much will she pay in the long run for the camera if she makes monthly payments of$75?arrow_forwardChapter 6 Practice Problem #4arrow_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