Accounting Computer Spreadsheet Problems
Not what you're looking for?
Accounting 350 - Computer Spreadsheet Assignment #2 (Chapter 7)
Dusty Horseman Corporation provides the following aging schedule of accounts receivable at December 31, 2011. The balance in the Allowance for Doubtful Accounts was $175,000 at January 1. During the year, $159,000 of bad debts were written off.
Classification by Month of Sale Balance in Each Category Estimated Uncollectible
November-December $1,080,000 3%
July-October 650,000 15%
January-June 420,000 50%
Prior to 1/1 150,000 90%
$2,300,000
Instructions:
A. Prepare a spreadsheet analyzing the accounts receivable and allowance for Doubtful Accounts for the year ended December 31, 2011. Prepare the journal entry for the year-end adjustment to the Allowance for Doubtful Accounts..
B. The company discovered $100,000 of the accounts receivable listed as January-June sales had been ordered during that time period, but the actual sales were not made until August. Revise your report to include this information.
C. In addition to the change in part (B), assume Dusty Horseman Corporation revises its estimates of uncollectible accounts for the November-December sales category to 5%. Revise your report to include this additional information.
Accounting 350 - Computer Spreadsheet Assignment #3 (Chapter 10)
Insole Vent Company purchased a building on January 1, 2003, paying $500,000 down and signing a mortgage note for an additional $4,500,000. The mortgage will be paid off with semi-annual payments (June 30 and December 31) over a period of 15 years. The mortgage rate is 8%.
Required:
A. 1. Prepare the mortgage amortization schedule for the 15 years of this note.
2. Prepare the journal entries for the date of the sale and for the first two payments.
B. Repeat part A assuming the mortgage rate is 6%.
C. Repeat part A assuming the down payment of $1,000,000 and a mortgage of $4,000,000.
Purchase this Solution
Solution Summary
The solution prepares a spreadsheet analyzing the accounts receivable and allowance for Doubtful Accounts, pass journal entry and also separately prepares the mortgage amortization schedule for the 15 years for Mortgage Note.
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Introduction to Finance
This quiz test introductory finance topics.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.