Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 3R
To make the worksheet reusable each month, the Social Security tax formulas should be designed to automatically compute whether (1) full tax is due. (2) no tax is due (e g., cumulative gross pay is over the ceiling), or (3) some tax is due. =IF statements will be required. The =ROUND function should be used for FORMULAS 1 through 3 to eliminate rounding errors. FORMULAS 4 and 5 should also use the =IF function. FORMULA2 has been provided for you below. Review Appendix A of Excel Quick and explain the meaning of each part of the formula.
- a.
- b.
- c.
- d.
- e.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The accountant wishes you to provide an analysis of the company’s annual operating expenses. Add an extra worksheet called “Expense analysis”, and add your 20Y3 data next to the given 20Y2 data.
You must link this new Expense Analysis table/worksheet (relevant cells in column “E”) with the respective data from your 20Y3 income statement. Do not hard code the 20Y3 data. Use appropriate formula to calculate the total expenses in cell E10, E12 and percentages in column F and G.
Select one of the following short-term (current) liabilties and describe some of the accounting requirements for recognizing/accounting for it:
Accounts Payable
Notes Payable
Payroll
Contingent Liabilites
Then describe how working capital, current ratio and quick ratio can be useful in making economic decisions. Who would be making these decisions?
2) Use the information above to complete the Aging of Accounts Receivable Schedule below.
Create a formula for cach age category, using the Excel IF and AND FUNCTIONS (fx) to determine wh
customer amount belongs.
The IF statement may include the following arguments: ,>=, <=, Excel AND FUNCTION (fx).
Chapter 10 Solutions
Excel Applications for Accounting Principles
Ch. 10 - Based on 2011 tax rates provided, use a calculator...Ch. 10 - You have been asked to record the November payroll...Ch. 10 - To make the worksheet reusable each month, the...Ch. 10 - Prob. 4RCh. 10 - Prob. 5RCh. 10 - In the space provided below, prepare the journal...Ch. 10 - In the space provided below, prepare the journal...Ch. 10 - Prob. 8RCh. 10 - Click the Chart sheet tab. On the screen is a...
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
- ALSO: Prepare the journal entry to record income taxes payable, deferred taxes, and income tax expense for 2020. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)arrow_forwardYou have established your performance materiality for accounts payable and revenue; now you must determine the posting materiality for individual items. The materiality judgement is at 4%. What is the posting materiality? Show your work. Your work should look like: APPROPRIATE AMOUNT x MATERIALITY JUDGEMENT = POSTING MATERIALITYarrow_forward(b) Prepare the journal entry to record income tax expense, deferred income taxes, and income taxes payable for 2025. (List all debit entries before credit entries. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts.) Account Titles and Explanation Debit Creditarrow_forward
- The revenue recognition principle states that all types of incomes should be recorded or recognized when: Cash is received At the end of the accounting period When they are earned When the interest is paidarrow_forwardFill in the blank Add up all Earned Income from all and "Wages, salaries, tips, etc.". Input all Unearned Income amounts from your Sum all Earned & Unearned Income to determine Total Income on Form 1040. then input this figure forarrow_forwardInsert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors. Thom-Pierre Consultants (TPC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold 460,000 **Selling and admin administrative 195,000 ***Computer (operating) **Depreciation 55,000 **Interest expense 25,200 Total expenses and losses Income before taxes Income tax expense (30%) Net Incomearrow_forward
- Calculate the income before income taxes and net income/less. Please show how you got your answer.arrow_forwardComplete the worsheet one section at a time, beginning with the Adjustments columns. For the Adjustments columns use the appropriate letters a. through d. as posting references. For the Income Statement and Balance Sheet columns, remember to include the net income or loss after the totals and then total the columns again. (If a box is not used in the worksheet, leave the box empty; do not enter a zero. Abbreviations used: Acc. = Acccumulated; Adj. = Adjusted; Depr. = Depreciation; Stmt. = Statement.) Mullen Co. Worksheet For Year Ended December 31, 201X Trial Balance Adjustments Account Dr. Cr. Dr. Cr. Cash 7 Accounts Receivable 3 Merchandise Inventory 9 Store Supplies 7 Store Equipment 20 Acc. Depr., Store Equipment…arrow_forwardIn 2023, Windsor Ltd., which follows IFRS, reported accounting income of $1,130,000 and the 2023 tax rate was 20%. Windsor had two timing differences for tax purposes: CCA on the company's tax return was $512,000. Depreciation expense on the financial statements was $308,000. These amounts relate to assets that were acquired on January 1, 2023, for $2,048,000. Accrued warranty expense for financial statement purposes was $140,600 (accrued expenses are not deductible for tax purposes). This is the first year Windsor offers warranties. Both of these timing differences are expected to fully reverse over the next four years, as follows: Year 2024 2025 2026 2027 Depreciation Difference $70,500 57,500 40,500 35,500 Warranty Expense Rate $20,500 20% 29,900 20% 39,600 18% 50,600 18% $204,000 $140,600arrow_forward
- could please explain the solution steps of Pro Forma Balance Sheet Provincial Imports, Inc. for Next Year (Judgmental Method) for example how can I find account payable taxes payable notes payable.....arrow_forwardSkysong Corp. sold an investment on an installment basis. The total gain of $74,400 was reported for financial reporting purposes in the period of sale. The company qualifies to use the installment-sales method for tax purposes. The installment period is 3 years; one-third of the sale price is collected in the period of sale. The tax rate was 40% in 2020, and 20% in 2021 and 2022. The 20% tax rate was not enacted in law until 2021. The accounting and tax data for the 3 years is shown below. Financial Accounting Tax Return 2020 (40% tax rate). Income before temporary difference $86,800 $86,800 Temporary difference 74,400 24,800 Income $161,200 $111,600 2021 (20% tax rate) Income before temporary difference $86,800 $86,800 Temporary difference 24,800 Income $86,800 $111,600 2022 (20% tax rate). Income before temporary difference $86,800 $86,800 Temporary difference 24,800 Income $86,800 $111,600 Calculate cumulative temporary differences for years 2020-2022. (Negative amounts using…arrow_forwardYou are the new accounting manager at the Barry Transport Company. Your CFO has asked you to provide input on the company's income tax position based on the following: 1. Pretax accounting income was $70 million and taxable income was $8 million for the year ended December 31, 2018. 2. The difference was due to three items: a. Tax depreciation exceeds book depreciation by $60 million in 2018 for the business complex acquired that year. This amount is scheduled to be $80 million in 2019 and to reverse as ($70 million) and ($70 million) in 2020, and 2021, respectively. b. Insurance of $8 million was paid in 2018 for 2019 coverage. C. A $6 million loss contingency was accrued in 2018, to be paid in 2020. 3. No temporary differences existed at the beginning of 2018. 4. The tax rate is 40%. Required: 1. Determine the amounts necessary to record income taxes for 2018 and prepare the appropriate journal entry. 2. Assume the enacted federal income tax law specifies that the tax rate will…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
What Is And How To Calculate FICA Taxes Explained, Social Security Taxes And Medicare Taxes; Author: Whats Up Dude;https://www.youtube.com/watch?v=fzK3KDDYCQw;License: Standard Youtube License