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: 119
  • page 2.png
    page 2.png
    12.6 KB · Views: 109
  • page-3.png
    page-3.png
    43.5 KB · Views: 131
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: 104
Thread 'Erroneously finding discrepancy in transpose rule'

Thread 'Erroneously finding discrepancy in transpose rule'

Obviously, there is something elementary I am missing here. To form the transpose of a matrix, one exchanges rows and columns, so the transpose of a scalar, considered as (or isomorphic to) a one-entry matrix, should stay the same, including if the scalar is a complex number. On the other hand, in the isomorphism between the complex plane and the real plane, a complex number a+bi corresponds to a matrix in the real plane; taking the transpose we get which then corresponds to a-bi...
View full post »

Similar threads

I 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
I Can calculus be used to determine how much total interest I would pay?
  • · Replies 20 ·
Replies
20
Views
3K
B 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