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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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