(Answered) Assignment excel spreadsheet projecton december 31 2016

Accounting

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

View complete question

Financial Accounting, Accounting

Category:- Financial Accounting
Reference No.:- M92085776
Price:- $45

Verified Expert

Priced at $90 Now at $45, Verified Solution

Have any Question?

Related Questions in Financial Accounting

Need slides need a one page executive summarybelow is the

Need slides. Need a one page executive summary. Below is the scenario: "Hi again. I've got news about our client. "ExxonMobil is looking to increase revenue by 10 percent and possibly reduce costs. Need an executive summ ...

Question 1 an organization owes pound300000 tax at 17x4 and

Question 1 . An organization owes £300,000 tax at 1.7.X4 and £450,000 at 30.6.X5. Its income statement for the year to 30.6.X5 includes a tax charge of £400,000. How much tax was actually paid in the year to 30.6.X5?

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years? b. What would the value ...

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r--e". The revenue and expenses f ...

Ww productswith new productssales revenue

Without New Products With New Products Sales revenue $11,686,200 $16,263,600 Net income $486,300 $878,400 Average total assets $5,917,600 $13,539,700 (a) Compute the company's return on assets, profit margin, and asset t ...

At the start of 2013 shasta corporation has 15000

At the start of 2013, Shasta Corporation has 15,000 outstanding shares of preferred stock, each with a $60 par value and a cumulative 7% annual dividend. The company also has 28,000 shares of common stock outstanding wit ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

What has been strides position on dividend payouts in the

What has been Strides' position on dividend payouts in the past (pattern, relationship with earnings, etc.)? What factors affected its dividend policy?

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Accounting Expert