In: Accounting
Some Company | |
Cash Budget Given Information | |
For theYear Ended December 31, 2020 | |
Some Company has asked you to prepare a cash budget for the year 2020 using the following information: | |
Projected cash balance at January 1 | 50,000 |
Cash balance desired December 31 | 65,000 |
Projected sales by quarter (collected 70% in the quarter of sale and 20% in the quarter after sale, with the remaining 10% uncollectible): | |
Accounts recievable from 4th quarter 2019 (of which 20,000 is collectible and 10,000 is uncollectible) | 30,000 |
Sales Quarter 1 | 145,000 |
Sales Quarter 2 | 250,000 |
Sales Quarter 3 | 160,000 |
Sales Quarter 4 | 240,000 |
Projected 2020 sale of excess land: | |
Original cost | 40,000 |
Accumulated depreciation | 0 |
Book value | 40,000 |
Cash expected to be received | 75,000 |
Gain on sale expected | 35,000 |
Expected federal income tax refund from 2020 correction of error on 2018 tax return | 14,000 |
Projected 2020 transactions, to be paid in 2020, unless otherwise noted: | |
Purchases of merchandise inventory | 410,000 |
Operating expenses: | |
Sales and office salaries | 121,000 |
Office utilities | 9,000 |
Insurance expense (taken from Prepaid Insurance) | 6,500 |
Depreciation of building and equipment | 55,000 |
Amortization of copyright | 15,000 |
Purchases of office equipment | 20,000 |
Cash dividend (declared in December 2020; to be paid in January 2021 | 28,000 |
The company has a line of credit at the bank which allows borrowing up to $500,000. Currently, the company has loans of $250,000 taken out two years ago at 10% interest. Interest is due quarterly on March 31, June 30, September 30 and December 31. |
The amounts are listed in the above problem; "Some Company has asked you to prepare a cash budget for the year 2020 using the following information"