Hi, would you please help me with this , I need it to be done.

Dollars in $100,000 Fiscal years ended on Net sales Cost of sales Gross margin 31-Jan-16 $53,417 34,941 18,476 1-Feb-15 $50,521 33,194 17,327 3-Feb-14 $50,208 32,858 17,350 Expenses: Selling, general and administrative Depreciation Interest - net Total expenses 12,865 1,462 476 14,803 12,244 1,523 423 14,190 12,593 1,480 371 14,444 Pre-tax earnings Income tax provision Net earnings 3,673 1,387 $2,286 3,137 1,178 $1,959 2,906 1,067 $1,839 $2.14 $2.14 $0.70 $1.69 $1.69 $0.62 $1.43 $1.43 $0.53 Basic earnings per common share Diluted earnings per common share Cash dividends per share 31-Jan-16 1-Feb-15 $391 185 $541 125 118 9,127 252 341 10,414 96 8,600 217 301 9,880 20,834 279 1,323 $32,850 21,477 271 1,134 $32,762 Liabilities and shareholders' equity Current liabilities: Short-term borrowings Current maturities of long-term debt Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities $386 49 5,008 785 1,010 1,756 8,994 $0 47 4,657 670 920 1,510 7,804 Long-term debt, excluding current maturities Deferred income taxes - net Deferred revenue - extended protection plans Other liabilities Total liabilities 10,086 291 730 896 20,997 9,030 455 715 901 18,905 515 555 26 13,224 52 13,857 $32,762 31-Jan-14 ($ in 100,000, except par value) Assets Current assets: Cash and cash equivalents Short-term investments Accounts Receivable (less allowances for doubtful accounts of $6 and $9 respectively) Merchandise inventory - net Deferred income taxes - net Other current assets Total current assets Property, less accumulated depreciation Long-term investments Other assets Total assets Shareholders' equity: Preferred stock - $5 par value, none issued (5%), 5 shares authorized Common stock - $.50 par value; 5,000 shares authorized Shares issued and outstanding January 31, 2014 (1,030) February 1, 2013 (1,110) Capital in excess of par value Retained earnings Accumulated other comprehensive (loss)/income Total shareholders' equity Total liabilities and shareholders' equity 11,355 (17) 11,853 $32,850 $32,666 16,533 31-Jan-14 $32,666 16,533 Part One-- Financial Statement Analysis Use the given financial statements to complete the following ratios: 2016 2015 Current Ratio: Quick Ratio Gross Profit % Net Income % ROE ROA 1 Part Two- Transaction Analysis Use the financial statement effects template to indicate the effects from each of these transactions that occurred during 2/1/16-1/31/17 for the company in the financial statements in part one a. 2/1/16 Borrowed $1,800,000 from the local (expected repayment by 6/1/18) b. Had cash sales of $47.856 Million. This was for $30.1 million in inventory c. Issued 200,000 shares of the common stock at a market price of $25 per share d. Bought inventory for resale at a cost of $22.5 million on account. e. Inventory of $1.75 million was sold to customers for $2.69 million all on account. f. Customers paid $2,705,000 on account. g. Paid 30,125,000 for accounts payable h. A number of customers pre-ordered a new item that will be selling soon. They paid $250,000 in advance. i. Before the end of the year was able to deliver to customers $100,000 worth the items preordered. Inventory cost of the items was $40,000 j. incurred $500,000 in salaries, paid $475,000 in cash (considered general, selling and administrative cost) k. Wrote off $100,000 in accounts receivable deemed uncollectible. l. At year end an analysis of the accounts receivable aging schedule indicated the need for an allowance for uncollectible accounts of $800,000 m. Depreciation expense for previously owned property came to $1,105,000 n. At beginning of year purchased property valued at $5.2 million (with cash). The new property has a 20 year life and salvage value of $.2 million. The company uses straight line depreciation. o. Three years ago property was purchased for $2.5 million with a 10 year life and salvage value of $250,000. Due to change in the company's needs for the property it was sold for $1,025,000 this year. Depreciation related to the property is on the books for $675,000. p. Paid cash of $11,375,000 for other general, selling and administrative expenses incurred during the year q. Paid cash for a three year advertising campaign at the beginning of the year $600,000 r. Paid Cash of $6.5 million for accrued compensation and employee benefits 2 s. Interest Due for year $1.1 million, $900,000 paid. t. Paid $1,475,000 cash for income taxes, tax expense for the year is $1,225,880. Difference is due to a Deferred Tax Liab expected to reverse in 5 years. No changes to Deferred tax assets. u. Paid 287,000, cash to holders of short term borrowings v. Paid the balance of current maturities of long-term debt. Long-term debt to be paid within one year is $5.1 million w. Paid cash for other accrued current liabilities of $900,000 x. Paid cash for long term debt of $500,000 million Part Three- Financial Statement Updates Use the information in part one and two to create 2017 income statement and balance sheet for Jan 31, 2017. 3 Part 4 - Bond Principle and Interest Calculation 1. Calculate the sales price of the following bonds (interest pays semi-annually): a. $20,000,000 three year note, coupon rate 8%, market rate 12% b. $5,000,000 ten year note, coupon rate 12%, market rate 10% 2. What is the interest expense and interest payment after the first six months for each bond? 3. What amount of cash is necessary to repay these notes at maturity, assuming no other changes during the term of the notes? 4