MHB Please help me understand my Credit Card Module Project

Click For Summary
The discussion revolves around a credit card module project that involves creating a table using Microsoft Excel to analyze minimum payments, interest, and balance calculations. The user successfully completed the initial chart but struggles to understand the logical formulas provided by a tutor for calculating the minimum payment and balance. They specifically seek clarification on how to derive a formula for the balance at the end of m months, given that the minimum payment exceeds $25. The user needs this formula to complete a subsequent table and create a graph for their assignment. Assistance with formulating the necessary equations in Excel is requested to move forward with the project.
sijones009
Messages
2
Reaction score
0
View attachment 6478View attachment 6479This is the worksheet my quantitative reasoning teacher assigned us. I was able to complete the chart using Microsoft Excel and printed a page that has all the values for to table in with the table. A tutor at my college gave me the logical formula to find the minimum payment, interest, and Balance A at the end of month. I do not understand completely how he came to the equations I wrote on the bottom for each column of the table. Which brings me to my next problem.

I do not know how to answer question 4 where it asks me to use my table/chart to determine a formula for the balance A at the end of m months (as the minimum payment is greater than $25). The answer seem obvious and in my face but I do not know how to solve. Please clarify this form me.

View attachment 6480
 

Attachments

  • page 1.png
    page 1.png
    45.3 KB · Views: 126
  • page 2.png
    page 2.png
    12.6 KB · Views: 114
  • page-3.png
    page-3.png
    43.5 KB · Views: 140
Mathematics news on Phys.org
Are you looking for an Excel formula?
 
Yes because It is asking for me to use the formula i make in question 4 to then determine the balance A at the end of t years. There is a table on the next page I must fill out. I need the formula to then create a graph.

View attachment 6483
 

Attachments

  • table2.jpg
    table2.jpg
    95.8 KB · Views: 108

Thread 'Area of Overlapping Squares'

Here is a little puzzle from the book 100 Geometric Games by Pierre Berloquin. The side of a small square is one meter long and the side of a larger square one and a half meters long. One vertex of the large square is at the center of the small square. The side of the large square cuts two sides of the small square into one- third parts and two-thirds parts. What is the area where the squares overlap?
View full post »

Similar threads

Undergrad Formula for credit card balance as a function of payments
  • · Replies 3 ·
Replies
3
Views
2K
MHB Best Outcome for Personal Finances using Credit Card Math Help
  • · Replies 1 ·
Replies
1
Views
2K
MHB Credit Card Payments: Probability
  • · Replies 4 ·
Replies
4
Views
3K
MHB "Getting a personal loan from a bank" real life math problem - need a formula
  • · Replies 16 ·
Replies
16
Views
6K
Maths Behind Credit Card Transactions
  • · Replies 12 ·
Replies
12
Views
3K
MHB Calculate pay off debt with minimum payment only?
  • · Replies 2 ·
Replies
2
Views
3K
Undergrad Can calculus be used to determine how much total interest I would pay?
  • · Replies 20 ·
Replies
20
Views
3K
High School I do not understand Log tables
  • · Replies 15 ·
Replies
15
Views
3K
MHB Understanding Cubic Equation Formula for Polynomials of Degree Three
  • · Replies 9 ·
Replies
9
Views
3K
Calculating credit card debt using a geometric series
  • · Replies 2 ·
Replies
2
Views
4K