Major medical complexes and their service providers continue to move toward advanced health informatics - acquiring, managing, and using information to provide better healthcare. A new analyzer for researching and evaluating patient samples, and making informed recommendations in the treatment of complex blood cancers, is purchased for $250,000. It is estimated to have a useful life of 6 years and to be sold at the end of that time for $9,500. Part a Develop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and the Excel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimum time. Year 1 $ LA 2 $ LA 5 3 $ LA $ LA $ LA 6 $ Depreciation $ $ LA LA $ LA $ LA LA Book Value

Major medical complexes and their service providers continue to move toward advanced health informatics - acquiring, managing, and using information to provide better healthcare. A new analyzer for researching and evaluating patient samples, and making informed recommendations in the treatment of complex blood cancers, is purchased for $250,000. It is estimated to have a useful life of 6 years and to be sold at the end of that time for $9,500. Part a Develop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and the Excel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimum time. Year 1 $ LA 2 $ LA 5 3 $ LA $ LA $ LA 6 $ Depreciation $ $ LA LA $ LA $ LA LA Book Value

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Friendly Tests Inc. is a commercial testing lab, performing a variety of lab tests for hospitals in the area. The management is considering an addition of a new type of test. There is plenty of room in its existing lab facility, but the new test would require an acquisition of new test equipment. The purchase price of the equipment is $215,000. It will be depreciated using MACRS 7-year recovery period (use the rates listed in Table 16-2 in the textbook). The management expects the demand for the new test type to only last 6 years, and therefore the project is expected to end in 6 years, and the equipment to be sold for$60,000 at the end of year 6. The company will also need to hire a part-time lab technician, for $30,000 in the first year of the project, with an annual pay increase of 5% each year after. Equipment maintenance and operating costs are expected to be $4,000 per year. It is also expected additional supplies will be needed, costing $10,000 per year. The additional revenues…
Friendly Tests Inc. is a commercial testing lab, performing a variety of lab tests for hospitals in the area. The management is considering an addition of a new type of test. There is plenty of room in its existing lab facility, but the new test would require an acquisition of new test equipment. The purchase price of the equipment is $215,000. It will be depreciated using MACRS 7-year recovery period (use the rates listed in Table 16-2 in the textbook). The management expects the demand for the new test type to only last 6 years, and therefore the project is expected to end in 6 years, and the equipment to be sold for$60,000 at the end of year 6. The company will also need to hire a part-time lab technician, for $30,000 in the first year of the project, with an annual pay increase of 5% each year after. Equipment maintenance and operating costs are expected to be $4,000 per year. It is also expected additional supplies will be needed, costing $10,000 per year. The additional revenues…
Friendly Tests Inc. is a commercial testing lab, performing a variety of lab tests for hospitals in the area. The management is considering an addition of a new type of test. There is plenty of room in its existing lab facility, but the new test would require an acquisition of new test equipment. The purchase price of the equipment is $215,000. It will be depreciated using MACRS 7-year recovery period (use the rates listed in Table 16-2 in the textbook). The management expects the demand for the new test type to only last 6 years, and therefore the project is expected to end in 6 years, and the equipment to be sold for $60,000 at the end of year 6. The company will also need to hire a part-time lab technician, for $30, 000 in the first year of the project, with an annual pay increase of 5% each year after. Equipment maintenance and operating cost is expected to be $4, 000 per year. It is also expected additional supplies will be needed, costing $10,000 per year. The additional revenues…
A Corporation manages the back office functions of private medical practices. The company is analyzing a project to digitize the collection of medical records. Last year, the company spent $400,000 during a pilot project to prove that the digitization project was a viable idea, and now the company is evaluating whether to invest in it. Acquiring the necessary computer hardware and software to implement the project will cost $10,000,000. In addition, successful implementation will require the corporation to spend $1,300,000 to install and customize the software, plus $700,000 to purchase hand-held digital devices that medical staff will use to record medical data. Corporation will depreciate the system over 4 years to a net book value of zero. The corp expects an immediate increase in its Accounts Receivable balance of $200,000 as a result of the project. Because the purchases of paper forms and files will decline, the company also expects an immediate decrease in Accounts Payable of…
The hospital where you are employed is continuing with their analysis with the goal of opening a walk-in clinic. After conducting additional research, the financial projections for the first year of operations are as follows: Revenues (from 10,000 visits): $400,000 Wages and benefits: $220,000 Rent: $5,000 Depreciation: $30,000 Utilities: $2,500 Medical supplies: $50,000 Administrative supplies: $10,000 Assume that all costs are fixed except supply costs, which are variable. Assume that the clinic will be required to pay taxes at a 30% tax rate. Respond to the following questions. Be sure to show your work for all calculations. Prepare the clinic’s projected Profit and Loss (P&L) Statement. (8 points) What number of visits is required to break even? (3 points) What number of visits is required to provide you with an after-tax profit of $100,000? (4 points)
In September 2015, a 3.45 megawatt cooling,heating, and power (CHP) system was placed in intooperation for Southeast Regional Hospital with 360beds. The CHP system was part of a new 20,000 sq.ft. central utility plant that provided the 800,000 sq. ft.health-care facility with cooling, heating and power.By centralizing all of the utilities in one location, thehospital accrued significant energy savings, as wellas improved maintenance efficiency. The financialfacts related to the project are summarized as• Installed cost: $2.5 million• Annual energy cost savings: $786,000• Annual O&M costs: $233,000• Project service life: 15 years• Salvage value: $200,000At an interest rate of 8%, what is the net savings perdollar invested?
Alva Community Hospital has five laboratory technicians who are responsible for doing a seriesof standard blood tests. Each technician is paid a salary of $30,000. The lab facility representsa recent addition to the hospital and cost $300,000. It is expected to last 20 years. Equipmentused for the testing cost $10,000 and has a life expectancy of 5 years. In addition to the salaries,facility, and equipment, Alva expects to spend $200,000 for chemicals, forms, power, and othersupplies. This $200,000 is enough for 200,000 blood tests.Required:Assuming that the driver (measure of output) for each type of cost is the number of blood testsrun, classify the costs by completing the following table. Put an X in the appropriate box forvariable cost, discretionary fixed cost, or committed fixed cost.
Rio Grande Medical Center is needing to expand their HIM department. In order to move forward with the renovation and gain the needed square footage, all old records in storage will need to be archived. After researching the archival process, it is determined the archiving will be done via microfilm with a budget of $300,000 over a two-year period. You have contracted with a company to perform the microfilm services at $0.07 per page and have estimated that there are about 4.5 million pages to be converted. At the end of the first year, you review the invoice and see that you have been billed for converting 2,083,333 pages. Determine your budget variance and what type it is. Provide a short explanation that can be given to administration regarding the variance.
An IE works in the automation department of a surgical equipment manufacturing company that produces specially ordered equipment for hospitals. To upgrade the quality of the assembly process of the camera used in laparoscopic surgery probes, two approaches are available: make and buy. The make alternative has an initial equipment cost of $175,000, a life of 5 years, a $25,000 salvage value, a processing cost of $3,000 per camera, and an M&O cost of $65,000. The buy alternative requires contracting the assembly operation externally at a cost of $6,000 per camera. If the MARR is 12% per year, how many cameras per year must be assembled to justify the make alternative? cameras must be assembled per year to justify the make alternative.
The hospital is considering the purchase of imaging equipment worth $25,000 to improve its visual capture results, and improve outcomes. The operating costs will be reduced by $7,000 per year. The computer has an estimated life expectancy of 5 years, and an estimated salvage value of $5,000. What is the profitability index if the discount rate is 8%. Ignore reimbursement considerations.
In 2018, the Port of Spain General Hospital purchases a scanner at a cost of $ 100,000. The scanner has a useful life of 5 years with no residual value. It is depreciated using the straight line method and its annual operating costs are $ 120,000. In 2019 the hospital is approached by another supplier to purchase a more modern machine for $ 115,000. This new machine has a life span of 4 years and will save $ 25,000 in annual operating costs. The new supplier is willing to buy the old scanner for $ 30,000. Required: a) Compute the gain or loss if the old scanner is replaced in 2019. b) Advise the hospital on the purchase of the new scanner.
In 2018, the Port of Spain General Hospital purchases a scanner at a cost of $ 100,000. The scanner has a useful life of 5 years with no residual value. It is depreciated using the straight line method and its annual operating costs are $ 120,000. In 2019 the hospital is approached by another supplier to purchase a more modern machine for $ 115,000. This new machine has a life span of 4 years and will save $ 25,000 in annual operating costs. The new supplier is willing to buy the old scanner for $ 30,000. Required: Compute the gain or loss if the old scanner is replaced in 2019. 2. Advise the hospital on the purchase of the new scanner.