Question

Aunt Sally has just returned from a long trip to Europe. She started the trip with $7,500 in her pocket. She spent 2,330 traveling throughout euroland, 4,900NKr in Norway, and £1,760 in the U.K. The exchange rates were $1 = .8974, INKr = $.1219, and £1 = $1.2843. How many #dollars did she have left by the time she returned to the U.S.? $2,070.36 C $2,037.29 C $2,053.18 C $2,045.93 < $2,061.44

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

C D E Amount spent in euroland Amount spent in Norway Amount spent in UK Total amount spent in $ in local currency 2,330.00 4,900.00 1,760.00 exchange rate ($15) 0.8974 8.203445447 0.778634275 in dollars $2,596.39 $597.31 $2,260.37 $5,454.07 Initial Balance 7,500.00 Left Balance after trip 2,045.93

Cell reference -

LA B C D E in local currency exchange rate ($15) in dollars Amount spent in euroland 2330 0.8974 =C3/D3 Amount spent in Norway 4900 =1/0.1219 =C4/04 Amount spent in UK 1760 =1/1.2843 =C5/D5 Total amount spent in $ =SUM(E3:E5) Initial Balance 7500 Left Balance after trip =C8-E6

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.