Personal Finance Credit Card Project
xlsx
keyboard_arrow_up
School
University of Iowa *
*We aren’t endorsed by this school
Course
1234
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
8
Uploaded by MegaBaboon2816
Name:
David Louvie
Buildin
Goals
1. Establish a credit limit that will enable you to pay credit card balances in full eac
2. Select credit cards that will provide the most favorable terms at the lowest cost.
Analysis
1. Referring to your personal cash flow statement, determine how much excess ca
you have each month. Based on this amount, set a self-imposed credit limit each m
that you can pay off your balance in full. If you have existing credit card debt, use t
template below to determine how many months it will take you to pay off your balan
at three different monthly payment amounts. (The Excel template will perform the calculations for you.) Revise your cash flow statement based on your decisions.
Credit Card Debt
Monthly Payment
Interest Rate per Year
Months to Pay off Debt
2. Use the following template to select a credit card with favorable terms.
Rate the cards from "5" as the best in a category to "1" as the worst.
Bank Credit Card Scorecard
QUESTION
1. Annual fee
2. Rewards program
3. Welcome Bonus
4. Travel benefits
5. Dining benefits
6. Grocery benefits
7. Airline and Hotel partners
8.Annual travel credit
9. Dining credits
TOTAL
Decisions
1. What is your self-imposed credit limit each month for future credit card purchase
inflows do you need to allot each month to paying off any existing credit card debt
2. What credit cards offer the most favorable terms for your needs?
My self-imposed credit limit for each month is about $1,000 as I currently
groceries/necessites. I also give plasma every week which generates me about
friends. Since I only can save the $1,000 th
I would say that the American Express Gold credit card is the most favorable in benefits of the card help to outweight that higher expense. For example, I will adm
is higher than all of the other cards points rates. Additionally, this card offers 4x e
food for every day at work. This is higher point
ere
Chapter 8
ng Your Own Financial Plan
ch month.
ash inflows month so
the
nce
Alternative 1
Alternative 2
$1,000 $2,000 $200 $400 10.000%
15.000%
5.13
5.20
Capital One Venture Rewards
Citi Premier Card
1
2
$95 $95 2x miles on every purchase
3x points on air travel, hotels, restaurants, supermarkets, gas stations
60,000 miles after spending $3,000 on purchases in first 3 months
80,000 points after spending $4,000 in first 3 months
Travel insurance and no foreign transaction fees
Travel insurance and no foreign transaction fees
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
2x miles on dining purchases
None
None
None
None
es? How much of your cash
t?
Earns 3x points on dining purchases
2x miles on eligible delivery and takeout services, groceries
3x points on supermarket purchases
Offers transfer partnerships with various airlines and hotel loyalty programs
Transfer partnerships with various airlines and hotel loyalty programs
make about $2,000 per month with my job and need to allocate at least $
t $105 in income but I typically use this money for enterainment or fun act
hat is why my credit limit is $1,000. I don't currently have any existing cred
terms of my needs and especially my spending habits. While it does have
mit I go out to eat at restaurants quite often. This card offers 4x earned poin
earned points for money spent at U.S. supermarkets. I spend a good amou
ts earned than the other credit cards and I feel like I would make good use
Date:
6/18/2023
Alternative 3
$3,000 $600 20.000%
5.26
Bank of America Premium Rewards Card
Chase Sapphire
3
4
$95 $95 2x points on travel and dining
Travel insurance and no foreign transaction fees
2x points on travel and dining worldwide and 1x points on all other purchases
50,000 points after spending $3,000 on purchases in first 3 months
100,000 points after spending $4,000 in first 3 months
Provides travel insurance, no foreign transaction fees, ability to transfer points
2x points on dining purchases
2x points earned on dining purchases worldwide
None
1x points on grocery purchases
Selected airlines and hotel loyalty programs
$100 airline incidental statement credit annually
None
None
None
Ability to redeem points for statement credits towards travel purchases
$1,000 of that for my rent of $785 and then tivities I like to do such as golf and going out with dit card debt.
e the highest annual fee of $250, I think the other nts for money spent at restaurants worldwide, which unt per week on groceries as well to meal prep my e of that benefit.
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
American express gold
5
250.00
4x points at restaurants worldwide
60,000 points after spending $4,000 on purchases in first 3 months
Travel protections, ability to transfer points to travel partners
4x points on dining purchases worldwide
4x on U.S supermarket purchases Selected airlines and hotel loyalty programs
Up to $100 airline fee credit per year
Up to $120 dining credit annualy at certain restaurants
Related Documents
Related Questions
Please solve step by step and quick
arrow_forward
Please include explantions thank you
arrow_forward
Match the following credit terms with the correct description.
APR
[Choose ]
[Choose ]
Known as the Annual Percentage Rate.
Some credit cards charge these. They can be charged for membership and you may be required to pay them once a year.
Credit cards that offer these give you cash or points for purchases you make.
Occurs when you don't pay your monthly payment on time.
These occur when you transfer your balance to a different card.
When you move an existing balance to another credit card or account.
The least amount of money you are obligated to pay back on a monthly basis to avoid fees and penalties.
[Choose ]
[Choose ]
[Choose ]
[Choose ]
Fees
Rewards
Finance Charges
Late fees
Balance Transfer
Minimum payment
arrow_forward
Would love the help. 10
arrow_forward
Alpesh
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
H5.
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
if u don’t answer this i will report you.
arrow_forward
Alice’s second initiative calls for Fresh & Fruity to obtain a bank loan of a sufficient size to enable the company to take all suppliers’ discounts. What is the minimum size of this loan? (Hint: To take all suppliers’ discounts, the average payment period must be 10 days, and net purchases will be purchases – (Purchases from Figure 1 x .02). Assume that all this happens, and solve the following formula for the new accounts payable balance, using:
Accounts payable = Average payment period x Purchase per day*
*Based on net purchases/360.
Now compare the accounts payable you just solved with the new accounts payable balance you found in question 3. The difference is the size of the loan that is required.
Assume that Fresh &Fruity does obtain an 8 percent loan for one year in the amount you solved in question 5, and it reduces its accounts payable balance accordingly. Now the company is taking 2 percent discounts on all purchases and paying 8 percent a year on the loan…
arrow_forward
Need help
arrow_forward
Business Math
Worksheet 8.2: Installment loans-Amount Financed Name
Background: An installment loan is repaid in several equal payments over a specified period of time.
Usually, you make a down payment to cover a portion of the cash price of the item. The amount you
finance is the portion of the cash price that you owe after making the down payment.
Amount Financed = Cash Price - Down Payment
Down Payment = Cash Price x Percent
1. Flora Quinton is buying a new air compressor for her auto repair shop. It sells
for $1,299. She makes a down payment of $199 and finances the remainder.
How much does she finance?
2. Beatriz Ruiz is buying new office furniture. It sells for a cash price of
$2,358.60. The down payment is $200.00. What is the amount financed
3. An office remodeling project costs $15,880. If you pay $3,680 towards the
project, how much do you finance?
arrow_forward
Find the following. (Round your answers to the nearest cent.)
FinanceCharge
Number ofPayments
Frequency
Amount
Number ofPayments Left
$9.10
12
Monthly
$15
5
(b) the amount needed to pay off the loan
arrow_forward
You are the loan department supervisor for a bank. This installment loan is being paid off early, and it is your task to calculate the rebate fraction, the finance charge rebate (in $), and the payoff for the loan (in $).
(Round dollars to the nearest cent.)
Finance
Amount
Financed
Monthly
Payment
Number of
Rebate
Payments
Made
Loan
Charge
Rebate
Payoff
Payments
Fraction
$1,800
18
$128.89
12
Enter a number.
arrow_forward
You are the loan department supervisor for a bank. This installment loan is being
paid off early, and it is your task to calculate the rebate fraction, the finance
charge rebate (in $), and the payoff for the loan (in $). (Round dollars to the
nearest cent.)
Finance
Monthly
Payment
Amount
Number of
Rebate
Payments
Made
Loan
Charge
Financed
Payments
Fraction
Payoff
Rebate
$4,700
36
$168.33
28
0.044
$ 60
2$
1,286
arrow_forward
Assume that your team is in business and you must borrow $6,000 cash for short-term needs. You have been shopping banks for a loan, and you have the following two options. A. Sign a $6,000, 90-day, 10% interest-bearing note dated June 1. B. Sign a $6,000, 120-day, 8% interest-bearing note dated June 1. Required 1. Discuss these two options and determine the better choice. Ensure that all teammates concur with the decision and understand the rationale. 2. Each member of the team is to prepare one of the following journal entries. a. Option A—at date of issuance. b. Option B—at date of issuance. c. Option A—at maturity date. d. Option B—at maturity date. 3. In rotation, each member is to explain to the team the entry he or she prepared in part 2. Ensure that all team members concur with and understand the entries. 4. Assume that the funds are borrowed on December 1 (instead of June 1) and your business operates on a calendar-year reporting period. Each member of the team is to prepare…
arrow_forward
1. If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Lizzie is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 6% APR and the following transactions? (Round your answer to the nearest cent.)
31-day billing cycle
10/1
Previous balance
$ 1,170
10/3
Credit
$ 73 cr.
10/12
Charge: King Soopers
154
10/15
Payment
370 cr.
10/25
Charge: Delta
327
10/30
Charge: Holiday Fun
67
arrow_forward
4. What is the purpose of a bridge loan? 5. Distinguish between bank discount and simple interest.6. Differentiate between a stated rate of interest and an effective rate of interest. 7. What is the significance of finding the internal rate of return (IRR)? 8. Jill Kramer borrowed $25,000 to pay for a startup business. Jill must repay the loan at the end of five months in one payment with a 6 percent simple interest rate.What is the total amount that Jill must repay in five months?How much interest does Jill repay?9. Joe Jones went to his bank to find out how long it will take for $1,000 to amount to $1,350 at 9 percent simple interest. Solve Joe's problem.
arrow_forward
If you are trying to build credit by using a credit card, each time you make a purchase with the credit card, deduct that amount from
your checking account. That way, when your credit card bill is due, you will have enough to pay the credit card off in full. Kathy Lehner
is going to start doing this. She plans on paying her credit card bill in full this month. How much does she owe with a 6% APR and the
following transactions?
Note: Round your answer to the nearest cent.
31-day billing cycle
10/1
10/3
Previous balance
Credit
$ 1,164
10/12
Charge: King Soopers
$ 79
$ 148
Credit
10/15
Payment
$ 310 Credit
10/25
Charge: Delta
$ 321
10/30
Charge: Holiday Fun
$ 61
Answer is complete but not entirely correct.
Amount owed
$ 1,097.56×
arrow_forward
No Plagiarism Please!
Enter your answer and show all the steps that you use to solve this problem in the space provided.
You have two credit cards.
Card Name (APR %)
Existing Balance
Credit Limit
Murk (5.6%)
$675.49
$1,500.00
Mini (9.85%)
$902.43
$1,000.00
What is your debt ratio? If you budget $375 to payoff your credit card debt and you payoff the highest interest card first while maintaining the interest accrued on the other card, how many months does it take you to pay it off and how much is the payment each time excluding the last payment?
Be sure to include the following in your response:
the answer to the original question
the mathematical steps for solving the problem demonstrating mathematical reasoning
arrow_forward
You are the loan department supervisor for a bank. This installment loan is being paid off early, and it is your task to calculate the rebate fraction, the finance charge rebate (in $), and the payoff for the loan (in $).
(Round dollars to the nearest cent.)
Amount
Financed
Number of
Payments
Monthly Payments
Rebate
Payment
Made
Fraction
Finance
Charge
Rebate
$4,700
36
$167.33
29
15/666 X
$ 85.76
Loan
Payoff
x
$785 89
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
Related Questions
- Please solve step by step and quickarrow_forwardPlease include explantions thank youarrow_forwardMatch the following credit terms with the correct description. APR [Choose ] [Choose ] Known as the Annual Percentage Rate. Some credit cards charge these. They can be charged for membership and you may be required to pay them once a year. Credit cards that offer these give you cash or points for purchases you make. Occurs when you don't pay your monthly payment on time. These occur when you transfer your balance to a different card. When you move an existing balance to another credit card or account. The least amount of money you are obligated to pay back on a monthly basis to avoid fees and penalties. [Choose ] [Choose ] [Choose ] [Choose ] Fees Rewards Finance Charges Late fees Balance Transfer Minimum paymentarrow_forward
- Would love the help. 10arrow_forwardAlpesharrow_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
- H5.arrow_forwardFind 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_forwardif u don’t answer this i will report you.arrow_forward
- Alice’s second initiative calls for Fresh & Fruity to obtain a bank loan of a sufficient size to enable the company to take all suppliers’ discounts. What is the minimum size of this loan? (Hint: To take all suppliers’ discounts, the average payment period must be 10 days, and net purchases will be purchases – (Purchases from Figure 1 x .02). Assume that all this happens, and solve the following formula for the new accounts payable balance, using: Accounts payable = Average payment period x Purchase per day* *Based on net purchases/360. Now compare the accounts payable you just solved with the new accounts payable balance you found in question 3. The difference is the size of the loan that is required. Assume that Fresh &Fruity does obtain an 8 percent loan for one year in the amount you solved in question 5, and it reduces its accounts payable balance accordingly. Now the company is taking 2 percent discounts on all purchases and paying 8 percent a year on the loan…arrow_forwardNeed helparrow_forwardBusiness Math Worksheet 8.2: Installment loans-Amount Financed Name Background: An installment loan is repaid in several equal payments over a specified period of time. Usually, you make a down payment to cover a portion of the cash price of the item. The amount you finance is the portion of the cash price that you owe after making the down payment. Amount Financed = Cash Price - Down Payment Down Payment = Cash Price x Percent 1. Flora Quinton is buying a new air compressor for her auto repair shop. It sells for $1,299. She makes a down payment of $199 and finances the remainder. How much does she finance? 2. Beatriz Ruiz is buying new office furniture. It sells for a cash price of $2,358.60. The down payment is $200.00. What is the amount financed 3. An office remodeling project costs $15,880. If you pay $3,680 towards the project, how much do you finance?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 Learning

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