Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help Every year $12,000 are continuously deposited to a fund, which offers a continuous compounding interest rate of 10% per year. How can you calculate
help
Every year $12,000 are continuously deposited to a fund, which offers a continuous compounding interest rate of 10% per year. How can you calculate its future worth in 10 years in Excel? a. FV(0.1, 10, -12000 (exp(0.1)- 1)/0.1) b. FV(0.1,10,-12000) c. FV ((exp(0.1) 1), 10, -12000) d. FV(exp(0.1)-1, 10,-12000 * (exp(0.1)-1)/0.1) Consider to use a 12-month equal payment plan to pay off a loan of $10,000 @ 12% of nominal interest rate compounded monthly. If the first payment is scheduled 2 years after receiving the principal amount. In how many payments is there no principal paid? b. 3 c. 4 d. 5 If you borrow $10,000 at 12% monthly compound interest and repay the loan with 10 monthly payments, what will be the size of the last payment if you increase the payment each time by $100 on top of the previous payment? bu51,25.90 c$1201.12 d. None of above a. $1,410.52 b. $1,350.00 c. $1,201.12 d. None of aboveStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started