On December 31, 2013 Barker Inc. provided consulting services to Carr Company at an agreed price of $141,513. Barker accepted $30,000 down and agreed to accept the balance in four equal installments of $30,000 to be received quarterly (March 31, 2014; June 30, 2014; September 30, 2014; and December 31, 2014). An assumed annual 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) December 31, 20123 (b) March 31, 2014; (c) June 30, 2014; (d) September 30, 2014; and (e) December 31, 20164.

 

The syllabus for ACC 3300 Fall 2014 includes an assignment 8.1 Technology Objective . 

The assignment appears below.  It counts 25 points of your grade.

 

ACC3300 Excel Spreadsheet Project – Fall 2014  

 

On December 31, 2013 Barker Inc. provided consulting services to Carr Company at an agreed price of $141,513.  Barker accepted $30,000 down and agreed to accept the balance in four equal installments of $30,000 to be received quarterly (March 31, 2014; June 30, 2014; September 30, 2014; and December 31, 2014).  An assumed annual 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) December 31, 20123 (b) March 31, 2014; (c) June 30, 2014; (d) September 30, 2014; and (e) December 31, 20164.

 

You must submit the completed spreadsheet to Professor Richards by email by December 1, 2014.  Include the following in the subject line:  ACC3300 Excel Project Fall 2014, Student’s  Name.

 

    • 9 years ago
    Bakers
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bakers.xlsx