Excel File Edit View Insert Format Tools Data Window $ Help Gr Home Layout Table
ID: 2808311 • Letter: E
Question
Excel File Edit View Insert Format Tools Data Window $ Help Gr Home Layout Tables Charts S SmartArt Formulas Data Review Alignment | abc, Wrap Text EMerge" Edit Font 111.EA-A/ abc., Fill Calibri (Body) Clear N2 1. What is the future value of a $21,000 deposit earning 5.3% interest compounded quarterly at the end of two years? 412. what should an investor pay for an investment promising an $18,000 return after five years i, a 12% 25 return on investment is projected? 26 27 28 29 30 31 32 35 3. An Investor has an opportunity to invest in a rental property that will provide net cash returns of $1,500 36 per year for five years. The investor believes that an annual return of 10% should be earned on the property 34 37 How much should be paid for the property? 38 39 40 42 43 46 47 4.What is the formula for calculating a single present value payment? 48 49 Sheet, +Explanation / Answer
1.
=FV(5.3%/4,2*4,-21000)=$176,000.92
2.
=PV(12%,5,0,-18000)=$10,213.68
3.
=PV(10%,5,-1500)=$5,686.18
4.
=PV()
P.S.: I am allowed to answer only 4 questions
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.