Home / Questions / Complete each of the following four problems using the TVOM calculations within Excel. Th
Complete each of the following four problems using the TVOM calculations within Excel. The assignment MUST be done on an Excel spreadsheet (you will need to create your own spreadsheet) and MUST use TVOM calculations within Excel. These functions are under the Fx button in Excel, then look under the Financial Functions. The Fx Function is located just above the actual number section of your spreadsheet, right above the B or C column in most blank spreadsheets and most versions of Excel. Just click on the Fx button and then search for the specific function (present value, future value, etc., whatever you are trying to calculate).
Problem 1: What is the present value of:
a. $9,000 in 7 years at 8 percent?
b. $20,000 in 5 years at 10 percent?
c. $10,000 in 25 years at 6 percent?
d. $1,000 in 50 years at 16 percent?
Problem 2: If you invest $9,000 today, how much will you have:
a. In 2 years at 9 percent?
b. In 7 years at 12 percent?
c. In 25 years at 14 percent?
d. In 25 years at 14 percent (compounded semiannually)?
Problem 3: Your uncle offers you a choice of $30,000 in 50 years or $95 today. If money is discounted at 12 percent, which should you choose?
Problem 4: Your aunt offers you a choice of $60,000 in 40 years or $850 today. If money is discounted at 11 percent, which should you choose?
Dec 04 2019 View more View Less
A SECOND STUDY Organizational Learning Impact On Green Innovation: the mediating role of absorptive capacity "A Case Study at Al-Youm Food Company" Jordan. Question Four:...
Apr 02 2021Mix Co. started the year with no inventory. During the year, it purchased two identical inventory items. The inventory was purchased at different times. The first purchas...
May 09 2020At the interest rate of 5%, the people of the country of Rupertopia are willing to lend $10,000 to local business, while local businesses are willing to borrow $20,000. W...
May 05 2020nition 1.1.1 (here A and B are events): Prove the following results, using the properties of the probability measure in Defi- a) P(AC) = 1 - P(A). b) P(A U B) = P(A) + P(...
Aug 02 2020Larkspur Company has two classes of capital stock outstanding:8%, $20 par preferred and $5 par common. At December 31, 2017, thefollowing accounts were included in stockh...
Jun 01 2021If a sample of an isotope having a mass number of decays at a rate of what is its halflife
Feb 15 2020Anpin=0.83 Problem 6 (10 points) Larry's boat shop wants to monitor the number of blemishes in the paint of each boat. Construct a 3-sigma control chart to determine if t...
Aug 22 2020Two persons use a large winch to raise a mass of 470 kg. The radius of the wheel is 48 cm and the radius of the axle is 4.0 cm. (a) What force is required to lift the lo...
May 10 20206. What nursing care and teaching do patients with absorption disorders require?
Apr 28 2020L. Bowers and V. Lipscomb are partners in Elegant Event Consultants. Bowers and Lipscomb share income equally. M. Ortiz will be admitted to the partnership. Prior to the ...
May 05 2021