the finance charge, new balance, and carry-over balance (the balance at the beginning of a new month) are all calculated for you with pre-loaded formulas. you will need to enter the beginning balance and then calculate the monthly payment. use the autofill feature to answer the questions below. part 1 1. start with a beginning balance of $5,000. 2. the interest rate is set at 18.99% and the finance charge is calculated for you. remember, if this is a new credit card, or a new charge, there is no finance charge in the first month as that is generally a grace period. finance charges will begin in month 2 when there is a carry-over balance on the credit card. 3. use a monthly payment of $350 for the life of the credit card loan. use the autofill feature. 4. how many months until the credit card is paid off? how much is the final payment? part 2 5. start with the same beginning balance of $5,000. 6. use a monthly payment of 10% of your new balance. (in excel, use the formula: =0.10*d2 in cell e2) use the autofill feature to at least 72 months (6 years). 7. what do you notice? 8. will you ever pay off this loan? part 3 9. compare payment types from part 1 (set amount each month) vs. part 2 (percentage of your balance). what are your takeaways? 10. generally, the minimum payment on a credit card is calculated using a particular percent of your balance (or $25, whichever is larger). why do you