Spreadsheet and Statement of Cash Flows The following information was taken from Lamberson Company's accounting records: Data is presented in tabular format consisting of three columns. The headings are as follows: Column 1: No heading; Column 2: Account Balances January 1, 2016; and Column 3: Account Balances December 31, 2016. The following information appears in the respective columns: In the top section, Debits are presented as follows: Cash; $1,400; $2,400. Accounts Receivable (net); 2,800; 2,690. Marketable Securities (at cost); 1,700; 3,000. Allowance for Change in Value; 500; 800. Inventories; 8,100; 7,910. Prepaid Items; 1,300; 1,710. Investments (long-term); 7,000; 5,400. Land; 15,000; 15,000. Buildings and Equipment; 32,000; 46,200. Discount on Bonds Payable; ; 290 (amounts single underlined). Blank; $69,800; $85,400 (amounts double underlined). In the bottom section, Credits are presented as follows: Accumulated Depreciation; $16,000; $16,400. Accounts Payable; 3,800; 4,150. Income Taxes Payable; 2,400; 2,504. Wages Payable; 1,100; 650. Interest Payable; ; 400. Note Payable (long-term); 3,500; . 12% Bonds Payable; ; 10,000. Deferred Taxes Payable; 800; 1,196. Convertible Preferred Stock, $100 par; 9,000; . Common Stock, $10 par; 14,000; 21,500. Additional Paid-in Capital; 8,700; 13,700. Unrealized Increase in Value of Marketable Securities; 500; 800. Retained Earnings; 10,000; 14,100 (amounts single underlined). Blank; $69,800; $85,400 (amounts double underlined). Below the balance sheet table, a second table lists additional financial information for the year, as follows: Sales, $39,930; Cost of goods sold, (19,890); Depreciation expense, (2,100); Wages expense, (11,000); Other operating expenses, (1,000); Bond interest expense, (410); Dividend revenue, 820; Gain on sale of investments, 700; Loss on sale of equipment, (200); Income tax expense, (2,050) (single underlined); Net income, $4,800 (double underlined). Additional information for the year: Data is presented in tabular format consisting of three columns. The headings are as follows: Column 1: No heading; Column 2: Account Balances January 1, 2016; and Column 3: Account Balances December 31, 2016. The following information appears in the respective columns: In the top section, Debits are presented as follows: Cash; $1,400; $2,400. Accounts Receivable (net); 2,800; 2,690. Marketable Securities (at cost); 1,700; 3,000. Allowance for Change in Value; 500; 800. Inventories; 8,100; 7,910. Prepaid Items; 1,300; 1,710. Investments (long-term); 7,000; 5,400. Land; 15,000; 15,000. Buildings and Equipment; 32,000; 46,200. Discount on Bonds Payable; ; 290 (amounts single underlined). Blank; $69,800; $85,400 (amounts double underlined). In the bottom section, Credits are presented as follows: Accumulated Depreciation; $16,000; $16,400. Accounts Payable; 3,800; 4,150. Income Taxes Payable; 2,400; 2,504. Wages Payable; 1,100; 650. Interest Payable; ; 400. Note Payable (long-term); 3,500; . 12% Bonds Payable; ; 10,000. Deferred Taxes Payable; 800; 1,196. Convertible Preferred Stock, $100 par; 9,000; . Common Stock, $10 par; 14,000; 21,500. Additional Paid-in Capital; 8,700; 13,700. Unrealized Increase in Value of Marketable Securities; 500; 800. Retained Earnings; 10,000; 14,100 (amounts single underlined). Blank; $69,800; $85,400 (amounts double underlined). Below the balance sheet table, a second table lists additional financial information for the year, as follows: Sales, $39,930; Cost of goods sold, (19,890); Depreciation expense, (2,100); Wages expense, (11,000); Other operating expenses, (1,000); Bond interest expense, (410); Dividend revenue, 820; Gain on sale of investments, 700; Loss on sale of equipment, (200); Income tax expense, (2,050) (single underlined); Net income, $4,800 (double underlined). Dividends declared and paid totaled $700. On January 1, 2016, convertible preferred stock that had originally been issued at par value were converted into 500 shares of common stock. The book value method was used to account for the conversion. Long-term nonmarketable investments that cost $1,600 were sold for $2,300. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year. Equipment with a cost of $2,000 and a book value of $300 was sold for $100. The company uses one Accumulated Depreciation account for all depreciable assets. Equipment was purchased at a cost of $16,200. The 12% bonds payable were issued on August 31, 2016, at 97. They mature on August 31, 2026. The company uses the straight-line method to amortize the discount. Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $3,800 fair value at year-end by adjusting the related allowance account. Required: Prepare a spreadsheet to support Lamberson Company's 2016 statement of cash flows. Prepare the statement of cash flows.

I cannot figure out how to show this correctly but it based on the books 2nd edition problem P21-6/Lo21-4 I have gotten all of it done execpt for the following, and there are 2 things a debit and a credit that end up being 290, I can get the totals for the sheet if I can get this one thing. I have been trying for 3 hours and I cannot get it, even went back to the book and on the net. Please explain how to get this, formula and such, I really would like to know, the answer would help to.Thank you All the other answers on here are not correct, or at least the ones I can find, thank you

Discount on Bonds Payable

290