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: 114
  • page 2.png
    page 2.png
    12.6 KB · Views: 106
  • page-3.png
    page-3.png
    43.5 KB · Views: 126
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 'Video on imaginary numbers and some queries'

Thread 'Video on imaginary numbers and some queries'

Hi, I was watching the following video. I found some points confusing. Could you please help me to understand the gaps? Thanks, in advance! Question 1: Around 4:22, the video says the following. So for those mathematicians, negative numbers didn't exist. You could subtract, that is find the difference between two positive quantities, but you couldn't have a negative answer or negative coefficients. Mathematicians were so averse to negative numbers that there was no single quadratic...
View full post »
Thread 'Unit Circle Double Angle Derivations'

Thread 'Unit Circle Double Angle Derivations'

Here I made a terrible mistake of assuming this to be an equilateral triangle and set 2sinx=1 => x=pi/6. Although this did derive the double angle formulas it also led into a terrible mess trying to find all the combinations of sides. I must have been tired and just assumed 6x=180 and 2sinx=1. By that time, I was so mindset that I nearly scolded a person for even saying 90-x. I wonder if this is a case of biased observation that seeks to dis credit me like Jesus of Nazareth since in reality...
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