Question
How to calculate this with excel ( need the formulas) 9. What is the present value factor in five years at 10 percent? 10. What
How to calculate this with excel ( need the formulas)
9. What is the present value factor in five years at 10 percent?
10. What is the present value of receiving $50,000 in five years at 10 percent?
11. What is the future value factor in seven years at 12 percent?
12. What is the future value of $30,000 in seven years at 12 percent?
13. What is the mortgage constant of a 30-year fixed-rate mortgage with monthly payments at 5 percent?
14. What is the monthly mortgage payment of a 30-year fixed-rate mortgage of $100,000 at 5 percent?
15. What is the value of a 20-year mortgage with monthly payments of $824.95 at 5 percent?
16. What is the value of a 20-year mortgage with monthly payments of $824.95 at 3 percent?
17. What is the value of a 20-year mortgage with monthly payments of $824.95 at 7 percent?
18. Suppose you borrow $325,000 at six percent for 30 years with monthly payments. What is the payoff (balloon payment) in three years?
19. Suppose you borrow $325,000 at six percent for 30 years with monthly payments and a prepayment penalty of 2 percent. What is the payoff (balloon payment) in three years?
20. What is the monthly payment in year six of an adjustable-rate mortgage where $350,000 is borrowed at an interest rate of 4.5 percent for the first five years that resets to 6 percent in year six?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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