ACC3300 Excel Spreadsheet Project – Fall 2013
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.
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, 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.
-
Rating:
/5
Solution: ACC3300 Excel Spreadsheet Project – Fall 2013_Solution