Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Chapter 5 - More TVOM Problems Instructions: Complete each of the following four problems using the TVOM calculations within Excel. The assignment MUST be done

image text in transcribed
Chapter 5 - More TVOM Problems Instructions: 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). If you do not use the Excel functions you will lose 4 out of the 5 points on this assignment. Getting EACH answer correct using the spreadsheet function =4 points. Having good presentation =1 point. If you get the answers correct and have a good presentation, but you do NOT use the EXCEL TVOM functions, you will get 1 point. Problem 1: What is the present value of: 3. $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. ln7 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions