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
Question
Chapter 21, Problem 7R
81565-P21-7R
To determine
Prepare a chat that shows the relationship between monthly units sales, unit purchase and ending cash balance and determine the ending cash balance if the purchases on January reduced to 2,200 units.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Directions: Read each senterce carefully and determine whether the statement is TRUE or FALS E. Write
your answers on the space provided before each number.
1. At the beginning of the day, you have P200 cash in your pocket. At the end of the day,
you have P50 left. If you make a horizontal analysis of your cash, you would conclude that your cash has
decreased by 80% during the day.
2. In 2019, Entity A reported sales of P100 and profit of P20. In a vertical analysis, a
financial statement user would conclude that Entity A was able to generate 20% profit from every peso of
its sales during the period.
3. Entity A reported irventory balances of P100 and P50 in 2019 and 2018, respectively.
In a horizontal analysis, a financial statement user would conclude that Entity A's inventory has increased
by 50% from2018 to 2019.
4. An analysis of the intenelationships of infomation in a single period, expressed as
parcentages of a common denomirator, is called horizortal analysis.
5. A comparison…
Find the monthly revenue 1 month and 4 months after the online store opened. Record the value in the table. Round to the nearest whole dollar.
This question is for business math.
Complete the following (If more than one discount, assume date of last discount) (Assuming February will have 28 days.)
Invoice: Terms: Last day of discount period:
August 10th 2/10, 1/30, n/60
Final day bill is due:
I need the last day of discount period and the final day the bill is due but I dont know how to figure it out. Please explain this to me. I also dont know where the n/60 comes from, can you explain that when you explain how to do the problem?
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
- F SUM of Outstanding balance Status Customer C1003 C1004 C1006 C1010 C1012 C1013 C1026 C1028 C1029 C1036 C1037 C1045 C1048 C1051 G C1055 C1057 C1058 C1061 C1066 C1069 C1075 C1076 C1082 C1085 Grand Total H 0-Not Yet Due 30831 30831 I 1-30 Days 25579 3156 2353 31088 J 11791 26748 31-60 Days 61-90 Days 90+ Days 9367 10460 29297 K 25315 103611 25245 24713 L 49958 4115 1659 18793 12116 22957 20307 7791 30907 12102 12235 22997 25366 200712 M Grand Total 9367 25245 30831 24713 11791 26748 4115 1659 18793 10460 12116 22957 20307 25579 7791 3156 30907 12102 12235 2353 22997 29297 25366 25315 416200 Narrow_forwardCatherines 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_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
- Prepare the following journal entries. a. sales on account are $ 8,200. b.customer returns $ 1,200.arrow_forwardBased on the account balances shown below, calculate "Net Sales". Normal Account Balance Account Name Allowance for Uncollectible $5,000 A/R Deferred Revenue $15,725 Sales Revenue $114,139 Sales Discounts $2,000 Sales Returns $6,000 Fill in the blank with your calculated number. DO NOT include period, decimal points, etc., just enter the raw number. Webcourses will add commas to your nmas, $ sig answer automatically. For example, if you calculated the answer to be $24,123, you would only input: 24123 ASUS f3 f4 f5 f6 f7 f8 f9 f10 f11 口/東 %24 3 5 7 9. 01 因 LO 图arrow_forwardUse 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 spendingarrow_forward
- A household savings-account spreadsheet shows the following entries for the first day of each month: Month January February March April May June July August Additions Withdrawals Value 148,000 2,500 4,000 1,500 13,460 3,000 23,000 198,000 Required: Use the Excel function XIRR to calculate the dollar-weighted average return for this period. (Round your answer to 2 decimal places.) Dollar-weighted average Answer is complete but not entirely correct. 70.01%arrow_forwardYou have a credit card with an APR of 15%. You begin with a balance of $800. In the first month you make a payment of $300 and you make charges amounting to $100. In the second month you make a payment of $200 and you make new charges of $500. Determine all values in the given table. (Enter all answers to the nearest cent.) Month 1 Month 2 Previous Balance mil m21 Payments m12 m22 Purchases m13 M23 Finance Charge m14 m24 New Balance m15 m25arrow_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
- Analyze each situation given below and indicate which type of receivable it produces. (Choose one of the options provided in the drop down menu). - A company paid the salary to one of its employees in advance, at the beginning of the month { notes receivable, other receivable, accounts receivable, no receivable}. - A merchandies company sold goods to a customer abd cash was received one month before the items delivery { notes receivable, other receivable, accounts receivable, no receivable}. - A service company performed a service for a customer and cash was received one week before the service { notes receivable, other receivable, accounts receivable, no receivable}. - A merchandise company sold goods to a customer and cash was received at items delivery { notes receivable, other receivable, accounts receivable, no receivable}. - A service company performed a service for a customer and cash was received immediately after the service { notes receivable, other receivable, accounts…arrow_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_forwardPrepare a schedule of expected cash collections from sales by month and in total for quater 2. Whats hs the accounts receivable balance on june 30? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.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 Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College