Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 21, Problem 2R
Open the file CASHBUD from the website for this book at cengagebrain.com. Enter the eight formulas where indicated on the worksheet. Enter your name in cell A1. Save the file as CASHBUD2. Print the worksheet when done. Also print your formulas. Check figure: Ending cash balance for April (cell E54), $7,772.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The end-of-the month balance in Igado’s cash disbursement journal “Sundry Account” column is P19,870. How will the column be posted and what is the posting reference will be entered?
Use the following items to prepare a balance sheet and a cash flow statement.
Determine the total assets, total liabilities, net worth, total cash inflows, and total cash
outflows. (Omit the "$" sign in your response.)
Rent for the month
Monthly take-home salary
Cash in chequing account
Savings account balance
Spending for food
Balance of educational loan
Current value of automobile
Telephone bill paid for month
Credit card balance
Loan payment
picture Click here for the Excel Data File
Total assets
Total liabilities
Net worth
Total cash inflows
Total cash outflows
$
$
$
$ 1,410
3,740
650
2,860
1,040
2,320
7,960
70
265
98
Auto insurance
Household possessions
Stereo equipment
Payment for electricity
Lunches/parking at work
Donations
Home computer
Value of stock investment
Clothing purchase
Restaurant spending
The following information relates the questions 18. 19, 20, 21 and 22. (Note: The following Information
will also be needed to answer questions no. 19, 20, 21 and 22. You may want to take a picture or write it
on a paper.)
A summary of the entries in the cash ledger account of Bulacan Gardens for the month of March 2019
showed the following:
Cash from Accounts:
P400,000
250,000
100,000
600,000
Receivables
Cash Sales
Dividend Received
Cash from Issue of Shares
Payments for Accounts
Payable
Payments of Wages
Purchase of Land
Payment of Dividends
Purchase of Service Vehicle
300,000
150,000
200,000
200,000
450,000
150,000
50,000
Payment of Taxes
Payment of Interest
18. How much were the receipts from customers of Bulacan Gardens?
a. P650,000
b. P250,000
c. P1,350,000
d. P400,000
19. How much were the payments to suppliers an employees of Bulacan Gardens?
a. P 150,000
b. P 550,000
с. Р 300.000
d. P 450,000
20. How much was the cash flow from the operating activities of Bulacan Gardens?
а. Р…
Chapter 21 Solutions
Excel Applications for Accounting Principles
Ch. 21 - On January 1, Sweet Pleasures, Inc., begins...Ch. 21 - Open the file CASHBUD from the website for this...Ch. 21 - Can the 10,000 note be repaid on May 1? Explain.Ch. 21 - Prob. 4RCh. 21 - The following four suggestions have been made to...Ch. 21 - Reset cells to their initial values. Sweet...Ch. 21 - Prob. 7R
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Catherines Cookies has a beginning balance in the Accounts Payable control total account of $8,200. In the cash disbursements journal, the Accounts Payable column has total debits of $6,800 for November. The Accounts Payable credit column in the purchases journal reveals a total of $10,500 for the current month. Based on this information, what is the ending balance in the Accounts Payable account in the general ledger?arrow_forwardHelp Save & EXit Assume that the custodian of a $450 petty cash fund has $59.50 in coins and currency plus $385.00 in receipts at the end of the month. The entry to replenish the petty cash fund will include: Multiple Choice A debit to Petty Cash for $385.00. A debit to Cash for $390.50. A credit to Cash for $390.50. here to search 5:03 PA 96% 3/7/202arrow_forwardYou have a checking account and a savings account at a credit union. Your checking account has a constant balance of $500. The table shows the total balance of the accounts over time. Total Year, t balance $2500 1 $2540 2 $2580.80 $2622.42 4 $2664.86 $2708.16 a. Write a function m that represents the balance of your savings account after t years. m(t) b. Write a function B that represents the total balance of the two accounts after t years. B(t) =arrow_forward
- Catherine's cookies has a beginning balance in the account payable control total account of $8,200. In the cash disbursements journal, the account payable column has total debits of $6,800 for November. The accounts payable credit column in the purchases journal reveals a total of $10,500 for the current month. Based on this information what is the ending balance in the accounts payable account in the general ledger?arrow_forwardCASH SHORT AND OVER ENTRIES Based on the following information, prepare the weekly entries for cash receipts from service fees and cash short and over. A change fund of 100 is maintained.arrow_forwardJul 2 Recommended to the owner, Jen Beck, that she put some of the cash into a Money Market account that will earn interest. Jen agrees. Create the general ledger account 1030 Money Market and transfer $7,000 into the account. Just tell me in quickbooks where do i record this transaction?bill (enter bills window)credit (enter bills window)bill pmt - check (pay bills window)check (write checks window)invoice (create invoices window)payment (receive payments window)sales receipt (enter sales receipts window)deposit (make deposit window)general journal (make general journal entries window)inventory adjust (adjust quantity/value on hand window)sales tax payment (pay sales tax window)paycheck (pay employees window)liability check (pay payroll liabilities window)transfer (transfer funds between accounts window)credit card charge (enter credit card charges window)credit memo (create credit memos/refunds window)discounts (receive payments window)arrow_forward
- The Crying Fish has a change fund of $300. Cash sales on August 10 per the cash register are $1,125. Cash on hand at the end of the day was $1,419.Prepare the August 10 entry. (Credit account titles are automatically indented when the amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit August 10arrow_forwardCatherine's cookies has a beginning balance in the accounts payable total account of $8,200. In the cash disbursements journal, the accounts payable column has total debits of $6,800 for november. The accounts payable credit column in the purchases journal reveals a total of $10,500 for the current . Based on this information what is the ending balance in the accounts payable account in the general ledger?arrow_forwardCatherine’s Cookies has a beginning balance in the Accounts Payable control total account of $8,200. In the cash disbursements journal, the Accounts Payable column has total debits of $6,800 for November. The Accounts Payable credit column in the purchases journal reveals a total of $10,500 for the current month. Based on this information, what is the ending balance in the Accounts Payable account in the general ledger? Record the following transactions in the sales journal: Jan. 15 Invoice # 325, sold goods on credit for $2,400, to Maroon 4, account # 4501 Jan. 22 Invoice #326, sold goods on credit for $3,500 to BTS, account # 5032 Jan. 27 Invoice #327, sold goods on credit for $1,250 to Imagine Fireflies, account # 3896arrow_forward
- Help Save A company's Cash account shows a balance of $3,410 at the end of the month. Comparing the company's Cash account with the monthly bank statement reveals several additional cash transactions such as bank service fees ($60), an NSF check from a customer ($330), a customer's note receivable collected by the bank $(1,500), and interest earned $(190). Prepare the necessary entries to adjust the balance of cash. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) View transaction list А Record the entries that increase cash. Record the entries that decrease cash. Credit Note : = journal entry has been entered %3D Record entry Clear entry View general journal EX:arrow_forwardAt the end of the day, the cash register tape lists $1,021.18 as total income from services. Cash on hand consists of $17.66 in coins, $749.91 in currency, $70.00 in traveler's checks, and $276.27 in customers' checks. The amount of the Change Fund is $100. Required: Record the entry to record the day's cash revenue. If an amount box does not require an entry, leave it blank.arrow_forwardAt the end of the day, the cash register tape lists $885.69 as total income from services. Cash on hand consists of $15.68 in coins, $459.77 in currency, $90.00 in traveler's checks, and $409.74 in customers' checks. The amount of the Change Fund is $100. Required: Record the entry to record the day's cash revenue. If an amount box does not require an entry, leave it blank. GENERAL JOURNAL PAGE DATE DESCRIPTION DOC. NO. POST. REF. DEBIT CREDIT Cash Cash Short and Over Income from Services To record revenue earned during the day involving a cash shortage of $10.50.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY