Question: For the MPV using the excel, is this the correct formula? New Time Period Cash Flows 8% Discount Rate Present Value Equipment purchase 0 (200,000)

For the MPV using the excel, is this the correct formula? New Time Period Cash Flows 8% Discount Rate Present Value Equipment purchase 0 (200,000) 1 (200,000) Salvage value of old equip 0 42,000 1 42,000 Net cash flow 8 43,900 5.74664 252,277 Salvage value 8 90,000 0.54027 48,624 Net present value

=142,902 (New)

Old Time Period Cash Flows 8% Present Value Overhaul cost 1 (55,000) 0.92593 (50,926) Net cash flow 8 30,425 5.74664 174,842 Salvage value 8 15,000 0.54027 8,104 Net present value

= 132,019 (old)

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 Accounting Questions!