![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_largeCoverImage.gif)
With the 2013 data still on the screen, click the Chart sheet tab. The chart presented shows the
- a. In 2009, the rate of return on assets exceeded the rate of return on common stockholdersʼ equity. Why might this have occurred? Be as specific as possible.
- b. Is the company better off in 2013 than it was in 2009? Why or why not?
When the assignment is complete, close the file without saving it again.
Worksheet. Modify the RATIOA4 worksheet to have it compute two additional activity ratios: number of daysʼ sales in receivables and number of daysʼ sales in merchandise inventory. Use the 2012 and 2013 data and assume a 365-day year. Write out the formulas for your ratios in the spaces provided.
Daysʼ sales in receivables (average collection period) ________________
Daysʼ sales in inventory (average sales period) ________________
Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as RATIOAT.
Chart. Using the RATIOA4 file, prepare a column chart that compares the acid test and
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 15 Solutions
Excel Applications for Accounting Principles
- If Salaries and Wages Expense is $448,600 during the year and the beginning and ending balances of Salaries and Wages Payable are $21,500 and $17,100, respectively, the cash paid to employees is__.arrow_forwardNeed answerarrow_forwardDuring the month of March, Neji Company used $32,800 of direct materials and incurred $46,100 of direct labor costs. Jacob applied overhead to products in the amount of $21,900. If the cost of goods manufactured was $138,000 and the ending work in process balance was $23,600, the beginning work in process must have been equal to _.arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305635937/9781305635937_smallCoverImage.gif)