MHB Please help me understand my Credit Card Module Project

AI Thread 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: 115
  • page 2.png
    page 2.png
    12.6 KB · Views: 107
  • page-3.png
    page-3.png
    43.5 KB · Views: 127
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: 101

Thread 'Trigonometry problem of interest'

Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
View full post »

Thread 'Six Pencil Puzzle'

Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
View full post »

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

Hot Threads

Recent Insights

Back
Top