Insert Chan Text Shape Media Comment Colabor om Sheet #1.) Here is a sample credit card statemet. Use the CARD Statement to answer problems a.d. CARD Statement OOOO Account Number 124 1234 1234 1234 Siemens Closing Date 11/06/05 Cred Line 12.100.00 Avale Creo 315780 TERESA TORRES 123 ANY STREET CITY CA 12345 Account Summary Previous Dance - Credits - Payment Purchase & Orechos Cash Advances FINANCE CHARGE New Balance Payment Information New Scheduled Payment Scheduled Payment Due Date 3115 1000 516085 552320 30.00 3000 3523 20 352320 13500 12/01/08 Rate Information CLEAN WHO Daily FRANCE CHARGE Avenge Daily RATE Cone ANDAL PERCENTAGE Type of Balance RATE PURCHASES) 10.80% CASH ADVANCE(S) 21 N GARNUL PERCENTAGE RATES 05445 05972 3000 30.00 Depw Credit Char Transactions o Trans Post Reference Number 1008 1008 XOOOOOO 1008 10/0X000000000000 Description MERCHANT NAME PAYMENTS 12/01/08 Account Number 1234 1234 1234 12:34 New Balance 592320 Scheduled Minim Payment $35.00 Scheduled Payment Due Date 12010 Amount Enclosed S PIMENTADORES 23 ANN STREET LOS ANGELES CA 3.000 TERESA TORRES 123 ANY STREET CITY CASO a.) What is the APR on purchases for this creadit card? (Answer in the green cell) b.) Fill in the following table. Use the information from the sample CARD Statement. Previous balance Payments Purchases Finance charge New balance Month 1 c.) What is the minimum payment in dollars on this card? (Answer in the green cell) d.) Suppose that the minimum payment is made on this card. Calculate next month's new balance. Assume that there are no new purcases. Previous Balance Minimum Payment New balance Month Finance charge Purchases 1 The problems on this spreadsheet are based on the topics covered in section 4.4. "Remember, let Excel do the work for you. Do not use a calculator, instead use "=" operations such as +, -, /, and reference cells. Save your work as lastname_firstname_4.4.xlsx and upload the file on Blackboard. Section 4.4 with Excel The problems on this spreadsheet are based on the topics covered in section 4.4. "Remember, let Excel do the work for you. Do not use a calculator, instead use "=" operations such as +, --1,7, and reference cells. Save your work as lastname_firstname_4.4.xlsx and upload the file on Blackboard. #1.) Here is a sample credit card statemet. Use the CARD Statement to answer problems a- d. CARD Statement OOOO Account Number 1234 1234 1234 1234 Statement Closing Date 11/06/08 Credit Line $2,100.00 Available Credit $1,578.80 TERESA TORRES 123 ANY STREET CITY CA 12345 Account Summary Previous Balance - Credits - Payments Purchases & Other Chos Cash Advances FINANCE CHARGE New Balance Payment Information o New Balance O Scheduled Minimum Payment Scheduled Payment Due Date $523 20 $35.00 12/01/08 $1,686 15 30 00 51.668.15 $523 20 $0 00 $0.00 $523 20 RATE Rate Information YOU WAY FT YOUR SEANCE PALLAT ANY TIME YOUR LE MAY VARY ACCORDINO TO THE TERMS OF YOUR AGREEMENT NOTICE SERVER DE FOR IMPORTANT FORMATION ABOUT YOUR ACCOUNT Corresponding Daily ANNUAL FINANCE Average PERCENTAGE CHARGE Daily Type of Balance RATE Balance PURCHASE(S) 19.80% 05424% $0.00 CASH ADVANCE(S) 21.80% 05072% $0.00 Corpo ANUAL PERCENTAGE RATE 21 BON Days in any Transactions O Trans Post Reference Number Description Credits Charges 1008 10/08 xoooo MERCHANT NAME 9320 1008 10/09 XOO0000 PAYMENTS 1 AN 15 TEN Dupa intryckes UPUTULO Campo ANUAL PERCENTAGE RATE 21 808 Transactions o Trana Post Reference Number 1008 10/08 XOOOOX 10/08 1009 XXX Credits Charges Description MERCIWNT NAME PAYMENTS 30320 1. Du want to 12/01/08 Account Number 1234 1234 1234 1234 New Balance $523 20 Scheduled Minimum Payment $35 00 Scheduled Payment Due Date 12/01/08 Amount Enclosed S PAYMENT ADORESS 123 ANY STREET LOS ANGELES.CA SO DOS TERESA TORRES 123 ANY STREET CITY. CA 12306 a.) What is the APR on purchases for this creadit card? (Answer in the green cell) b.) Fill in the following table. Use the information from the sample CARD Statement. Previous balance Payments Purchases Finance charge New balance Month 1 c.) What is the minimum payment in dollars on this card? (Answer in the green cell) PAYMENT ADORESS 123 ANY STREET LOS ANGELES, CA 90030-0000 TERESA TORRES 123 ANY STREET CITY, CA 12360 a.) What is the APR on purchases for this creadit card? (Answer in the green cell) b.) Fill in the following table. Use the information from the sample CARD Statement. Previous balance Payments Purchases Finance charge New balance Month 1 c.) What is the minimum payment in dollars on this card? (Answer in the green cell) d.) Suppose that the minimum payment is made on this card. Calculate next month's new balance. Assume that there are no new purcases. Month Previous Balance Minimum Payment Finance charge New balance Purchases 1