User Account

All Pages

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

  An activity based costing allocation system

Assume that X Company has decided to switch to an activity-based costing allocation system. It has identified three activities with the following budgeted costs and cost drivers for 2015:

  What is sharam industries cash conversion cycle

Sharam Industries has a 120-day operating cycle. If its average age of inventory is 50 days, how long is its average collection period? If its average payment period is 30 days, what is its cash conversion cycle?

  Prepare the manufacturing statement for company

Use the following information to prepare the manufacturing statement for Forsythe Company for the month ended June 30.

  What basis will deli corporation have in the equipment

Individual A, an accountant, receives 50 shares of stock for services in connection with the organization of X corporation. Individual A has ordinary income to the extent of fair market value of the 50 shares.

  Revisit the federal payroll tax calculations

The purpose of this assignment is to revisit the federal payroll tax calculations that were demonstrated in the Careers in Practice: Payroll for a Medical Group exercise. Your assignment is to complete the Federal Tax calculations in Column F of the ..

  Prepare the service revenue budget for 2012

Prepare the service revenue budget for 2012 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue

  What is the effect of continuing the contributions

How much will be in the account when the individual retires at the age of 65 if the contributions start when the person is 45 years old?

  Assignment of costs to transferred out units and ending

assignment of costs to transferred out units and ending work in process given beginning of process and period

  Prepare the stockholders equity section of the balance sheet

Issued 100,000 shares of common stock at $5 each; 1,000,000 shares are authorized at $1 par value. Issued 10,000 shares of common stock for a building and land. The building was appraised for $20,000, but the value of the land is undeterminable. The ..

  What is the before and after tax npv and irr show all

you have been hired to perform an investment analysis for a high net worth individual to determine if they should

  What is your breakeven

Suppose you were starting a graphics printing business. It will cost you $2000 for a computer and commercial ink jet printer. What is your breakeven? You want to consider a color laser printer instead of an ink jet. The fixed costs would be $4000 and..

  Calculate the cost of the companys retained earnings

The corporate treasurer of Rollinsford Company expects the company to grow at 3% in the future, and debt securities at 4% interest (tax rate = 35%) to be a cheaper option to finance the growth. The current market price per share of its common stock i..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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