Credit Cards, Interest, Loans, Retirement and Savings Plan
Not what you're looking for?
1. You have to charge $500 of car repairs and have no additional charges during the next two months. You will just pay the minimum payment each month for the next two months. The Annual Percentage Rate (APR) is 15.99% and the minimum payment each month is 4% of the balance. Determine the finance charge, new balance, and minimum payment required for each of the next two months, and the starting balance for month 3 in the table below (round all answers to the nearest cent)
Month Starting balance Finance charge New balance Minimum payment
1 500.00
2
3
2. Find the balance on an account if you invest $100 at 5% for 10 years compounded annually. (round to the nearest cent)
3. Find the balance on an account if you invest $100 at 5% for 10 years compounded monthly. (round to the nearest cent)
Questions 4-6. Your friend purchases a $165,000 house. He is able to make a 20% down payment. The bank will give him a 30-year loan with a 4% APR.
4. How much money will he borrow for his mortgage? (round to the nearest dollar)
5. What would his monthly payment be? (round to the nearest cent)
6. How much interest will your friend pay over 30 years of his loan? (round to the nearest cent)
Questions 7-10. Your friend is able to invest $120 a month in a 401(k) with a predicted growth rate of 3%. Your friend's company will match 50% of your friend's contributions.
7. How much does your friend's company contribute every month? (round to the nearest dollar)
8. Use Excel's FV function to find the account balance after 20 years (round to the nearest cent)
9. How much was deposited over 20 years by your friend? By the company? (round to the nearest dollar)
10. How much did your friend earn in interest? (round to the nearest cent)
Purchase this Solution
Solution Summary
The Word file contains computations and final answers. Please refer to the Excel file for additional formulas and supporting work.
Solution Preview
1
Please see the attached Excel workbook for the computations. The final answer is shown below.
Month Starting Balance Finance charge New Balance Minimum Payment
1 $500.00 $6.66 $506.66 $20.27
2 $486.40 $6.48 $492.88 $19.72
3 $473.16 $6.30 $479.47 $19.18
2
100 (1 + 0.05) ^10 = 162.89
The balance ...
Education
- MSc, California State Polytechnic University, Pomona
- MBA, University of California, Riverside
- BSc, California State Polytechnic University, Pomona
- BSc, California State Polytechnic University, Pomona
Recent Feedback
- "Excellent work. Well explained."
- "Can you kindly take a look at 647530 and 647531. Thanks"
- "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
- "GREAT JOB!!!"
- "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.