_Credit Card Project Template Y

.xlsx

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

123-27B

Subject

Finance

Date

May 8, 2024

Type

xlsx

Pages

6

Uploaded by ColonelOpossum1089 on coursehero.com

Download this file to your computer to begin your project. Go to "File", "Download >", "Microsoft Excel" Name: Katrina Belzile Credit Card Purchase: Your starting balance is the price given in question 2 of your project. Assume you will make no additional purchases. This credit card requires a minimum payment of 9% of the balance or $15 each month, whichever is higher. Introductory APR: 0% for months 0-3 APR: 17.99% after the 3rd month Use page 130 and the credit card information provided above to complete the table below. Use the drag-down feature of Excel to extend the calculations as far as necessary to pay off this credit card. Remember: Excel should be doing ALL calculations. Month Starting Balance Finance Charge New Balance Minimum Payment 0 $1,352.00 $0.00 $1,352.00 $135.20 Once your table is complete, answer the follow 1 $1,216.80 $0.00 $1,216.80 $121.68 2 $1,095.12 $0.00 $1,095.12 $109.51 How long did it take to pay off the credit card? 3 $985.61 $14.78 $1,000.38 $100.04 38 4 $900.35 $13.50 $913.84 $91.38 5 $822.46 $12.33 $834.79 $83.48 Use Excel's SUM function to calculate the total 6 $751.31 $11.26 $762.57 $76.26 $1,514.86 7 $686.32 $10.29 $696.61 $69.66 8 $626.94 $9.40 $636.34 $63.63 Calculate the total amount paid in finance char 9 $572.71 $8.59 $581.30 $58.13 $158.53 10 $523.17 $7.84 $531.01 $53.10 11 $477.91 $7.16 $485.07 $48.51 12 $436.57 $6.54 $443.11 $44.31 What percent of the total paid went to finance 13 $398.80 $5.98 $404.78 $40.48 11.90% 14 $364.30 $5.46 $369.76 $36.98 15 $332.79 $4.99 $337.77 $33.78 16 $304.00 $4.56 $308.55 $30.86 17 $277.70 $4.16 $281.86 $28.19 18 $253.68 $3.80 $257.48 $25.75 19 $231.73 $3.47 $235.20 $23.52
20 $211.68 $3.17 $214.86 $21.49 21 $193.37 $2.90 $196.27 $19.63 22 $176.64 $2.65 $179.29 $17.93 23 $161.36 $2.42 $163.78 $16.38 24 $147.40 $2.21 $149.61 $15.00 25 $134.61 $2.02 $136.63 $15.00 26 $121.63 $1.82 $123.46 $15.00 27 $108.46 $1.63 $110.08 $15.00 28 $95.08 $1.43 $96.51 $15.00 29 $81.51 $1.22 $82.73 $15.00 30 $67.73 $1.02 $68.74 $15.00 31 $53.74 $0.81 $54.55 $15.00 32 $39.55 $0.59 $40.14 $15.00 33 $25.14 $0.38 $25.52 $15.00 34 $10.52 $0.16 $10.68 $15.00 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
Fixed-Rate Store Loan Purchase: Enter the APR and loan term given on question 2 of your project. APR: 3.87% Term: 36 Use page 134 in your book, and the information above, to find the monthly pay Payment: $39.84 wing questions: Answer the following questions for the store loan (there's no need for a table here): How long did it take to pay off the loan? 36 months amount paid on the card. Use Excel to calculate the total amount paid on the loan. 1434.24 rges. Calculate the total amount paid in interest. $82.24 e charges? What percent of the total paid went to interest? 5.7 You're going to be making some adjustments to this information, but we want to save this wond Once your spreadsheet is complete, copy this page to another page of the same workbook (se Right-click the tab that says "Original Purchase" at the bottom left corner of the
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help