Prepare an amortization schedule using excel

Assignment Help Financial Accounting
Reference no: EM131332178

Assignment: Excel Spreadsheet Project

On December 31, 2016, Carson Company rendered services to Lincoln Corporation at an agreed price of $125,939, accepting $50,000 down and agreeing to accept the balance in three equal annual installments of $30,000, to be received every December 31, starting December 31, 2017. An assumed interest rate of 9% is imputed.

Instructions:

(a) Prepare an amortization schedule using excel. Use the effective-interest method for amortization purposes.

(b) Prepare the journal entries required on each of the following dates: December 31, 2016; December 31, 2017; December 31, 2018; and December 31, 2019.

628_Techonology Practice feedback Form.jpg

Reference no: EM131332178

Questions Cloud

What does the IRR rule advise regarding payment arrangement : Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain her for an upfront payment of $49,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is ..
Both perpetuities have the same present value : One perpetuity-imediate with annual payments of $50 has a present value of $300. A second perpetuity has first payment equal to $35, increasing by 3% each year for the next 5 years; the payments are $X thereafter. Both perpetuities have the same pres..
What is the expected return of stock : The stock of company A has a beta of 1.5. The return of market portfolio is 9% and the risk-free rate is1%. 1) According to the Capital Asset Pricing Model (CAPM), what is the expected return of this stock?
Average of three month return for the stock price : Practice; create a macro to create the moving average of three month return for the stock price . Date Price Jan 100 Feb 110 Mar 115 Apr 140 May 120 Jun 132 Jul 124 Aug 120 Sep 115 Oct 132 Nov 143 Dec 128
Prepare an amortization schedule using excel : ACC3300- On December 31, 2016, Carson Company rendered services to Lincoln Corporation at an agreed price of $125,939. Prepare amortization schedule using excel. Use effective-interest method for amortization purposes.
Describe your own personal perspective of reform : Describe your own personal perspective of reform (Islah) and revivalism (ihya). In this essay, you must support and justify your outlook on the topic and mention how Islah /Ihya should begin and where it should start
What is the current yield on bond : Consider $1000 par value bond with a 7 percent annual coupon. The bond pays interest annually. There are 9 years remaining until maturity. What is the current yield on the bond assuming that the required return on the bond is 10 percent?
Draw the extensive form of the game : Draw the extensive form of the game.- Write down strategic form of the game.- Find two equilibria in pure strategies.
Heathrow airport in london : In the summer of 2008, at Heathrow airport in London, Bestofthebest (BB), a private company, offered a lottery to win a Ferrari or 108 comma 000British pounds, equivalent at the time to about $ 216 comma 000.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Equivalent unit for conversion using average cost procedure

In the cutting department of Chess Company, conversion costs are added uniformly throughout the process. With the information given below, calculate the cost per equivalent unit for conversion using the average cost procedure.

  No journal entry required in first account field

Austin, Inc., acquired 10 percent of McKenzie Corporation on January 1, 2014, for $320,600 although McKenzie’s book value on that date was $2,100,000. McKenzie held land that was undervalued by $116,000 on its accounting records. Prepare all of the 2..

  Under the cost method and the equity method

On January 1, 2014, Brown Corp. acquired 40% (10,000 shares) of Blue Company common stock for $1,000,000 as a long-term investment. Prepare the necessary journal entries for Brown’s investment in Blue under the cost method and the equity method.

  Present value of a single payment

Edgemont Enterprises holds a note receivable from a regular customer. The note is for $22,000, which includes principal and interest, and is due to be paid in exactly two years.

  Explain the type of business you have created

Describe the type of business you have created including the product or service, and general staffing plan. Provide a rationale for your plan.

  Evaluate the cost of producing a helmet

Evaluate the cost of producing a helmet - Armstrong Helmet Company manufactures a unique model of bicycle helmet.

  Repay the loan in five equal annual installments

Assume that you borrowed $500 from a friend and promised to repay the loan in five equal annual installments, starting a year from today. Your friend wants to be reimbursed at an 8% annual interest rate. Explain how you would compute the required ann..

  Explain how would this action save antonella in today tax

If Antonella's employer paid her bonus on January 1 of next year instead of December, explain how much would this action save Antonella in today's tax dollars? If Antonella's tax rate increased to 32% next year, would receiving the bonus in Januar..

  Exclusions from gross income

Which of the following items are exclusions from gross income? Select all that apply.

  Break-even point in unit sales using the formula method

Mauro Products distributes a single product, a woven basket whose selling price is $18 and whose variable expense is $15.66 per unit. The company’s monthly fixed expense is $6,786. Solve for the company’s break-even point in unit sales using the equa..

  Te 2011 balance sheet of the captain jet inc is attached

the 2011 balance sheet of the captain jet inc. is attached. during 2012 the following events occurred.1. on january 10

  What was the revenue earned in march

How could the Grays have concluded that the business operated at a loss of $6,100? Was this a valid basis on which to determine net income?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd