Answered step by step
Verified Expert Solution
Link Copied!

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! image text in transcribed
image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Municipal Finances A Handbook For Local Governments

Authors: Catherine D. Farvacque-Vitkovic, Mihaly Kopanyi

1st Edition

ISBN: 082139830X, 978-0821398302

More Books

Students also viewed these Finance questions