Given the following information, determine the balance on the United States current account and capital accounts and answer the questions below in EXCEL.

imports $211.5

net income from foreign investments $32.3

foreign investments in U.S. $7.7

government spending abroad $4.6

exports $182.1

U.S. investments abroad $24.7

foreign securities bought by U.S. $4.9

U.S. securities bought by foreigners $2.8

purchase of short-term foreign securities $6.5

foreign purchases of U.S. short-term securities $9.1

Be sure to also answer each of the questions within the spreadsheet. 1) What was the currency outflow (in dollars) on the current account? 2) What was the currency outflow (in dollars) on the capital account? 3) What was the total currency outflow (in dollars)? 4) What was the overall effect of the income from previous foreign investments on the cash outflow caused by the merchandise trade deficit plus government spending? 5) Was there any offsetting currency inflow to cover the direct foreign investments? Please explain your answer. 6) Did the currency that flowed out of the U.S. "disappear"? Please explain your answer. Please explain question 6