Question

All Kiwi Ltd (a New Zealand-based company) has a wholly-owned subsidiary in Malaysia whose manager is being evaluated on the basis of the variance between actual profit and budgeted profit in New Zealand dollars (NZD). Relevant information in Malaysian ringgit (MYR) for the current year is as follows: Budget Actual Revenues MYR 12,000,000 MYR 11,000,000 Expenses 9,000,000 9,000,000 Current year actual and projected exchange rates between the New Zealand dollar (NZD) and the Malaysian ringgit (MYR) are as follows: Actual at time of budget preparation NZD 0.312 per MYR 1 Projected ending at time of budget preparation NZD 0.340 per MYR 1 Actual at end of budget period NZD 0.357 per MYR 1
Required: Calculate the total budget variance for the current year using the exchange rate that exists at the time the budget is prepared.
Required: Calculate the total budget variance for the current year using the exchange rate that exists at the end of the budget period. Required: Calculate the total budget variance for the current year using a projected exchange rate (projected at the time the budget is prepared).

Answer 1

Answer

The answer and procedures of the exercise are attached in a microsoft excel document.  

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

Download xlsx