Good morning,

Can you help me to do the exercise as the file attached. Thank you very much.

Leyna

Case Study Cambridge Millworks, Inc. reported the below values from their 2016 income statement and balance sheet. All values (in millions): Investments in affiliated companies Common stock, 9,000,000 shares, $1 par Net sales and other operating revenue Depreciation and amortization Accounts payable Paid-in capital in excess of par Cash Retained income Interest expense Accrued income taxes payable Cost of goods sold Subordinated debentures, 11% interest, due Dec. 31, 2020 Goodwill Noncontrolling interest in consolidated subsidiaries' net income First mortgage bonds, 10% interest, due Dec. 31, 2021 Property, plant, and equipment, net Preferred stock, 2,000,000 shares, $50 par, dividend rate is $3.5 per share Short-term investments at market value Income tax expense Accounts receivables, net Noncontrolling interest in subsidiaries Inventories at average cost Dividends declared and paid on preferred stock Equity in earnings of affiliated companies $100 9 890 20 210 103 20 188 25 20 650 100 95 20 80 125 100 45 90 175 90 340 10 20 In excel, create Cambridge's consolidated income statement and balance sheet for fiscal year 2016. Must include proper headings