Answer:
The real exchange rates calculated are 4.5 and 3
Explanation:
We understand that
Real exchange rate = Nominal exchange rate × (Basket cost in US ÷ Basket cost in Norway)
Utilizing this formula, the calculation proceeds as follows:
For a nominal exchange rate of 3, the real exchange rate is calculated as follows:
= 3 × (60 ÷ 40)
= 4.5
For a nominal exchange rate of 2, the real exchange rate is:
= 2 × (60 ÷ 40)
= 3
Response:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
Justification:
Below is the formula intended to be entered in cell C8:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
This formula computes the bonus based on the provided data, utilizing the IF function. The formula begins with an equal sign, followed by IF and the application of all relevant terms.
The excess cash balance stands at $9000, and the correct option is C.
