Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How is each questions solved ? Suppose you have an outstanding balance in your credit card account of $588.76 at the beginning of the month.

How is each questions solved ?

image text in transcribed
Suppose you have an outstanding balance in your credit card account of $588.76 at the beginning of the month. During the month, you make the following transactions: Day Amount Type Amount Type $73.08 Purchase $32.02 Purchase $78.56 Purchase $5.14 Return $62.00 Purchase $65.97 Purchase $87.24 Purchase $51.58 Purchase $78.57 Purchase $47.47 Purchase $92.65 Purchase $85.74 Return $83.17 Purchase $67.14 Purchase $13.21 Purchase $78.05 Payment Assume the month has 30 days. Use an interest rate of 1.25% per month. Use a Microsoft Excel spreadsheet to a. find the total of your purchases on the ninth of the month. b. find the total of your purchases on the eleventh of the month. c. find the day during the month when your end-of-day balance was the least. 1. day 2. balance d. find the day during the month when your end-of-day balance was the greatest. 1. day 2. balance e. calculate the balance on your account at the end of the month before the bank adds interest. f. calculate the total dollar amount of all the purchases you placed on your account during the month g. calculate the total dollar amount of all the payments you placed on your account during the month. h. calculate the total dollar amount of all the returns you placed on your account during the month. i. calculate the total dollar amount of the thirty end-of-day balances on your account for the month. j. calculate the net change to your balance over the course of the month. k. calculate the average daily balance on your account for the month. 1. calculate the interest the bank will charge on your account for the month. m. calculate the new balance on your account at the end of the month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions