Case Study # 4 Excel Submission – Capital Budgeting Comprehensive Problem Pinnacle Custom Home Builders purchased a 40 foot articulating boom lift three years ago for $50,000. The equipment has been depreciated under the 5-year MACRS schedule (20%, 32%, 19%, 12%, 12% & 5%). The old equipment can be sold for $33,000. Pinnacle is considering the purchase of a new 60 foot articulating boom lift that would allow the to complete nearly all of its construction projects without the need for costly rental company lifts. The new lift could be purchased for $105,000 and would also fall under the 5-year MACRS depreciation schedule. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years. New Equipment Old Equipment $40,000 38,000 35,000 30,000 25,000 22,500 $25,000 16,000 9,000 8,000 6,000 5,000 2. 4. 5. 6.. The firm has a 28 percent tax rate and a 7 percent cost of capital. Should the new equipment be purchased to replace the old equipment? Briefly justify your answer. 123 456
Case Study # 4 Excel Submission – Capital Budgeting Comprehensive Problem Pinnacle Custom Home Builders purchased a 40 foot articulating boom lift three years ago for $50,000. The equipment has been depreciated under the 5-year MACRS schedule (20%, 32%, 19%, 12%, 12% & 5%). The old equipment can be sold for $33,000. Pinnacle is considering the purchase of a new 60 foot articulating boom lift that would allow the to complete nearly all of its construction projects without the need for costly rental company lifts. The new lift could be purchased for $105,000 and would also fall under the 5-year MACRS depreciation schedule. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years. New Equipment Old Equipment $40,000 38,000 35,000 30,000 25,000 22,500 $25,000 16,000 9,000 8,000 6,000 5,000 2. 4. 5. 6.. The firm has a 28 percent tax rate and a 7 percent cost of capital. Should the new equipment be purchased to replace the old equipment? Briefly justify your answer. 123 456
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Study Excel Instructio x
EXAM 3-BUSI 320 class notes x
b Login (bartieby
es/155996/assignments/1958552
E Individual Differen...
M Corporate Finance
U SPAN101: Element...
L Canvas Dashboard
U Course Registration
out
# 4 Comp Prob - Ch 12 (D).docx
I Downle
Case Study # 4 Excel Submission – Capital Budgeting Comprehensive Problem
Pinnacle Custom Home Builders purchased a 40 foot articulating boom lift three years ago for
$50,000. The equipment has been depreciated under the 5-year MACRS schedule (20%, 32%,
19%, 12%, 12% & 5%). The old equipment can be sold for $33,000.
Pinnacle is considering the purchase of a new 60 foot articulating boom lift that would allow
the company to complete nearly all of its construction projects without the need for costly rental
lifts. The new lift could be purchased for $105,000 and would also fall under the 5-year MACRS
depreciation schedule.
Assume the old and new equipment would provide the following operating gains (or losses)
over the next six years.
New Equipment Old Equipment
$40,000
38,000
35,000
30,000
25,000
22,500
$25,000
16,000
1
2.
9,000
8,000
3.
4.
6,000
5,000
5.
6.
The firm has a 28 percent tax rate and a 7 percent cost of capital. Should the new equipment
be purchased to replace the old equipment? Briefly justify your answer.
All interim calculations (including TVM) must be made using the built-in Excel functions
and your submission should be in good form (i.e., neat and easy to follow with descriptive labels,
etc.).
Students are permitted to work with other students from the class but spreadsheet
download.html
ailed No file
MacBook Air](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7b07311e-f579-4ac8-b710-7e0c1ec8bc92%2F565ed8a0-9adf-4369-a2e4-d03fc9836c89%2Fwlmli7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Study Excel Instructio x
EXAM 3-BUSI 320 class notes x
b Login (bartieby
es/155996/assignments/1958552
E Individual Differen...
M Corporate Finance
U SPAN101: Element...
L Canvas Dashboard
U Course Registration
out
# 4 Comp Prob - Ch 12 (D).docx
I Downle
Case Study # 4 Excel Submission – Capital Budgeting Comprehensive Problem
Pinnacle Custom Home Builders purchased a 40 foot articulating boom lift three years ago for
$50,000. The equipment has been depreciated under the 5-year MACRS schedule (20%, 32%,
19%, 12%, 12% & 5%). The old equipment can be sold for $33,000.
Pinnacle is considering the purchase of a new 60 foot articulating boom lift that would allow
the company to complete nearly all of its construction projects without the need for costly rental
lifts. The new lift could be purchased for $105,000 and would also fall under the 5-year MACRS
depreciation schedule.
Assume the old and new equipment would provide the following operating gains (or losses)
over the next six years.
New Equipment Old Equipment
$40,000
38,000
35,000
30,000
25,000
22,500
$25,000
16,000
1
2.
9,000
8,000
3.
4.
6,000
5,000
5.
6.
The firm has a 28 percent tax rate and a 7 percent cost of capital. Should the new equipment
be purchased to replace the old equipment? Briefly justify your answer.
All interim calculations (including TVM) must be made using the built-in Excel functions
and your submission should be in good form (i.e., neat and easy to follow with descriptive labels,
etc.).
Students are permitted to work with other students from the class but spreadsheet
download.html
ailed No file
MacBook Air
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education