Question

In: Finance

eBook Do the Math 7-3 Average Daily Balance and Finance Charges Kayla Sampson, an antiques dealer...

eBook Do the Math 7-3 Average Daily Balance and Finance Charges Kayla Sampson, an antiques dealer from Mankato, Minnesota, received her monthly billing statement for April for her MasterCard account. The statement indicated that she had a beginning balance of $600, on day 5 she charged $150, on day 12 she charged $300, and on day 15 she made a $250 payment. Out of curiosity, Kayla wanted to confirm that the finance charge for the billing cycle was correct (assume a 30-day month and that the card balance is actually reduced on the day the payment is made).

What was Kayla's average daily balance for April without new purchases? Round your answer to the nearest dollar. Use rounded answer for later calculations.

$ What was her finance charge on the balance in part (a) if her APR is 19.5 percent? Round your answer to the nearest cent.

$ What was her average daily balance for April with new purchases? Round your answer to the nearest dollar. Use rounded answer for later calculations.

$ What was her finance charge on the balance in part (c) if her APR is 19.5 percent? Round your answer to the nearest cent. $

Solutions

Expert Solution

Part 1)

The value of Kayla's average daily balance for April without new purchases is calculated as follows:

Kayla's Average Daily Balance for April without New Purchases = Balance Upto the end of 14th Day*14/30 + Balance from 15th Day till the End of Month*16/30

Here, Balance Upto the end of 14th Day = $600 and Balance from 15th Day till the End of Month = 600 - 250 = $350 [the balance is immediately reduced after payment]

Using these values in the above formula, we get,

Kayla's Average Daily Balance for April without New Purchases = 600*14/30 + 350*16/30 = $467

____

Part 2)

The value of finance charge on the balance in part (a) if APR is 19.5 percent is arrived as below:

Value of Finance Charge = Average Daily Balance without New Purchases*APR*1/12 = 467*19.5%*1/12 = $7.58

____

Part 3)

The average daily balance for April with new purchases is calculated as follows:

Average Daily Balance with New Purchases = Balance Upto the end of 4th Day*4/30 + Balance from 5th Day Upto the End of 11th Day*7/30 + Balance from 12th Day Upto the End of 14th Day*3/30 + Balance from 15th Day till the End of Month*16/30

Here, Balance Upto the end of 4th Day = $600, Balance from 5th Day Upto the End of 11th Day = 600 + 150 =$750, Balance from 12th Day Upto the End of 14th Day = 750 + 300 = $1,050 and Balance from 15th Day till the End of Month = 1,050 - 250 = $800

Using these values in the above formula, we get,

Average Daily Balance with New Purchases = 600*4/30 + 750*7/30 + 1,050*3/30 + 800*16/30 = $787

____

Part 4)

The value of finance charge on the balance in part (c) if APR is 19.5 percent is arrived as below:

Value of Finance Charge = Average Daily Balance with New Purchases*APR*1/12 = 787*19.5%*1/12 = $12.78


Related Solutions

PLEASE DO BY HAND AND NOT EXCEL 1.A car dealer believes that average daily sales for...
PLEASE DO BY HAND AND NOT EXCEL 1.A car dealer believes that average daily sales for four different dealerships in four separate states are equal. A random sample of days results in the following data on daily sales: Ohio                New York       West Virginia              Pennsylvania                3                          10                         3                                  20                2                            0                         4                                  11                6                            7                         5                                  8                4                            8                                                             2                4                            0                                                             14                7...
Use the average daily balance method to compute the finance charge on the credit card account...
Use the average daily balance method to compute the finance charge on the credit card account for the month of August​ (31 days). The starting balance from the previous month is ​$300. The transactions on the account for the month are given in the table to the right. Assume an annual interest rate of 22​% on the account and that the billing date is August 1st. The finance charge for the month of August is $________? Date Transaction August 66...
Use the average daily balance method to compute the finance charge on the credit card account...
Use the average daily balance method to compute the finance charge on the credit card account for the previous month. The starting balance and transactions on the account for the month of April are given to the right. Assume an annual interest rate of​ 18%. ​Month: April​ (30 days); previous​ month's balance: $310 The finance charge is $_______? April 55 Charged ​$9898 for a coat April 1717 Made payment of ​$7070 April 2323 Charged ​$101101 for DVDs April 2828 Charged...
Use the average daily balance method to compute the finance charge on the credit card account...
Use the average daily balance method to compute the finance charge on the credit card account for the previous month. The starting balance and transactions on the account for the month of April are given to the right. Assume an annual interest rate of? 18%. ?Month: April? (30 days); previous? month's balance: ?$380 April 5 Charged ?$51 for a coat April 8 Made payment of ?$90 April 14 Charged ?$149 for DVDs April 29 Charged ?$29 for groceries The finance...
Use the average daily balance method to compute the finance charge on the credit card account...
Use the average daily balance method to compute the finance charge on the credit card account for the month of August​ (31 days). The starting balance from the previous month is ​$220. The transactions on the account for the month are given in the table to the right. Assume an annual interest rate of 17​% on the account and that the billing date is August 1st. The finance charge for the month of August is $___ . (Round to the...
Use the average daily balance method to compute the finance charge on the credit card account...
Use the average daily balance method to compute the finance charge on the credit card account for the month of August​ (31 days). The starting balance from the previous month is ​$290. The transactions on the account for the month are given in the table to the right. Assume an annual interest rate of 18​% on the account and that the billing date is August 1st. Date Transaction August 5 Made payment of ​$81 August 6 Charged ​$135 for hiking...
A car dealer believes that average daily sales for four different dealerships in four separate states...
A car dealer believes that average daily sales for four different dealerships in four separate states are equal. A random sample of days results in the following data on daily sales: Ohio                New York       West Virginia              Pennsylvania                3                          10                         3                                  20                2                            0                         4                                  11                6                            7                         5                                  8                4                            8                                                             2                4                            0                                                             14                7                2 Use ANOVA to test...
Calculate the average daily balance and finance charge: (Assume a 30-day billing cycle.) 4. 4/20 Billing...
Calculate the average daily balance and finance charge: (Assume a 30-day billing cycle.) 4. 4/20 Billing date previous balance $700 4/26 Payment 200 4/30 Charge 400 5/4 Payment 150 5/12 Cash advance 180 APR is 12%
Calculate average daily balance and finance charge. 6. 6. 29-day billing cycle 9/4 Balance $500 9/13...
Calculate average daily balance and finance charge. 6. 6. 29-day billing cycle 9/4 Balance $500 9/13 Payment 20 9/19 Charge 100 Finance charge is 2% of average daily balance
The credit card with the transactions described on the right uses the average daily balance method...
The credit card with the transactions described on the right uses the average daily balance method to calculate interest. The monthly interest rate is .5​% of the average daily balance. Calculate parts​ a-d using the statement on the right. Transaction Description Transaction Amount Previous​ balance, ​$6240.00 March 1 Billing date March 5 Payment ​$400.00 credit March 7​ Charge: Restaurant ​$50.00 March 12​ Charge: Groceries ​$70.00 March 21​ Charge: Car Repairs ​$260.00 March 31 End of billing period Payment Due​ Date:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT