Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wildhorse Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2 0 2 2 . Daniel Jackson, the firm's director of marketing,

Wildhorse Instruments, a rapidly expanding electronic parts distributor, is formulating its plans for 2022. Daniel Jackson, the firm's director of marketing, has completed his 2022 forecast and is confident that the company will meet or exceed sales estimates. The following sales figures show the growth that is expected and are the basis for planning in the other corporate departments: Mark White, assistant controller, is responsible for the cash flow projection, a critical element during a period of rapid expansion. She will use the following information in preparing her cash analysis: 1. Wildhorse has experienced an excellent record in accounts receivable collection and expects this trend to continue. The company collects of billings in the month after the sale and in the second month after the sale. Uncollectible accounts are nominal and can be ignored in the analysis. 2. The purchase of electronic parts is Wildhorse's largest expenditure; the cost of these items is equal to of sales. Wildhorse receives of the parts one month before it sells them and during the month of sale. 3. Historically, Wildhorse has cleared of the accounts payable one month after it receives its purchases, and the remaining two months after. 4. Hourly wages, including fringe benefits, depend on the sales volume; they are equal to of the current month's sales. The company pays these wages in the month incurred. 5. General and administrative expenses are projected to be for 2022. The composition of these expenses is given WILDHORSE INSTRUMENTS Cash Budget For the Second Quarter Ended June 30,20225. General and administrative expenses are projected to be for 2022. The composition of these expenses is given below. The company incurs all of these expenses uniformly throughout the year, except for property taxes. It pays the property taxes in four equal instalments in the last month of each quarter: 6. Wildhorse makes income tax payments in the first month of each quarter based on income for the prior quarter. The tax rate is . The net income for the first quarter of 2022 is projected to be .7. Wildhorse has a corporate policy of maintaining an end-of-month cash balance of . It invests or borrows cash monthly, as necessary, to maintain this balance. 8. Wildhorse uses a calendar-year reporting period. Prepare a schedule of Cash Receipts and Disbursements for Wildhorse Instruments, by month, for the second quarter of 2022. Be sure that all receipts, disbursements, borrowing, and investing amounts are presented on a monthly basis. Ignore the interest expense and income from borrowing and investing. (Round answers to 0 decimal places, e.g.125.)

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

Fundamentals Of IT Audit For Operational Auditors

Authors: Timothy McWilliams

1st Edition

1634541332, 978-1634541336

More Books

Students also viewed these Accounting questions

Question

What is a specification tree?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago

Question

When is it appropriate to show grace toward others?

Answered: 1 week ago