Question: If we receive $ 5,000, eight years from now, how much is that equivalent to today, if we believe that we can earn 5 percent

If we receive $ 5,000, eight years from now, how much is that equivalent to today, if we believe that we can earn 5 percent on other opportunities? See earlier NOTE regarding requirements for Exercises.
A. Solve using a spreadsheet program such as Excel. Indicate the spreadsheet formula showing numeric values rather than cell references. For example, for the value that $ 100 today could grow to in two years, assuming 10 percent annual compounding, the spreadsheet solution formula would be: FV(10%, 2, 0, 100). Note that since there is no payment (PMT) in this problem, it is necessary to show the blank between two commas or a zero after the number of periods. In addition, answer the questions using formulas with cell references.
B. Solve using a financial calculator. This is optional.

Step by Step Solution

★★★★★

3.32 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style45 msonumberformat00220022 00000220022 00000220022 00220022 msostylenam... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

369-B-F-F-M (5530).xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

The List Company, which can earn 7 percent on money market instruments, currently has a lockbox arrangement with a New Orleans bank for its Southern customers. The bank handles $3 million a day in...

Calculate and rank the equivalent values eight years from now of the following cash flow streams: (i) A single payment of $5000 today. (ii) An ordinary annuity starting today with eight annual...

Brenda Young desires to have $10,000 eight years from now for her daughter's college fund. If she will earn 7 percent (compounded annually) on her money, what amount should she deposit now? Use the...

Solve using a spreadsheet program such as Excel. Indicate the spreadsheet formula showing numeric values rather than cell references. For example, for the value that $100 today could grow to in 2...

https://youtu.be/733mgqrzNKs https://youtu.be/TDpuYH7d7Nc TVM Spreadsheet Problems . Use the youtube link to solve for the problems 5-14 to 5-19 . 5-14. How much will $20,000 invested today at 3...

Task: Use excel and the appropriate formulas to complete the following problems. Identify the knowns and solve for the unknown. accordingly. Save your file as lastname.firstname.hw 4 3 and upload it...

Hi, I do not understand how to determine the responses to the following questions and if this is TVM. 5-15. If we receive $5,000 eight years from now, how much is that equivalent to today if we...

Instead of total sales volume, examine average sales volume. Right-click on the Total Sales by Customer tab, and duplicate. Rename this tab Average Sales by Customer. Click on the dropdown arrow ne...

If we receive $5,000 eight years from now, how much is that equivalent to today, if we believe that we can earn 5 percent on other opportunities? Show work(formula) in Excel

Variances are differences between __________ and __________ revenues or expenses. The three factors involved in variance analysis are __________, __________ and __________.5-15. If we receive $5,000...

The Cubbie Inn is a restaurant in DeKalb, Illinois. It specializes in deluxe sandwiches in a moderate price range. Bill Michael, the manager of Cubbie Inn, has determined that during the last 2 years...

The following information appeared in a footnote to the 2011 annual report of Delta Air Lines, Incorporated: The following table summarizes, as of December 31, 2011, our minimum rental commitments...

Company A has 3 6 . 8 8 million shares outstanding trading at $ 2 . 7 8 each ( the same shares were $ 3 . 1 1 last week ) . Company B has 1 2 6 . 1 5 million shares outstanding trading at $ 1 1 . 4 2...

An examination of a financial forecast is a professional service that involves a. Compiling or assembling a financial forecast that is based on managements assumptions. b. Limiting the distribution...

Commercial banks moved heavily into equipment leasing during the early 1970s, acting as lessors. One major reason for this invasion of the leasing industry was to gain the benefits of accelerated...

One alleged advantage of leasing voiced in the past is that it kept liabilities off the balance sheet, thus making it possible for a firm to obtain more leverage than it otherwise could have. This...

CAN SOMEONE ANSWER PART C QUESTION 3: Show work. Consider the following information about three stocks: a. If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the...

P89 Rate of return, standard deviation, and coefficient of variation Mike is searching for a stock to include in his current stock portfolio. He is interested in Hi-Tech, Inc.; he has been impressed...

7. Your country's employment rate is a micro factor that affects your financial thinking. True False 8. One popular spending plan allocates your after-tax dollars as follows: 20% for necessities, 30%...