B D E Your revolving account is charged 21% APR. The finance charge is computed using the
Fantastic news! We've Found the answer you've been seeking!
Question:
Please help with formulas needed, to check my work.
Transcribed Image Text:
12 A B E Your revolving account is charged 21% APR. The finance charge is computed using the 3 average daily balance. Compute the new balance. 4 5 Billing cycle 6 Previous Balance on Apr. 1 7 Charge on Apr. 5 8 Charge on Apr. 15 9 Payment on Apr. 21 IU 11 Activity 12 Previous Balance 13 Charge 14 Charge 15 Payment 16 Total 17 18 1-May April 1-30 $631.21 APR 21% Monthly Rate 1.75% $42.00 $68.13 $300.00 Number Dates of Days Unpaid Balance Daily Balance Average Daily Balance Finance Charge New Balance 19 20 21 Directions: 22 a. Fill in the Dates in Cells B12 through B15. 23 24 b. In Cells C12 through C15, enter a formula to calculate the Number of Days for each Activity. c. In Cell C16, enter a formula to calculate the Total Number of Days in the billing cycle. 25 d. In Cell D12 enter a formula to place the Previous Balance in the cell. 26 e. In Cells D13 through D15, enter formulas to calculate the Unpaid Balance. 27 f. In Cells E12 through E15, enter formulas to calculate the Daily Balance. 28 g. In Cell E16, enter a formula to calculate the Total Daily Balance. 29 h. In Cell E17, enter a formula to calculate the Average Daily Balance. 30 i. In Cell E18, enter a formula to calculate the Finance Charge. 31 j. In Cell E19, enter a formula to compute the New Balance. 12 A B E Your revolving account is charged 21% APR. The finance charge is computed using the 3 average daily balance. Compute the new balance. 4 5 Billing cycle 6 Previous Balance on Apr. 1 7 Charge on Apr. 5 8 Charge on Apr. 15 9 Payment on Apr. 21 IU 11 Activity 12 Previous Balance 13 Charge 14 Charge 15 Payment 16 Total 17 18 1-May April 1-30 $631.21 APR 21% Monthly Rate 1.75% $42.00 $68.13 $300.00 Number Dates of Days Unpaid Balance Daily Balance Average Daily Balance Finance Charge New Balance 19 20 21 Directions: 22 a. Fill in the Dates in Cells B12 through B15. 23 24 b. In Cells C12 through C15, enter a formula to calculate the Number of Days for each Activity. c. In Cell C16, enter a formula to calculate the Total Number of Days in the billing cycle. 25 d. In Cell D12 enter a formula to place the Previous Balance in the cell. 26 e. In Cells D13 through D15, enter formulas to calculate the Unpaid Balance. 27 f. In Cells E12 through E15, enter formulas to calculate the Daily Balance. 28 g. In Cell E16, enter a formula to calculate the Total Daily Balance. 29 h. In Cell E17, enter a formula to calculate the Average Daily Balance. 30 i. In Cell E18, enter a formula to calculate the Finance Charge. 31 j. In Cell E19, enter a formula to compute the New Balance.
Expert Answer:
Answer rating: 100% (QA)
Heres a revised version of the formulas for the given scenario a Fill in the Dates in Cells B12 thro... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
Who was the petitioner? Who was the respondent? b. In what year was the case heard? c. What tax years did the case address? d. Who was the judge in the case? e. What was the basic issue in the case?...
-
Dinoco Petroleum faces three potential contingency situations, described below. Dinoco's fiscal year ends December 31, 2012, and it issues its 2012 financial statements on March 15, 2013. Required:...
-
A cell site is a site where electronic communications equipment is placed in a cellular network for the use of mobile phones. The numbers y of cell sites from 1985 through 2014 can be modeled by y =...
-
What are some of the main features of economic inequality in the United States?
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
A party was held to celebrate the bicentennial of Clarksville, the county seat of Caroline County. Six-hundred attendees were estimated, but 700 arrived. The food and entertainment budget was $6,000,...
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
Q23. Write a Servlet Program that uses two filters i) ii) Authentication Filter: Checks authentication value (userid/password) Config Param Filter: Checks value of config param in web.xml
-
Simulate a tally counter that can be used to admit a limited number of people. First, the limit is set with a call public void setLimit(int maximum) If the click button is clicked more often than the...
-
In the Java library, a color is specified by its red, green, and blue components between 0 and 255 (see Table 4 on page 57). Write a program BrighterDemo that constructs a Color object with red,...
-
Write a program that fills the window with a large ellipse, with a black outline and filled with your favorite color. The ellipse should touch the window boundaries, even if the window is resized....
-
The StringBuilder class has a method for reversing a string. In a ReverseTester class, construct a StringBuilder from a given string (such as "desserts"), call the reverse method followed by the...
-
Show that the BankAccount(double initialBalance) constructor is not strictly nec essary. That is, if we removed that constructor from the public interface, how could a programmer still obtain...
-
A research organization releases a story about the results of a survey they conducted on whether or not people approve of their government. What type of data source are these results based on?
-
Prove that if Σ an is absolutely convergent, then a. an
-
1. Identify the primary goals of monetary asset management. 2. Explain the circumstances when it would be appropriate to have funds in a checking account, a saving account, or in investments. 3....
-
(a) In what way does Nicoles return to school alter the Greenwoods life insurance needs? (b) Would you agree that the amount of life insurance provided by the Greenwoods respective employers is...
-
1. Distinguish among financial success, financial security, and financial happiness. 2. Explain the five fundamental steps in the financial planning process. 3. What are the building blocks to...
-
A river barge, whose cross section is approximately rectangular, carries a load of grain. The barge is \(28 \mathrm{ft}\) wide and \(90 \mathrm{ft}\) long. When unloaded, its draft (depth of...
-
A barge is \(40 \mathrm{ft}\) wide by \(120 \mathrm{ft}\) long. The weight of the barge and its cargo is denoted by \(W\). When in salt-free riverwater, it floats \(0.25 \mathrm{ft}\) deeper than...
-
A 1-ft-diameter, 2-ft-long cylinder floats in an open tank containing a liquid having a specific weight \(\gamma\). A U-tube manometer is connected to the tank as shown in Fig. P2.142. When the...
Study smarter with the SolutionInn App