Question
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
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 | |||||||||
Actual Unit Revenues and Costs | Planning Budget Unit Revenues and Costs | Variances | |||||||
Exchanges completed | 50 | 40 | |||||||
Revenue | $ | 385 | $ | 395 | $ | 10 | U | ||
Expenses: | |||||||||
Legal and search fees | 184 | 165 | 19 | U | |||||
Office expenses | 112 | 135 | 23 | F | |||||
Equipment depreciation | 8 | 10 | 2 | F | |||||
Rent | 36 | 45 | 9 | F | |||||
Insurance | 4 | 5 | 1 | F | |||||
Total expense | 344 | 360 | 16 | F | |||||
Net operating income | $ | 41 | $ | 35 | $ | 6 | F | ||
Note that the revenues and costs in the above report are unit revenues and costs. For example, the average office expense is $135 per exchange completed on the planning budget; whereas, the average actual office expense is $112 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 $5,200.
All of the companys revenues come from fees collected when an exchange is completed.
Required:
2. Complete the performance report that would help the owner/manager assess the performance of the company in May.
Required 1 Required 2 Complete the performance report that would help the owner/manager assess the performance of the company in May. (Indicat variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as Exchange Corp. Flexible Budget Performance Report For the Month Ended May 31 Actual Results Flexible Planning Budget Budget Exchanges completed 401 50 50 S 19,250 $ 500 U 19,750 S 3,950 F S 15,800 9,200 U Revenue Expenses: Legal and search fees Office expenses Equipment depreciation Rent Insurance Total expense Net operating income 5,600 400 8,250 6,750 500 1,800 200 17,200 2,050 U None None None U 300 U 2,250 250 18,000 1,750 U U None None None U F 6,600 5,400 400 1,800 200 14,400 1,400 S $ S $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started