Exchange Corp. is a company that acts as a facilitator in tax-favored real estate swaps....

90.2K

Verified Solution

Question

Accounting

Exchange Corp. is a company that acts as a facilitator in tax-favored real estate swaps. Such swaps, know as 1031 exchanges, permit participants to avoid some or all of the capital gains taxes that would otherwise be due. The bookkeeper for the company has been asked to prepare a report for the company to help its owner/manager analyze performance. The first such report appears below:

Exchange Corp Analysis of Revenues and Costs For the Month Ended May 31
Planning Budget Unit Revenues and Costs Actual Unit Revenues and Costs Variances
Exchanges completed 40 54
Revenue $401 $391 $10 U
Expenses:
Legal and search fees 160 181 21 U
Office expenses 144 106 38 F
Equipment depreciation 12 8.89 3.11 F
Rent 59 43.7 15.3 F
Insurance 6 4.44 1.56 F
Total expense 381 344.03 36.97 F
Net operating income $20 $46.97 $26.97 F

Note that the revenues and costs in the above report are unit revenues and costs. For example, the average office expense is $144 per exchange completed on the planning budget; whereas, the average actual office expense is $106 per exchange completed.

Legal and search fees is a variable cost; office expenses is a mixed cost; and equipment depreciation, rent, and insurance are fixed costs. In the planning budget, the fixed component of office expenses was $4,100.

All of the company's revenues come from fees collected when an exchange is completed.

Required:

Prepare a performance report that would help the owner/manager assess the performance of the company in May. (Do not round the intermediate answers. Round your final answers to the nearest dollar amount. To compute Spending Variances, round your "actual results answers" to the nearest dollar amount. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Omit the "$" sign in your response.)

Exchange Corp Flexible Budget Performance Report For the Month Ended May 31
Activity Variances Spending Variances
Revenue $ (Click to select)UFNone $ (Click to select)UFNone
Legal and search fees (Click to select)FNoneU (Click to select)UNoneF
Office expenses (Click to select)UFNone (Click to select)UNoneF
Equipment depreciation (Click to select)UNoneF (Click to select)NoneFU
Rent (Click to select)NoneFU (Click to select)FNoneU
Insurance (Click to select)UNoneF (Click to select)UNoneF
Total expense (Click to select)NoneFU (Click to select)UFNone
Net operating income $ (Click to select)FUNone $ (Click to select)UFNone

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students