Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use 2016 as the base year. Please enter the trend percent of accounts receivable, long-term debt, and net sales revenue for 2018 and 2020 in

Use 2016 as the base year. Please enter the trend percent of accounts receivable, long-term debt, and net sales revenue for 2018 and 2020 in the following table.

image text in transcribedimage text in transcribedimage text in transcribed

B - Question 1234 - Excel Jaze File Home Insert Page Layout Formulas Data Review View Add-ins Help Tell me what you want to do Share A1 fix Silmaril Company G H I J - A B D E F Silmaril Company Statement of Comprehensive Income For the Year Ended December 31, 2020, 2019, 2018, 2017, 2016 2020 2019 2018 2017 2016 $ 10,000 $ 8,500 $ 9,000 $ 9,300 $ 8,100 (7,900) (6,800) (7,200) (7,500) (6,500) 2,100 1,700 1,800 1,800 1,600 (110) (100) (500) 1,390 (120) (110) (500) 970 (100) (120) (490) 1,090 (100) (130) (490) 1,080 (90) (140) (490) 880 1 2 3 4 5 Net sales revenue 6 Cost of goods sold 7 Gross profit 8 Operateing expenses: 9 Rent expense 10 Depreciation expense 11 Other expenses 12 Operating Income 13 Non-operating gains or losses: 14 17 Gain on sale of equipment 15 Interest revenue 16 Interest expense 17 Income before income tax 18 Income tax expense 19 Net income 20 21 22 23 24 25 200 120 (110) 1,600 (250) 1,350 150 120 (110) 1,130 (210) 920 0 110 (100) 1,100 (200) 900 110 110 (80) 1,220 (190) 1,030 120 100 (90) 1,010 (180) 830 Statement of CI Balance sheet Ready e 100% 14:34 H . - LINE 100" :) : 131 18/6/2564 Question 1234 - Excel Jaze File Home Insert Page Layout Formulas Data Review View Add-ins Help Tell me what you want to do Share A1 fr Silmaril Company G H I B 9,220 9,130 D 8,600 E 8,810 F 8,790 1,720 100 200 2,020 1,880 100 200 2,180 2,010 110 220 2,340 2,380 110 230 2,720 2,530 120 260 2,910 A 19 Total assets 20 21 Liabilities and Equity 22 Current Liabilities: 23 20 Accounts payable 24 Interest payable 25 Income tax payable 26 Total current liabilities 27 Non-current liabilities: 28 Notes payable 29 Long-term debt 30 Total non-current liabilities 31 Total liabilities 32 Equity: 33 Common stock 34 Retained earnings 35 Total equity 36 Total liabilities and equity 37 38 3 39 40 41 42 43 50 550 600 2.620 50 550 600 2,780 40 550 590 2,930 30 550 580 3,300 30 500 530 3,440 3,500 3,100 6,600 9,220 3,500 2,850 6,350 9,130 3,000 2,670 5,670 8,600 3,000 2,510 5,510 8,810 3,000 2,350 5,350 8,790 Statement of CI Balance sheet Ready e 100% 14:34 H LINE 100" :) : 131 18/6/2564 3. Use 2016 as the base year. Please enter the trend percent for 2018 and 2020 in the following table. Round your answer to the second decimal place. If the answer is 153.82631%, enter 153.83 into the box. 2020 2018 Accounts receivable % % Long-term debt % % Net sales revenue % %

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

Modern Auditing

Authors: Guadarshan S. Gill, Cosserat Graham, Leung Philomena, Coram Paul

5th Edition

0471340723, 978-0471340720

More Books

Students also viewed these Accounting questions