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 15, Problem 2R
The comparative financial statements of Global Technology are as follows:
Open the file RATIOA from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells. Enter your name in cell A1. Save the completed model as RATIOA2. Print the worksheet when done. Also print your formulas. Check figure: Acid test (quick) ratio (cell C58), .82.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
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.
Further info is in the attached images
For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B34 enter the formula "= B9".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50.
Thank you!
Chapter 15 Solutions
Excel Applications for Accounting Principles
Ch. 15 - The comparative financial statements of Global...Ch. 15 - The comparative financial statements of Global...Ch. 15 - a. What information does a comparison of the...Ch. 15 - Prepare a ratio analysis for Global Technology for...Ch. 15 - Compare your printout from requirement 2 with your...Ch. 15 - With the 2013 data still on the screen, click the...
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
- Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver parameters, (i optimal solution. Partial credit is available. The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to 4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table. Time Period Minimum No. of Tellers 8:00 AM - 10:00 AM 10:00 AM - 12:00 PM 12:00 PM - 2:00 PM 10 15 2:00 PM - 4:00 PM 12 Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8 per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…arrow_forwardRequired information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…arrow_forwardPlease note: You can draw your trees either by hand on paper or in Excel. If you do it on a paper, please take a picture of the tree and insert it in your solution file. You can submit your solution as an Excel file or Word document. In either case, your solution should contain your decision trees and all necessary calculations (not just the results of calculations). Problem 1. The WHN Company Problem. The WHN Company is going to introduce one of the three new products: a widget, a hummer, or a nimnot. The market condition could be favorable, stable, or unfavorable with the probabilities 0.2, 0.5, and 0.3 respectively. The monetary outcomes for each product under each condition are described in the following table: Unfavorable $120,000 $70,000 -875,000 $40,000 $20,000 $30,000 $30,000 Favorable Stable Widget Hummer $60,000 Nimnot $35,000 Create a decision tree to identify which new product should be introduced in order to maximize the company's profit?arrow_forward
- For the following five spreadsheet functions, (a) write the values of the engineering economy symbols P, F, A, i, and n, using a ? for the symbol that is to be determined, and (b) state whether the displayed answer will have a positive sign, a negative sign, or it can’t be determined from the entries. (1) = FV(8%, 10, 3000, 8000) (2) = PMT(12%, 20, –16000) (3) = PV(9%, 15, 1000,600) (4) = NPER(10%, –290,, 12000) (5) = FV(5%, 5, 500, –2000)arrow_forward1. Choose three of the following five technologies/techniques and explain why you think it is helpful in accounting analytics based on your lab experience in this course. Use some examples in your explanation. Limit your answer to 500 words in total. A. XBRL B. Tableau C. VLOOKUP function D. Pivot table E. Regressionarrow_forwardWhat are the Microsoft Excel formulaues used to input these? Is there a way to show each formula for how you came up with these. Not just the ratios but what you would input into excel that would automatically calculate the correct answers?arrow_forward
- Please see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.arrow_forwardGIVEN THE FOLLOWING DATA, COMPUTE FOR THE FOLLOWING: 1. STRAIGHT LINE METHOD 2. ARITHMETIC GEOMETRIC CURVE 3. STATISTICAL PARABOLIC CURVE WRITE A RECOMMENDATION REGARDING THE RESULTS AND WHICH OF THE NETHOD IS BEST FIT FOR THE DATA. Nate: answer on a separate document. Use excel in compute. 2. Supposed this is Yc (straightline) 450,000 370,000 750,000 1,100,000 1,500,000 1,000,000 1,700,000 2,000,000 1,900,000 2,300,000 Yi + 1 (Geometric) YEAR SALES 415,000 1 356,000 703,556 1,023,400 1,308,905 900,573 1,504,789 1,705,932 1,895,890 2,094,256 450,000 370,000 750,000 1,100,000 1,500,000 1,000,000 1,700,000 2,000,000 1,900,000 2,300,000 2011 2012 2013 3 2014 4. 2015 2016 6. 2017 2018 8 2019 2020 10arrow_forwardClick the Chart sheet tab. This chart is based on the problem data and the two income statements. Answer the following questions about the chart: a. What is the title for the X-axis? b. What is the title for the Y-axis? c. What does data range A represent? d. What does data range B represent? e. Why do the two data ranges cross? f. What would be a good title for this chart? When the assignment is complete, close the file without saving it again. Worksheet. The VARCOST2 worksheet is capable of calculating variable and absorption income when unit sales are equal to or less than production. An equally common situation (that this worksheet cannot handle) is when beginning inventory is present and sales volume exceeds production volume. Revise the worksheet Data Section to include: Also, change actual production to 70,000. Revise the Answer Section to accommodate this new data. Assume that Anderjak uses the weighted-average costing method for inventory. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as VARCOSTT. Check figure: Absorption income, 670,000. Chart. Using the VARCOST2 file, fix up the chart used in requirement 5 by adding appropriate titles and legends and formatting the X- and Y-axes. Enter your name somewhere on the chart. Save the file again as VARCOST2. Print the chart.arrow_forward
- 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.arrow_forwardTask: Enter data as shown below and use the appropriate formulas Save the work as ThinkTech and upload on your enaz portal when done. Equipment Type BRAND Category Stock Sold Cost per unit Stock Balance Total Computer Dell PC 55 25 49000 Phone Infinix Mobile 15 9 16500 Computer Toshiba Laptop 30 20 63000 Phone iPhone Mobile 7 5 28400 Computer HP Laptop 12 7 45000 Computer Compaq PC 25 3 37500 Phone Nokia Mobile 45 14 12000 (a) Add a new row above the header row and title it "Think Technology Solutions". Merge, Center, and bold the title with a Red font color. (2M) (b) Reorganize the data in descending order by the category Column. (1M) (c) Calculate the number the stock balance for each type of equipment. (1M) (d) Insert a new column between stock balance and Total called Discount. Use the IF function to calculate the discount of PC at 21%, Laptops at 15% and mobiles at 5% per unit cost (5M) (e) Calculate the Total amount of money received after selling each equipment (Remember to…arrow_forwardOpen the datafile named StartSalary (attached). Follow the instructions under “using Excel’s Descriptive Statistics Tool in Chapter 3 of textbook. Develop Figure 3.8. Make sure to use Microsoft Excel functions to generate the descriptive statistics. Upload the final figure showing descriptive statistics.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 LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Topic 6 - Financial statement analysis; Author: drdavebond;https://www.youtube.com/watch?v=uUnP5qkbQ20;License: Standard Youtube License