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
ſ sinx cos3x dx Select one: O cos2.c 2 cos4r tc sin2.r b. sin4x + tc c. sin 2x 2 sin4r tc d. cos2.r 4 cos4x te 8
Apr 25 2021George Atlas started a business on June 1, 20-. Analyze the following transactions for the first month of business using T accounts. Label each T account with the title o...
Aug 10 2021Using First Partial DerivativesIn Exercises 107 and 108, determine whether there exists a function f ( x, y ) with the given partial derivatives. Explain your reasoning. ...
Aug 01 2021Sketch a first-order step response: mark off increments on the abscissa as multiples of the time constant; mark off the ordinate as a fraction of the long-term response. ...
Jun 10 2020The multiplier effect means that:A. consumption is typically several times as large as saving.B. a change in consumption can cause a larger increase in inve...
May 01 20211. “Organizations are more likely to succeed when they have an adaptive culture.” What can an organization do to foster an adaptive culture?2. Acme Corp. is planning to a...
May 20 2020One page abstract around describe the whole project(summary) with the abstract keywords: most imp words in the project Table of contents Introduction maximum 3 pages main...
Jul 27 2020What are the characteristics of Intensive subsistence agriculture?
Aug 19 2021Draw an example of a red-black tree that is not an AVL tree.2. Give a proof of Proposition 11.93. Give a proof of Proposition 11.10
Jun 11 2020To make sure you have mastered pronouns, read the following sentences and identify any faulty pronoun use. Write an improved form in the space provided. Each sentence con...
Jun 16 2021