50.1K
Verified Solution
Link Copied!
Find the remaining values (Highlighted in Red) using the information provided
2017A Income statement Revenue Cost of sales Gross Profit SG&A & other indirect expenses Operating Profit Interest expense Other nonoperating income (expense) Earnings Before Tax Taxes Net income 2016A 6,538,227 (3,061,704) 3,476,523 (2,111,724) 1,364,799 (165,980) 16,495 1,215,314 (203,089) 1,012,225 7,004,057 (3,382,135) 3,621,922 (2,191,060) 1,430,862 (174,228) 24,356 1,280,990 (218,315) 1,062,675 2018A 8,298,560 (3,832,313) 4,466,247 (2,268,521) 2,197,726 (169,178) 20,421 2,048,969 (331,945) 1,717,024 2019E 9,349,193 (4,019,261) 5,329,932 (2,833,340) 2,496,592 (193,791) 200,152 2,502,953 (405,493) 2,097,460 2020E 10,532,840 (4,192,118) 6,340,721 (3,192,053) 3,148,668 (196,802) 228,178 3,180,045 (515,186) 2,664,859 2021E 11,866,342 (4,344,322) 7,522,020 (3,596,180) 3,925,839 (223,771) 266,556 3,968,624 (642,940) 3,325,684 2018A Balance sheet information Short-term debt Current portion of long-term debt Long-term debt (in long-term liabilities) 2016A ?? ?? ?? 5,127,879 2017A 858,964 0 9,318,148 4,283,047 982,681 1,302,271 8,558,133 2,895,579 2019E 991,102 0 10,044,195 1,422,727 2020E 995,936 664,783 9,546,037 834,248 2021E 464,158 0 12,278,366 277,257 Cash 2016A 2017A 2018A 2019E 2020E 2021E Statement of Cash Flows Cash Flow from Operating Activities Net income Depreciation Amortization Other operating cash flow Cash from Operating 1,012,225 938,629 267,840 (2,450,642) (231,948) 1,062,675 1,052,044 337,666 (2,589,502) (137, 117) 1,717,024 1,258,506 457,473 (2,827,336) 605,667 2,097,460 1,494,502 449,703 (2,921,092) 1,120,572 2,664,859 1,770,081 545,608 (2,098,910) 2,881,638 3,325,684 2,091,485 658,590 (2,120,421) 3,955,338 Cash Flow from Investing Activities CAPEX Other investing cash flow Cash from Investing (1,521,595) 741,963 (779,632) (1,900,036) 797,666 (1,102,370) (1,413,024) 1,177,803 (235,221) (2,101,302) 1,856,965 (244,337) (2,367,336) 2,650,130 282,794 (2,667,050) 1,469,645 (1,197,405) Cash Flow from Financing Activities Net debt issued (repaid) Net equity issued (repurchased) Dividends paid Other financing cash flow Cash from Financing 876,866 (2,101,476) (243,414) 540,262 (927,762) 1,525,304 (1,443,012) (269,258) 195,824 8,858 (2,844,718) (316,252) 736,604 (3,204,871) (359,858) 986,313 (3,610,622) (414,159) 402,269 (4,067,741) (468,565) 765,871 370,446 876,235 3,164,433 2,757,932 Other changes in cash Net increase (decrease) in cash ?? ?? (1,230,629) 385,797 (844,832) (1,387,468) (1,472,852) (588,479) (556,991) 2017A Income statement Revenue Cost of sales Gross Profit SG&A & other indirect expenses Operating Profit Interest expense Other nonoperating income (expense) Earnings Before Tax Taxes Net income 2016A 6,538,227 (3,061,704) 3,476,523 (2,111,724) 1,364,799 (165,980) 16,495 1,215,314 (203,089) 1,012,225 7,004,057 (3,382,135) 3,621,922 (2,191,060) 1,430,862 (174,228) 24,356 1,280,990 (218,315) 1,062,675 2018A 8,298,560 (3,832,313) 4,466,247 (2,268,521) 2,197,726 (169,178) 20,421 2,048,969 (331,945) 1,717,024 2019E 9,349,193 (4,019,261) 5,329,932 (2,833,340) 2,496,592 (193,791) 200,152 2,502,953 (405,493) 2,097,460 2020E 10,532,840 (4,192,118) 6,340,721 (3,192,053) 3,148,668 (196,802) 228,178 3,180,045 (515,186) 2,664,859 2021E 11,866,342 (4,344,322) 7,522,020 (3,596,180) 3,925,839 (223,771) 266,556 3,968,624 (642,940) 3,325,684 2018A Balance sheet information Short-term debt Current portion of long-term debt Long-term debt (in long-term liabilities) 2016A ?? ?? ?? 5,127,879 2017A 858,964 0 9,318,148 4,283,047 982,681 1,302,271 8,558,133 2,895,579 2019E 991,102 0 10,044,195 1,422,727 2020E 995,936 664,783 9,546,037 834,248 2021E 464,158 0 12,278,366 277,257 Cash 2016A 2017A 2018A 2019E 2020E 2021E Statement of Cash Flows Cash Flow from Operating Activities Net income Depreciation Amortization Other operating cash flow Cash from Operating 1,012,225 938,629 267,840 (2,450,642) (231,948) 1,062,675 1,052,044 337,666 (2,589,502) (137, 117) 1,717,024 1,258,506 457,473 (2,827,336) 605,667 2,097,460 1,494,502 449,703 (2,921,092) 1,120,572 2,664,859 1,770,081 545,608 (2,098,910) 2,881,638 3,325,684 2,091,485 658,590 (2,120,421) 3,955,338 Cash Flow from Investing Activities CAPEX Other investing cash flow Cash from Investing (1,521,595) 741,963 (779,632) (1,900,036) 797,666 (1,102,370) (1,413,024) 1,177,803 (235,221) (2,101,302) 1,856,965 (244,337) (2,367,336) 2,650,130 282,794 (2,667,050) 1,469,645 (1,197,405) Cash Flow from Financing Activities Net debt issued (repaid) Net equity issued (repurchased) Dividends paid Other financing cash flow Cash from Financing 876,866 (2,101,476) (243,414) 540,262 (927,762) 1,525,304 (1,443,012) (269,258) 195,824 8,858 (2,844,718) (316,252) 736,604 (3,204,871) (359,858) 986,313 (3,610,622) (414,159) 402,269 (4,067,741) (468,565) 765,871 370,446 876,235 3,164,433 2,757,932 Other changes in cash Net increase (decrease) in cash ?? ?? (1,230,629) 385,797 (844,832) (1,387,468) (1,472,852) (588,479) (556,991)
Answer & Explanation
Solved by verified expert
