Question

In: Accounting

PLEASE show you work so it is easier to undersand, thank you!! There are two parts...

PLEASE show you work so it is easier to undersand, thank you!!

There are two parts to this problem a) & b)
A company made the following expenditures in connection with the construction of a new building:
Architect’s fees $12,000
Cash paid for land and unusable building on the land 300,000
Removal of old building 18,000
Salvage from sale of old building materials -4,000
Construction survey 1,500
Legal fees for title search 3,000
Excavation for basement construction 25,000
Machinery purchased for operations 100,000
Freight on machinery purchased 1,600
Construction costs of new building 1,000,000
Construction of parking lot and driveway 33,000
Install perimeter fencing 7,500
Installation of machinery 2,500
a) Required: Prepare a schedule showing the amounts to be recorded as Land, Land Improvements, Buildings, and Machinery.
(See pages 355 &356 Cost Determination for how to determine)
Land Land Improv Buildings Machinery
Architect’s fees
Cash paid for land and unusable building on the land
Removal of old building
Salvage from sale of old building materials
Construction survey
Legal fees for title search
Excavation for basement construction
Machinery purchased for operations
Freight on machinery purchased
Construction costs of new building
Construction of parking lot and driveway
Install perimeter fencing
Installation of machinery
Useful life Indefinate 15 years 40 years 10 years
Salvage $5,000 $250,000 $25,000
Depreciation method DDB SL DDB
   (DDB - double declining balance, SL - straight line)
Assume that all assets are put in service on 7-1-16
b) Required: Calculate straight line for the Building in 2016 & 2017
                       Prepare depreciation schedules for the life of Land Improvements & Machinery     (Round everything to a dollar)
                      (Straight-line is on pages 358 & 359) (Double Declining Balance is on pages 360 & 361) (Partial year depreciation - page 362)
Building
2016
2017
Land Improvements
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
Machinery
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026

Solutions

Expert Solution

My dear!

Hope you're doing well and enjoying your studies. I'm glad to help you learn more. Please find below the solution to your above question. If you find any alignment issues in the text below, please make use of attached image.

