11-23 images 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 to compute the 60% bonus depreciation with the MACRS depreciation schedule. Show the total depreciation taken (=sum( )) as well as the Pw of the depreciation charges discounted at 10%.

11-23 images 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 to compute the 60% bonus depreciation with the MACRS depreciation schedule. Show the total depreciation taken (=sum( )) as well as the Pw of the depreciation charges discounted at 10%.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: View Policies Current Attempt in Progress A project that cost $63000 has a useful life of 5 years…

Q: Answer using excel and make sure answer is correct. here is the data only answer based on this

A: Detailed Calculations:Year 1 OCF (at t=1):187500/(1+0.10)1=187500/1.10=170,455 Year 2 OCF (at…

Q: What is annual worth of the project?

A: Annual Worth Analysis is a method which converts all cash flows to annual value of MARR. This is…

Q: Consider the financial data for a project given in the table below. Initial investment $70,000…

A: Internal Rate of Return is the rate at which the Net Present Value of a project becomes zero. It can…

Q: salvage value of 10,000.00

A: Double declining method of depreciation where as per the double declining rate , the annual…

Q: Bartlett Car Wash Company is considering the purchase of a new facility. It would allow Bartlett to…

A: Accounting rate of return is the net income divided by the investment Payback period is the period…

Q: Required information A potential investment has a cost of $555,000 and a useful life of 6 years.…

A: Under the capital budgeting process, different projects are evaluated with an intention of selection…

Q: A project with a life of 10 has an initial fixed asset investment of $31,920, an initial NWC…

A: Equivalent annual cost is the cost of operating and maintaining an asset annually. It is also called…

Q: Current Attempt in Progress Sheffield, Inc. is considering purchasing equipment costing $43000 with…

A: Internal rate of return is one of the capital budgeting method widely used by the companies to…

Q: Haresh

A: To determine the internal rate of return (IRR) for each project, we can use the following…

Q: Bartlett Car Wash Co. is considering the purchase of a new facility. It would allow Bartlett to…

A: Introduction: Accounting rate of return-Accounting rate of return is the ratio of the average…

Q: Initial investment (2 1imos) Useful life Salvage value Annual net income generated. LLT's cost of…

A: Present value (PV) is a financial concept that refers to the current value of a future sum of money…

Q: You are to create a year-by-year depreciation schedule for an asset that has a cost basis (B) of…

A: The salvage Value is $80,000 The price of the Equipment is $950,000 Project life is 10 years To…

Q: Answer using excel and make sure answer is correct. here is the data only answer based on this

A: Here is how you would set this up in Excel:DescriptionValueFormulaInstallation…

Q: Compute Project A's accounting rate of return.

A: The accounting rate of return (ARR) formula is helpful in determining the annual percentage rate of…

Q: Project Year MACRS Year 0 Depreciation Rate 33.33% Year 1 Year 2 Year 3 44.45% 14.81% 7.41% A…

A: MACRS refers to the Modified Accelerated Cost Recovery System.Under MACRS,Annual depreciation = Cost…

Q: 8-18 QZY, Inc. is evaluating new widget machines offered by three companies. The chosen machine will…

A: The given data is executed in excel.

Q: Required Information [The following information applies to the questions displayed below.] Project A…

A: Payback period is a financial metric used to determine the length of time required for an investment…

Q: Give me step by step solution and explanation

A: Payback period is the time taken to recover the initial investment in a project. The formula for…

Question

11-23 images 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 to compute
the 60% bonus depreciation with the MACRS
depreciation schedule. Show the total
depreciation taken (=sum()) as well as the PW
of the depreciation charges discounted at
10%.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Depreciation

VIEW

EXCEL:

VIEW

Answer:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Section 179 Deduction and Modified Accelerated Cost Recovery System (MACRS) Depreciation

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Rr.3.
Required Information [The following information applies to the questions displayed below.] Project A requires a $365,000 initial investment for new machinery with a five-year life and a salvage value of $42,000. The company uses straight-line depreciation. Project A is expected to yield annual net income of $25,300 per year for the next five years. Compute Project A's accounting rate of return. Choose Numerator: Accounting Rate of Return I Choose Denominator: = Accounting Rate of Return Accounting rate of return
D. Double Declining Method Problem: Determine the rate of depreciation, the total depreciation up to end of the 8th year, and the book value at the end of 8 years for an asset that costs P15,000 now and has an estimated scrap value of P2,000 at the end of 10 years by (a) declining balance method and (b) the double declining balance method. (Make a table in Microsoft Excel)
Please help me with show all calculation thanku
Q3: The following table gives the operation cost, maintenance cost and salvage value at the end of every year of a machine whose purchase value is 25,000$. Find the economic life of the machine assuming interest rate, i = 15%. End of Year (n) 1 2 3 4 5 6 7 8 9 10 Cost operation at the end of year ($) 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 Maintenance cost at the end of year ($) 300 400 500 600 700 800 900 1000 1100 1200 Salvage value ate end of the year ($) 9000 8000 7000 6000 5000 4000 3000 2000 1000 500
Required information A company that manufactures magnetic flow meters expects to undertake a project that will have the cash flows estimated. First cost, $. Equipment replacement cost in year 2, $ Annual operating cost, $/year Salvage value, $ Life, years -870,000 -300,000 -920,000 250,000 4 At an interest rate of 10% per year, what is the equivalent annual cost of the project? Find the AW value using tabulated factors. The equivalent annual cost of the project is $-1
Input area: Installation cost Pretax salvage value Operating cost per year Initial NWC Tax rate Discount rate *Depreciation straight-line over life Output area: Annual depreciation charge Aftertax salvage value OCF NPV $ SA SA SA GA $ 385,000 $ 60,000 $ 135,000 35,000 21% 10% ᏌᏊ Ꮚ Ꮚ $ 77,000 $ 47,400 $ 122,820 5
onsider the following financial informationabout a retooling project at a computer manufacturing company:• The project costs $2.5 million and has a five-yearservice life.• The retooling project can be classified as sevenyear property under the MACRS rule.• At the end of the fifth year, any assets held for theproject will be sold. The expected salvage valuewill be about 10% of the initial project cost.• The firm will finance 40% of the project moneyfrom an outside financial institution at an interestrate of 10%. The firm is required to repay the loanwith five equal annual payments.• The firm’s incremental (marginal) tax rate on theinvestment is 35%.• The firm’s MARR is 18%.With the preceding financial information,(a) Determine the after-tax cash flows.(b) Compute the annual equivalent worth for thisproject.
11-31 A small used delivery van can be purchased for $20,000. At the end of its useful life (8 years), the van can be sold for $3000. Determine the PW of the depreciation schedule based on 15% interest using: (a) Straight-line depreciation (b) Sum-of-years'-digits depreciation (c) MACRS depreciation (d) Double declining balance depreciation
Provide step by step manual solution, given, and depreciation table for below mentioned problem. Make sure yet that your answer is the same as the given answer before sending your solution. An asset costing P50,000 has a life expectancy of 6 years and an estimated salvage value of P8,000. Calculate the depreciation charge at the end of the fourth period using fixed-percentage method. Answer. P5,263.87
12.12 Butler Buildings purchased semi-automated as- sembly and riveting robotics equipment for con- structing its modular warehouse buildings. The first cost was $475,000 and installation costs were $75,000; life is estimated at 10 years with a sal- vage of 15% of first cost. Use the SL method to determine (a) annual recovery rate, (b) annual depreciation, (c) book value after 5 years, and (d) book value after 10 years.
Problems 43 and 44 are based on the following statement: Used New machine machine Initial Cost 15,000 40,000 ($) Annual 8,000 2,000 operating cost ($/year) Salvage 5,000 10,000 value ($) Life (years) 3 6 Use an interest rate of 10% per year 43. The present worth of the new machine is closest to: (A) $43,630 (B) $43,066 (C) $45,210 (D) $49,660 44. To compare the machines on the basis of a present worth analysis, the present worth values to use are: (A) PWused $31,139, PW new = $43,066 (B) PWused $31,139, PW new = $37,461 (C) PWused $54,533, PW new = $43,066 (D) PWused $54,533, PW new = $37,461

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS