Question

In: Finance

Biswaroop wants to take a year long vacation in Thailand. He figures he can live on...

Biswaroop wants to take a year long vacation in Thailand. He figures he can live on 33600 bhat per month. (1 Canadian dollar = 39 Thai bhat (rougly)). He plans to withdraw that amount at the start of each month from his Thai savings account paying 3% interest compounded monthly. a) How much money (in Thai bhat) will he need in his Thai account at the start of his vacation? In order to save up the necessary amount of money, Biswaroop will deposit money at the end of each month for 2 years in a Canadian savings account paying 4% per year compounded monthly. His first deposit will be $P and then each subsequent deposit will increase by $P. b) How much does he need in Canadian dollars so that when he transfers it to his Thai account he has enough bhat for the year? c) What is the PV of an annuity due paying $1 (Canadian) per month for 12 months? d) How big does $P have to be so that he ends up with enough Canadian dollars in his account to start his vacation?

Solutions

Expert Solution

a. Amount required in Thai Bhats:

Formulas:

In Thailand (Thai Bath)
Monthly requirement 33600
Period in months 12
Interest rate per year 0.03
Amount at the start of travel =PV(B4/12,B3-1,-B2)+B2

b.

Formulas:

Convertion rate in Bhat/Dollar 39
In Canada pre travel (Dollar)
Amount at the start of travel =B5/B7

c.

Formulas:

Deposit 1
Interest rate yearly 0.04
Preriod in months 12
Present Value =PV(B21/12,B22,-B20)

d.

Formulas:

In Canada pre travel (Dollar)
Amount at the start of travel =B5/B7
Period in months 24
Interest rate per year 0.04
Initial deposit, P =B17
Subsequent deposit increase, P =B17
Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Total
Amount 33.1303599773223 =B17+$B$14 =C17+$B$14 =D17+$B$14 =E17+$B$14 =F17+$B$14 =G17+$B$14 =H17+$B$14 =I17+$B$14 =J17+$B$14 =K17+$B$14 =L17+$B$14 =M17+$B$14 =N17+$B$14 =O17+$B$14 =P17+$B$14 =Q17+$B$14 =R17+$B$14 =S17+$B$14 =T17+$B$14 =U17+$B$14 =V17+$B$14 =W17+$B$14 =X17+$B$14
FV of each deposit =B17*(1+$B$12/12)^(24-B16) =C17*(1+$B$12/12)^(24-C16) =D17*(1+$B$12/12)^(24-D16) =E17*(1+$B$12/12)^(24-E16) =F17*(1+$B$12/12)^(24-F16) =G17*(1+$B$12/12)^(24-G16) =H17*(1+$B$12/12)^(24-H16) =I17*(1+$B$12/12)^(24-I16) =J17*(1+$B$12/12)^(24-J16) =K17*(1+$B$12/12)^(24-K16) =L17*(1+$B$12/12)^(24-L16) =M17*(1+$B$12/12)^(24-M16) =N17*(1+$B$12/12)^(24-N16) =O17*(1+$B$12/12)^(24-O16) =P17*(1+$B$12/12)^(24-P16) =Q17*(1+$B$12/12)^(24-Q16) =R17*(1+$B$12/12)^(24-R16) =S17*(1+$B$12/12)^(24-S16) =T17*(1+$B$12/12)^(24-T16) =U17*(1+$B$12/12)^(24-U16) =V17*(1+$B$12/12)^(24-V16) =W17*(1+$B$12/12)^(24-W16) =X17*(1+$B$12/12)^(24-X16) =Y17*(1+$B$12/12)^(24-Y16) =SUM(B18:Y18)

Related Solutions

