Can you give me the Excel formulas and answers to put in the boxes?
B
C
D
E
F
G
H
M
N
Q
R
71 QUESTION 3 - FINANCING OPTIONS 72 73 THE US COMPANY HAS VARIOUS OPTIONS TO FINANCE THIS ACQUISITION FOR ITS EXACT USD AMOUNT 74 75 OPTION 1: A LOAN AT 7%, MATURITY 4 YEARS, WITH FIXED ANNUITIES. CALCULATE THE ANNUITY 76 CAPITAL 77 INTEREST RATE 7% 78 MATURITY ANNUITY 2,610 13 pts 80 81 OPTION 2: A LOAN AT 8% YEARLY INTEREST RATE, REIMBURSABLE AT MATURITY (4 YEARS) 82 CAPITAL 83 INTEREST RATE 8% 84 MATURITY 85 PLEASE DETERMINE PAYMENTS CASH FLOWS 86 Y2 Y3 Y4 87 12 pts 89 OPTION 3: A LOAN AT 8% YEARLY INTEREST RATE, FULLY PAYABLE (INTEREST & CAPITAL) AT MATURITY (4 YEARS) 90 CAPITAL 91 INTEREST RATE 8% 92 MATURITY 93 PLEASE DETERMINE PAYMENTS CASH FLOWS 94 Y2 Y3 74 S6 12 pts 96 97 86 99 WHICH OPTION? PLEASE EXPLAIN IN A FEW WORDS WHY EACH OPTION WOULD WORK/NOT WORK 100 10 pts 101 102 103 104 HOW WOULD YOU CHANGE YOUR ANSWER TO THE PREVIOUS QUESTION, IF THE SPOT RATE WAS TO BECOME 0.9 IN Y1 AND THEN REMAIN AT THIS LEVEL OVER THE FOLLOWING 3 YEARS? 105 106 PLEASE EXPLAIN 107 10 pts 108