Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Electronic Data Processing Controls And Auditing

Authors: W.Thomas Porter

1st Edition

0534009336, 978-0534009335

More Books

Students also viewed these Accounting questions