Upload your study docs or become a
Course Hero member to access this document
Unformatted text preview: Investment period (yrs) 3.00 Annual Percentage Rate 7.00% Quarterly interest rate 1.75% 1 2 Monthly cash flows $0.00 $1,500.00 $1,500.00Account balance$1,500.00 $3,026.25Long Form Future value annuity factor 13.2251 Future value of annuity$ 19,837.66 Excel Function Future value of annuity $19,837.66 〖 〖〗 ?? _=?×1/ ( 〖 (1+) 〗 ^−1) 3 4 12... $1,500.00 $1,500.00$1,500.00 $4,579.21 $6,159.35 $ 19,837.66 Assumptions Periodic payments Number of payments per year Interest rate (APR) Target account value Monthly interest rate 1 2 Monthly cash flows Account balance Excel FunctionNumber of months to reach target Number of Periods =NPER(rate,pmt,pv,[fv],[type]) 3 4 5 6 N ... Assumptions Periodic payments $ 1,800.00 Number of payments per year 12.00 Life of loan (yrs)5.00Amount of loan $ 90,000.00 1 2 Monthly cash flows $90,000.00-$1,800.00-$1,800.00 Excel Function Implied periodic interest rate 0.62% Implied APR 7.42% Interest Rate =RATE(nper,pmt,pv,[fv],[guess]) 34 60 ...-$1,800.00-$1,800.00-$1,800.00...
View
Full Document
