please complete in excel. Thank you.

K16 D F M N O P o A B 1 Formula: Multiply, Divide, Subtract; Cell Referencing 2 3 BE12.9. Using Excel to Calculate the carrying Value of a Patent 4 PROBLEM 5 Nieland Industries had one patent recorded on its books as of January 6 1.2020. Additional information concerning this patent follows. 7 8 Book value, January 1, 2020 $ 288,000 Remaining useful life 8 years Student Work Area -BE12.9 Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area for the first three calculations, and to this work area for the last calculation. Carrying amount at December 31, 2020 before amortization 10 Cost of all the patent pieces Amortization of book value of original cost full year of amort for original patent Amortization of additional cost(s) amort of add'l costs (prorated) assume that useful life will end same time as original patent Carrying amount December 31, 2020 11 During 2020, Nieland incurred research and development costs and 12 brought a patent infringement suit against a competitor. On December 1, 13 2020, Nieland received the good news that its patent was valid and that 14 its competitor could not use the process Nieland had patented. Cost 15 information concerning these items follows: 16 17 Research and development costs $ 96.000 Patent infringement defense costs 85,000 18 19 20 At what amount should patent(s) be reported on the December 31, 21 2020, balance sheet, assuming monthly amortization of patents ? 22 23 24 25 26 27 28 29 30 Enter Answer Focus