Solution: Asset Capitalization and Depreciation
Expenditures Amount Explanations for Classification
Architect’s fees $                    12,000 Being architect will be the person who plans and designs the construction of building, we have to consider this expenses as part of Buildings.
Cash paid for land and unusable building on the land $                  300,000 As said the existing building over the land is unusable, we can conclude the that the said amount is completely towards the price of Land.
Removal of old building $                    18,000 Cost of removal of old building has to be accounted as Land being it is part of making the land ready for intended purpose.
Salvage from sale of old building materials $    (4,000) This is to be decrease in the total of cost of Land for the same reason mentioned in the above line.
Construction survey $    1,500 As it will be part of construction of new building, we should account it along with the cost of Building construction.
Legal fees for title search $    3,000 Being this is legal fees with respect to purchase of land, we have to capitalize this as part of Land.
Excavation for basement construction $                    25,000 As it will be part of construction of new building, we should account it along with the cost of Building construction.
Machinery purchased for operations $                  100,000 This expense directly comes under Machinery and need to be capitalized so.
Freight on machinery purchased $                       1,600 Being this is related to purchase of machinery, we have to add this along with price of Machinery.
Construction costs of new building $               1,000,000 This expense directly comes under Buildings and need to be capitalized so.
Construction of parking lot and driveway $                    33,000 This cannot be assume as part of building as well land, but to be accounted as Land Improvements having definite life.
Install perimeter fencing $                       7,500 This cannot be assume as part of building as well land, but to be accounted as Land Improvements having definite life.
Installation of machinery $                       2,500 Being this is related to purchase and installation of machinery, we have to add this along with price of Machinery.
Answer to Part (a) - Required: Prepare a schedule showing the amounts to be recorded as Land, Land Improvements, Buildings, and Machinery.
Expenditures    Land Land Improv Buildings    Machinery
Architect’s fees $                    12,000
Cash paid for land and unusable building on the land $                  300,000
Removal of old building $                    18,000
Salvage from sale of old building materials $                     (4,000)
Construction survey $                       1,500
Legal fees for title search $                       3,000
Excavation for basement construction $                    25,000
Machinery purchased for operations $                  100,000
Freight on machinery purchased $    1,600
Construction costs of new building $               1,000,000
Construction of parking lot and driveway $                    33,000
Install perimeter fencing $    7,500
Installation of machinery $                       2,500
Total $                  317,000 $                    40,500 $              1,038,500 $                  104,100
Answer to Part (b) - Required:
> Calculate straight line for the Building in 2016 & 2017
> Prepare depreciation schedules for the life of Land Improvements& Machinery (Round everything to a dollar)
Explanations of Straight Line Depreciation of Building:
Formula for Straight Line Method of Depreciation = [Total Asset Value minus Salvage Value] divided by Useful Life.
Here, in the case of Building, Depreciation = [$1,038,500 minus $250,000] divided by 40 years = $19,713 per year.
However, as said in the problem, the assets were put in service on Jul 01, 2016 onwards.
Hence, the depreciation for the first year (2016) to be proportioned accordingly.
So, number of months from Jul 01, 2016 to Dec 31, 2017 are 06 months.
Therefore, depreciation on building for the first year = $19,713 * 6 months / 12 months = $9,856.
Whereas, from the second year onwards, the depreciation to be provided for full months.
Building Amount Calculation
2016 $                       9,856 (1038500-250000)/40*6/12
2017 $                    19,713 (1038500-250000)/40
Explanations of Double Declining Balance (DDB) Depreciation of Land Improvements:
Formula for DDB Depreciation = 2 multiplied by Straight Line Depreciation Rate multiplied by Book Value at the Beginning of the year.
Given that the useful life of Land Improvements is 15 years.
Therefore, Straight Line Depreciation Rate = Straight Line Depreciation per Year divided by Total Asset Value multiplied by 100
Here, Straight Line Depreciation per Year = Total Asset Value divided by Useful Life = $40,500 / 15 years = $2,700.
Then, Straight Line Depreciation Rate = $2,700 / $40,500 * 100 = 6.67%
So, 2 multiplied by Straight Line Depreciation Rate = 2 * 6.67% = 13.34%
Application of formula of DDB Depreciation (as said above) in the below table:
Land Improvements Book Value (at year start) 2 * Straight Line Depreciation Rate Depreciation Book Value (at year end) Depreciation Calculation for your reference
2016 $                    40,500 13.34% $                       2,701 $                    37,799 (Book Value at year start * 13.34% * 6 / 12)
2017 $                    37,799 13.34% $                       5,042 $                    32,756 (Book Value at year start * 13.34%)
2018 $                    32,756 13.34% $                       4,370 $                    28,387 (Book Value at year start * 13.34%)
2019 $                    28,387 13.34% $                       3,787 $                    24,600 (Book Value at year start * 13.34%)
2020 $                    24,600 13.34% $                       3,282 $                    21,318 (Book Value at year start * 13.34%)
2021 $                    21,318 13.34% $                       2,844 $                    18,474 (Book Value at year start * 13.34%)
2022 $                    18,474 13.34% $                       2,464 $                    16,010 (Book Value at year start * 13.34%)
2023 $                    16,010 13.34% $                       2,136 $                    13,874 (Book Value at year start * 13.34%)
2024 $                    13,874 13.34% $                       1,851 $                    12,023 (Book Value at year start * 13.34%)
2025 $                    12,023 13.34% $                       1,604 $                    10,419 (Book Value at year start * 13.34%)
2026 $                    10,419 13.34% $                       1,390 $                       9,029 (Book Value at year start * 13.34%)
2027 $                       9,029 13.34% $                       1,205 $                       7,825 (Book Value at year start * 13.34%)
2028 $                       7,825 13.34% $                       1,044 $                       6,781 (Book Value at year start * 13.34%)
2029 $                       6,781 13.34% $                          905 $                       5,877 (Book Value at year start * 13.34%)
2030 $                       5,877 13.34% $                          784 $                       5,093 (Book Value at year start * 13.34%)
2031 $                       5,093 13.34% $                            93 $                       5,000 (Adjusted to keep the salvage value $5,000)
Please note that the first year depreciation has to proportioned for 06 months considering the date of asset put to service.
Also, please note that the depreciation should be stopped when the book value equals the expected salvage value.
In the above case, being given the salvage value as $5,000, the last year depreciation is limited to $93 than at the normal rate.
Explanations of Double Declining Balance (DDB) Depreciation of Machinery:
In the same way what we done for the calculation of depreciation of Land Improvements, we can do for Machinery.
(Unable to explain the same here again due to time limit of 120 minutes)
That give the results as in the below table.
Machinery Book Value (at year start) 2 * Straight Line Depreciation Rate Depreciation Book Value (at year end) Depreciation Calculation for your reference
2016 $                  104,100 20.00% $                    10,410 $                    93,690 (Book Value at year start * 20% * 6 / 12)
2017 $                    93,690 20.00% $                    18,738 $                    74,952 (Book Value at year start * 20%)
2018 $                    74,952 20.00% $                    14,990 $                    59,962 (Book Value at year start * 20%)
2019 $                    59,962 20.00% $                    11,992 $                    47,969 (Book Value at year start * 20%)
2020 $                    47,969 20.00% $                       9,594 $                    38,375 (Book Value at year start * 20%)
2021 $                    38,375 20.00% $                       7,675 $                    30,700 (Book Value at year start * 20%)
2022 $                    30,700 20.00% $                       6,140 $                    24,560 (Book Value at year start * 20%)
2023 $                    24,560 20.00% $                       4,560 $                    20,000 (Adjusted to keep the salvage value $25,000)
2024 $                    20,000 20.00% $                             -   $                    20,000 (Adjusted to keep the salvage value $25,000)
2025 $                    20,000 20.00% $                             -   $                    20,000 (Adjusted to keep the salvage value $25,000)
2026 $                    20,000 20.00% $                             -   $                    20,000 (Adjusted to keep the salvage value $25,000)
Please note that the first year depreciation has to proportioned for 06 months considering the date of asset put to service.
Also, please note that the depreciation should be stopped when the book value equals the expected salvage value.
In the above case, being given the salvage value as $25,000, the is limited to $4,560 than at the normal rate of the year 2023.
For the next 03 years, the depreciation amount should be Zero.

