{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

annuity_calc(1)

# annuity_calc(1) - The solution will be such that the cash...

This preview shows page 1. Sign up to view the full content.

Berk/DeMarzo, Corporate Finance Annuity Spreadsheet 1 Instructions NPER RATE PV PMT FV Excel Formula Given 15 8.00% -20,000 0 Solve For FV 63,443 =FV(0.08,15,0,-20000) Date 0 1 2 15 PV (20,000) PMT 0 0 ... 0 FV 63,443 Cash Flow (20,000) 0 0 63,443 Enter 4 of the items NPER, RATE, PV, PMT, or FV in the shaded area below, and the annuity calculator will solve for the fifth item.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The solution will be such that the cash flows shown on line 14 have NPV = 0. Note that PV, PMT, and FV are initially set to round to the nearest dollar. To change this default, right click and select "Format Cells > Number > Decimal Places" and enter the desired precision....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online