Unformatted text preview: the first interest payment being made July 1, 2017. The bonds were sold to yield 12%. Using the Excel Present Value Function find the PV and have the answer appear in cell F26 below. The present value for problem 3 is = 4. Jill Morris is leasing a small business computer from Eller Office Equipment Company for 6 years. The lease requires 12 semi-annual payments of $10,000 each with the first payment being made when the lease is signed and has an 8% effective (market) rate of int Using the Excel Present Value Function find the present value of the lease when it is signed at the beginning of the lease. Have present value answer appear in cell F37 below. The present value for problem 4 is = ($390,084.61) ($54,026.89) ($558,394.78) terest. ($97,604.77)...
View Full Document
- Spring '14
- Time Value Of Money, Finance lease, Excel Present Value Function