If you need any clarifications, please let me know! Your feedback is highly important!

?Best wishes!


Related Solutions

Please show your work so it is easier to understand, thank you! The payroll records of...
Please show your work so it is easier to understand, thank you! The payroll records of Airtech Solutions, Ltd. are provided for the period ended December 7: (See Payroll Liabilites on pages 404-406) Required: Compute the necessary information for the payroll journal entries. Complete the entry to accrue the payroll. Complete the entry to record the payroll tax expense. Employee Earnings to End of Previous Week Gross Pay Federal Income Taxes Medical Insurance Deduction Union Dues United Way R. Arthur...
Please answer all parts, thank you, and please type your answer and show all work including...
Please answer all parts, thank you, and please type your answer and show all work including excel formulas Exercise 15-15 The following data were taken from the balance sheet accounts of Shamrock Corporation on December 31, 2016. Current assets $554,000 Debt investments 596,000 Common stock (par value $10) 455,000 Paid-in capital in excess of par 148,000 Retained earnings 800,000 Prepare the required journal entries for the following unrelated items. (Credit account titles are automatically indented when amount is entered. Do...
(Please show work so I can understand how you got to the answer - Thank you...
(Please show work so I can understand how you got to the answer - Thank you very much ) Via Gelato is a popular neighborhood gelato shop. The company has provided the following data concerning its operations: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 13.00 $ 72,540 Raw materials $ 4.75 $ 30,330 Wages $ 5,700 $ 1.50 $ 14,560 Utilities $ 1,730 $ 0.30 $ 3,800 Rent $ 2,700 $ 2,700 Insurance...
Please show full work so that I can understand these types of problems, thank you! Complete...
Please show full work so that I can understand these types of problems, thank you! Complete the following Complex Time Value of Money problem. You are doing some long-range retirement planning. On the day you retire (23 years from now) you want to be able to withdraw $200,000. Then, you want to withdraw the following amounts at the end of each year after that (during your retirement period).                            Years 1-4            $160,000                            Years 5-9            $175,000                            Years 10-15       $165,000...
Please show work thank you! In a random sample of 519 judges, it was found that...
Please show work thank you! In a random sample of 519 judges, it was found that 285 were introverts. a) Let p represent the proportion of all judges who are introverts. Find a point estimate for p. b) Find a 99% confidence interval for p. Give a brief interpretation of the meaning of the confidence interval you have found. c) Do you think the confidence np > 5 and nq > 5 are satisfied in this problem? Explain why this...
Please show the work for how to get the answer. Thank you in advance. Assume that...
Please show the work for how to get the answer. Thank you in advance. Assume that all of the mass of a bicycle wheel is concentrated at its rim. Such a wheel of mass 1.2 kg and radius 30 cm starts from rest at the top of a hill 100 m long and inclined at 20� to the horizontal. What will be the speed of the wheel at the bottom of the hill if it rolls without slipping? (Answer: 15...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
Can you please show me the work on how you get your answer please (thank you...
Can you please show me the work on how you get your answer please (thank you in advance kings and queens of chegg) Problem 1: The following selected information is provided about a manufacturing company: Raw material purchases800,000 Direct labor 415,000 Overhead applied730,000 Actual overhead745,000 Selling and administrative salaries500,000 Other selling and administrative expenses185,000 Sales revenue5,000,000 Inventory data: January 1 December 31Raw material 75,000 100,000Work in process 105,000 140,000Finished goods 120,000 125,000Calculate the cost of goods sold. Assume that under/over...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
Important: please show work for each question. Thank you! In a previous section of PSY230, the...
Important: please show work for each question. Thank you! In a previous section of PSY230, the second exam was worth 80 points. The scores from that class were normally distributed with a mean (μ ) of 65 and a standard deviation (σ) of 5. If the exam scores were converted to a Z distribution, the distribution would form a perfect bell shape. The following questions require locating individual exam scores on the Z distribution and examine the percentage (or proportion)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT