ACC3300 Excel Spreadsheet Project – Fall 2013

Question # 00003707 Posted By: ACCOUNTS_GURU Updated on: 11/19/2013 12:06 AM Due on: 12/31/2013
Subject Accounting Topic Accounting Tutorials:
Dot Image

ACC3300 Excel Spreadsheet Project – Fall 2013

On December 31, 2012, Barker Inc. provided consulting services to Carr Company at an agreed price of $151,121. Barker accepted $60,000 down and agreed to accept the balance in four equal installments of $30,000 to be received each December 31, beginning December 31, 2013. An assumed interest rate of 12% is imputed.


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, 2012; (b) December 31, 2013; (c) December 31, 2014; (d) December 31, 2015; and (e) December 31, 2016.

You will be assessed on the following skills:

(1) correct data entered,

(2) correct and accessible formulas,

(3) column headings and labels,

(4) titles merged and centered, and

(5) spreadsheet formatting and printing.

· Each student must submit the completed spreadsheet to me by email

· Include the following in the subject line of your email: ACC3300 Excel Project Fall 2013, Your Name

· Failure to use the appropriate subject line in the email will result in grade reduction of 1 letter grade.

Dot Image
Tutorials for this Question
  1. Tutorial # 00003518 Posted By: ACCOUNTS_GURU Posted on: 11/19/2013 12:11 AM
    Puchased By: 78
    Tutorial Preview
    The solution of ACC3300 Excel Spreadsheet Project – Fall 2013_Solution...
    ACC3300_Excel_Spreadsheet_Project_–_Fall_2013_Solution.xlsx (10.65 KB)

Great! We have found the solution of this question!

Whatsapp Lisa