Question: Complete the 3 following Finance problems using Excel, upload the excel file if possible, if not explain detailed how to input it into excel, and

Complete the 3following Finance problems using Excel, upload the excel file if possible, if not explain detailed how to input it into excel, and the answers.
1)PRESENT VALUE What is the present value of a security that will pay $29,000in 20years if securities of equal risk pay 5%annually?
2)TIME FOR A LUMP SUM TO DOUBLE If you deposit money today in an account that pays 4%annual interest, how long will it take to double your money?
3)PRESENT VALUE OF AN ANNUITY Find the present values of these ordinary annuities. Discounting occurs once a year.
a.
$600per year for 12years at 8%
b.
$300per year for 6years at 4%
c.
$500per year for 6years at 0%
d.
Rework parts a,b,and c assuming they are annuities due.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!