Question

In: Finance

You plan to visit France for 6 months, (starting next month). You will spend $7,558 in...

You plan to visit France for 6 months, (starting next month). You will spend $7,558 in each of those months. How much do you need to invest today to just fund your visit if your investments earn 3.08% APR (compounded monthly)?   

Solutions

Expert Solution

Nper = 6
PMT = $7558
Rate = 3.08% / 12
FV = 0

Present value can be calculated by using the following excel formula:
=PV(rate,nper,pmt,fv)
=PV(3.08%/12,6,-7558,0)
= $44,943.40

The amount you need to invest today = $44,943.40


Related Solutions

- You plan to visit France for 5 months, (starting next month).You will spend $6,248...
- You plan to visit France for 5 months, (starting next month). You will spend $6,248 in each of those months. How much do you need to invest today to just fund your visit if your investments earn 4.98% APR (compounded monthly)?- You will have a property tax payment due in 11 months that will cost $8,277. How much do you have to invest today to have just enough to pay your property tax bill if your investments earn 5.36%...
You plan to spend a semester abroad in France. You will live in France for 8...
You plan to spend a semester abroad in France. You will live in France for 8 months starting 12 months from now. Each month in France will cost you $6,489 How much must you invest each month, for 4 months, starting next month to exactly pay for your trip if your investments earn 3.36% APR (compounded monthly)?
You plan to spend a semester abroad in France. You will live in France for 11...
You plan to spend a semester abroad in France. You will live in France for 11 months starting 10 months from now. Each month in France will cost you $7,794 How much must you invest each month, for 5 months, starting next month to exactly pay for your trip if your investments earn 4.46% APR (compounded monthly)?
You plan to spend a semester abroad in France. You will live in France for 8...
You plan to spend a semester abroad in France. You will live in France for 8 months starting 9 months from now. Each month in France will cost you $6,515 How much must you invest each month, for 5 months, starting next month to exactly pay for your trip if your investments earn 3.63% APR (compounded monthly)?
You plan to spend a semester abroad in France. You will live inFrance for 10...
You plan to spend a semester abroad in France. You will live in France for 10 months starting 9 months from now. Each month in France will cost you $7,829 How much must you invest each month, for 4 months, starting next month to exactly pay for your trip if your investments earn 3.46% APR (compounded monthly)?
You plan to save $340 per month starting today for the next 43 years "just to...
You plan to save $340 per month starting today for the next 43 years "just to start the month off right." You feel that you can earn an interest rate of 10 percent compounded monthly. How much will there be in the account 43 years from today?
You plan on going on a 6 month vacation 8 months from now. You can pay...
You plan on going on a 6 month vacation 8 months from now. You can pay $3,458 per month during the vacation, or you can pay $22,523 today. If you pay today, how much does it save (or cost) you in present value term if your investments earn 3.41% APR (compounded monthly)? If it costs you more to pay today, state your answer with a negative sign (eg., -2000).
You can pay $91 per month, starting next month, for the next 5 years to have...
You can pay $91 per month, starting next month, for the next 5 years to have a lawn mowing service. Alternatively, you can purchase a riding lawn mower and pay $506 today and mow your own lawn for 5 years, starting next month. If you decide to mow your own lawn, how much do you save in PV terms if your investments earn 3.31% APR, compounded monthly? Note: If you would lose money, make your answer with a negative sign...
You plan to visit one of your friends living in Colorado, America in three months. You...
You plan to visit one of your friends living in Colorado, America in three months. You expect to incur the total cost of US$20,000 for lodging, meals, and transportation during your stay. As of today, the spot exchange rate is RM_____/ US$ and the three-month forward rate is RM_____/ US$ (please refer to Table 1 below for your given rates). You can buy the three-month call option on US$ with the exercise rate of RM4.3/ US$ for the premium of...
You can pay $110 per month, starting next month, for the next 5 years to have a lawn mowing service.
You can pay $110 per month, starting next month, for the next 5 years to have a lawn mowing service. Alternatively, you can purchase a riding lawn mower and pay $587 today and mow your own lawn for 5 years, starting next month. If you decide to mow your own lawn, how much do you save in PV terms if your investments earn 4.92% APR, compounded monthly? Note: If you would lose money, make your answer with a negative sign...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT