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

  Values for a lump sum assuming annual compounding

Find the following values for a lump sum assuming annual compounding: Assume that you won 35 million and the state will pay you 20 annual payments of 1.7 million each begining immediately. Rate of return on securities of similar risk to the lottery e..

  Is there a difference in due process in law

In the Australian accounting sphere the concept of due process is applied within the institutional arrangements for regulating financial reporting and falls particularly within the promulgation of accounting standards.

  Determine the accuracy of any given forecasting method

What three most popular methods are used to determine the accuracy of any given forecasting method? And in what circumstances would they be used.

  Describe some of the challenges facing financial reporting

Explain how accounting assists in the efficient use of scarce resources. Identify the objective of financial reporting. Describe some of the challenges facing financial reporting.

  Using a perpetual inventory system

McCoy Warehouse distributes hardback books to retail stores and extends credit terms of 3/10, n/30 to all of its customers. During the month of June, the following merchandising transactions occurred. Journalize the transactions for the month of June..

  Job costing system can be used by which types of companies

A job costing system can be used by which types of companies?

  Short questions on standard costing and flexible

short questions on standard costing and flexible budgeting.1.nbspwhich of the following is not true about variances in

  Operating activities section of statement of cash flows

Staley Inc. reported the following data: Net income $280,000 Depreciation expense 48,000 Loss on disposal of equipment 19,520 Increase in accounts receivable 17,280 Increase in accounts payable 8,960 Prepare the Cash Flows from Operating Activities s..

  The west regions costs were over or under budget

Budgetary Performance for Cost Center Caroline Company's costs were over budget by $319,000. The company is divided into West and East regions. The East Region's costs were under budget by $47,500. Determine the amount that the West Region's costs we..

  Question a what is the significance of the information

question a. what is the significance of the information about sales person compensation to the audit of receivables and

  Assume perpetual inventory system is used

On July 4, a hardware manufacturing firm purchased inventory on account for $1,300. The company plans to pay $700 in the next week and the remaining in the week after. Which of the following is the correct entry to record this transaction in a purcha..

  Describe briefly advantage of raising funds by issuing bonds

Compute the company’s after- tax cost of borrowing on this bond issue stated as a percentage of the amount borrowed. Describe briefly advantage of raising funds by issuing bonds as opposed to stocks.

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