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
Which of the following includes all of the others?a. homeotic genesb. master regulatorsc. SRY gened. PAX6
Jul 04 2021The function x(t) is shown below. Sketch the function y1 (t)-x(-t) in the space provided. 2. x(t) 10 0 2 4 t(sec) -10 Answer: y1 (t) 10 2 t(sec) -10 >
Jul 13 2020Read “An Organizational Behavior Moment” on page 76 at the end of Chapter 2 and on page 114 at the end of Chapter 3. Choose one of the two “Moments” and present your answ...
May 25 20182.On January 1, 2012, Stewart Corporation had 1,000,000 ordinary shares outstanding. On March 1, the corporation issued 150,000 new shares to raise additional capital. On...
Jun 17 2021At the end of the current year, Accounts Receivable has a balance of $800,000, Allowance for Doubtful Accounts has a credit balance of $7,500, and sales for the year tota...
May 02 20211 through 3
Sep 19 2020Criteria Excellent The student shows how three tools are T Discuss and show how tools are used used to implement fiscal policy by to implement fiscal policy by changing c...
Feb 01 2020Suppose you own an outdoor recreation company and you want to purchase all-terrain vehicles (ATVs) for your summer business and snowmobiles for your winter business. Your...
Apr 04 2020Analysis of water for dissolved oxygen experiment A. Standard Sodium Thiosulfate SolutionFind the molarity of 1. Mass in grams of in is Aliqout volume is Sample Sample ...
May 17 2021Oceanwide Enterprises, Inc., is involved in building and operating cruise ships. Each ship is identified as a separate discrete job in the accounting records. At the end ...
Apr 20 2020