Spreadsheet #1 (F17) due 917 2S points assume all cash flows occur annually and

Question

Spreadsheet #1 (F17) due 917 2S points assume all cash flows occur annually and interest is annually =-PV(rate,nper.pmt.fv,type) the PV function gives a negative result; to make it appear as positive, put a minus sign before PV rate-annual interest rate always a cell reference to a data cell nper . # of years always a cell reference to a data cell pmt-amount of annual cash flow for an annuity (0 for a single sum) annuity: cell reference to a data cell single sum: 0 is a constant and therefore may be typed in the function fv-amount of a single cash flow (0 for an annuity) single sum: cell reference to a data cell annuity: 0 is a constant and therefore may be typed in the function type-0 for an ordinary annuity, I for an annuity due (omit for a single sum) depending on the situation, may be a cell reference to a data cell or a constant; for this assignment you may assume it is a constant and therefore may be typed in the function

Explanation / Answer

Please hit the like button if the answer helped you else leave a comment for further clarification.

Thank you! All the best!

a.1. =PV(0.08,5,,-1,0) 0.68058 2 =PV(0.08,5,-1,,0) 3.99271 3 =PV(0.08,5,-1,,1) 4.31213 b.1 =10000*0.68058 $6,805.83 2 =2000*3.99271 $7,985.42 3 =2000*4.31213 $8,624.25 c.1 =PV(0.08,5,,-10000,0) $6,805.83 2 =PV(0.08,5,-2000,,0) $7,985.42 3 =PV(0.08,5,-2000,,1) $8,624.25

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.