Compute depreciation expense and carrying value

Assignment Help Accounting Basics
Reference no: EM13509786

Would be willing to give out an extra 3,000 points for this question answered correctly. (By posting another question worth that much) This is a longer question but if you know accounting it should be somewhat simple. I just don't have any extra time to get it done. It needs to be done on an excel spreadsheet, but you could just upload a screenshot of the final spreadsheet with formulas shown. I will awarding with points after I get my grade back which will be within a week. To show formulas on excel follow these steps.

Press and hold down the Ctrl key on the keyboard

Press and release the

grave accent key ( ` ) key on the keyboard without releasing the Ctrl key

Consider all of the following information:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Bison Industries is in its first year of operations. Bison purchased the following assets during 2012:

A?· On January 1, Bison purchased land and buildings for $20 million. The amount allocated to land is $5 million and the amount allocated to the buildings is $15 million. The buildings' expected useful life is 30 years and its salvage value is $2 million.
A?· On January 1, Bison purchased a delivery truck for $20,000. The truck has a useful life of 7 years and no expected salvage value.
A?· On April 1, Bison purchased some machinery for $1 million. The machinery is to be depreciated over 10 years and has a $50,000 salvage value.
A?· Bison's standard practice is to recognize depreciation expense to the nearest month in the year of acquisition or disposal.
A?· Bison uses the straight-line method of depreciation

Use MS Excel to prepare an annual depreciation schedule for the fixed assets of Bison Industries as of December 31, 2012. At a minimum the schedule should include the following information:

A?· Asset
A?· Cost
A?· Salvage Value
A?· Depreciable Cost
A?· Useful life
A?· Date of Acquisition
A?· Depreciation Expense* (for the 2012 income statement)
A?· Accumulated Depreciation* (as of December 31, 2012)
A?· Carrying Value* (as of December 31, 2012)
A?· Totals* for Cost, Depreciation Expense and Carrying Value

Students may include other information as appropriate for the carrying out of formulas in the schedule.

Students should format cells such that amounts are rounded and presented to the nearest dollar.

* The cells for Depreciation Expense, Accumulated Depreciation, Carrying Value and Totals should all be based on formulas utilizing the other cells within the spreadsheet. Students are not to do separate calculations to input the answers. Let the spreadsheet do the calculations for you. Instructors will be checking the spreadsheet by changing input fields and testing the resulting calculations of Depreciation Expense, Accumulated Depreciation, and Carrying Value. The grade for this project will be based on correct solutions, proper formulas, and formatting of the schedule.

Reference no: EM13509786

Questions Cloud

How much of investment interest expense can they deduct : Tom and Nancy are married and file a jointly. The income for the year is made up of: 1) $120,000 in combined salaries 2) $1,000 interest income 3) $1,000 LTCG 4) $1,500 on nonqualifying dividends. Expenses include: 1) $900 tax prep paid to the..
Write a recursive function to draw the pattern : write a program that prompts the user to enter the number of lines in the pattern and uses the recursive function to generate the pattern. For example, specifying 4 as the number of lines generates the above pattern.
Major sociological perspectives-symbolic interaction : Taking a clear, concise stance, applying critical thinking skills using relevant points/factors to support your stance, consider the USA Patriot Act and its provisions. Explain how each of the three major sociological perspectives would go about s..
Estimate the new angular speed of the merry-go-round : A playground merry-go-round of radius R = 1.20 m has a moment of inertia I = 260 kg · m2 and is rotating at 8.0 rev/min about a frictionless vertical axle, What is the new angular speed of the merry-go-round
Compute depreciation expense and carrying value : Use MS Excel to prepare an annual depreciation schedule for the fixed assets of Bison Industries as of December 31, 2012. At a minimum the schedule should include the following information.
Memo on capitalization of cable equipment : Memo on Capitalization of Cable Equipment
Compute the velocity of the boat : A speedboat starts from rest and accelerates at +2.01 m/s2 for 7.40 s. What is the velocity of the boat at t = 21.8 s
Recursive function returns number of vowels in a string : Write a recursive function, vowels, that returns the number of vowels in a string and write a program to test your function.
How much time is required to bring the crate to a stop : A 45-kg crate slides to the left initially at a speed of 5.2 m/s. A rope pulls on it with a tension of 240 N in a direction 35 degrees above the horizontal to the right. How much time is required to bring the crate to a stop

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Prepare the journal entry to issue the bonds on july 1

on july 1 2009 a corporation issued 800000 of 9 8 yearbonds to yield 10. interest is paid semiannually on december

  Legal services incrueed during company organization

Prepare journal entries to record, Jan. 10 sold 102,000 shares of commone stock for $8 cash per share. Jan 15 Exchanged 10,000 shares of common stock for equipment with a market value of $80,000. Feb. 1 Exchanged 500 shares of common stock for $3,..

  Draper treatment of the lease

The building has an expected economic life of 30 years. Which of the following statements is correct regarding Draper's treatment of the lease?

  What is the companys contribution margin cm ratio estimate

last month when harrison creations inc. sold 40000 units total sales were 300000 total variable expenses were 240000

  Burden of unlimited liability

Which of the following business has the burden of unlimited liability?

  Shady lanes income taxes payable account reduced from 14

shady lanes income taxes payable account decreased from 14 million to 12 million during 2006. if its income tax expense

  Qualities and characteristics of modular information system

What are the qualities and characteristics of a modular information system and integrated software system and how do they help in financial control in an organisation?

  Plantwide versus department overhead rates

Suppose that instead of using a plantwide overhead rate, the company had used a separate predetermined overhead rate in each department. Under these conditions:

  Decision problem of lakewood fashions

Lakewood Fashions must decide how many lots of assorted ski wear to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table, in thousands.

  Accounting principle-company financial statements

On January 1, 2010, Robins Inc. changed from the LIFO method of inventory pricing to the FIFO method. Explain how this change in accounting principle should be treated in the company's financial statements.

  1with respect to a corporation select the statement that is

1.with respect to a corporation select the statement that is correct. a. its organization requires an approved charter

  Compute taxable income and income taxes payable

Evaluate taxable income and income taxes payable. Prepare the journal entries for income tax expense, income taxes payable, and deferred taxes.

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