urchase Price $90,000 $60,000 Annual Operation and Maintenance  1 $10,000 $20,000 2 $10,000 $20,000 3 $10,000 $20,000 4 $10,000 $20,000         Calculate the present values of total costs for Model A Truck and Model B Truck, respectively. (Interest rate: 3%) (1’)             *Results round to the nearest 2 decimal places. (Note: you may consider u

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 5R
icon
Related questions
Question
  1. A local sanitation authority needs to purchase a new garbage truck. The authority has two truck models under consideration. The purchase price for Model A is $90, 000. The maintenance and operation costs are $10,000/year. Model B is less expensive to acquire ($60,000 at purchase), but costs more on operation and maintenance. Details of the costs are shown in the table below. Interest rate is 3%. Please help this authority to decide which truck they should purchase.

Year

Model A Truck

Model B Truck

Purchase Price

$90,000

$60,000

Annual Operation and Maintenance

 1

$10,000

$20,000

2

$10,000

$20,000

3

$10,000

$20,000

4

$10,000

$20,000

 

 

 

 

  1. Calculate the present values of total costs for Model A Truck and Model B Truck, respectively. (Interest rate: 3%) (1’)

            *Results round to the nearest 2 decimal places. (Note: you may consider using an Excel worksheet to do the calculation). 

Present value of Model A Truck total costs:

Present value of Model B Truck total costs:

 

  1. Which truck model should this authority choose? Why? (0.5’)

 

 

  1. The authority charges garbage collection fees from local residents. The estimated fee collection is $35,000 per year. Calculate the present value of total benefit, the net present value, and the benefit-cost ratio. Interpret what your results suggest. (2.5’)

*Results round to the nearest 2 decimal digits. 

Present value of total benefits:

Net Present Value of Model A Truck: 

Net Present Value of Model B Truck: 

Benefit-Cost Ratio of Model A Truck:  

Benefit-Cost Ratio of Model B Truck: 

What do the net present value and the benefit-cost ratio suggest? Interpret the results. (1’)

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College