Please provide Excel calculations/formulas, so that I may understand where everything is coming from... (Specially for "Premium on Bonds Payable," if PV formula is used...)

Exercise 5-9 On January 1, 2013, Point Corporation acquired an 80% interest in Sharp Company for $1,973,000. At that time Sharp Company had common stock of $1,476,000 and retained earnings of $694,000. The book values of Sharp Company's assets and liabilities were equal to their fair values except for land and bonds payable. The land had a fair value of $98,000 and a book value of $81,000. The outstanding bonds were issued at par value on January 1, 2008, pay 11% annually, and mature on January 1, 2018. The bond principal is $490,000 and the current yield rate on similar bonds is 9%. Your answer is partially correct. Try again. Prepare a Computation and Allocation Schedule for the difference between book value and the value implied by the purchase price in the consolidated statements workpaper on the acquisition date. (Round present value factor calculations to 5 decimal places, e.g. 1.25136 and final answers to o decimal places, e.g. 5,125.) Parent Share Non- Controlling Share Entire Value Purchase Price and Implied Value 1973000 493250 2466250 Less Book Value of Equity Acquired 1736000 T 434000 2170000 Difference between Implied and Book Value 1 237000 59250 296250 Land 13600 3400 17000 Premium on Bonds Payable 45131 11283 56414 Balance 268531 67133 335664 Goodwill 268531 167133335664 335664 Balance Prepare the workpaper entries necessary on December 31, 2013, to allocate and depreciate the difference between book value and the value implied by the purchase price. (Round answers to o decimal places, e.g. 5,125. If no entry is required, select "No Entry" for the account titles and enter o for the amounts. Credit account titles are automatically indented when the amount is entered. Do not indent manually. Account Titles and Explanation Debit Credit