My Bank Acct - Xcel - INSTRUCTIONS: 1. You will make a 2 month Xcel Account...
My Bank Acct - Xcel -
INSTRUCTIONS:
1. You will make a 2 month Xcel Account for your banking transactons.
2. Each month will have at least 1 Credit and 4 Debits.
4. You must use formulas to get the balance.
5. Use Green for the Credit Title. Use Yellow for the Debit title
Homework Answers
| Bank of America | |||
| MR. ABC | |||
| Statement From: 01/01/2020 to 02/28/2020 | Opening Balance | ||
| 10,000 | |||
| Date | Debit | Credit | Closing Balance |
| 01-04-2020 | 15 | 9,985 | |
| 01-08-2020 | 1,400 | 11,385 | |
| 01-10-2020 | 63 | 11,322 | |
| 01-16-2020 | 1,965 | 9,357 | |
| 01-22-2020 | 4,884 | 4,473 | |
| 02-02-2020 | 5,000 | 9,473 | |
| 02-07-2020 | 1,200 | 8,273 | |
| 02-13-2020 | 1,650 | 6,623 | |
| 02-19-2020 | 870 | 5,753 | |
| 02-26-2020 | 1,875 | 3,878 | |
| STATEMENT SUMMARY:- | Debits | Credits | Closing Balance |
| 12,522 | 6,400 | 3,878 | |
| Dr Count | Cr Count | ||
| 8 | 2 |
Add Answer to:
My Bank Acct - Xcel -
INSTRUCTIONS:
1. You will make a 2 month Xcel Account...
My Bank Acct - Xcel - INSTRUCTIONS: 1. You will make a 2 month Xcel Account...
My Bank Acct - Xcel - INSTRUCTIONS: 1. You will make a 2 month Xcel Account for your banking transactons. 2. Each month will have at least 1 Credit and 4 Debits. 3. Use the Xcel template that we made in class. 4. Use Green for the Credit Title. Use Yellow for the Debit title 5. Upload the Xcel Account to Blackboard by
Determine how long it will take to accumulate at least $20,000 in a bank account if...
Determine how long it will take to accumulate at least $20,000
in a bank account if you deposit $250 initially, $1200 at the end
of each year and the account pays 5% annual interest. Highlight the
year that this takes place and final amount in your account at that
time in yellow and create an XY graph identical to the one shown.
You must use formulas and absolute and relative referencing to
complete this problem. Make your EXCEL sheet look...
Journal entry worksheet On March 1, Glenn Corporation borrows $25,000 from the bank. Note: Enter debits...
Journal entry worksheet On March 1, Glenn Corporation borrows $25,000 from the bank. Note: Enter debits before credits. Date Account Title Debit Credit March 01 Journal entry worksheet On April 7, Carlton Company purchases supplies for $600 cash. Note: Enter debits before credits. Date Account Title Debit Credit April 07 Journal entry worksheet On January 5, Fairbanks Corporation provides services on account to customers totaling $10,000. Note: Enter debits before credits. Account Title Debit Credit Date January 05 Journal entry...
Project 1 2 Instructions: 4 Project 1 in eCampus requires you to record transactions, prepare the...
Project 1 2 Instructions: 4 Project 1 in eCampus requires you to record transactions, prepare the financial statements and answer questions based on these transactions. in theyellow cells, you are required to record the transactions in the accounting equation below and prepare thefinancial statements in the worksheet titled 'Statements" before entering your answers into eCampus This must beyour own work; working with others is considered academic dishonesty. Shareholder's Equity During April, its first month ofbusiness, Honest Tea, Inc. Liabilities Cosh...
Make adjusting journal entries. 2. The deposits to the bank account, as recorded on the bank...
Make adjusting journal entries.
2. The deposits to the bank account, as recorded on the bank statement, are compared to the deposit slips retained by the company. It is noted that the last deposit, of $760, occurred after banking hours on the day of the bank statement and therefore has not been recorded by the bank on this bank statement. 3. Checks returned with the bank statement are compared to the checks written and listed in checkbook. This comparison shows...
Part Four Instructions In this part of the practice set, the student will prepare a Bank...
Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Start by using the ending balance in your cash account for the cash for your books and the ending balance on the bank statement for the bank balance. ACCOUNTING SOCIETY Requirements 1. Correct Errors: Correct any errors that you made on the journal entries. Both the debits and the credits must equal each other. 2. Bank Reconciliation: Using...
2021 May 1 Received a $3,000, 12-month, 6% note in exchange for an outstanding account receivable...
2021 May 1 Received a $3,000, 12-month, 6% note in exchange for an outstanding account receivable from R. Stoney. Dec. 31 Accrued interest revenue on the R. Stoney note. 2022 May 1 Received principal plus interest on the R. Stoney note. (No interest has been accrued since December 31, 2021.) Record the transactions in the general journal. The company does not make entries to accrue interest except at December 31.(Credit account titles are automatically indented when amount is entered. Do...
On April 1, Carla Vista Company borrows $110,000 from West Bank by signing a 6-month, 8%,...
On April 1, Carla Vista Company borrows $110,000 from West Bank
by signing a 6-month, 8%, interest-bearing note.
Prepare the necessary entries below associated with the note
payable on the books of Carla Vista Company.
Prepare the entry on April 1 when the note was issued.
(Credit account titles are automatically indented when
the amount is entered. Do not indent manually.)
Date
Account Titles and Explanation
Debit
Credit
April 1
enter an account title
enter a debit amount
enter a...
You agree to make 24 deposits of $500 at the beginning of each month into a...
You agree to make 24 deposits of $500 at the beginning of each month into a bank account. At the end of the 24th month, you will have $13,000 in your account. If the bank compounds interest monthly, what nominal annual interest rate will you be earning? a) Use the formula and explain all your work. b) Use the financial calculator and explain what number you used to get final answer.
The December bank statement and cash T-account for Stewart Company follow: BANK STATEMENT Checks Deposits Balance...
The December bank statement and cash T-account for Stewart Company follow: BANK STATEMENT Checks Deposits Balance Date Other 60,000 52,280 79,630 60,730 97,730 97,080 89,480 89,580 89,330 Dec. 1 $7,720 650 $28,000 18,900 11 17 23 37,000 26 650 $400 19,000 30 26,200 NSF* 31 Interest earned 100 Service charge 250 31 NSF check from J. Left, a customer. Cash (A) Dec. 1 Balance 60,000 Deposits Checks written during December: 7,720 650 Dec. 11 28,000 37,e00 19,000 14,00e 23 18,900...
Determine how long it will take to accumulate at least $20,000
in a bank account if you deposit $250 initially, $1200 at the end
of each year and the account pays 5% annual interest. Highlight the
year that this takes place and final amount in your account at that
time in yellow and create an XY graph identical to the one shown.
You must use formulas and absolute and relative referencing to
complete this problem. Make your EXCEL sheet look...
Journal entry worksheet On March 1, Glenn Corporation borrows $25,000 from the bank. Note: Enter debits before credits. Date Account Title Debit Credit March 01 Journal entry worksheet On April 7, Carlton Company purchases supplies for $600 cash. Note: Enter debits before credits. Date Account Title Debit Credit April 07 Journal entry worksheet On January 5, Fairbanks Corporation provides services on account to customers totaling $10,000. Note: Enter debits before credits. Account Title Debit Credit Date January 05 Journal entry...
Project 1 2 Instructions: 4 Project 1 in eCampus requires you to record transactions, prepare the financial statements and answer questions based on these transactions. in theyellow cells, you are required to record the transactions in the accounting equation below and prepare thefinancial statements in the worksheet titled 'Statements" before entering your answers into eCampus This must beyour own work; working with others is considered academic dishonesty. Shareholder's Equity During April, its first month ofbusiness, Honest Tea, Inc. Liabilities Cosh...
Make adjusting journal entries.
2. The deposits to the bank account, as recorded on the bank statement, are compared to the deposit slips retained by the company. It is noted that the last deposit, of $760, occurred after banking hours on the day of the bank statement and therefore has not been recorded by the bank on this bank statement. 3. Checks returned with the bank statement are compared to the checks written and listed in checkbook. This comparison shows...
Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Start by using the ending balance in your cash account for the cash for your books and the ending balance on the bank statement for the bank balance. ACCOUNTING SOCIETY Requirements 1. Correct Errors: Correct any errors that you made on the journal entries. Both the debits and the credits must equal each other. 2. Bank Reconciliation: Using...
On April 1, Carla Vista Company borrows $110,000 from West Bank
by signing a 6-month, 8%, interest-bearing note.
Prepare the necessary entries below associated with the note
payable on the books of Carla Vista Company.
Prepare the entry on April 1 when the note was issued.
(Credit account titles are automatically indented when
the amount is entered. Do not indent manually.)
Date
Account Titles and Explanation
Debit
Credit
April 1
enter an account title
enter a debit amount
enter a...
The December bank statement and cash T-account for Stewart Company follow: BANK STATEMENT Checks Deposits Balance Date Other 60,000 52,280 79,630 60,730 97,730 97,080 89,480 89,580 89,330 Dec. 1 $7,720 650 $28,000 18,900 11 17 23 37,000 26 650 $400 19,000 30 26,200 NSF* 31 Interest earned 100 Service charge 250 31 NSF check from J. Left, a customer. Cash (A) Dec. 1 Balance 60,000 Deposits Checks written during December: 7,720 650 Dec. 11 28,000 37,e00 19,000 14,00e 23 18,900...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago