Question: @ Please answer all the questions using Excel. FV() is an Excel function that is used for savings situations when you are earning interest. PMT()
@ Please answer all the questions using Excel.
FV() is an Excel function that is used for savings situations when you are earning interest.
PMT() is an Excel function that is used for loan situations when you are paying out interest.
@ Choose FV() or PMT() to answer questions.
Emily and Steve just had their first baby, Carolyn. They plan to start a college fund with the $2000 Emily's mother gave them. If they find a savings account with an APR of 3.8% and they add $150 to the account every month, how much money will be in the account when Carolyn turns 18?
| APR= | APR= |
| n= | n= |
| Y= | Y= |
| PMT= | P= |
| P= | PMT= |
| FV= |
Jacob can only afford a payment of $500 per month for the new boat he plans to purchase for himself. He qualifies for a 5-year loan with 1.75% APR. What is the maximum purchase price he can afford?
| APR= | APR= |
| n= | n= |
| Y= | Y= |
| PMT= | P= |
| P= | PMT= |
| FV= |
Judy wants to start saving money for a down payment on a house with the $2,500 tax refund she just received. Her goal is to have $20,000 after 2 years of saving. If her savings account has an APR of 1.9% compounded monthly, how much does she need to add to the account each month to accomplish her goal?
| APR= | APR= |
| n= | n= |
| Y= | Y= |
| PMT= | P= |
| P= | PMT= |
| FV= |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help