Question: *************************************show me the steps how to do the excel formula Answer the following compounding/discounting questions assuming year-end cash flows. St Elsewhere Hospital purchased a DaVinci

Answer the following compounding/discounting questions assuming year-end cash flows. St Elsewhere Hospital purchased a DaVinci Robotic System for $3.75 million dollars, using a 5 -year loan at 4.4% interest. (Same as problem 1). 3 a If the above DaVinci Robotic System, which costs $3.75 million, comes with a service charge for an additional amount of $45,000 each year for 5 years. What is the present value of cash outflow for the MRI machine (use 6% as the discount rate)? 14 15 b. The salvage value of the machine is $750,000 five years from now. What is the present value of the salvage value of the DaVinct Robotic System (use 6% as the discount rate)? b. The salvage value of the machine is $750,000 five years from now. What is the present value of the salvage value of the DaVinci Robotic System (use 6% as the discount rate)
Step by Step Solution
There are 3 Steps involved in it
To solve these questions in Excel we need to calculate the present value of two separate cash flows ... View full answer
Get step-by-step solutions from verified subject matter experts
