answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Amiraneli [1.4K]
1 year ago
5

A profitable company making earthmoving equipment is considering an investment of $150,000 on equipment that will have a 5 year

useful life and a $50,000 salvage value. Use a spreadsheet function to compute the MACRS depreciation schedule. Show the depreciation taken (=sum ()) as well as the PW of the depreciation charges discounted at the MARR%. If money is worth 10%m which one of the following three methods of depreciation would be preferable? (a) Straight line method), (b) double declining balance method, (c) MACRS method.
Business
1 answer:
Anuta_ua [19.1K]1 year ago
8 0

Answer:

Earthmoving Equipment Company

The preferable method of depreciation based on the Present Worth is:

(a) Straight line method

Explanation:

a) Data and Calculations:

Cost of equipment = $150,000

Estimated useful life = 5 years

Salvage value = $50,000

Depreciable amount = $100,000 ($150,000 - $50,000)

Annual Depreciation:

Straight-line method = $20,000 ($100,000/5)

Double-declining-balance method rate = 40% (100%/5 * 2)

Depreciation Schedules:

a) Straight line method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000     $20,000             $20,000             $130,000

Year 2 $150,000     $20,000             $40,000              $110,000

Year 3 $150,000     $20,000             $60,000              $90,000

Year 4 $150,000     $20,000             $80,000              $70,000

Year 5 $150,000     $20,000           $100,000              $50,000

b) double declining balance method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000    $60,000            $60,000              $90,000

Year 2 $150,000      36,000              96,000                 54,000

Year 3 $150,000       4,000              100,000                 50,000

Year 4 $150,000

Year 5 $150,000

c) MACRS method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000    $30,000             $30,000              $120,000

Year 2 $150,000      48,000                78,000                  72,000

Year 3 $150,000      28,800              106,800                  43,200

Year 4 $150,000       17,280              124,080                  25,920

Year 5 $150,000      17,280                141,360                    8,640

Year 6 $150,000       8,640               150,000                    0

Discount rate (MARR) = 10%

PW of Straight-line Depreciation Charges:

PV annual factor = 3.791

PW = $75,820 ($20,000 * 3.791)

PW of Double-declining-balance:

Year 1 = $54,540 ($60,000 * .909)

Year 2 = $29,736 ($36,000 * .826)

Year 3 = $3,004 ($4,000 * .751)

PW =    $87,280

PW of MACRS:

Year 1 = $27,200 ($30,000 * .909)

Year 2 = $39,648 ($48,000 * .826)

Year 3 = $21,629 ($28,800 * .751)

Year 4 = $11,802 ($17,280 * .683)

Year 5 = $10,731 ($17,280 * .621)

Year 6 = $4,873 ($8,640 * .564)

PW =   $115,883

You might be interested in
It is election day and 1800 voters vote in their precinct’s library during the 10 hours the polls are open. On average, there ar
lorasvet [3.4K]

Answer:

Inventory = 15 voters

Flow rate = 3 voters per minute

Flow Time = 5 minutes

Explanation:

Flow rate is defined as the flow of units for each minute, or the minutes or each unit.

Here, number of voters is the units = 1,800 voters

Also provided number of hours = 10

Thus, flow rate shall be:  1,800/10 = 180 voters each hour

Now \frac{180}{60\ minutes} = 3 voters per minute.

Flow time is the average time by each unit, that is time taken for each unit.

Flow time = 5 minutes

Now, that we know what flow rate and flow time is:

Inventory of voters = Flow rate \times Flow time = 3 voters \times 5 minutes = 15 voters.

5 0
2 years ago
​a major big box store allegedly adds 5 percent to the total cost of production or cost of purchasing items it sells in its stor
cupoosta [38]
Given that <span>a major big box store allegedly adds 5 percent to the total cost of production or cost of purchasing items it sells in its store, then adds to this number the additional costs and profits in order to arrive at the product's selling price. the 5 percent represents the markup amount.</span>
8 0
2 years ago
Eppich Corporation has provided the following data for the most recent month: Raw materials, beginning balance $ 20,500 Work in
Nesterboy [21]

Answer:

Raw Materials T - Account

Debit  :

Beginning Balance                              $ 20,500

Raw materials purchases                     $ 79,100

Total                                                      $99,600

Credit :

Raw materials used in production      $ 77,900

Closing Balance                                   $ 21,700

Total                                                      $99,600

Overheads T - Account

<u>Debit  :</u>

Manufacturing overhead costs incurred   $ 92,500

Totals                                                           $ 92,500

<u>Credit :</u>

Manufacturing overhead applied               $ 72,800

Understatement of Overheads                   $ 19,700

Totals                                                           $ 92,500

Work In Process T - Account

Debit  :

Beginning Work In Process                      $ 32,800

Raw materials                                            $ 77,900

Direct Labor                                              $ 52,800

Manufacturing overhead applied            $ 72,800

Totals                                                        $236,300

Credit :

Transferred to Finished Goods              $ 190,000

Ending Work In Process                            $46,300

Totals                                                        $236,300

Finished Goods T - Account

<u>Debit :</u>

Beginning Balance                                    $ 50,800

Transferred from Work In Process          $ 190,000

Totals                                                         $240,800

<u>Credit :</u>

Trading Account                                       $ 221,700

Ending Balance                                           $ 19,100

Totals                                                         $240,800

Cost of Goods Sold = $241,400

Explanation:

Cost of Goods Sold = $ 221,700 + $ 19,700 (under-applied overheads)

                                 = $241,400

6 0
2 years ago
Caitlin's $5000 CD is nearing its maturity and will have a maturity value of $6101.89. The renewal rate for her CD will be lower
Airida [17]
I believe withdrawal is the option for her CD
6 0
2 years ago
Read 2 more answers
oss Music Inc. reported the following selected information at March 31. 2022 Total current assets $262,787 Total assets 439,832
Alexxandr [17]

Answer:

Please see below

Explanation:

a. Current ratio

= Total current assets / Total current liabilities

= $262,787 / $293,625

= 0.89

b. Debt to assets ratio

= Total current liabilities / Total assets

= $293,625 / $439,832

= 0.67

c. Free cash flow

= Net cash provided by operating activities - Dividends - Capital expenditure

= $62,300 - $12,000 - $24,787

= $15,685

5 0
2 years ago
Other questions:
  • An instruction to a securities agent to sell a stock when it reaches a specific price is a ________. short sell market order lim
    13·1 answer
  • A movie star was paid $1 million in 1960 to do a movie. the cpi was 29.3 in 1960 and the cpi in 2017 was 255. approximately how
    15·1 answer
  • It is the beginning of the football season for the local college team. Martha redecorates the Coffee Collective with a theme tha
    10·1 answer
  • Duffert Industries has total assets of $940,000 and total current liabilities (consisting only of accounts payable and accruals)
    7·1 answer
  • A partial listing of costs incurred at Archut Corporation during September appears below:Direct materials $ 113,000Utilities, fa
    12·1 answer
  • Which statement regarding headings is accurate? Group of answer choices Headings provide visual distraction for readers; thus th
    13·1 answer
  • Sarah has a flair for architecture. She has had good grades all through college. She wishes to become an architect at the renown
    15·2 answers
  • 1. Describe Village Volvo's service package.
    5·1 answer
  • The cost to manufacture one unit of Killian Audio Products' best-selling hearing aid, the Zone, is $67.50. The CFO of the compan
    7·1 answer
  • When an appraiser assumes that no one is being forced to sell at a reduced price because of an impending divorce or similar situ
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!