Kelley_2020 annotated EOC Chapter 3_final

.xlsx

School

Paradise Valley Community College *

*We aren’t endorsed by this school

Course

ACC222

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by JudgePelicanPerson503

Excel Instructions: 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incor 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding func EXCEPTION: Continuing Payroll Problems A & B: When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calc Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by e =(Round(Weekly/40,2))*1.5 Where "Weekly" entered as either the weekly pay or cell reference. Failure to use the ROUND function will cause the OT rate to be incorrect. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can You can save the file to the current name, or you may want to keep multiple versions of your work by saving each succes To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolba It is recommended that you save the file to a new name that identifies the file as yours, such as Excel_End_of_Chapter_Pr To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. 4. Rounding : These templates have been formatted to round numbers to either the nearest whole number or the neare

rrect answer. ction. culating overtime rate. entering the formula n save your work at any time. ssive version under a different name. ar. roblems_Your_Name.xlsx est cent. For example,

Name: Steph Kelley Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear Student Work Area to the right of an incorrect answer. 3-1A Rite-Shop Employee No. Employee Name OASDI HI 711 Castro, Manny $ 1,000.00 $ 62.00 $ 14.50 512 Corrales, Pat 968.00 60.02 14.04 624 Guitar, Joseph 1,004.00 62.25 14.56 325 Moore, Connie 1,046.40 64.88 15.17 422 Morrison, Harry 1,200.00 74.40 17.40 210 Robertson, Catherine 1,044.80 64.78 15.15 Instructor Comment/Grade Area 111 Swarez, Joseph 1,122.00 69.56 16.27 Totals $ 7,385.20 $ 457.89 $ 107.09 Employer's OASDI $ 7,385.20 $ 457.88 Total Taxable Employer's OASDI Wages Tax Employer's HI Tax $ 7,385.20 $ 107.09 Total Taxable Employer's HI Wages Tax Biweekly Taxable Wages

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear Student Work Area to the right of an incorrect answer. 3-1B Wee-Ones Employee No. Employee Name OASDI HI 711 Adams, Jane $ 1,100.00 $ 68.20 $ 15.95 512 Candy, James 1,000.00 62.00 14.50 624 Guiterrez, Roberta 1,050.00 65.10 15.23 325 Harrison, Ken 1,250.00 77.50 18.13 422 Lowland, Harriet 1,600.00 99.20 23.20 210 Ranger, Ralph 1,310.50 81.25 19.00 Instructor Comment/Grade Area 111 Sweat, Rudy 1,419.45 88.01 20.58 Totals $ 8,729.95 $ 541.26 $ 126.59 Employer's OASDI $ 8,729.95 $ 541.26 Total Taxable Employer's OASDI Wages Tax Employer's HI Tax $ 8,729.95 $ 126.58 Total Taxable Employer's HI Wages Tax Biweekly Taxable Wages

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 3-5A a. November 15 Name and Title HI Tax Hanks,Timothy, President $156,000 $ 2,900.00 $ 179.80 $ 6,500.00 $ 94.25 Grath, John, VP Finance 138,000 5,750.00 356.50 5,750.00 83.38 James,Sally, VP Sales 69,600 2,900.00 179.80 2,900.00 42.05 Kimmel, Joan, VP Mfg. 54,000 2,250.00 139.50 2,250.00 32.63 Wie, Pam, VP Personnel 51,600 2,150.00 133.30 2,150.00 31.18 Grant, Mary, VP Secretary 49,200 2,050.00 127.10 2,050.00 29.73 b. December 31 Name and Title HI Tax Hanks,Timothy, President $156,000 $ 6,500.00 $ 94.25 Grath, John, VP Finance 138,000 650.00 40.30 5,750.00 83.38 James,Sally, VP Sales 69,600 2,900.00 179.80 2,900.00 42.05 Kimmel, Joan, VP Mfg. 54,000 2,250.00 139.50 2,250.00 32.63 Wie, Pam, VP Personnel 51,600 2,150.00 133.30 2,150.00 31.18 Grant, Mary, VP Secretary 49,200 2,050.00 127.10 2,050.00 29.73 Student Work Area Instructor Comment/Grade Area Annual Salary OASDI Taxable Earnings OASDI Tax HI Taxable Earnings Annual Salary OASDI Taxable Earnings OASDI Tax HI Taxable Earnings

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 3-5B a. November 15 Name and Title HI Tax Perez, Paul, President $153,600 $ 4,900.00 $ 303.80 $ 6,400.00 $ 92.80 Donald, Donna VP Finance 134,400 5,600.00 347.20 5,600.00 81.20 Funke, Jack, VP Sales 76,800 3,200.00 198.40 3,200.00 46.40 Weis, Al, VP Mfg. 92,400 3,850.00 238.70 3,850.00 55.83 Lang, Hope, VP Personnel 78,000 3,250.00 201.50 3,250.00 47.13 Lee, Amy, VP Secretary 52,800 2,200.00 136.40 2,200.00 31.90 b. December 31 Name and Title HI Tax Perez, Paul, President $153,600 $ 6,400.00 $ 92.80 Donald, Donna VP Finance 134,400 4,100.00 254.20 5,600.00 81.20 Funke, Jack, VP Sales 76,800 3,200.00 198.40 3,200.00 46.40 Weis, Al, VP Mfg. 92,400 3,850.00 238.70 3,850.00 55.83 Lang, Hope, VP Personnel 78,000 3,250.00 201.50 3,250.00 47.13 Lee, Amy, VP Secretary 52,800 2,200.00 136.40 2,200.00 31.90 Student Work Area Instructor Comment/Grade Area Annual Salary OASDI Taxable Earnings OASDI Tax HI Taxable Earnings Annual Salary OASDI Taxable Earnings OASDI Tax HI Taxable Earnings

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Questions

