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 solutionStudents have asked these similar questions
fast
Please do not give solution in image format thanku
Create a two-variable data table as follows to provide the comparison that Liam requests:
a)In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Liam wants to compare the monthly payments.
b) Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.
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_forwardCreate a chart that would show the fluctuation of revenue throughout the month. Put a note in the worksheet stating which day of the month has the highest sale show the solution using excelarrow_forwardCan I get some help on this table, thank you!arrow_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_forwardA 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_forward
- 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 spendingarrow_forwardPart of your job is to review customer requests for credit. You have three new credit applications on your desk and part of your analysis requires that the current ratlos and quick ratlos be compared.arrow_forwardPart of your job is to review customer requests for credit. You have three new credit applications on your desk and part of your analysis requires that the current ratios and quick ratios be compared a. Complete the following schedule. (Round the final answers to 2 decimal places.) Account Cash Current non-strategic investments Current receivables Inventory Prepaid expenses Land Current liabilities Current ratio Quick ratio $ $ S $ $ $ $ Kasta 3.900 0 4,320 2,900 460 5,550 3,780 4 1 $ $ $ $ $ $ $ Nasta 1,640 0 1,740 1,610 930 6,380 2,410 $ S $ $ $ 5 5 Dusta 3,300 1,300 310 14,530 4720 25.750 11,080arrow_forward
- The days' sales uncollected ratio is used to: Measure how many days of sales remain until the end of the year. Determine the number of days that have passed without collecting on accounts receivable. Identify the likelihood of collecting sales on account. D. Estimate how much time is likely to pass before the amount of accounts receivable is collected.arrow_forwardBased on the following data for the current year, what is the number of days' sales in receivable? Net sales on account during year $498,171 Cost of goods sold during year 163,215 Accounts receivable, beginning of year 42,207 Accounts receivable, end of year 51,640 Inventory, beginning of year 92,904 Inventory, end of year 119,969 Round your answer up to the nearest whole day. Select the correct answer. 88 days 78 days 120 days 34 daysarrow_forwardRESOLVE THIS PROBLEM IN DIGITAL FORMAT (NOT HANDWRITTEN) Solve the following problem step by step, include the formulas you use and the development pleasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
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
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,