Business, 26.01.2021 03:20 valeriegarcia12

Superior Printing, Inc. has provided its June bank statement and Cash T-account. The Controller has asked you to prepare the Bank Reconciliation at June 30 using the information from the bank statement and T-account. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B6" was entered, the formula would output the result from cell B6, or 440 in this example.
Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=B6+B7" was entered, the formula would add the values from those cells and output the result, or 1640 in this example. If using the other math symbols the result would output an appropriate answer for its function.

Answers: 3

Show answers

Other questions on the subject: Business

Business, 21.06.2019 18:10, diamondk2019

In a sumif conditional function, what should be the order of terms in the parentheses?

Answers: 1

continue

Business, 21.06.2019 19:50, elijahbebeastin

One investigating company tracked all credit card purchase during 2012 and measured two variables: (1) the type of credit card used (visa, mastercard, american express, or discover), and (2) the amount (in dollars) of each purchase. identify the level of each variable measured.

Answers: 1

continue

Business, 22.06.2019 06:20, karankhatri1946

James albemarle created a trust fund at the beginning of 2016. the income from this fund will go to his son edward. when edward reaches the age of 25, the principal of the fund will be conveyed to united charities of cleveland. mr. albemarle specified that 75 percent of trustee fees are to be paid from principal. terry jones, cpa, is the trustee. james albemarle transferred cash of $500,000, stocks worth $400,000, and rental property valued at $250,000 to the trustee of this fund. immediately invested cash of $360,000 in bonds issued by the u. s. government. commissions of $7,900 are paid on this transaction. incurred permanent repairs of $9,000 so that the property can be rented. payment is made immediately. received dividends of $8,000. of this amount, $3,000 had been declared prior to the creation of the trust fund. paid insurance expense of $4,000 on the rental property. received rental income of $10,000. paid $8,000 from the trust for trustee services rendered. conveyed cash of $7,000 to edward albemarle.

Answers: 2

continue

Business, 22.06.2019 14:20, Champion9701

For the year ended december 31, a company has revenues of $323,000 and expenses of $199,000. the company paid $52,400 in dividends during the year. the balance in the retained earnings account before closing is $87,000. which of the following entries would be used to close the dividends account?

Answers: 3

continue

You know the right answer?

Superior Printing, Inc. has provided its June bank statement and Cash T-account. The Controller has...