Prepare a balance sheet, income statement and statement of retained earnings in Excel. Prepare one workbook with 3 different worksheets. Use formulas for all calculations.

PASTINA COMPANY Trial Balance December 31, 2014 Credits Debits 130,000 40,000 Account Title Cash Accounts receivable Allowance for uncollectible accounts Supplies Inventory Note receivable Interest receivable Prepaid rent Prepaid insurance Equipment Accumulated depreciation-equipment Accounts payable Wages payable Note payable Interest payable Unearned revenue Common stock Retained earnings Sales revenue Interest revenue Cost of goods sold Wage expense Rent expense Depreciation expense Interest expense Supplies expense Insurance expense Bad debt expense 3,000 1,500 60,000 20,000 2,000 0 80,000 30,000 28,000 50,000 60,000 24,500 248,000 70,000 18,900 11,000 1,100 6,000 3,000 443,500 Totals 443,500