Question: Challenge Problem (A computer spreadsheet software program or a financial calculator that can handle uneven cash flow streams will be needed to solve the following

Challenge Problem (A computer spreadsheet software program or a financial calculator that can handle uneven cash flow streams will be needed to solve the following problems.) The following cash flow streams are expected to result from three investment opportunities.

Investment Investment Investment Stable Declining $35,000 30,000 20,000 5,000 Growing $10,000 15,000

a. Find the present values (PVs) at the end of time period zero for each of these three investments if the discount rate is 15 percent. Find the PVs for each investment using 10 percent and 20 percent discount rates.

b. Find the future values (FVs) of these three investments at the end of year five if the compound interest rate is 12.5 percent. Also find the future values for each investment using 2.5 percent and 22.5 percent compound rates.

c. Find the PVs of the three investments using a 15 percent annual discount rate but with quarterly discounting. Find the PVs for semi-annual and monthly discounting for a 15 percent stated annual rate.

d. Find the FVs of the three investments using a 12.5 percent annual compound rate but with quarterly compounding. Find the FVs for semi-annual and monthly compounding for a 12.5 percent stated annual rate.

e. Assume that the PV for each of the three investments is $75,000. What is the annual interest rate (%i) for each investment?

f. Show how your answers would change in (e) if quarterly discounting takes place.

g. Assume that the FV for each of the three investments is $150,000. What is the annual interest rate (%i) for each investment? [Note: (e) and (g) are independent of each other.]

h. Show how your answers would change in (g) if quarterly compounding takes place.

Because of more frequent than annual compounding and the complexities associated with uneven cash flows, we show results only for the “Stable” investment. The future value of the investment is $150,000, the period cash flow is $5000, and the number of periods is 20. This results in a compound rate of 4.0715% quarterly, or 16.29% (4.0715% x 4) annually.

Investment Investment Investment Stable Declining $35,000 30,000 20,000 5,000 Growing $10,000 15,000 20,000 30,000 50,000 Y ear $20,000 20,000 20,000 20,000 20,000

Step by Step Solution

★★★★★

3.50 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b c We are only presenting results for the stable investment To calculate present values using more frequent than annual discounting when uneven cas... 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)

433-B-A-I (5619).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Solve the following problems for x(t). Compare the values of x(0+) and A(0-). For parts (b) through (d), also compare the values of i(0+) and i(0-). a. 7* + 5x = 48(t) x(0-) = 3 b. 3x + 30x + 63x =...

Solve the following problems for x(t): a. 5x + 3x = 10 +t? x(0) = 2 b. 4x + 7x = 6te 5t + e-3t x(0) = 5 c. 4x + 3x = te-3t sin 5t x(0) = 10 * (0) = -2

A. For the following table of information: i. Draw the network diagram ii. List the network paths iii. Determine the critical path(s) iv. Determine the float for each activity Prepare a detailed...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

This assignment is to review Amazon?s most recent financial statements (provided) and find recent business articles on Amazon (examples provided) to get the answer to the following: 1. What does...

This case MUST be submitted in a Word document. Your Exhibits should be in an Excel spreadsheet, but that is not required. Develop a five-year strategic plan with cost estimates and a time line. It...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

1. You have $49,061.69 in a brokerage account, and you plan to deposit an additional $5,000 at the end of every future year until your account totals $200,000. You expect to earn 9.1% annually on the...

Problems 85 (a-6) a. Find the present values of the following cash flow streams. The appropriate Uneven Cash interest rate is 8 percent. (Hint: It is fairly dealin Fow Stwith the individual cash...

For the last six years, Ms. Sarah Delmor has carried on the business called operated Delmor Industries as a sole proprietor. The business has been very successful and, as a consequence, has...

Alices parents are very strict with her. In her family, her father always makes decisions about everything from what kind of car they will buy to how weekend time is spent. She is required to obey...

Given the normally distributed variable X with mean 18 and standard deviation 2.5, find (a) P(X

An investor sells a TUV Sep 70 put for 5 and sells a TUV Sep 80 call for 4. If the investor closes the put for 4 and the call for 3, what is the gain or loss? (A) $200 loss (B) $200 gain (C) $400...

What major trends are changing the content of the financial statements prepared by financial firms?

What are the key features or characteristics of the financial statements of banks and similar financial firms? What are the consequences of these statement features for managers of financial-service...

What are the principal accounts that appear on a bank's balance sheet (Report of Condition)?

Spiller Corporation plans to issue 8%,9-year, $410,000 par volue bonds payable that poy interest semlannually on June 30 and December 31 . The bonds are dated January 1 of the current year and are...

A study probing how cell phone use immediately before bed affects sleep was performed. In the study, the length of time it took participants to fall asleep in minutes while in a controlled...

Apply EXTRACT-MAX(A, 10) on the following heap A , and show all steps to build the new heap tree. [1 Points] 10 9 3 20 8 50 30 1 0 15