Please provide answer in proper format with all working clearly

Note : Answer in word or excel only ( Hand written answer is strictly prohibited)

WHITTAKER INC. Balance Sheet December 31, 2020 Current assets: Cash Accounts receivable, net Inventory Total current assets $ 150,000 Property, plant, and equipment, net Total assets Current liabilities Bonds payable, 12% 67,000 Total liabilities Stockholders' equity: Common stock, $4 par value 10,000 Additional paid-in capital 15,000 Retained earnings Total stockholders' equity Total liabilities and stockholders' equityFinancial ratios computed for Whittaker Inc. include the following: Current ratio 1 . 6 to 1 Acid-test ratio 1 . 3 to 1 Debt/equity ratio 2 .0 to 1 Inventory turnover 2. 5 times Accounts receivable turnover 5 . 8 times Times interest earned 4 . 80 times Gross profit ratio 408 Return on investment 9 . 268 Earnings per share $8 . 71 . All sales during the year were made on account. Cash collections during the year exceeded sales by $17,000, and no uncollectible accounts were written off. . The balance of the accounts receivable account was $45,000 on January 1, 2020. . No common stock was issued during the year. . Dividends declared and paid during the year were $8,628. . The balance of the inventory account was $73,491 on January 1, 2020. . Interest expense on the income statement relates to the 12% bonds payable; $10,000 of these bonds were issued on May 1, 2020; the remaining amount of bonds payable were outstanding throughout the year. All bonds were issued at face amount.Required: a. Complete the income statement and balance sheet for Whittaker Inc. WHITTAKER INC. Income Statement For the Year Ended December 31, 2020 Sales Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before taxes Income taxes (25%) Net income