Question: Please help with A-D excel functions would be helpful thank you Check my work Six months ago, Qualitybank issued a $130 million, one-year-maturity CD, denominated

Please help with A-D excel functions would be helpful thank you
Check my work Six months ago, Qualitybank issued a $130 million, one-year-maturity CD, denominated in British pounds (Euro CD). On the same date, $75 million was invested in a -denominated loan and $55 million in a U.S. Treasury bill. The exchange rate on this date was 1.5382 for $1. If you assume no repayment of principal and if today's exchange rate is 1.1905 for $1: a. What is the current value of the Euro CD principal in dollars and pounds? b. What is the current value of the British loan principal in dollars and pounds? c. What is the current value of the U.S. Treasury bill in dollars and pounds? d. What is Qualitybank's profit/loss from this transaction in dollars and pounds? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D What is the current value of the Euro CD principal in dollars and pounds? (Do not round intermediate calculations. Enter your answers in millions. Round your answers to 2 decimal places. (e.g., 32.16)) Euro CD principal in pounds Euro CD principal in dollars
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
