Using excel prepare the amortization schedule and then


Question - On Dec. 31, 2014, Barker Inc. provided consulting services to Carr Company at an agreed price of $408,004.35. Barker accept $40,000 down and agreed to accept the balance in five equal installments of $50,000 to be received each June 30th and Dec. 31st, beginning June, 2015. An assumed interest rate of 12% is imputed.

Instructions: Using EXCEL prepare the amortization schedule and then record all required journal entries that would be made by Barker on the following dates (a) Dec. 31, 2014; (b) June 30, 2015; (c) Dec. 31,2015; (d) June 30, 2016; (e) Dec. 31, 2016; (f) June 30, 2017; (g) Dec. 31, 2017; (h) June 30, 2018; (I) Dec. 31, 2018; (j) June 30, 2019; and (k) Dec. 31, 2019.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Using excel prepare the amortization schedule and then
Reference No:- TGS02390750

Now Priced at $25 (50% Discount)

Recommended (98%)

Rated (4.3/5)