Explore BrainMass

# Discounted Cash flow valuation

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Your company will generate \$65,000 in cash flow each year for the next 10 years from a new information database. The computer system needed to set up the database costs \$307,000. (Round your answer to 2 decimal places. Omit the "\$" sign in your response.)

1) If you can borrow the money to buy the computer system at 8.25 percent annual interest, the present value of the savings is \$ ----------- .

2) The present value of the revenue ----------- greater than the cost, so your company ----------- afford the equipment.

3) An investment will pay you \$59,000 in 6 years. If the appropriate discount rate is 9 percent compounded daily, the present value is \$ -------- . (Round your answer to 2 decimal places.

4) Beginning three months from now, you want to be able to withdraw \$1,000 each quarter from your bank account to cover college expenses over the next 4 years. If the account pays 1.25 percent interest per quarter, you need to have \$ --------- in your bank account today to meet your expense needs over the next four years .(Round your answer to 2 decimal places

5) Amortization with Equal Principal Payments
Prepare an amortization schedule for a 3-year loan of \$45,000. The interest rate is 15 percent per year, and the loan calls for a principal reduction of \$15,000 every year. (Omit the "\$" sign in your response.)

Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance
1 45,000
2
3

Total interest paid: \$

6) Calculating Present Values
In 2001, an athlete signed a contract reported to be worth \$302 million. Including a deferred signing bonus, he would receive \$29 million per year from 2001-2004, \$32 million in 2005, \$30 million in 2006, and \$31 million per year from 2007-2010. Assume the first payment is made immediately, and the next payment occurs in exactly one year. If the appropriate interest rate is 12 percent, the present value of the contract is \$ --------- .

#### Solution Preview

The answers are in attached file:

Note:
PVIF= Present Value Interest Factor for a single Sum
PVIFA= Present Value Interest Factor for an annuity
Your company will generate \$65,000 in cash flow each year for the next 10 years from a new information database. The computer system needed to set up the database costs \$307,000. (Round your answer to 2 decimal places. Omit the "\$" sign in your response.)

If you can borrow the money to buy the computer system at 8.25 percent annual interest, the present value of the savings is \$ .

Present Value of savings = Present value interest factor for annuity (PVIFA) x Annuity
PVIFA (10 years, 8.25%) = 6.635070
Annuity = \$65,000
Therefore, present value of savings = 6.635070 x \$ 65,000 =\$ 431,279.54
The present value of the revenue greater than the cost, so your company afford the equipment.

An investment will pay you \$59,000 in 6 ...

#### Solution Summary

Questions on Discounted Cash flow valuation have been answered.

\$2.19