Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2022, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell H5. Clear the conditional formatting rule from the range H5:H52 if Excel applies it.

Time value an iowa state savings bond can be converted to $750 at maturity 5 years from purchase. if the state bonds are to be competitive with u. s. savings bonds, which pay 5% annual interest (compounded annually), at what price must the state sell its bonds? assume no cash payments on savings bonds prior to redemption. ignore taxes.

Eliminating entries (including goodwill impairment) and worksheets for various years on january 1, 2013, porter company purchased an 80% interest in the capital stock of salem company for$850,000. at that time, salem company had capital stock of $550,000 and retained earnings of $80,000.differences between the fair value and the book value of the identifiable assets of salem company were asfollows: fair value in excess of book valueequipment$130,000land65,000inv entory40,000the book values of all other assets and liabilities of salem company were equal to their fair values onjanuary 1, 2013. the equipment had a remaining life of five years on january 1, 2013. the inventory was sold in2013.salem company’s net income and dividends declared in 2013 and 2014 were as follows: year 2013 net income of $100,000; dividends declared of $25,000year 2014 net income of $110,000; dividends declared of $35,000required: a. prepare a computation and allocation schedule for the difference between book value of equity acquired andthe value implied by the purchase price. b.present the eliminating/adjusting entries needed on the consolidated worksheet for the year endeddecember 31, 2013. (it is not necessary to prepare the worksheet.)lo6lo1

Steffi is reviewing various licenses and their uses. match the licenses to their respective uses. you are eligible to work within the state. you are eligible to sell limited investment securities. you are eligible to sell fixed income investment products. your compensation is fee based. section 6 section 7 section 63 section 65