Prepare a balance sheet and income statement for Belmond, Inc. from the following information. EXCEL PLS

Inventory Common stock Cash $ 6,500 45,000 16,550 1,350 600 Operating expenses Short-term notes payable Interest expense 900 500 Depreciation expense Net sales Accounts receivable Accounts payable Long-term debt Cost of goods sold Buildings and equipment Accumulated depreciation Taxes General and administrative expense Retained earnings 12,800 9,600 4,800 55,000 5,750 122,000 34,000 1,440 850