Question: please answer all parta and show excel formulas please answer all parts and show formulas on excel thanks! Please use Excel to complete this assignment.
please answer all parts and show formulas on excel thanks! Please use Excel to complete this assignment. Submit the excel file to document your work. Apopka Urgent Care, a for-profit medical practice, has decided to acquire a new top-of-the-line magnetic resonance imaging (MRI) scanner. One alternative would be to purchase the equipment outright for $90,000. If purchased, the practice could borrow the amount needed from a local bank at a 6 percent interest rate. Also, if purchased, the practice would have to sign a maintenance contract with a vendor that would cost $3,000 annually, payable at the beginning of each year. Alternatively, the practice could lease the machine on a four-year guideline lease with a payment of $28,000 payable at the beginning of each year. The lease includes maintenance. The MRI scanner falls into the MACRS three-year class (allowances are 33, 45, 15, and 7 percent in Years 1 through 4, respectively), the machine's estimated residual value is $12,000, and the practice's federal-plus-state tax rate is 35 percent. Should the practice buy, or should the practice lease the equipment? Please explain. its payable at the begining of the year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
