Question: I need help solving this using excel formula. TRUCK A PERIOD PMT FV PV INTEREST 12 1500 7000 6% Anually Solve PV= ($9,096.98) I think

 I need help solving this using excel formula. TRUCK A PERIOD

I need help solving this using excel formula.

TRUCK A
PERIOD PMT FV PV INTEREST
12 1500 7000 6%
Anually
Solve
PV= ($9,096.98)

I think what I have is wrong. Help please!

P7-2. Present Value, Present Value of an Ordinary Annuity, Analysis of Alternatives. Boyne Painting Contrac- tors needs to purchase a new truck. The owner is considering two different truck models that are currently on the market. Boyne's two alternatives are presented here: Truck A: Boyne can purchase Truck A for $45,000. The truck has a useful life of 12 years and will require annual maintenance costs of $1,500 each year. Boyne expects to sell the truck for $7,000 after 12 years. Truck B: Boyne can purchase Truck B for $40,000. This truck also has a useful life of 12 years but will have no scrap value. It will require maintenance costs every four years as follows: Year 4: Year 8: $3,000 $6,000 $8,000 Year 12: Which truck should Boyne purchase given an interest rate of 6% compounded annually? Assume that main- tenance costs will be paid at year-end

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!