Biswaroop wants to take a year long vacation in Thailand. He figures he can live on...
Biswaroop wants to take a year long vacation in Thailand. He figures he can live on 41200 bhat per month. (1 Canadian dollar = 36 Thai bhat (rougly)). He plans to withdraw that amount at the start of each month from his Thai savings account paying 3% interest compounded monthly. a) How much money (in Thai bhat) will he need in his Thai account at the start of his vacation? In order to save up the necessary amount of money,...
Doug wants to go on vacation to Disneyland with his family every 5 years. He figures...
Doug wants to go on vacation to Disneyland with his family every 5 years. He figures that travel costs today are $3,000 for all expenses associated with the trip, and he expects these costs to increase with inflation. Assume inflation is 2%, compound quarterly. He wants to take his family on their next Disneyland trip in exactly 5 years, and he wants to do these trips for the next 50 years. If he can earn 6.6% APR, compounded monthly, on...
Nicholas Matveev wants to take a year-long cycling trip throughSouth America in three years.  He will...
Nicholas Matveev wants to take a year-long cycling trip through South America in three years.  He will have to pay $5,000 costs at the start of the trip and then $1,000 per month for 12 months.  Assume the monthly payments are at the end of the month.  He has $1,000 saved now.  How much must he save each month until the trip if he earns 0.2% interest per month?
A family comes home from a long vacation with laundry to do and showers to take....
A family comes home from a long vacation with laundry to do and showers to take. The water heater has been turned off during vacation. If the water heater has a capacity of 49.1 gallons and a 4610 W heating element, how much time is required to raise the temperature of the water from 18.8°C to 62.1°C? Assume that the heater is well insulated and no water is withdrawn from the tank during this time.
Teenager Mike wants to borrow the car. He can ask either parent for permission to take...
Teenager Mike wants to borrow the car. He can ask either parent for permission to take the car. If he asks his mom, there is a 20% chance she will say ”yes,” a 30% chance she will say ”no,” and a 50% chance she will say, ”ask your father.” Similarly, that chances of hearing ”yes”/”no”/”ask your mother” from his dad are 0.1, 0.2, and 0.7 respectively. Imagine Mike’s efforts can be modeled as a Markov chain with state (1) talk...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a $50,000 term (i.e., straight death benefit) life insurance policy until he is 65. The policy will expire on his 65th birthday. The probability of death in a given year is provided. x = age 60 61 62 63 64 P(death at this age) 0.01180 0.01447 0.01627 0.02038 0.02335 Jim is applying to Big Rock Insurance Company for his term insurance policy. (a) What is...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a $50,000 term (i.e., straight death benefit) life insurance policy until he is 65. The policy will expire on his 65th birthday. The probability of death in a given year is provided. x = age 60 61 62 63 64 P(death at this age) 0.01066 0.01402 0.01663 0.01978 0.02377 Jim is applying to Big Rock Insurance Company for his term insurance policy. (a) What is...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a $50,000 term (that is, straight death benefit) life insurance policy until he is 65. The policy will expire on his 65th birthday. The probability of death in a given year is provided by the Vital Statistics Section of the Statistical Abstract of the United States (116th Edition). x = age 60 61 62 63 64 P(death at this age) 0.01138 0.01309 0.01645 0.01942 0.02287...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a...
Jim is a 60-year-old Anglo male in reasonably good health. He wants to take out a $50,000 term (that is, straight death benefit) life insurance policy until he is 65. The policy will expire on his 65th birthday. The probability of death in a given year is provided by the Vital Statistics Section of the Statistical Abstract of the United States (116th Edition). x = age 60 61 62 63 64 P(death at this age) 0.01084 0.01345 0.01657 0.02071 0.02314...
Jim is a 60-year-old male in reasonably good health. He wants to take out a $75,000...
Jim is a 60-year-old male in reasonably good health. He wants to take out a $75,000 term (that is, straight death benefit) life insurance policy until he is 65. The policy will expire on his 65th birthday. The probability of death in a given year is provided by the Vital Statistics Section of the Statistical Abstract of the United States (116th edition) X=age 60 61 62 63 64 P(death at this age) 0.01091 0.01192 0.01296 0.01403 0.01513 Jim is applying...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT