Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows: a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell Gs, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

You are attending college in the fall and you need to purchase a computer. you must finance the purchase because your parents will not purchase it for you, and you do not have the cash on hand to purchase it. in blank #1 determine which type of credit would you use to finance your purchase (installment, non-installment, or revolving credit). (2 points) in blank #2 defend your credit choice by explaining why your financing option is the best option for you. (2 points) in blank #3 explain why you selected that credit option over the other two options available. (2 points)

Determining effects of stock splits oracle corp has had the following stock splits since its inception. effective date split amount october 12, 2000 2 for 1 january 18, 2000 2 for 1 february 26, 1999 3 for 2 august 15, 1997 3 for 2 april 16, 1996 3 for 2 february 22, 1995 3 for 2 november 8, 1993 2 for 1 june 16,1989 2 for 1 december 21, 1987 2 for 1 march 9, 1987 2 for 1 a. if the par value of oracle shares was originally $2, what would oracle corp. report as par value per share on its 2015 balance sheet? compute the revised par value after each stock split. round answers to three decimal places.

John and daphne are saving for their daughter ellen's college education. ellen just turned 10 at (t = 0), and she will be entering college 8 years from now (at t = 8). college tuition and expenses at state u. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. ellen should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11).so far, john and daphne have accumulated $15,000 in their college savings account (at t = 0). their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t = 1, 2, 3, and 4). then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. they expect their investment account to earn 9%. how large must the annual payments at t = 5, 6, and 7 be to cover ellen's anticipated college costs? a. $1,965.21b. $2,068.64c. $2,177.51d. $2,292.12e. $2,412.76