use excel functions to answer each problem

8) (10 points) Portable maintains foreign currency accounts, denominated in Euros and Brazilian Real. Current exchange rates are 1 Euro =1.17 USD and 1BR=0.19 USD. (Show all work/calculations.) A. What is the current value of one USD in terms of Euros? B. What is the current value of one USD in terms of BR? C. What is the current value of one Euro in terms of BR? D. If inflation in the US is expected to be 2% next year and 3% in the Euro markets, what will be the exchange rate of one USD in terms of Euros a year from now? E. If inflation in the US is expected to be 2% next year and 4% in Brazil, what will be the exchange rate of one USD in terms of BR a year from now? pertinent financial data is included in the tables below. The applicable corporate tax rate is 21%. \begin{tabular}{|l|c|l|r|} \hline \multicolumn{4}{|c|}{ Table 3: Portable Coffee Express Balance Sheet (December 31, 2020) } \\ \hline Assets & \multicolumn{2}{|l|}{ Liabilities \& Equity } \\ \hline Cash & $3,000,000 & Current liabilities & $3,600,000 \\ \hline Accounts Receivable & 2,000,000 & Mortgages payable & 5,900,000 \\ \hline Inventory & 7,000,000 & Common stock & 14,800,000 \\ \hline Land & 7,250,000 & Retained Earnings & 9,700,000 \\ \hline Fixed assets (net) & 14,750,000 & Total Liabilities \& Equity & $34,000,000 \\ \hline Total Assets & $34,000,000 & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{3}{|l|}{ Table 4: NCC and Portable additional data (December 31, 2020) } \\ \hline Item & NCC & Portable \\ \hline \begin{tabular}{l} Earnings available for \\ common stock \end{tabular} & $29,000,000 & $12,580,000 \\ \hline \begin{tabular}{l} Number of shares of \\ Common stock \end{tabular} & 7,000,000 & 3,400,000 \\ \hline \begin{tabular}{l} Market price per share \\ ( Estimated by NCC) \end{tabular} & $43.30 & $19 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Euro & USD & & \multicolumn{2}{|c|}{ Inflation } & \\ \hline 2 & \multirow[t]{2}{*}{1} & \multicolumn{2}{|l|}{1.17} & US & 2% & \\ \hline 3 & & & & Euro & 3% & \\ \hline 4 & BR & USD & & Brazil & 4% & \\ \hline 5 & 1 & 0.19 & & & & \\ \hline \multicolumn{7}{|l|}{6} \\ \hline \multicolumn{7}{|l|}{7} \\ \hline \multicolumn{7}{|l|}{8} \\ \hline \multicolumn{7}{|l|}{9} \\ \hline 10 & Part A & \multicolumn{2}{|c|}{ Euros to 1 USD } & & & \\ \hline \multicolumn{7}{|l|}{11} \\ \hline 12 & Part B & \multicolumn{2}{|c|}{BR to 1USD} & & & \\ \hline \multicolumn{7}{|l|}{13} \\ \hline 14 & Part C & \multicolumn{2}{|c|}{BR to 1 Euro } & & & \\ \hline \multicolumn{7}{|l|}{15} \\ \hline 16 & Part D & \multicolumn{2}{|c|}{ Euros to 1 USD } & & & \\ \hline 17 & & & & & & \\ \hline 18 & Part E & \multicolumn{2}{|c|}{BR to 1USD} & & & \\ \hline 19 & & & & & & \\ \hline 20 & & & & & & \\ \hline \end{tabular}