A European-based cattle genetics engineering research lab is planning for a major expenditure on research equipment. The lab needs $5 million of today’s dollars so that it can make the acquisition 4 years from now. The inflation rate is steady at 5% per year. (a) How many future dollars will be needed when the equipment is purchased if purchasing power is maintained? (b) What is the required amount of the annual deposit into a fund that earns the market rate of 10% per year to ensure that the amount calculated in part (a) is accumulated? (c) Write a single-cell spreadsheet function that immediately displays the correct annual deposit required.
What will be an ideal response?
(a) To maintain purchasing power, use f to find future dollars.
F = 5,000,000(F/P,5%,4)
= 5,000,000(1.2155)
= $6,077,500
(b) Use market rate to find A
A = 6,077,500(A/F,10%,4)
= 6,077,500(0.21547)
= $1,309,519 per year
(c) Function: = - PMT(10%,4,,-FV(5%,4,,5000000)) displays A = $1,309,530
You might also like to view...
When working with process equipment, which of the following factors should process technicians be aware of that can have an impact on worker safety or the environment?
A. Excess vibration B. Lack of proper PPE C. Not complying with government regulations D. All of the above
The purpose of planning and decision making is to
a. serve as a guide for future activities. b. monitor organizational progress. c. structure the organization for effective goal attainment. d. get the members of the organization to work together. e. enhance the company’s image.
Which type of shielding utilizes braid, foil, metal wrap, conduit or twisted wire around a conductor?
a. Cable. b. Circuit. c. Facility. d. Equipment.
Automatic connections between what type of devices create a piconet?
A. VoIP B. Infrared C. Bluetooth D. WirelessHD