Problem I: Computer Spreadsheet Assignments
Overall Instructions:
1. Prepare the report in good form as if you were submitting it to the financial vice-president of the company. It should be neat, well organized, and easy to follow. The standard is that anyone with accounting knowledge should be able to pick up your paper and quickly see what it accomplishes.
2. Besides printing the spreadsheet for each answer, print the cell-contents or cell-formulas for at least part A of each problem.
3. The spreadsheet should be programmed to make all calculations. For revisions, you should need only to type in the new information. Specific rules include:
a. Type each item of information only once.
b. Never embed information in formulas.
c. All information and solutions should be clearly labeled.
Problem II: Computer Spreadsheet Assignment:
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.
Problem III: Computer Spreadsheet Assignment
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.Overall Instructions:
1. Prepare the report in good form as if you were submitting it to the financial vice-president of the company. It should be neat, well organized, and easy to follow. The standard is that anyone with accounting knowledge should be able to pick up your paper and quickly see what it accomplishes.
2. Besides printing the spreadsheet for each answer, print the cell-contents or cell-formulas for at least part A of each problem.
3. The spreadsheet should be programmed to make all calculations. For revisions, you should need only to type in the new information. Specific rules include:
a. Type each item of information only once.
b. Never embed information in formulas.
c. All information and solutions should be clearly labeled.
Problem IV: Computer Spreadsheet Assignment
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.
Problem V: Computer Spreadsheet Assignment
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.