Reference no: EM13328998
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.
|
What was shaffer cost of financing this inventory
: On January 1, 2007, Shaffer Co. purchased inventory for $1,000 cash. These goods were sold on April 30, 2007 for $1,400 cash. The company can currently earn 3% interest on an account at a bank.
|
|
What is the plaintext for the ciphertext 10000001
: What is the ciphertext (in binary form) generated by the encryption of the character T (Please show your work.)
|
|
How many years is market price until the bond matures
: The Lo Sun Corporation offers a 10 percent bond with a current market price of $896.37. The yield to maturity is 11.34 percent. The face value is $1,000. Interest is paid semiannually. How many years is it until this bond matures
|
|
What average power is delivered to the head
: The head of a grass string trimmer has 100 g of cord wound in a light cylindrical spool with inside diameter 3.00 cm, What average power is delivered to the head by the trimmer motor while it is accelerating
|
|
Prepare the amortization schedule
: 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, 201..
|
|
Explain the organic substance is converted to ammonia
: The amount of nitrogen in an organic substance can be determined by an analytical method called the Kjeldahl method, in which all the nitrogen in the organic substance is converted to ammonia.
|
|
What is the encrypted message entropy
: Consider the following plaintext message: FAIN 460 9043 IS A GRADUATE COURSE.
|
|
What is the motion of the cylinder
: Suppose a cylinder is resting on a horizontal platform on plane x-y with its axis parallel to the y axis, What is the motion (acceleration:linear as well as rotational) of the cylinder
|
|
A mechanistic explanation as to why (z)-3-methyl-2-pentene
: Dehydrohalogenation of (2R, 3R)-2-bromo-3-methylpentane by a bimolecular reaction produces only (E)-3-methyl-2-pentene and 3-methyl-1-pentene as products. Provide a mechanistic explanation as to why (Z)-3-methyl-2-pentene is not formed.
|