forecast Accounts Receivable for 2020. Round to the second decimal place
A B C D E F G H J K N 1 2 Balance Sheet 3 4 5 Actual Financial Statements 2012 2013 Forecasts (you do this) 2017 2018 2014 2015 2016 2019 2020 2021 2022 2023 $8,084 $8,658 $14,557 $15,890 $19,334 $20,522 3,364 3,789 2,859 3,918 6,647 10.464 6,031 7,411 8,299 10,243 11,461 16,047 3,817 4,767 5,612 8,339 13,164 21,296 24,625 31,327 36,474 45,781 60,197 6,423 7,060 10,949 16,967 21,838 29,114 48,866 2,552 2,655 3,319 3,759 3,784 13,350 1,647 1,930 2,892 3,373 4,723 8,897 11,259 15,534 23,178 28,970 37,621 71,113 $32,555 $40,159 $54,505 $65,444 $83,402 $131,310 $$ 6 ASSETS 7 Current assets: 8 Cash and cash equivalents 9 Marketable securities 10 Inventories 11 Accounts receivable, net and other 12 Total current assets 13 Non-Current assets: 14 Property and equipment, net 15 Goodwill 16 Other assets 17 Total non-current assets 18 Total assets 19 20 LIABILITIES AND STOCKHOLDERS? EQUITY 21 Current liabilities: 22 Accounts payable 23 Accrued expenses and other 24 Current Maturities on Long-Term Debt 25 Notes Payable - Current 26 Total current liabilities 27 Non-Current liabilities: 28 Long-term debt 29 Other long-term liabilities 30 Commitments and contingencies (Note 7) 31 otal non-current liabilities 32 Total Liabilities 33 34 Stockholders' equity: 35 Authorized shares - 5,000 36 Issued shares - 500 and 507 37 Outstanding shares - 477 and 484 38 Treasury stock, at cost 39 Additional paid-in capital 40 Accumulated other comprehensive loss 41 Retained earnings 42 Total stockholders' equity 43 Total liabilities and stockholders? equity 44 $13,318 $15,133 $16,459 $20,397 $25,309 $34,616 4,892 6.688 9,807 10,384 13,739 18.170 579 753 1,520 238 1,056 100 792 1,159 1,823 3,118 4,768 5,097 19,581 23,733 29,609 34,137 44,872 57,983 3,084 1,698 3,191 3,489 8,265 1,881 4,009 14,155 43,764 8,235 5,679 4,009 17.923 52,060 7,694 24,743 5,138 6,728 6,413 14,147 19,245 45,618 64,117 103,601 4,782 6,680 24,363 30.413 5 5 5 5 5 5 (1,837) (1,837) (1,837) (1,837) (1,837) (1,837) 8,347 9,573 11,135 13,394 17,186 21,389 (239) (185) (511) (723) 1985) (484) 1,916 2,190 1,949 2,545 4,916 8,636 8,192 9,746 10,741 13,384 19,285 27,709 $32,555 $40,159 $54,505 $65,444 $83,402 $131,310 I A B C D E F G H J K N 1 2 Balance Sheet 3 4 5 Actual Financial Statements 2012 2013 Forecasts (you do this) 2017 2018 2014 2015 2016 2019 2020 2021 2022 2023 $8,084 $8,658 $14,557 $15,890 $19,334 $20,522 3,364 3,789 2,859 3,918 6,647 10.464 6,031 7,411 8,299 10,243 11,461 16,047 3,817 4,767 5,612 8,339 13,164 21,296 24,625 31,327 36,474 45,781 60,197 6,423 7,060 10,949 16,967 21,838 29,114 48,866 2,552 2,655 3,319 3,759 3,784 13,350 1,647 1,930 2,892 3,373 4,723 8,897 11,259 15,534 23,178 28,970 37,621 71,113 $32,555 $40,159 $54,505 $65,444 $83,402 $131,310 $$ 6 ASSETS 7 Current assets: 8 Cash and cash equivalents 9 Marketable securities 10 Inventories 11 Accounts receivable, net and other 12 Total current assets 13 Non-Current assets: 14 Property and equipment, net 15 Goodwill 16 Other assets 17 Total non-current assets 18 Total assets 19 20 LIABILITIES AND STOCKHOLDERS? EQUITY 21 Current liabilities: 22 Accounts payable 23 Accrued expenses and other 24 Current Maturities on Long-Term Debt 25 Notes Payable - Current 26 Total current liabilities 27 Non-Current liabilities: 28 Long-term debt 29 Other long-term liabilities 30 Commitments and contingencies (Note 7) 31 otal non-current liabilities 32 Total Liabilities 33 34 Stockholders' equity: 35 Authorized shares - 5,000 36 Issued shares - 500 and 507 37 Outstanding shares - 477 and 484 38 Treasury stock, at cost 39 Additional paid-in capital 40 Accumulated other comprehensive loss 41 Retained earnings 42 Total stockholders' equity 43 Total liabilities and stockholders? equity 44 $13,318 $15,133 $16,459 $20,397 $25,309 $34,616 4,892 6.688 9,807 10,384 13,739 18.170 579 753 1,520 238 1,056 100 792 1,159 1,823 3,118 4,768 5,097 19,581 23,733 29,609 34,137 44,872 57,983 3,084 1,698 3,191 3,489 8,265 1,881 4,009 14,155 43,764 8,235 5,679 4,009 17.923 52,060 7,694 24,743 5,138 6,728 6,413 14,147 19,245 45,618 64,117 103,601 4,782 6,680 24,363 30.413 5 5 5 5 5 5 (1,837) (1,837) (1,837) (1,837) (1,837) (1,837) 8,347 9,573 11,135 13,394 17,186 21,389 (239) (185) (511) (723) 1985) (484) 1,916 2,190 1,949 2,545 4,916 8,636 8,192 9,746 10,741 13,384 19,285 27,709 $32,555 $40,159 $54,505 $65,444 $83,402 $131,310
