Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

im confused on the purchases part, there isnt any or am i missing something? homeWork Assignment for February 15th (6 points) The following information was

im confused on the purchases part, there isnt any or am i missing something? image text in transcribed
homeWork Assignment for February 15th (6 points) The following information was taken from AVF Company's accounting records: 2020 2019 2018 2017 Year-end Inventory 525,000 460,000 390,000 310,000 Year-end Accounts Payable 115,000 113,000 97,500 85,000 Cost of Goods Sold 1,650,000 1,225,000 1,025,000 850,000 An Excel file, 2-15-21 Homework Assignment Solution, containing a solution template, is posted on Blackboard in the Information Textbook Chapter 4 Analytical Procedures Homework Assignment for 2-15-21 folder Required: 1. Download the Excel file, 2-15-21 Homework Assignment Solution to your computer and rename the file as follows: "Your Name" - 2-15-21 Homework Assignment Solution 2. Insert your name at the top of the worksheet. 3. Calculate the following ratios for 2018, 2019, and 2020 using Excel formulas and the ratio formulas presented in Chapter 4 of Auditing, A Practical Approach with Data Analytics Inventory turnover in days. Payables turnover in days. 4. Recalculate the payables turnover in days ratio using Purchases in the numerator instead of Cost of Goods Sold. 5. Copy the Value View worksheet to a Formula View worksheet and show the Excel formulas on the Formula View worksheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions

Question

How are the residuals used in estimating ?????

Answered: 1 week ago