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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Capital Budgeting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education