Untitled document (2)

.docx

School

Sinclair Community College *

*We aren’t endorsed by this school

Course

1220

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by GrandArmadilloMaster752

Report
Chapter 13 Financial Statement Project 40 Points Maximum Credit Company name: J.M. Smucker Company INSTRUCTIONS: In order to answer the questions below, you will need to locate Smucker’s Income Statement, Balance Sheet and Statement of Cash Flows in the annual report. Since Smucker’s owns many subsidiaries, these reports will have the term “Consolidated” in the title to signify that the operations of the subsidiaries have been added into the statements. Round answers (both numbers and percents) to 1 decimal place. (Example: 5.9 or 12.3%) 1. What are the dates of Smucker’s fiscal year? (Hint: you can determine this by looking at the financial statements.) Smucker’s fiscal year begins on May 1st and ends April 30th every year. The current fiscal year is from May 1st, 2018 to April 30th, 2019. 2. Using horizontal analysis, compute Smucker’s percentage change in net sales from 2018 to 2019. Was this a positive or negative trend compared to the prior year’s percentage change in net sales? (Hint: you will also need to compute the percentage change in net sales from 2017 to 2018 to determine if the trend is positive or negative.) Net Sales Given 2017 2018 2019 7392.30 7357.10 7838.00 Increase/ decrease in net sales -35.20 [7357.10-7392.30] 480.90 [7838-7357.10] % Change in Net Sales -.48% [(-35.50/7392.30)*100] 6.54% [(480.90/7357.10)*100] Decrease in net sales and increase in net sales Trend 48% 6.54% Downward trend Upward trend 3. What was Smucker’s 2019 profit margin? Was this an improvement over the company’s 2018 profit margin?
Particulars 2018 2019 Profits (a) 1338.60 514.40 Net Sales (b) 7357.10 7838.00 Profit Margin [(a)/(b)*100] 18.20% 6.56% Profit margin for 2019 was 6.56% This profit margin was not an improvement over 2018 because it was less than 18.20% 4. What was Smucker’s times-interest-earned ratio for 2019? Did the company improve its ability to pay interest on its long term debt in 2019 when compared to 2018? (Hint: it’s OK to use net interest expense in your computation.) Particulars 2018 2019 EBIT (Given) 861.00 701.60 (+) Interest Expenses 174.10 207.30 (+) Depreciation & Amortisation 206.80 240.30 EBITDA (a) 1241.90 1149.80 Interest Expense (b) 174.10 207.90 Times Interest Earned Ratio (a)/(b) 7.13 times 5.53 times Conclusion: TIE ratio of 2019 is less than TIE ratio of 2018. Hence the TIE ratio did not improve in 2019. 5. What was Smucker’s return on total assets for 2019? Particulars 2018 2019
Net income (given) [a] 1338.60 514.40 Total assets (given) [b] 15301.20 16711.30 Return on total assets [a/b] 8.75% 3.10% 6. What was Smucker’s debt ratio for 2019? Debt ratio = 8740.80 16711.30 = 0.523 or 52.30% 7. What was Smucker’s current ratio for 2019? Did the company’s ability to pay its current liabilities improve in 2019 when compared to 2018? Particulars 2018 2019 Current assets (a) 1555 1625.20 Current liabilities (b) 1033.80 2341.50 Current ratio [a/b] 1.50 .69 We can see that the company’s ability to pay its current liabilities did not improve in 2019 when compared to 2018. 8. Compute Smucker’s days sales in inventory for 2019. Based on this ratio, is the company improving on the management of its inventory from 2018 to 2019? (Note: total inventory is the sum of the Raw Materials and Finished Products inventories.) Particulars 2018 2019 Total inventory (a) 854.4 910.3
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