Please provide answers for the attached file that has 2 questions in excel.

Quiz 1 Note: 'K' means '1000', and 'M' = '1,000,000'. For Example, 50K = 50,000 and 5M = 5,000,000 Please give yourself an hour at a quiet place to complete this quiz. There are 2 questions. Each worth 10 points. These are the types of questions you can expect to see on the final. Question 1 Let's assume that you are a newly-hired finance manager for NH Corporation, a small but growing manufacturing company of winter hiking socks. On your first day at work, 12/31/2014, CFO tells you that the company has 50K shares of common stock. Also, that same day, you review the company's accounts with the CFO revealed the following information: Total revenue Loss due to magnitude 8 earthquake Marketing and sales expenses Cash and cash equivalents Accounts receivable Common stock COGS Accumulated depreciation Dividend revenues Unearned service revenue Interest payable Land Patents Retained earnings, 1/1/2014 Interest expense Administrative expenses Dividends declared Allowance for doubtful accounts Notes payable (matures on July 1, 2017) PP&E Raw Materials Accounts payable $1.2M 56K 128K 60K 90K 200K 701K 180K 8K 4.4K 1K 370K 100K 290K 17K 170K 24K 5K 200K 450K 40K 60K Further, you learn from a finance director that the amount of income taxes for ordinary income was $57.6K, not including the tax effect of the earthquake loss of $24K. Instructions (a) Please put together an income statement (multistep) (b) Please put together a retained earnings statement. Question 2 Since you did such an outstanding work on your first day on the job, on your second day at NH Corp, January 2, 2015, CFO gives you the following account information as of 12/31/2014 for the company. Please prepare a balance sheet for NH Corp as of 12/31/2014. Assume all accounts have normal balances. Machinery 60K Interest Expense 2.4K Interest Payable 0.6K Retained Earnings ? Dividends 50.4K Land 137.32K Accounts Receivable 102K Bonds Payable 78K Notes Payable (matures on 6/30/2015) 29.4K Common Stock 70K Accumulated Depreciation for Machinery 10K Prepaid Advertising 5K Service Revenue 341.4K Plant 80.4K Supplies 1.86K Income Taxes Payable 3K Utilities Expense 1.32K Advertising Expense 1.56K Salaries Expense 53.04K Salaries Payable 0.9K Accumulated Depreciation for the Plant 15K Cash 45K Depreciation Expense 8K