Details: Use Excel to organize your answers. Your table should be organized similar to the example...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Details: Use Excel to organize your answers. Your table should be organized similar to the example below. The cells labelled 1-65 are cells you must populate based on the inputs provided. Example: Year Variables 0 1 2 3 4 5 6 7 8 9 CT Scanner Initial Purchase Delivery, installation and training Annual maintenance contract Estimated annual scan volume Supply cost per scan1 Technician salary and benefits2 Average charge per scan3 Expected useful life of the scanner 1,750,000 175,000 25,000 2,000 130 84,000 325 19723 2 3 10 11 18 19 25 26 27 33 34 35 42288 12 20 36 52223 6 7 8 13 14 15 21 22 23 29 30 31 32 37 38 39 40 20 16 24 8 years Estimated salvage value at end of period 250,000 65 Annual Revenue Annual expense Net Cash Flow Discount rate You calculate 41 42 43 You calculate 49 50 51 You calculate 57 58 59 426 44 45 46 52 53 54 60 61 62 256 47 48 55 56 63 64 8.00% PV of salvage value You calculate PV of future cash flows You calculate NPV of project You calculate IRR of project You calculate 1. Annual supply inflation rate is estimated to be 6% through the next 8 years 2 Employee wages and benefits are estimated to grow at 4% annually through the next & years Unit 6 Assignment ASSIGNMENT DETAILS Assignment Introduction Assignment Directions Instructions: < > Your hospital is considering the purchase of a CT scanner. You, as the administrator for the Imaging Department, have been asked to conduct a financial analysis on the proposed purchase. Given the information and assumptions below, use Microsoft Excel to conduct a net present value analysis of a capital equipment request. When complete, think of some areas of the analysis where you might be able to make changes to improve the performance of the project. What are your thoughts on how you can positively influence this project? The information below is provided for your use in conducting the analysis on the CT Scanner. All prices and expenses are current as of year 0. Any planned growth will occur in year 1. CT Scanner Initial Purchase price 1,750,000 Delivery, installation, and training 175,000 Annual maintenance contract 25,000 Estimated annual volume 2,000 Supply cost per scan 130 Technician salary and benefits 84,000 Average charge per scan 325 Discount rate 8.00% Expected useful life of the scanner 8 years Estimated salvage value after 8 years 250,000 1. Annual supply inflation rate is estimated to be 6% through the next 8 years 2. Employee wages and benefits are estimated to grow at 4% annually through the next 8 years. 3. Charges for CT scans is estimated to increase 5% annually through the next 8 years Details: Use Excel to organize your answers. Your table should be organized similar to the example below. The cells labelled 1-65 are cells you must populate based on the inputs provided. Example: Year Variables 0 1 2 3 4 5 6 7 8 9 CT Scanner Initial Purchase Delivery, installation and training Annual maintenance contract Estimated annual scan volume Supply cost per scan1 Technician salary and benefits2 Average charge per scan3 Expected useful life of the scanner 1,750,000 175,000 25,000 2,000 130 84,000 325 19723 2 3 10 11 18 19 25 26 27 33 34 35 42288 12 20 36 52223 6 7 8 13 14 15 21 22 23 29 30 31 32 37 38 39 40 20 16 24 8 years Estimated salvage value at end of period 250,000 65 Annual Revenue Annual expense Net Cash Flow Discount rate You calculate 41 42 43 You calculate 49 50 51 You calculate 57 58 59 426 44 45 46 52 53 54 60 61 62 256 47 48 55 56 63 64 8.00% PV of salvage value You calculate PV of future cash flows You calculate NPV of project You calculate IRR of project You calculate 1. Annual supply inflation rate is estimated to be 6% through the next 8 years 2 Employee wages and benefits are estimated to grow at 4% annually through the next & years Unit 6 Assignment ASSIGNMENT DETAILS Assignment Introduction Assignment Directions Instructions: < > Your hospital is considering the purchase of a CT scanner. You, as the administrator for the Imaging Department, have been asked to conduct a financial analysis on the proposed purchase. Given the information and assumptions below, use Microsoft Excel to conduct a net present value analysis of a capital equipment request. When complete, think of some areas of the analysis where you might be able to make changes to improve the performance of the project. What are your thoughts on how you can positively influence this project? The information below is provided for your use in conducting the analysis on the CT Scanner. All prices and expenses are current as of year 0. Any planned growth will occur in year 1. CT Scanner Initial Purchase price 1,750,000 Delivery, installation, and training 175,000 Annual maintenance contract 25,000 Estimated annual volume 2,000 Supply cost per scan 130 Technician salary and benefits 84,000 Average charge per scan 325 Discount rate 8.00% Expected useful life of the scanner 8 years Estimated salvage value after 8 years 250,000 1. Annual supply inflation rate is estimated to be 6% through the next 8 years 2. Employee wages and benefits are estimated to grow at 4% annually through the next 8 years. 3. Charges for CT scans is estimated to increase 5% annually through the next 8 years
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
You're pretty sure that your candidate for class president has about 55% of the votes in the entire school. But you're worried that only 100 students will show up to vote. How often will the underdog...
-
Consider the hanging crane structure in Figure AP2.6. Write the equations of motion describing the motion of the cart and the payload. The mass of the cart is M, the mass of the payload is m, the...
-
(11%) Problem 3: A thin, flat ring (an annulus) with inner radius R and outer radius R2 is uniformly charged on one side with a surface charge density > 0. Refer to the figure. P h R R 17% Part (a)...
-
The Money Pit Mortgage Company is interested in monitoring the performance of the mortgage process. Fifteen samples of five completed mortgage transactions each were taken during a period when the...
-
Gross charges for hospital services, all charged to accounts and notes receivable, were as follows: Patient service revenue $1,668,700 The hospital cafeteria and gift shop had cash sales of $297,200....
-
What are the incorrect statements regarding the disposition process for Class I (not Class II) Engineering Change Proposals (ECPs)? Disposition must be approved or disapproved for implementation by a...
-
Please explain to me about Microsoft Window s Firewall Selection in about a page ?
-
Partially completed T-accounts and additional information for Cardinals, Inc., for the month of November appear as follows. Finished Goods Inventory Materials Inventory Work-In-Process Inventory BB...
-
You have placed $5,000 in your bank savings account. If you allow the interest in this account to accumulate, what will be your balance at the end of three years if interest at 8 percent is...
-
Describe your approach to testing a new feature before deployment. What types of tests would you perform, and how would you address any defects found?
-
You throw a 170 g Frisbee whose radius is 7 cm. Your friend throws a 140 g Frisbee whose radius is 10 cm. Explain how the experience of throwing the two Frisbees differs from one another
-
Strategic management researches the mission and vision statements for four companies of choosing. Companies like Starbucks, southwest airlines, Costco, Wal-Mart etc., are examples of ones that have...
-
Without solving, determine the character of the solutions of each equation in the complex number system. 3x 2 3x + 4 = 0
-
Under IFRS, a cash flow statement is: A. Optional. B. Compulsory for listed companies only. C. Not required. D. Compulsory.
-
Under IAS 7, a cash flow statement focuses on changes in: A. Cash. B. Net current assets. C. Current assets. D. Cash and cash equivalents.
-
Explain the concept of a temporary difference in the context of IASB rules. Why is it thought necessary to account for deferred tax on these differences?
Study smarter with the SolutionInn App