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: 111
  • page 2.png
    page 2.png
    12.6 KB · Views: 104
  • page-3.png
    page-3.png
    43.5 KB · Views: 124
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: 98
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Back
Top