Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help putting info into excel. thanks! 8) Selma and Troy are planning to take a second honeymoon in two years. They estimate that the
need help putting info into excel. thanks! 8) Selma and Troy are planning to take a second honeymoon in two years. They estimate that the cost will be roughly $7,985 74. They plan to make monthly payments of $275 and expect to receive 10% annual interest on their savings. Given this information: a) Would they be able to take the vacation (what is the exact amount over or under their goal)? b) What must the annual interest rate be in order to make their goal exactly? c) What must their monthly savings payments be in order to reach their goal if the annual interest rate drops 4.5% below the rate found in part b of this problem? 13 14 13 Relevant Information Annual Interest Rate Periods Per Year Number of Years Needed Information Present Value Future Value Payment Rate Number of Periods PV FV PMT RATE NPER Additional Calculations (if needed)
need help putting info into excel. thanks!
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