Question: ? - x 10 S. Calculating present values - Excel FORMULAS DATA REVIEW FILE VIEW HOME INSERT PAGE LAYOUT Sign In Calibri - 11 M
? - x 10 S. Calculating present values - Excel FORMULAS DATA REVIEW FILE VIEW HOME INSERT PAGE LAYOUT Sign In Calibri - 11 M A A - Cells Paste BIU Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X B D A E F G H 1 1 2 3 An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent compounded daily, what is the present value? 4 5 6 7 Future value of investment Number of years Discount rate Times compounded per year 65,000 10 7% 365 8 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. 13 Present value of investment 15 16
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
