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: 117
  • page 2.png
    page 2.png
    12.6 KB · Views: 108
  • page-3.png
    page-3.png
    43.5 KB · Views: 128
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: 103

Similar threads

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