Reference no: EM133611061
Case: Sarasota Hotels Ltd. (SHL) is a small boutique hotel that provides 35 suites that can be rented by the day, week, or month. Food service is available through room service. In addition, there are two suites that have been rented on a long-term basis to corporate tenants, who have access to their suites any time throughout the year without making a reservation. The company has a December 31 year end, and you are preparing the year-end financial statements using IFS.
The following issues require your consideration:
1. Cash
• The hotel keeps a significant amount of euro currency on hand to meet the needs of its guests. At year end, there was €13,440 on hand. The year-end exchange rate was $1.45, and the average rate for the year was $1.52.
. The bank statement balance at December 31 was $177,288. There were outstanding cheques of $58,660 and an outstanding deposit of $17,345. Bank charges per the bank statement were $73 for the month of December and have been recorded.
2 . Accounts receivable and allowance for expected credit losses
• The hotel charges $168 per night for accommodation in one of the rental suites, and guests pay at the end of their stay, daily revenue being accrued as it is earned. At December 31, the amount outstanding from short-term guests was $11,760
At year end, management expects to be unable to collect an amount equal to 5% of the outstanding receivables for this of suite. During the year, Service Revenue amounted to $1,960,000, and the balance in Allowance for Expected Credit Losses at the end of the previous year was $16,800. During the year, $35,840 in accounts was written off.
• The two corporate suites are rented for $50,400 apiece per year. The payment for these longer-term rentals is due in advance each July 1 for the following 12 months. One of these corporate suites has been in use for part of the year, but th corporate tenant went bankrupt and was unable to pay the $50,400 fee. Hotel management had hoped the tenant would eventually be able to pay, and it allowed the company to use the suite until the end of October. Since then, the hotel has bi in negotiations with the bankruptcy accountant and expects to eventually receive a settlement of $11,200. The balance w become uncollectible; no allowance for expected credit losses has been recorded with respect to these suites as there hav never been collection problems in the past.
3. Inventory
PHL follows a policy of FIFO costing, and values items at the lower of cost and net realizable value based on an individual item basis.
• The hotel has a standing weekly order at set prices with a local catering firm. If the food is not eaten before the next delivery is received, it is donated to the local women's shelter. This ensures that all meals are of appropriate quality for the hotel guests.
• On December 31, the following items were delivered:
Item Unit Cost Net Realizable Value
41 chicken dinners $6 $13
33 beef dinners $8 $17
69 frozen vegetable servings $1 $2
69 units of fresh fruit $1 $2
91 desserts $3 $5
• The invoice for the food delivery on December 31 included an additional delivery charge of $0.10 per item, totalling $30.30.
•
On December 31. an ice storm resulted in a loss of electricity to the hotel building. As a result, 20 chicken and 8 beef dinners thawed and were unusable.
The hotel also maintains an inventory of white terry cloth bathrobes and towels that are available for sale to its clients.clients. At
• December 31, the following information is available:
Product Quantity Cost/Unit Selling Price/Unit
Bathrobes, assorted sizes 40 $51.50 $85.00
Towels, extra-large 28 $19.80 $18.00
Towels, large 28 $14.00 $28.00
*The extra-large towels are no longer popular and management has decided to discontinue them. It offers the hotel staff a 20% commission for all extra-large towels they sell at the sale price of $18.00.
Investments
• On December 1, PHL purchased a $112,000, 90-day Canadian government treasury bill for $109,000 to yield 8%.
• During the year, PHL purchased 30% of the shares in Western Hotel Company, a company that owns a similar hotel property in a nearby city, for $5 million, a price corresponding to 30% of its book value. Subsequently, Western Hotel paid a dividend totalling $112,000 and earned income of $280,000. The fair value of the common shares as at December 31 was $5,712,000
• PHL also purchased common shares of Dufort Corp. as a temporary investment for $53,760. At the end of the year, these shares had a fair value of $52,640 according to the December 31 closing price on the Toronto Stock Exchange. A dividend of $560 was received during the year.
(a)
Cash and investments presentation
Determine whether each financial instrument should be presented in the cash and cash equivalents or in the investments section of the statement of financial position
Bank reconciliation
Prepare a bank reconciliation for PHL as at December 31 to determine the adjusted cash balance per the general ledger. Enter the description and amount of any adjustment in the table below.
(Description)
($)
Cash per bank account:?
Add:?
Deduct:?
Adjusted cash per general ledger:?
Inventory carrying values
Calculate the carrying amount of each inventory item as at December 31. Identify any inventory that requires a writedown, (Round answers to 2 decimal places, e.g. 52.75.)
Food: Carrying Amount ($)
Chicken dinners ?
Beef dinners ?
Vegetable servings ?
Fruit servings ?
Desserts ?
Bathrobes and towels:
bathrobes
Towels, extra-large
Towels, large
Investment income
Calculate the carrying amount as at December 31 and investment income for the year ended December 31 for each of the financial instruments listed below. (Round answers to 0 decimal places, e.g. 5,275. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45). Use 365 days for calculation.)
Financial instrument Carrying Amount$ Investment Income $
90-day Canadian government treasury bill ?$ ?$
Using: Amortized Cost
Western Hotel Company common shares ?$ ?$
Using: Equity Method
Western Hotel Company common shares ?$ ?$
Using: FV-OCI
Dufort Corp. common shares ?$ ?$
Using: FV-NI
Accounts receivable
Calculate the accounts receivable, allowance for doubtful accounts, and bad debt balances as at December 31. (Round answers to O decimal places, e.g. 5,275.)
Amount as at December 31
Accounts receivable $?
Allowance for doubtful accounts $?
Bad debt expense $?