6C-4 with Excel This file is used with Problem 6C-4, and contains the three worksheet tabs listed below. Simply click on the tab you wish to view. 1. "Working Trial Balance" contains the KCN Working Trial Balance for the year ended December 31, 20X5 (unadjusted) and 20X4 (adjusted). 2. "Financial Statements" contains comparative KCN Financial Statements which are the results of the adjusted working trial balance amounts for 20X5 and 20X4. 3. "Ratios" contains the Financial Statement Ratios calculated from KCN Financial Statements, both for 20X5 and for 20X4. Required: a. Recalculate the 12/31/X5 and 12/31/X4 ratios using Excel on the Ratios schedule. b. Identify financial statement accounts that should be investigated because the related ratios are not what one would expect as compared to the prior-year ratios, industry averages, or your knowledge of th company. c. For each account identified in part b., list potential reasons for the unexpected account balances and related ratios.

The mccolls have made an offer on a new home. the home is new construction and scheduled to be completed by the end of the year. they provide a purchase deposit--a check in the amount of $40,000--to their agent, suzette. suzette, at the broker's direction, deposits the earnest money in the broker's trust fund account within two business days of receipt of the funds. did suzette follow the proper procedures? a. no, the check should not have been cashed. if a check is used as an earnest money deposit, it is to be held until acceptance of the offer. the seller must also be informed the buyer's check is being held and not negotiated.b. yes, suzette deposited the earnest money in the broker's trust fund account as directed. she also deposited the check within three business days of receipt. unless there were written instructions to hold the check until acceptance of the offer, the check may be cashed.c. no, suzette needed to deposit the earnest money in the broker's trust fund account within two days of receipt, not necessarily two business days.d. both a and c