A chart of accounts would best be coded using a(n) ______________ coding scheme. a. alphabetic b. mnemonic c. block d. sequential

How do you make a two-dimensional columnar chart in excel?

All answers must be entered as a formula only. Please reference the correct cell(s) or the cell(s) value.

State the purpose for each of the following six built-in spreadsheet functions. (a) PV(i%, n, A, F) (b) FV(i%, n, A, P) (c) RATE(n, A, P, F) (d ) IRR(first_cell:last_cell) (e) PMT(i%, n, P, F) ( f ) NPER(i%, A, P, F)

What is the result of inputting lF(5>9,ok,error) into a cell? #NAME? ok error

Typing clearly urjent

Using the worksheet pictured below, assume the formula in c8 is =sum(c2:c4), if cell c8 is copied to d9 then the value displayed in d9 will be 1 2 23 4 A B 0 1 2 C 3 4 5 D 6 7 8

(a) In cell A6, type 1. Rather than copying the numbers 2 to 25, we can fill down based on the formula in cell A7 which is = A6+1. Locate A7 (Since this is where the formula begins) by clicking on the center of the cell. Go to the far lower right hand corner of cell A7 and hold down the left mouse button when you see the cursor change. Holding the left mouse button down, drag the cell down to year 40 and let go off the mouse button. Couple A opens a bank account and decides to deposit $1900.00 at the end of each year for 8 years in an account which earns 8% interest compounded annually for 40 years. Year 8 is the last time they deposit any money meaning there is no deposit value for years 9 to 40. Remember that the Interest column is for the Interest formula, do not just put in the interest rate. When the couple opens the bank account (the first year), there is no money in Beginning Balance. Set up your spreadsheet for Couple A accordingly. You should get $23572.47 for your ending…

All answers must be entered as a formula only. Please reference the correct cell(s) or the cell(s) value.

If the following pseudocode were an actual program, what would it display? Declare Integer a = 5 Declare Integer b = 2 Declare Integer c = 5 Declare Integer result Set result a % (b+c) Display result Select one: a. 21 b. 0 C. 5 d. 2

The letters in the screenshot aren't what they normally are, but: what are the names of each formula, what are they used for, and how are they used.

On the graph presented, match each element to its appropriate description. H B E (A Element Description Point A Area G Area C Line H Line I Area B Area F Axis E Axis D

I need answer typing clear urjent no chatgpt used i will give upvotes

Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items as listed in the feedback portion of the pictures. Note that the pictures are for the same problem, I have just included the separate feedback parts for specification purposes.

Using the diagram, answer the following questions:What do Symbols 1 and 2 represent?What does the operation involving Symbols 3 and 4 depict?What does the operation involving Symbols 4 and 5 depict?What does the operation involving Symbols 6, 8, and 9 depict?

Select the letter of the item below that best matches the definitions that follow. a. Data Files CD ________ b. Lists ________ c. Forms ________ d. Registers ________ e. Reports and graphs ________ f. Restoring a backup ________ g. Icon bar ________ h. Home page ________ i. Backing up a file ________ 1. One click access to QuickBooks Accountant Centers and Home page. 2. The process of rebuilding a backup file to a full QuickBooks Accountant file ready for additional input. 3. Electronic representations of paper documents used to record business activities such as customer invoices, vendor bills, and checks. 4. A big-picture approach of how your essential business tasks fit together organized by logical groups such as customers, vendors, and employees. 5. Groups of names such as customers, vendors, employees, items, and accounts. 6. Contains backups of all the practice files needed for chapter work and completion of assignments. 7. The process of creating a copy of a…

please solve with full working

Which of the following is a feature of Power Query?

Define the following term using 1 or 2 complete sentences (not just key words). ERP System

What combination of keys will autofill highlighted cells to the right?

All answers must be entered as a formula only. Please reference the correct cell(s) or the cell(s) value.

Match the two lists, below, by placing the capital letter from List 1 in each of the cells preceding the five descriptions in List 2 to which they best relate. One description in List 2 can be answered with 2 matches from List 1. Therefore, you should have 2 letters left over from List 1. List 1: Concepts A. Application (i.e., automated) control. B. Corrective control. C. Control environment. D. Input validity. E. Input completeness. F. Input accuracy G. Update completeness. H. Efficient use of resources. List 1: Capital letter List 2: Definitions/Descriptions 1. Insurance policy reimburses a company for losses due to a fire in a warehouse. 2. Shipping notices have a serial number that is tracked to ensure that they are all input. 3. Computer reviews each input to ensure that all the required data are included. 4. Inventory movements are tracked with a scanner to reduce manual counting. 5. Purchase orders are signed to approve the purchase.

Fill out the missing columns and show the calculation and formulas

Show how to insert formula in excel

help with this question please

What is the mode for the following data set: A,C,D,E,F,R,S,T,C,D,

← Assignment Worksheet- Formulas_-1892213908 Functions and Formulas Individual Assignment 1) Define a model 2) Define a function 3) Define a formula : ||

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:9781260013962

Author:BREALEY

Publisher:RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:9781337909730

Author:Brigham

Publisher:Cengage

Foundations Of Finance

Finance

ISBN:9780134897264

Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...

Finance

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...

Finance

ISBN:9780077861759

Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:McGraw-Hill Education

SEE MORE TEXTBOOKS