Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 5R
To determine
Determine whether the formulae for Employee J work by providing the given inputs in the cumulative gross pay column.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.
Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2)
Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed,
compound. 4) In the "ANSWER" cell show us your TVM calculation.
Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an
LG2-Q8 emergency fund within one year (no additional payments).
What would the quarterly interest rate be needed to reach this goal?
Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card
LG2-Q9 by the end of the year. (future is a $0 balance)
What would be the monthly payment to reach this goal?
Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future
LG2-Q10 is a $0 balance)
How many months will it take to complete this goal?
in fuo (no
Compounding Number
(select from dropdown)
4
Compounding Number
(select from dropdown)
12
Compounding Number
(select from…
Click on the "Prepare Fin Sts" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score.
Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas for all dollar amounts.
The formula must only contain cell addresses.
Each correct formula will begin with =, +, or -.
The basic mathematical operators are +, -, * and /
Addition: To add the values in cells A1 and B4, the formula is =A1+B4
Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4
Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4
Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4
THIS FILE REQUIRES THE USE OF =SUM FOR ALL TOTALS AND SUBTOTALS
The =SUM function adds all values…
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
Similar questions
- 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.arrow_forwardComplete the formula to get the email address of Cardo Dalisay. *arrow_forwardI need the numbers for this accountarrow_forward
- Answer the following questions in a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Please respond to the following: You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in 26 equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. What is the present value of the payments you will receive? In your own words and using various bond websites, locate one of each of the following bond ratings: AAA, BBB, CCC, and D. Describe the differences between the bond ratings. Identify the…arrow_forwardRequired: Record the payment that Mookie The Beagle Concierge receives from Sandy Copper in payment for services provided Remy. 1. Create Receive Payment. a. From the Navigation Bar, select Projects > Sandy Copper: Remy b. From the Add to project menu, select Receive payment c. Select Payment Date: 01/23/2023 d. Select Payment Method: Check e. Select Deposit to: 1600 Undeposited Funds f. Select Invoice Number 1002 g. After selecting the Invoice, what is the Amount Received displayed? Note: Answer this question in the table shown below. Round your answer 2 decimal places. h. Select Save and close Amount received $ 2. View the Transaction Journal for Receive Payment. a. From the Navigation Bar, select Sales > All Sales tab b. From the Sales Transactions List, select the Sandy Copper: Remy payment just entered c. From the bottom of Receive Payment, select More > Transaction Journal d. What are the Account and Amount Debited? Debit Credit 20.00 Note: Answer this question in the table shown…arrow_forwardPlease help me answering this in DIRECT METHOD with schedule of T-ACCOUNTS. Thank you so much. I need to pass this tonightarrow_forward
- The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forwardI need help with requirement one and two. however, I am only allowed to upload two images per question.  even though I already turned us and I want to learn how to do the calculations correctly for the future. arrow_forwardI have pasted another pic which contains the question if this is what your asking. The pic I previously pasted was the answer on your website that I checked with monthly payment. It wasn't a big help because it was a screen shot of the spreadsheet and I couldn't check the funtions. So I would like to ask the exact funtion that I can't see in whole for columnB. And how 'i' in columnC is determined with those numbers. And also how the monthly payment in column F is calculated according to the table. ->I would like on overall description of Chapter 4 Question 132SE. You can deduct more questions if this is counted as multiple questions. But I would like to have a fast and accurate answer because I am in a bit of a hurry. Thank you.arrow_forward
- Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars.arrow_forwardHey there.The question is in the attached document. Can you please answer this question in a spreadsheet-like manner and show the formulas?It's only through the formulas that I can truly understand and learn from your work.Please note that the question has five subparts. If you want, please deduct five questions from my total amount of 30 questions to be asked.I am looking forward to hearing from you.arrow_forwardPlease look at the questions on the first picture and answer them on secound picture. thanks for your timearrow_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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning